Microsoft Access Programming Jobs

73 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 - Intermediate ($$) - Est. Budget: $100 - Posted
I've got a simple Access database. It has one table containing 26 columns and 592 rows. I need a form created that will display information from the following 15 columns: ID Services TypeOfServices NameOfGroup Address City Province Postal Region Country Contact Title Info Email Phone And it will provide combo-box filters for the following: Services TypeOfServices City Province Region Country I see this being done easiest with a set of text-boxes at the top of the form (combo-boxes for the ones where a filter is desired), and a datasheet on the lower-half of the form, but if you see a different way of doing it, have at it. The challenge is being able to select multiple filters and having the combo-boxes update automatically.
Skills: Microsoft Access Programming SQL VBA
Hourly - Entry Level ($) - Est. Time: Less than 1 week, 10-30 hrs/week - Posted
I am an Excel user at an intermediate level. I have a project which I do not have any experience designing and creating so I am looking for some help. My company host events which can have up to 180 teams participating. Our company reps keep track of each team's event activity on a single sheet (see attached). I would like for our employees to be able use data entry to key into each sheet as the event plays out usually over a few days. I think Excel's userform may be the best approach, but I have no experience with it other than a few overviews I went through. I can modify VBA but cannot build from scratch as I am not fluent writing code. Once this data is entered, I need the ability to access it and summarize with Pivots. This part I can do. If Access is a better option, I ok with that as well as long as I can export data to Excel. I need someone to organize this project, perhaps get me started in the right direction so I can have a working copy.
Skills: Microsoft Access Programming Excel VBA
Hourly - Entry Level ($) - Est. Time: Less than 1 month, Less than 10 hrs/week - Posted
I am looking for a MS Access developer with Access VBA experience. If you have developed projects using MS Access please respond with examples of work, availability and versions used Thanks Kay
Skills: Microsoft Access Programming
Fixed-Price - Intermediate ($$) - Est. Budget: $300 - Posted
Hi! I am looking for someone with extensive experience with MS Access and VBA to help me set up a software I have already purchased. The name of the software is SimpleLIMS (in case you've heard of it). I would like you to set up the software for us so that we can make the switch as seamless as possible. Please contact me as soon as possible, as I am looking to get this done in the next week. Thank you!
Skills: Microsoft Access Programming Microsoft Access Administration VBA
Fixed-Price - Entry Level ($) - Est. Budget: $50 - Posted
Looking for a freelancer to create a MS Access template ( a simple one ). Aprroximate hours= 3-4 Tasks: 1. Create a log in credential form/table which would allow to add multiple users and provide me with suitable clearance as required. (admin/user) 2. Create an option to mail and print reports. 3. Suggestion to automatically update database: like update via excel/ pre created form 4. Creation of forms, tables, tabs and query 5. Auto- record of login basically to track who made changes to database with time stamp. 6. Option to attach files(.pdf, jpeg, tiff) 7. Report section with a possibility to view the attachments. Reference: MS access project management database template. Emphasis on UI would be highly appreciated. You may have to tell me on how to update the database with my data once the template is ready. Also, If I choose to change any of the header/ table/form name will that affect the reports section?
Skills: Microsoft Access Programming
Hourly - Entry Level ($) - Est. Time: Less than 1 month, 10-30 hrs/week - Posted
I am currently building a custom inventory system in Microsoft Access 2016 and need some assistance in getting some of the views, reports, and queries to work the way they should. The majority of this database will be completed by myself, you are being brought in to develop some of the items towards the end of the database development. Examples of types of tasks need to be completed can be seen below: // Sample View: Manifest Input (i) Create single view where user can input data relevant to an individual manifest that is stored across multiple tables (ii) View should be divided into multiple tabs for a cleaner interface. User will click on the tab that is most relevant to where they are in the input process (iii) Each tab should have a datatable view embedded so that the user can see how the data is being stored in the database // Sample Reports Task: Inventory Reconciliation (i) Number of items received and added to inventory per inventory database (total) (ii) Number of items received per incoming manifests (total) Total from (i) should equal total from (ii) (iii) Number of items shipped and removed from inventory per inventory database (total) (iv) Number of items shipped per outgoing invoices and returns to vendors (total) Total from (iii) should equal total from (iv) // Sample Query Task: Inventory Filterable Query Form (i) Create a form that enables the user to view items in inventory by product type, sample id, manifest id, metastasis, treatment (ii) Link the form to a query that displays all the inventory items with the various fields mentioned in (i) (iii) Editing the form will filter the data displayed in the table based on the parameters set in the form In your quote make sure to include: 1) Your hourly rate 2) The amount of time each of the sample tasks above will take 3) Do you provide fixed rate quotes (if yes I will provide you with an entire list of tasks in full that you can create a quote off of) Ideal candidate will be available on a periodic basis throughout the year to help maintain, tweak, and build new features for the database.
Skills: Microsoft Access Programming Microsoft Access Administration Microsoft Excel Microsoft Office
Fixed-Price - Expert ($$$) - Est. Budget: $250 - Posted
Looking for an experienced Excel/Access developer to create a template in either Access or Excel that has a number of rules built in to filter a daily downloaded/emailed Excel spreadsheet. The Excel Spreadsheet is emailed daily. I want to have it so it can be emailed to a specific site or email address to be uploaded in Access. In Access, there are approximately 10 Rules/Filters that I need to have applied. Once the rules are applied, I need to have them Scored and then subtotaled. The Rules are If/Then or Greater Than/Less Than type rules. Right now I do it manually in Excel.
Skills: Microsoft Access Programming Microsoft Excel
Fixed-Price - Entry Level ($) - Est. Budget: $10 - Posted
I have a list of 490 names and contact information in an Excel Sheet. (This page of the workbook is called Primary SSO Sheet PSS.) I am trying to find which of these names are NOT in my company database. Using the email address, I found 247 names in my database. (These names are listed in the sheet entitled Found Emails in Database.) I need to eliminate the names on FEiD from PSS. Please return this list to me in an Excel sheet. Thank you.
Skills: Microsoft Access Programming Microsoft Excel