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 - 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: $30 - Posted
I have started this new business of taxi rentals. I have created a database. What i wants the candidate to do is: 1. Clean up with database. 2. Design beautiful forms with the logo and branding in place for taxi and drivers. The forms should be able to save and retrieve the database content. Database can be given to interested parties.
Skills: Microsoft Access Administration Microsoft Access Programming
Fixed-Price - Expert ($$$) - Est. Budget: $200 - Posted
Database will be created to assist the Roads and Highways construction industry. Services: Overlays, Demolition & Removal, Asphalt Repairs, Sealcoating, and Marking & Striping. The database needs to be able to calculate cost to do a job with a user-friendly experience. 1. Auto filter. 2. Drop down menu. 3. Show related items only in drop down menu. 4. Create template documents, (Quote and Invoices) 5. Create Reports Easily 6. Easy to update. 7. Intuitive, well thought out. 8. Efficient 9. Pleasant, easy-to-navigate GUI.
Skills: Microsoft Access Administration Database Administration Database design database management
Fixed-Price - Intermediate ($$) - Est. Budget: $40 - Posted
We are looking for someone that are willing to grow with us and can work with pressure. We need some sort of minor fixing today asap and we may hire you for a long term job for this application.;jsessionid=OWsMbF+ephxb98czkmCxC0FR.undefined Login: David Pass: David We need someone who can check the application for issues and provide us some sort of advice what to do. The application is not 100% good as I check but for this day we need someone who can fix some minor issues. We need someone who can work on our budget and not just work with us just for getting money but work with us because they want to grow with us.
Skills: Microsoft Access Administration HTML Java Java EE
Fixed-Price - Expert ($$$) - Est. Budget: $600 - Posted
We have an intricate sale process. We are a venue and event production company. I had 17 hats but as we grow so did our needs which zoho seems to be able to handle all. I need a lead management system with different/various workflows, reminder, tasks -It starts from an online inquiry, which once filled out should go directly into our new leads -once there, it should automatically send out a price sheet and assign a follow up immediately. -There is a couple of different sales processes I'd like to kick in based on the criteria. I can go in details. I also need client management where my lead turn into paying clients. -Once a lead becomes a client, there is also a timeline to follow -The most important thing I need is to be able to 1.create a job for the client, where I can assign vendors I refer to (as our vendors pay us for promotion, and if booked, need to remit payment to us based on their sale-so I need something that keeps track on how much I make in commissions for referrals. Sort of QB in essence, where I can connect vendors to jobs, who are not really vendors who pay me. But I also want the ability to add vendors as sometimes I hire for my client. The biggest issue is getting done, and having someone reliable to meet deadlines. You'll also be our connection for maintenance, upgrades, module implementation, ect. THIS PROJECT IS SUPER DUE, AS I HIRED SOMEONE WHO DRAGGED ME FOR A WHOLE MONTH AND GOT NOTHING DONE WHEN PAID UPFRONT.
Skills: Microsoft Access Administration Microsoft Access Programming Website Development Zoho Creator
Hourly - Intermediate ($$) - Est. Time: Less than 1 month, 10-30 hrs/week - Posted
Seeking support for custom MS Access program that was created for our meal delivery division at a Non-Profit Organization. We have setup multi-user access via SQL but are running into a few errors during client input and need an experienced candidate who can help debug the program to get rid of a few minor glitches. This project will potentially become an ongoing support contract depending on the candidate's experience.
Skills: Microsoft Access Administration Database design Microsoft Access Programming SQL
Fixed-Price - Intermediate ($$) - Est. Budget: $80 - Posted
I need a developer to convert an Excel spreadsheet used as a ledger to an Access database. The database will have a structure corresponding to how the Excel spreadsheet has been designed. The database will have a form for viewing and entering data as well as a field for entering comments. The Excel spreadsheet will be provided to the developer that is selected for this job.
Skills: Microsoft Access Administration Microsoft Excel VBA
Hourly - Entry Level ($) - Est. Time: 3 to 6 months, 30+ hrs/week - Posted
I need a Virtual Assistant - long term. 30 hours per week. =========================================================== Your tasks will include: 1. Sending emails to our existing customers, reminders/followups/testimonial requests. We prefer you use Microsoft Outlook 2016 if possible, or company Gmail system (this will be slower). 2. Searching and updating records in our Microsoft Access 2016 based Database. Training will be provided on how to use our database. 3. Checking 1 Gmail type email account for spam - check the SPAM folder each day and mark REAL emails as 'not spam'. We want to make sure important emails are not being detected as spam. 4. Work with our staff using Google Spreadsheets to see the tasks for each day, add comments/replies when done. 5. Helping with checking for duplicates, sorting, tidying up data, looking for mistakes in Google sheets for our collection of parts. 6. In any extra time, helping with finding potential sales leads and putting this info into an Google Sheet. 7. Updating our list of re-sellers, check their current address, phone #, all details spelt correctly - by checking their web site. 8. Going through records in our database and making changes in bulk, 1 at a time - slowly and carefully. Requirements: ============ Excellent Written English Skills. Must be SUPER organised. Must be VERY careful (better to double check everything 2 times than make mistakes and have to fix them). Must be able to carefully read information in our customer job database and update the status of the jobs (if our staff did not do it). You must have an internet connection with a static/fixed IP address (our database system is secure and we can only grant access to you if you have a fixed IP address). Use Microsoft Access and Outlook 2016 Use Gmail/Google Sheets You must have a 'can do' attitude, always be prepared to say 'i have finished my work, what else can i do to help?' You must want to make a difference, the jobs you will be doing will be helping our company a massive amount and it will make a HUGE difference to our company to help us focus on our own tasks and less on admin tasks. We are looking for a 12 month contract, ideally 30 hours per week - but be flexible with hours if it's less or more. You must also track and record your time so there is always transparency and trust from employer to employee In return, i will be the best boss you have ever had - helpful, supporting, appreciative, always respectful and considerate to your needs. You must use Hubstaff (i will provide the login) to track all time for work you are doing for me.
Skills: Microsoft Access Administration Administrative Support Email Handling Microsoft Excel