Exam MO-500: Microsoft Access Expert (Office 2019)
Exam MO-500: Microsoft Access Expert (Office 2019) assesses your ability to create and manage Access Database objects, including tables, relationships, data entry forms, multi-level reports, and multi-table queries. To pass the exam, candidates must demonstrate their understanding of the principal features of Access and demonstrate their ability to complete tasks independently.
Exam Details: Exam MO-500
| Exam Name Microsoft Access Expert (Office 2019) | Exam Code M0-500 |
| Exam Language English, Japanese, Spanish, German, Chinese (Simplified), French, Korean | Exam Fee $100 USD |
Schedule Your Exam
Follow the steps below to schedule your Microsoft certification exam –
- Go to the Microsoft portal, to register yourself
- Click on “Schedule Exam” to schedule an exam date at your convenience
- Fill in all your details asked on the next page that appears
- Select the exam delivery option on the Pearson VUE page
- Pay your exam fees. You have successfully registered for the MO-500 Exam
Exam Retake Policy
If anyhow you are not able to achieve a passing score in the Microsoft MO-500 exam. However, you will have to wait for a minimum of 24 hours before you become eligible for a retake. Failure in the second attempt will result in a waiting time of 14 days before rescheduling your third attempt. The waiting period for the fourth and fifth attempts will also be 14 days. All candidates are allowed a maximum of five attempts per year.
Exam Cancellation Policy
Microsoft offers candidates to cancel or reschedule their exams within a minimum of 24 hours prior to the exam date. However, to prevent any cancellation fee, you must cancel or reschedule your exam, at least 6 business days prior to the date scheduled for your exam. Also, if you fail to appear in the exam, you will not receive any refund of the fee.
Recertification Policy
Microsoft certification is expected to expire when the products are out of mainstream support although the person’s certificate will be recognized.
Exam Result
Right after successfully completing your Exam MO-500: Microsoft Access Expert (Office 2019), you will be notified of your pass or fail status within a few minutes of completing your exam. Also, printed reports providing your exam score and feedback on your performance will also be provided to you. Your score will be forwarded to Microsoft within five business days.
For More Details See: Exam MO-500: Microsoft Access Expert (Office 2019)
Course Outline – Exam MO-500: Microsoft Access Expert (Office 2019)
The Exam MO-500: Microsoft Access Expert (Office 2019) covers the following domains:
Manage databases
Modify database structure
- • import objects or data from other sources
- • delete database objects
- • hide and display objects in the Navigation Pane
Manage table relationships and keys
- • understand relationships
- • display relationships
- • set primary keys
- • enforce referential integrity
- • set foreign keys
Print and export data
- • configure print options for records, forms, and reports
- • export objects to alternative formats
Create and Modify tables
Create tables
- • import data into tables
- • create linked tables from external sources
- • import tables from other databases
Manage tables
- • hide fields in tables
- • add total rows
- • add table descriptions
Manage table records
- • find and replace data
- sort records
- filter records
Create and modify fields
- • add and remove fields
- • add validation rules to fields
- • change field captions
- • change field sizes
- • change field data types
- • configure fields to auto-increment
- • set default values
- • apply built-in input masks
Create and modify queries
Create and run queries
- • create simple queries
- • create basic crosstab queries
- • create basic parameter queries
- • create basic action queries
- • create basic multi-table queries
- • save queries
- • run queries
Modify queries
- • add, hide, and remove fields in queries
- • sort data within queries
- • filter data within queries
- • format fields within queries
Modify forms in layout view
Configure form controls
- • add, move, and remove form controls
- • set form control properties
- • add and modify form labels
Format forms
- • modify tab order on forms
- • sort records by form field
- • modify form positioning
- • insert information in form headers and footers
- • insert images on forms
Modify reports in the layout view
Configure report controls
- • group and sort fields on reports
- • add report controls
- • add and modify labels on reports
Format reports
- • format a report into multiple columns
- • modify report positioning
- • format report elements
- • change report orientation
- • insert information in report headers and footers
- • insert images on reports
Preparation Guide for Exam MO-500: Microsoft Access Expert (Office 2019)
Get Familiar with the Exam Objectives
Going through the course outline can help you better understand what the exam is all about. Furthermore, you’ll learn how to manage your time, what you need to accomplish, and how to accomplish it. Regularly checking the official website throughout the course will ensure you’re up-to-date on any changes. In the Exam MO-500, the following topics are covered:
- Manage databases (15-20%)
- Create and modify tables (25-30%)
- Create and modify queries (25-30%)
- Modify forms in layout view (10-15%)
- Modify reports in layout view (10-15%)
Microsoft Official Study Guide for Microsoft Access Expert Exam MO-500
This official Study Guide delivers:
- In-depth preparation for each MOS objective
- Detailed procedures to help build the skills measured by the exam
- Hands-on tasks to practice what you’ve learned
- Practice files and sample solutions
Microsoft Press Books
While studying for the exam, Microsoft provides reference books that can be helpful. There are various useful resources in these books that can be used during the study process. Get a deeper understanding of the exam objectives by visiting Microsoft Press books, and you will find books that will help you crack the test and earn your certification.
- Microsoft Access 2013 Inside Out – by Jeff Conrad
- Microsoft Access 2013 Step by Step – by Joan Lambert, Joyce Cox
Join Microsoft Community/ Online Forum
There is always something positive to be gained from a healthy discussion, wherever it takes place. Involving more people increases the odds of getting a resolution to an issue. A variety of viewpoints also adds to the dynamic of the content. It is through these discussions that the studies become more comprehensive. Forums are great for building a community that helps us understand one another.
Practice Tests
You can benefit greatly from a practice run or two no matter how you prepare for Exam MO-500: Microsoft Access Expert (Office 2019). Practice tests are a great way to ensure the best results on your real test by diversifying your study strategy. It will also allow you to determine whether you align with the exam objectives by analyzing your answers.
