Microsoft Access Jobs

42 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}})
Hourly - Intermediate ($$) - Est. Time: More than 6 months, Less than 10 hrs/week - Posted
We are a large eCommerce retailer looking for the perfect individual to manage our hundreds of thousands of products that we sell online. We get raw data from our various vendors and this data needs to be mined, organised, stored and exported to various third-party systems and also needs to be managed long-term. The ultimate goal is to have every single item that we want to sell, listed online on every single marketplace that we sell on. There are are many issues and problems with the data that you will have to resolve - on your own. You should be motivated self-starter that can work independently in a fast paced, ambiguous environment. You should have excellent business and communication skills to be able to work with business owners. Basic Qualifications ----------------------- Strong sense of ownership, urgency, and drive Strong troubleshooting and problem solving skills Expertise with SQL and relational database systems Knowledge of data warehousing concepts. Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets. Proven ability at looking at solutions in unconventional ways. Sees opportunities to innovate and can lead the way. Top notch communication (verbal and written) and interpersonal skills to convey key insights from and an ability to effectively communicate with technical teams and business owners. Ability to work with shifting deadlines in a fast paced environment.
Skills: Microsoft Access Administration Data mining Microsoft Excel Product management
Hourly - Entry Level ($) - Est. Time: Less than 1 month, Less than 10 hrs/week - Posted
I need someone to develop a basic cloud based database to manage our property income and accountant. currently we doing this task using a shared excel file in Google drive. but we want something bit professionals - It should have two different admin and user (read only) access - List of tenant (including pay due and paid ) - culculate income and expenses - Report - it has only 14 users (no public access internal use only) -web interface for database could be a solution. Happy to hear all suggestions and solution from candidates detailed information will be available once we start discussing the job
Skills: Microsoft Access Administration Certified Public Accountant (CPA) Cloud Foundry database programming
Hourly - Entry Level ($) - Est. Time: Less than 1 month, Less than 10 hrs/week - Posted
I need someone to develop a basic cloud based database to manage our property income and accountant. currently we doing this task using a shared excel file in Google drive. but we want something bit professionals - It should have two different admin and user (read only) access - List of tenant (including pay due and paid ) - culculate income and expenses - Report - it has only 14 users (no public access internal use only) -web interface for database could be a solution. Happy to hear all suggestions and solution from candidates detailed information will be available once we start discussing the job
Skills: Microsoft Access Administration Certified Public Accountant (CPA) Cloud Foundry database 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
Fixed-Price - Intermediate ($$) - Est. Budget: $500 - Posted
Looking for an experienced SQL Programmer to work on a ongoing basis fine tuning and optimizing current Access application that runs on SQL. Individual will be able to work onsite at our client once a month in person with rest of work to be performed remotely.
Skills: Microsoft Access Administration Microsoft Access Programming Microsoft SQL Server Administration Microsoft SQL Server Programming
Fixed-Price - Expert ($$$) - Est. Budget: $100 - Posted
Hi, we are looking for an expert in Access and VBA for a one-off micro project. The function of the database is to gather relevant project information through an automated email communication with the managers. The database has already been created (forms, reports, queries), we just need to create a function to gather the relevant data through automated emails. Your task – to enable managers to receive an auto email (monthly), fill in the table and send it back – the gathered info should be collected automatically and recorded in the Access table columns (see under 1) through the managers replied emails. More detailed - our database is intended to: 1) Based on the query “ProgressReportQuery”, we want a form, preferably as a simple Excel-file with the table entries, sent out to the person under the column “TWApprover” in table “ProjectDefinition” for each project. The column “TWApprover” is a drop-down list from the query “PMFilter”, which is linked to the table “PeopleTable” where the emails for each person are stored. We would like a function that sends out the forms automatically once every month to the relevant emails, and lets the “TWApprover” for each project fill the “ProgressReportQuery”-entries in so that data are automatically stored in the database when sent back. 2) As an additional function, if within our budget, we would like to be able to prompt “TWApprover”s that does not fill in the form every day until it’s filled in, either through an alarm system, or through automatically resending the form.
Skills: Microsoft Access Administration Excel VBA VBA
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