Who should take the MO-500: Microsoft Access Expert Exam

The MO-500 exam test certification is an internationally recognized certification that helps to have validation for those professionals who are keen to make their career in this domain. Candidates for this exam should be familiar with work order lifecycle, capabilities for billing accounts, requirement groups concepts, and the technologies. Candidates should have some hands-on experience with resource scheduling optimization, schedule board implementation dispatch work orders. It is good for these candidates:

• Fresher
• IT Professional

Skills Measured in Microsoft MO-500 Exam

The Microsoft MO-500: Microsoft Access Expert (Access and Access 2019) exam is developed to measure the skills of the candidates in developing and sustaining the Access Database objects. These include multi-table queries, multi-level reports, data entry forms, tables, and relationships. The highlights of the topics are as follows:

• Construct & Adapt Tables

  This subject area requires that the examinees demonstrate their skills in creating tables, which includes importing data to tables, importing tables from different databases, and creating various linked tables from peripheral sources. It will also measure their competence in managing tables, covering the skills in hiding fields within tables, adding total rows, and adding table narratives. This section of the certification exam will also evaluate your expertise in managing table records as well as constructing and adapting fields.

• Adapt Reports within Layout View

  This topic focuses on equipping the learners with competence in configuring report controls, which include adding report controls, grouping and sorting fields of reports, and adding and adapting labels on reports. It will evaluate these skills as well as competence in formatting reports.

• Construct & Adapt Queries

  The candidates for the Microsoft MO-500 exam need to develop the ability to construct and run different queries. These skills should include creating simple queries, basic crosstab queries, basic parameter queries, basic action queries, and basic multi-queries as well as saving and running queries. Additionally, the applicants need to demonstrate their expertise in modifying queries.

• Manage Database

  The test takers should have the capacity to modify the structure of a database, including importing data or objects from some other sources, deleting the database objects, and displaying or hiding the objects within the Navigation Pane. This domain also requires the skills in managing keys and table relations as well as exporting and printing data.

• Adapt Forms within Layout View

  This section will evaluate your competence in configuring form controls, which requires the skills in adding, removing, and moving form controls; setting properties of form control as well as adding and adapting form labels. It will also test the capacity of the students in formatting forms, which covers the skills in adapting form positioning and tab order on forms, inserting details in form footers and headers, as well as images on forms.

The Microsoft MO-500 exam qualifies the candidates for obtaining the Microsoft Office Specialist: Microsoft Access Expert (Access and Access 2019) certification. This test focuses on their ability to develop and sustain the Access Database objects, such as data entry forms, multi-table queries, multi-level reports, tables, and relationships. To get this certificate, the students must demonstrate their skills in the appropriate applications of a variety of principal structures of Access as well as independently complete some technical tasks.

Although the Microsoft MO-500 exam is an expert-level certification exam, it does not have any compulsory requirements. However, the applicants must develop competence in the domains of this test.

Schedule exam

Languages: English, Japanese, French, Chinese (Simplified), Chinese (Traditional)

Retirement date: none

This exam measures competency in database design principles. The exam covers the ability to create and maintain Access Database objects including tables, relationships, data entry forms, multilevel reports, and multi-table queries.

Reference: https://docs.microsoft.com/en-us/learn/certifications/exams/mo-500