Microsoft Access Jobs

43 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: $80 - Posted
Hello. See detailed specs in the attached file. The goal of this project is to find an experienced database administrator with MySQL and Microsoft Access experience that can help me add my first two (relatively large) tables to MYSQL, preferably using MySQL Workbench. Additionally, I am hoping to set up an ODBC connection with Microsoft Access so that I can easily query (and join to) the data using Microsoft Access. This is the initial project, which will hopefully lead to a long term working relationship in which I can incrementally expand the capabilities of the MySQL database. Overview is shown below, but the attached file has more detail as to the contents of the tables. 1 Design simple MySQL DB for storage of Product Data (on my desktop) 2 The initial tables are currently available in either MDB files or in Txt files, whichever is easiest for you to use to import them into the MySQL DB 3 Msft Access ODBC Connection will be established so that Msft Access Queries can be performed on the MySQL Tables 4 Strive for the simplest possible setup, to ensure that queries and maintenance of the Database is as simple as possible for the Analyst using the data. 5 Note: I believe the MySQL and MySQL Workbench is already properly installed on my (desktop) computer, though we may need to ensure it is installed properly. 6 The initial two tables have around 2 Million records, but I will soon be growing them to 5 or 6 million records. 7 The reason for this project is because the size of the files in Msft Access have a 2 GB limit, so I am required to use a larger Database to house the data. 8 I will need to also have the ability to easily update/append/delete records in the below two tables, often times using lists of ASINs that exist in txt files or in Microsoft Access Tables. Using MySQL workbench is probably the best option, though I am open to other simple solutions. 9 Would like to eventually transition this to a Big Data Database setup using clusters through Hadoop and MapReduce or MySQL clusters for more advanced storage and analytics.
Skills: Microsoft Access Administration Amazon MWS Apache CloudStack Database Administration
Fixed-Price - Intermediate ($$) - Est. Budget: $200 - Posted
Looking for some help to complete one of my own personal project, conversion from worksheet based system to Access database application. Most of the work has been accomplished for initial version. Design and roll out of last two modules which involves some reporting by macro's generating excel worksheet. Plan is we work as a team to accomplish this task and product better version for resale to same client and other clients in same industry.
Skills: Microsoft Access Administration Document Conversion Excel VBA Microsoft Access Programming
Fixed-Price - Intermediate ($$) - Est. Budget: $500 - Posted
I have an MS Access database that houses about 135,000 records. I have the database on my dropbox account. Currently I update the database myself but I would like to have someone (you) create a portal that will allow someone (remotely) to gain access to the database so that they can update information only... not delete information. I have uploaded a video to youtube that will help explain what I am looking for you to create. Copy and paste the following link:
Skills: Microsoft Access Administration Database design Website Development
Fixed-Price - Intermediate ($$) - Est. Budget: $50 - Posted
I am looking for an applicant that has experience with Microsoft Access and SQL to work for a project. Project work shouldn't take too long at all. I am not asking for work that would take a substantial amount of time. I will send all the documents as soon as you apply so that you can review them and see if you'd be comfortable with doing the work or not.
Skills: Microsoft Access Administration Microsoft Access Programming SQL
Fixed-Price - Intermediate ($$) - Est. Budget: $150 - Posted
We are updating a weekly funnel of opportunities within 8 people across different countries. We need to automate the process in Excel, creating entries and self-generate report and funnel in accordance with the data Excel shall compare weekly changes and produce the report. Macros and tables expertise is required Nice user interface I tried to summarise the scope on the attached slides, with the required dashboards and entries. Important to take in consideration, the new update files every week and carry on information. Please read the attached info and quote for a full Lump Sum
Skills: Microsoft Access Administration Data Analytics Data mining Excel VBA
Fixed-Price - Expert ($$$) - Est. Budget: $200 - Posted
I want to further automate my excel based schedule using macros. This main sheet should be able to collect relevant info from other excel schedules and templates, consolidate it and then perform search functions. Then afterwards, I wish to perform a gap analysis with this template by comparing demand and availability from the schedule. In other words, I want to use this as a planner as well. Automated dashboards is a plus
Skills: Microsoft Access Administration Excel VBA IMacros JavaScript
Fixed-Price - Intermediate ($$) - Est. Budget: $1,000 - Posted
We are in the process of updating some very outdated methods of tracking current work in progress. We are looking for an individual that can listen to what we would like to see our database do and make it happen. In general, database needs to be able to track medical claims for a number of clients that come due for filing on a yearly basis. I need my employees to know exactly when each claim is due, which have been filed, location of relative information on each claim, etc. A conversation is required to gain a full understanding of what we need as well as what you will need from us (time, budget etc).
Skills: Microsoft Access Administration Microsoft Access Programming Microsoft Excel