Exam MO-500: Microsoft Access Expert (Office 2019) Practice Test
MO-500 practice focuses on advanced Microsoft Access database work: structuring tables, choosing field types and properties, building queries, and presenting data through forms and reports. The available practice bank includes scenarios involving validation rules, calculated controls, sort order, record limits, report sections, and database copies. These tasks call for understanding how Access objects and their settings affect stored data and user workflows.
Exam overview
About the Exam MO-500: Microsoft Access Expert (Office 2019) Exam
Effective Access work depends on matching each requirement to the right object or property. Table design involves selecting suitable types for dates, long text, and identifiers, then applying validation to restrict permitted values. Queries can sort records and limit the returned set, while forms provide a user-facing view that can apply its own record order and display calculated values without storing them. Reports require deliberate placement of content, such as information that should appear only once at the start of the report. Access also supports automation through macros for sequences such as opening a form and displaying a message. Database maintenance decisions include creating a separate backup before structural changes. Practice with these scenarios can help sharpen the distinction between data definition, retrieval, presentation, and automation choices in Access.
Sample Practice Questions
Review a selection from this exam's published US Practice Tests practice bank.
You are designing a table to store each employee’s date of hire. Which field data type is most appropriate?
Show answer
Correct answer: ADate/Time is intended for storing dates and times, including an employee’s hire date.
You need to make a backup copy of an Access database before changing its structure. Which action creates a separate copy while leaving the current database available?
Show answer
Correct answer: ASaving or copying the database file creates a separate backup. Compact and Repair operates on the database rather than serving as a backup-copy method.
When designing a report, which section is appropriate for information that should print once at the beginning of the entire report?
Show answer
Correct answer: BThe Report Header prints at the beginning of the report, typically once. The Detail section repeats for records, while page and group footers serve different repeated-summary purposes.
A table has a field containing values such as “North”, “South”, and “West”. Which field property can make Access reject values outside that set?
Show answer
Correct answer: AA Validation Rule can restrict the values accepted in a field. For this example, a rule such as In ("North","South","West") would limit entries to the listed values.
Which Access feature can automatically perform a sequence of actions, such as opening a form and displaying a message, without writing VBA code?
Show answer
Correct answer: AAn Access macro consists of actions that automate tasks and can be triggered by events or run directly. It provides a way to automate common operations without writing VBA code.
In a query, you want to show only the first 10 records after sorting them by a score field from highest to lowest. Which query property controls the maximum number of returned records?
Show answer
Correct answer: AThe Top Values property limits how many records a query returns, such as the top 10. Sorting by the score in descending order determines which records rank among those returned.
A form should open with its records arranged by LastName in ascending order without changing the underlying table. Which form property is most relevant?
Show answer
Correct answer: BThe form's Order By property specifies the sort expression for records displayed on the form. It changes presentation order, not the stored table data.
How to use this practice test
The free US Practice Tests practice bank contains 50 MO-500 questions. Each session presents up to 20 questions selected at random, then shows your results. Use the session to identify which Access decisions need more attention, such as choosing a field type, setting query behavior, or configuring form and report properties.
Preparation tips
- For table-design scenarios, compare the field’s purpose with Access types such as Date/Time, Long Text, and Replication ID, and consider how validation rules constrain entries.
- Distinguish query sorting and record limits from form-level sorting; identify whether a requested change affects retrieved records or only their presentation.
- Practice locating report sections by when content should print, especially content shown once for the entire report versus content tied to a group or record.
- For form calculations, identify when an unbound calculated control is appropriate instead of storing a derived value in a table.
- Review how Access macros sequence interface actions, and how a separate database copy supports safe structural changes.