Exam MO-500 skills outline
Focus your studies as you prepare for the exam. Review the exam skills outline for a summary of the topics the exam covers.
Certification
Microsoft Office Specialist: Microsoft Access Expert (Office 2019)
Demonstrate that you have the skills needed to get the most out of Access 2019 by earning the Microsoft Office Specialist (MOS) Expert certification.
At a glance
-
Level
-
Product
-
Role
Jump to
Overview
As a candidate for this certification, you demonstrate your ability to apply the main features of Access 2019, such as:
- Creating and maintaining Access database objects.
- Understanding database design principles.
Examples of database objects include:
- Tables
- Relationships
- Data entry forms
- Multilevel reports
- Multi-table queries
As a candidate, you should:
- Have approximately 150 hours of instruction and hands-on experience with the product.
- Have proven competency at an industry expert-level.
- Be ready to enter the job market.
Skills measured
- Manage databases
- Create and modify tables
- Create and modify queries
- Modify forms in layout view
- Modify reports in layout view
Prepare for the exam
No training available for this exam.
Take the exam
You will have 50 minutes to complete this assessment.
Exam policy
This exam will be proctored, and is not open book. You may have interactive components to complete as part of this exam. To learn more about exam duration and experience, visit: Exam duration and exam experience.
If you fail a certification exam, don’t worry. You can retake it 24 hours after the first attempt. For subsequent retakes, the amount of time varies. For full details, visit: Exam retake policy.
Need accommodations?
We offer a variety of accommodations to support you.
This exam is offered in the following languages:
English, Japanese, French, Chinese (Simplified), Chinese (Traditional), German, Korean, Spanish
Schedule through Certiport if you are a student or an educator
Schedule exam
We strongly recommend that you register for an exam with a personal MSA account. If you register with an organizational (work/school) AAD account, your exam records will be lost if you leave your organization and they will be unrecoverable.
Price based on the country or region in which the exam is proctored.
Certification resources
Exam Replay
Boost your odds of success with this great offer.
Support for credentials
Get help through Microsoft Credentials support forums. A forum moderator will respond in one business day, Monday–Friday.
Choose your Microsoft Credential
Microsoft Applied Skills or Microsoft Certifications? Choose the path that fits your career goals, desired skillset, and schedule.