Microsoft Access Jobs

21 were found based on your criteria {{|number:0 }} were found based on your criteria

show all
  • Hourly ({{ jobTypeController.getFacetCount("0")|number:0}})
  • Fixed Price ({{ jobTypeController.getFacetCount("1")|number:0}})
Fixed-Price - Intermediate ($$) - Est. Budget: $300 - Posted
Here is a list of what we are looking at doing. We have this DB password protected in which the prior developer is no longer in the industry. We need to do the following as this is a database built for one of the companies we work with that gives us raw data that this imports and allows for detailed reports and simplified reports. Here is what we are trying to do to the existing database attached: Modify existing access program to allow for the recognition of alphanumeric characters in a data field(agent code). The current program only recognizes numeric agent codes and all alphanumeric codes are defaulted to an agent code “O”. The program converts a TXT file into a database in which an access program breaks down commission payments and subtotals them by agent code which allows for summary reports and individual detail reports. Please bid only if you have the understanding and good communication skills to get the job done. Thanks in advance Please bid for the best price you can once you see the project. Thanks
Skills: Microsoft Access Administration database management Microsoft Access Programming Visual Basic
Hourly - Intermediate ($$) - Est. Time: Less than 1 month, 10-30 hrs/week - Posted
We need a set up in which techs can enter data from individual offices and have the information centralized on our server. The data will then be automatically sorted between several spreadsheets and reports. The individual techs should be able to access only their individual information, but the central office will be able to access all data. This project will require a one time set up, and ongoing support if any changes need to be made. We already have a functioning database, but we want to upgrade and modernize to make more user friendly and versatile.
Skills: Microsoft Access Administration Microsoft Access Programming Microsoft Excel
Fixed-Price - Intermediate ($$) - Est. Budget: $250 - Posted
Dear Superstar; The system will cater for 4-5 job roles to begin with. Many forms will be integrated with each other. I will provide all the forms as they are in word and pdf format, or I can create excel files with your direction if it helps. Be sure to add Superstar in your application and let me know how you can brand the program and make it more visually based rather than technical with rows and columns of cells. • Password protected • User rights per function or per job role • Some sort of online updating/back uping capabilities with regular if not real time updates/backups • Ability to update accounting softwares • Ability to send notifications and track time, dates etc 1st Module: Ads Tracking We will place ads for 4-5 job roles and we need to track where the ads were placed and at what cost if they were paid for. Also we would like to track which ads our clients found us on and generate ROI reports. 2nd Module: Call tracking + screening As people call in we will need to pre-screen them which might include a call back and scheduler for interview dates with options to track all contact from the call to hiring and beyond. 3rd Module: Interview As we go thru the process of interviewing the person we would like forms to transfer the paper application to the database and still track the process of hiring and steps involved. This must also allocate employee reference numbers and stage names if applicable. We may also need to upload ID details, scanned copies of agreements and such, this must only be in a secure location for Data protection regulations. 4th Module: Induction and Training As the employees go thru training we would like to keep track of this in each one of they files as well as in a distinct module with comments on there performance and dates to refresh. 5th Module: Work Schedule We will require all employees to submit a two week schedule at a certain interval. We will need to track these as well as set reminders and notifications of when the schedules are due from the employees. It must allow for changes and track history. 6th Module: Daily Schedule All the information from the bi-weeky schedule must populate a daily planning worksheet with all the people working that day. It must allow for changes and track history. People not coming into will be disinclined under certain conditions and that must be recorded here or somewhere more convenient. 7th Module: Disciplinary Rules We must be able to log and track any punishments and rules under many different conditions from other modules 8th Module: Booking We will need to book clients and recording the details, we have a processes for this. Also we will need to track the time of each booking and be informed when each is about to end or overdue. Disciplinary Rules will apply to this for failing to maintain our standards. 9th Module: Client database We will need to keep a record of our clients and be able to look them up quickly as they call. These should be updated with every booking or every call for estimates and quotations. Also our backlist and white list must be integrated. 10th Module: Bonuses The more bookings our employees do is the more reward they will need, so we need to track these over time. 11th Module: Stock control (rent and purchase) We will need to track what we have rented and sold to employees and customers, there will be paper forms that will update this module. 12th Module: Revenue tracking For all sales (cash, credit card, etc) we will need to track how much was made and how much was the cost of sale and any commissions owed to employees. 13th Module: QuickBooks integration If this can be done via API then great, if not then an excel document can be generated which can be uploaded to QBs easily. This will assist us in issues invoices and receipts without having to wait for data entry to occur. 14th Module: Call consolidation We would also need to cross reference the calls made for business purposes with unauthorized personal calls. So if we know people with access to phones on any given day we can deduct unauthorized calls. 15th Module: Promotion We will need to produce promotion materials and its idea to have all the processes created for our databases. We would need to find talent, track costs, track licenses and agreements. Track places were the materials were used and have QBs online updated via file upload or API. If you have no attention to detail I will not hire you. I want you to tell me your process of working, if you will be able to create flow charts, a user Manuel, how you will test it, if you will provide a trouble shooting document and any other details you believe are relevant. Thanks Daniel
Skills: Microsoft Access Administration API Development C# C++
Fixed-Price - Intermediate ($$) - Est. Budget: $40 - Posted
We have a need to establish a long term relationship with someone that is skilled in large data management, and database administration. We are currently using Microsoft Access for our reporting and data maintenance, but we will soon be transitioning to MySQL or another setup that allows us to more efficiently store, analyze, and retrieve data. As an attempt to get quick insight into your skill set, we have an initial task we are seeking assistance with. 1. Assist in opening and filtering a large file (4.5 GB, and 13 million records) so that we can narrow it down to a smaller sized file. Once applied, the query should filter the file to around 2 million records. Note that the file is available to us via FTP (and was originally a .dat format). The need is simply to apply the following filter to the text file: (A). On Hand Quantity > "00000000" (B). Price >50 (C). Select ALL columns (or simply the following columns, if it makes it easier: GTIN Prefix, ISBN-10, Price, On-Hand Quantity, Discount Level, Publication Date, On Sale Date, Product Classification Type, and Product Type 2. Ensure that we are able to access the resulting reduced file within Microsoft Access, whether through an ODBC connection, link to txt file, or placing the file directly in Access Thanks for your interest in working with us. We hope you can use this task to establish a long term relationship and help us craft a long term strategy for managing our data.
Skills: Microsoft Access Administration Big Data Database Administration Database design
Hourly - Intermediate ($$) - Est. Time: More than 6 months, 10-30 hrs/week - Posted
Looking for experienced Access developer. We have several already created databases which manage our dropship orders from vendors. These databases: Downloads and imports Files from FTP site Barcodes created for each Line Item on Order Creates Invoices (including Barcodes). Invoices also serve as picking tickets Adjusts Inventory Each barcode is scanned on each Invoice at the product moves through the production process (Customization and Shipping) When product is scanned in shipping, database interacts with UPS Mail Innovations, setting up the shipment and printing shipping label End of day, database sends file to customer with ship confirmation for each order including tracking number If you have experience working with similar databases and integrations, please contact us. We are looking for someone permanent to help us with managemnet, maintanence and improvements. I anticipate monthly hours to be between 5-40 depending on needs.
Skills: Microsoft Access Administration Microsoft Access Programming
Fixed-Price - Intermediate ($$) - Est. Budget: $100 - Posted
I need someone to create a Microsoft Access File that we will host on our server for all of our employees to login and show where a job is at different stages. I have attached a sample Excel File I found but not near enough info (and it's obviously not Access). It needs to have drop downs and various categories. I will give a clear description of exactly what I want when you are hired. I know if you are familiar with this program the project shouldn't be to difficult to create or take to long we just do not use it enough to put it together properly.
Skills: Microsoft Access Administration Microsoft Access Programming
Fixed-Price - Intermediate ($$) - Est. Budget: $1,000 - Posted
Looking to build a complex access database that can be accessed and saved by multiple users at the same time. File will be located on a corporate shared drive. Database will contain approximately 50 tables of information with up to 400 records per table. All information will be related to project management (construction). Access database will need extensive VBA coding to automate workflow for all tasks (including automation with Outlook - mail merge, will need access data to auto-fill to PDF documents and attach to outlook e-mails, will need reminders built in to work-flow that is broken down by user, sync outlook calendar with information in access database). We are looking for this access database to replace approximately 12 spreadsheets that are currently being used and combine all tasks in to one program with complete automation of workflow.
Skills: Microsoft Access Administration Microsoft Access Programming VBA
Hourly - Expert ($$$) - Est. Time: More than 6 months, Less than 10 hrs/week - Posted
Hello, I’m glad to meet you. Maybe you are interested in this job. I would be glad to get a short response, thanks. What we look for: A freelancer / staff who has skills in Microsoft Access Administration, Microsoft Access Programming, Database design, Database Modeling, database programming, Online and web applications (not the focus on mobile applications) and is interested in doing interesting job for smart start-up activity. What we would like to be solved: • Requirement 1: Data-Entry Procedure (manual, automated) - Focus in designing the manual (by human) and automated data management. • Requirement 2: Database Infrastructure - Focus on set-up of infrastructe either on local server or on cloud, depends on worldwide online data entry, security,… • Requriement 3: Workflow Design and User-Interface Design (UI) - Focus on design and development of the workflow und UI. • Requirement 4: Category List Management - Focus on management of hierarchical data sets, key words with „relation factor“ (to be explained) We would like to prefer MS Access due to our reasonable experience and well established interface to excel and ms office at all. We have started MS Access database with some tables, forms, queries… on a desktop/server version. Users of this database can be experts as well as absolut beginners (e.g. for simple data entry). How we would like to start: 1. A paid Interview focusing on set of questions about our database vision, strategies and requirements. You will get the questions before our interview. I can explain the question in interview if desired. After the interview please make a short summary of your answers. All be on fixed price or hourly rate. Please make your proposal. 2. After internal review and discussion we would like to set a second interview with further questions, if necessary. 3. After that we talk about future cooperation. Who we are: We are a smart start-up „Sensing Innovations“ from Germany with good funding in background and looking for longterm cooperation freelancer experts. I’m responsible to design and realise our database with specific requirements for B2B in the field of Market & Technology Intelligence Reports with analyst experts and latest machine learning technologies. Thanks for your interest and we are glad to hear from you, Kind regards, Thomas
Skills: Microsoft Access Administration Database Administration Database design database management