Microsoft Access Jobs

13 were found based on your criteria {{ paging.total|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 - Entry Level ($) - Est. Budget: $50 - Posted
I need to have someone create a Microsoft Access Report. I have already entered the data into a table and started the report, but realized it is beyond my ability. Truthfully, it is not a difficult. All I need it to do is display the data sorted based on the variables I have already entered and display some images. This seems like a small job, so I would like to get it quickly.
Skills: Microsoft Access Administration Microsoft Access Programming
Fixed-Price - Entry Level ($) - Est. Budget: $30 - Posted
I have a small project where I need help with a query in Access I'm attaching the Access database with the input query. Also attaching the output required in csv format. Once I have the query working I want to export to csv which I will just do form the query. I don't need help with that Basically, the input and output are the same except for when an sku repeats in the input I only want it to show in the top row See the attached
Skills: Microsoft Access Administration database programming
Fixed-Price - Intermediate ($$) - Est. Budget: $500 - Posted
We have a master DB in Access format. We need to import data from about 110 excel spreadsheets into the master DB by matching one or two fields. If matching record exists in the master DB, then import and update the existing records. If there is no matching record, insert as a new record. After the importing is completed, export records which have been updated or inserted. We have to make sure that there are no duplicate records. Please send your quote ASAP, since this is very time sensitive project which needs to be completed within 2 days. I will provide the detailed instructions to shortlisted candidate.
Skills: Microsoft Access Administration Microsoft Access Programming Microsoft Excel VBScript
Fixed-Price - Intermediate ($$) - Est. Budget: $500 - Posted
We have a master DB in Access format. We need to import data from about 110 excel spreadsheets into the master DB by matching one or two fields. If matching record exists in the master DB, then import and update the existing records. If there is no matching record, insert as a new record. After the importing is completed, export records which have been updated or inserted. Please send your quote ASAP, since this is very time sensitive project which needs to be completed within 2 days. I will provide the detailed instructions to shortlisted candidate.
Skills: Microsoft Access Administration Microsoft Access Programming Microsoft Excel VBScript
Fixed-Price - Entry Level ($) - Est. Budget: $40 - Posted
I work as a Agent for a apparel company and I use excel sheets to follow up with the customer and factory. There are many steps which are repeated again and again. I need to stop this and this is the reason why I need these excel sheets to be converted into a MS Access application. Please review the attached file and advise if you can do this project Project will involve creating login, menus, forms, tables, queries and reports. - Include Source Code - Revision if required - Delivery 4 days + 2 days for review maximum - Total project cost US$40/- Please calculate exact lead time, DO NOT SUBMIT UNFINISHED PROJECTS JUST TO AVOID CANCELLATION.
Skills: Microsoft Access Administration Microsoft Access Programming
Fixed-Price - Expert ($$$) - Est. Budget: $500 - Posted
We had a 2003 Microsoft Access database created for us - we need it updated and completed. This will be on a network drive and shared between 3 users. Ultimately there will be 60-100 work orders (jobs) per month, approximately 350 daily items per vendor, and approximately 60 employees (workers and supervisors). ****** IMPORTANT ****** This will be paid by the project. Please recommend milestones and funding estimates but keep in mind that the goal of the project is a working database that pulls the reports listed below. If the reports don't run properly, everything else in the database doesn't mean anything. ======= Forms that need to be updated ======= Employee Form Add auto-look up so we can automatically look up record by Emp#, First name, or Last Name (currently have to enter field and press ctrl+F - the people using this aren't going to be that savvy). GL, PO, WO Form 1. Current form looks like an Access entry table with "+" signs that need to be expanded to enter in data. Our staff won't understand it. I need form updated so we can enter all of this information without needing to expand the fields. This should look like the rest of our forms. *I need to know if this is possible* 2. I currently can't enter data in properly if I enter in multiple WorkOrder under the same PONbr field. I can enter in duplicate PO numbers in the PONbr field with one WorkOrder under it and it works fine. *I need to know that this is how it's supposed to work.* Job Data Add auto-lookup so we can automatically fill out the top portion of this form. We should be able to look it up by Job#, PO#, or WO ======= Reports that need to be fixed ======= This database was created so we could easily pull these reports, but these have not been finished. Payroll Report 1. I need to be able to select 1 employee and pull their hours for the week. Currently get an error message. 2. The numbers in the report aren't correct - this report needs to be reviewed and updated. PO Report - shows all POs in date range 1. I need this changed to be a calendar icon/date picker to select the dates, not a drop down. Revenue Report 1. Currently asks for supervisor but provides an error message if you select a supervisor. 2. If you don't include a supervisor it includes all information under all supervisors but repeats the same information - so a report that is only 2 pages ends up being 24 pages long. 3. You cannot pull the report by Job ID Billable Report 1. The information on the left side of the report (SOW code, Description, Qty, and Rate) is wrong - it's pulling the right data but the data repeats. Invoice 1. Show titles above final table (SOW Code, Description, Qty, Rate, Total)
Skills: Microsoft Access Administration Microsoft Access Programming
Fixed-Price - Intermediate ($$) - Est. Budget: $100 - Posted
Looking for an experienced technical Individual (or) team capable of Intermediate to Advanced Microsoft office suite application usage (Access and Excel) Experience with Manufacturing Defect product per million calculations, Manufacturing Quality principles, LEAN operations/principles preferred but not required. See attached file "Areas of interested improvement" Tab and/or "Desired Work scope" tabs for additional information. Desired Work scope listings' open to discussion for potentially more effective input and output reporting criteria based upon Workflow process listed. Listed Budget is negotiable considering available experience.
Skills: Microsoft Access Administration Microsoft Access Programming Microsoft Excel Microsoft Excel PowerPivot
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 https://drive.google.com/a/brandowlpromo.com/file/d/0B-_Z-hrXqE5JdGFFUHpNdEZzYlU/view?usp=sharing
Skills: Microsoft Access Administration database management Microsoft Access Programming Visual Basic
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++