1. What does the Microsoft MO-500 exam certify?
The Microsoft MO-500 exam, officially known as the Microsoft Access Expert (Office 2019) certification, validates a candidate’s expertise in creating and maintaining Microsoft Access database objects. This includes proficiency with tables, relationships, data entry forms, multi-level reports, and multi-table queries, demonstrating the correct application of Access’s principal features and the ability to complete tasks independently.
2. What are the key domains covered in the exam?
The MO-500 exam assesses skills across five primary domains:
- Manage Databases: Focuses on modifying database structure, managing table keys and relationships, and exporting/printing data.
- Create and Modify Tables: Covers table creation, importing data, managing tables (including hiding fields and adding total rows), and constructing/adapting fields.
- Create and Modify Queries: Involves creating and running various queries (simple, crosstab, parameter, action, multi-queries) and modifying existing queries.
- Modify Forms in Layout View: Tests the ability to configure form controls (add, remove, move, set properties) and format forms (positioning, tab order, headers/footers, images).
- Modify Reports in Layout View: Evaluates skills in configuring report controls (add, group, sort fields, add labels) and formatting reports.
3. What is the typical duration and number of questions for the MO-500 exam?
This exam is typically designed to be completed within 50 minutes. It usually contains between 40 to 60 questions, encompassing various formats such as multiple-choice, drag-and-drop, active screen, build list, case studies, short answer, and best answer questions.
4. What is the passing score for the Microsoft MO-500 exam?
To successfully pass the exam, candidates need to achieve a scaled score of 700 or greater out of a possible 1000. It’s important to note that this is a scaled score and may not directly equate to 70% of the raw points, as it accounts for question difficulty.
5. Are there any prerequisites for taking the MO-500 exam?
While there are no strict formal prerequisites for the MO-500 exam, candidates are expected to possess strong practical experience and competence in Microsoft Access. This includes a thorough understanding of database design principles and the ability to execute tasks involving Access database objects independently. Hands-on experience with the technology is essential for success.
6. How much does it cost to take the Microsoft MO-500 exam?
The standard cost for the exam may vary, as the fee can be based on region and specific testing center policies. If a candidate does not pass on the first attempt, a new fee will be required for a retake.
7. What is the retake policy for the exam?
If a candidate does not pass the exam on the first attempt, they must wait 24 hours before retaking it. For any subsequent retakes after the second attempt, a waiting period of 14 days is required. Each retake incurs the full exam fee.
8. What are the recommended preparation resources for the MO-500 exam?
Effective preparation for the MO-500 exam typically involves a combination of resources. Candidates are advised to utilize official Microsoft learning paths, “MOS Study Guide for Microsoft Access Expert Exam MO-500” books, practice tests, and hands-on practice with Microsoft Access. Understanding the detailed skill outlines provided by Microsoft is crucial for focused study.
9. How can I register for the Microsoft MO-500 exam?
To register for the MO-500 exam, you generally start by visiting the Microsoft Learn website and navigating to the certification details page. Since this is a Microsoft Office Specialist (MOS) exam, you will typically schedule it through Certiport. You may need to sign in with your personal Microsoft account and ensure your legal name matches your identification before proceeding with the scheduling and payment process.
10. Can the MO-500 exam be taken online or only at a test center?
This exam, as a Microsoft Office Specialist (MOS) exam, is primarily scheduled through Certiport. While some Microsoft Certification exams offer both online proctored and test center options via Pearson VUE, Certiport typically handles MOS exams, and these are often taken at authorized Certiport testing centers. It’s best to verify the available delivery options directly on the Certiport website when registering.
