Overview
On Site
Contract - Independent
Contract - W2
Skills
Database Migration
Scripting
Documentation
User Guides
Training
Quality Assurance
Testing
Data Integrity
Collaboration
Migration
MDB
Database
Microsoft Office
Microsoft Access
Forms
Macros
VBA
Database Design
Normalization
Optimization
Microsoft SQL Server
Finance
Accounting
Marketing
Legal
Customer Support
Online Training
Artificial Intelligence
Insurance
.NET
Job Details
Description
We are seeking a skilled Microsoft Access Database Developer Consultant for a 3-month contract to lead the upgrade of our legacy Microsoft Access database from .mdb to .accdb format and support the transition from Office 2013 to Office 2019. The ideal candidate will have extensive experience in Microsoft Access development, database migration, and Office suite upgrades, ensuring a seamless transition with minimal disruption to operations.
Key Responsibilities
Database Migration:
o Analyze the existing .mdb database structure, forms, queries, macros, and VBA code.
o Upgrade the database to .accdb format, ensuring compatibility with Microsoft Access 2019.
o Identify and resolve any deprecated features or compatibility issues during the migration.
o Optimize database performance and implement best practices for the .accdb format.
Office Upgrade Support:
o Collaborate with IT teams to support the transition from Office 2013 to Office 2019.
o Test and validate database functionality in the Office 2019 environment.
o Update or rewrite VBA code, macros, and scripts to ensure compatibility with Office 2019.
Documentation and Training:
o Document the migration process, including any changes to database structure or code.
o Provide user guides or training materials for end-users to adapt to the updated database.
o Train internal staff on new features or changes resulting from the upgrade.
Testing and Quality Assurance:
o Conduct thorough testing of the migrated database to ensure data integrity and functionality.
o Troubleshoot and resolve any issues related to the database or Office upgrade.
Stakeholder Collaboration:
o Work closely with project managers, IT staff, and end-users to gather requirements and ensure alignment with business needs.
o Provide regular updates on project progress and escalate issues as needed.
Requirements
Qualifications
Experience:
o 5+ years of experience in Microsoft Access database development and administration.
o Proven track record of successfully migrating .mdb databases to .accdb format.
o Experience with Office suite upgrades, particularly from Office 2013 to newer versions.
Technical Skills:
o Expertise in Microsoft Access (versions 2013-2019), including forms, queries, reports, macros, and VBA programming.
o Strong understanding of database design, normalization, and optimization techniques.
o Familiarity with SQL Server integration or other backend systems is a plus.
o Knowledge of Office 2019 compatibility and feature differences from Office 2013.
Technology Doesn't Change the World, People Do.
Robert Half is the world's first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.
Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app and get 1-tap apply, notifications of AI-matched jobs, and much more.
All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information.
2025 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking "Apply Now," you're agreeing to Robert Half's Terms of Use.
We are seeking a skilled Microsoft Access Database Developer Consultant for a 3-month contract to lead the upgrade of our legacy Microsoft Access database from .mdb to .accdb format and support the transition from Office 2013 to Office 2019. The ideal candidate will have extensive experience in Microsoft Access development, database migration, and Office suite upgrades, ensuring a seamless transition with minimal disruption to operations.
Key Responsibilities
Database Migration:
o Analyze the existing .mdb database structure, forms, queries, macros, and VBA code.
o Upgrade the database to .accdb format, ensuring compatibility with Microsoft Access 2019.
o Identify and resolve any deprecated features or compatibility issues during the migration.
o Optimize database performance and implement best practices for the .accdb format.
Office Upgrade Support:
o Collaborate with IT teams to support the transition from Office 2013 to Office 2019.
o Test and validate database functionality in the Office 2019 environment.
o Update or rewrite VBA code, macros, and scripts to ensure compatibility with Office 2019.
Documentation and Training:
o Document the migration process, including any changes to database structure or code.
o Provide user guides or training materials for end-users to adapt to the updated database.
o Train internal staff on new features or changes resulting from the upgrade.
Testing and Quality Assurance:
o Conduct thorough testing of the migrated database to ensure data integrity and functionality.
o Troubleshoot and resolve any issues related to the database or Office upgrade.
Stakeholder Collaboration:
o Work closely with project managers, IT staff, and end-users to gather requirements and ensure alignment with business needs.
o Provide regular updates on project progress and escalate issues as needed.
Requirements
Qualifications
Experience:
o 5+ years of experience in Microsoft Access database development and administration.
o Proven track record of successfully migrating .mdb databases to .accdb format.
o Experience with Office suite upgrades, particularly from Office 2013 to newer versions.
Technical Skills:
o Expertise in Microsoft Access (versions 2013-2019), including forms, queries, reports, macros, and VBA programming.
o Strong understanding of database design, normalization, and optimization techniques.
o Familiarity with SQL Server integration or other backend systems is a plus.
o Knowledge of Office 2019 compatibility and feature differences from Office 2013.
Technology Doesn't Change the World, People Do.
Robert Half is the world's first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.
Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app and get 1-tap apply, notifications of AI-matched jobs, and much more.
All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information.
2025 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking "Apply Now," you're agreeing to Robert Half's Terms of Use.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.