Free MO-500 – Microsoft Access Expert (Access and Access 2019) Practice Test Question

Free demo downloads

Loading demo links...

Showing 1–10 of 10 questions

Question 1 (Manage databases)

Which command reduces database file size and fixes minor corruption?

Select an option, then click Submit answer.

  • ○ Database Tools > Compact and Repair Database
  • ○ Database Tools > Encrypt with Password
  • ○ File > Save As > Repair
  • ○ External Data > Compact

Ask AI for More Explanation

— your own AI account, opens inside the app

About the MO-500 Free Practice Test

This page holds a free practice test for the Microsoft Access Expert (Access and Access 2019) (MO-500) certification from Microsoft. You will find 10 free questions, drawn from the full Study4Pass practice set of 78 questions for this exam. The questions follow the same topic balance as the real exam: Manage databases; Create and modify tables; Create and modify queries; Modify forms in Layout view; Modify reports in Layout view.

How to use this MO-500 free practice test

Pick an answer for each question and check it straight away — the correct answer and a full explanation appear under the question. There is no time limit and nothing to sign up for. When an explanation is not enough, use Ask AI: this is an AI-Enabled practice test, and Ask AI explains the concept behind the question in plain language. Ready for more? The full 78-question set adds a timed Exam Simulation mode, topic training for your weak areas, and a flagged-question review.

What to study for each MO-500 domain

Manage databases

Modify database structure, manage relationships and primary/foreign keys, work with linked tables, print database objects and export data to other formats.

Key skills

Create and modify relationships, set primary and foreign keys, link external data, compact and repair, export objects and data

Create and modify tables

Import data into tables, create and restructure tables, set field properties and data types, add validation rules and input masks, and create calculated fields.

Key skills

Import from Excel and text files, set field properties, validation rules and input masks, indexing, calculated and lookup fields

Create and modify queries

Build select, parameter, action and multi-table queries, add criteria and joins, group and summarise data, and add calculated fields to queries.

Key skills

Inner and outer joins, criteria and wildcards, aggregate and grouped queries, parameter queries, update/append/delete/make-table queries, subqueries

Modify forms in Layout view

Add and arrange controls on forms in Layout view, set control properties and tab order, add calculated controls and format forms for data entry.

Key skills

Bound and unbound controls, combo and list boxes, tab order, calculated controls, form headers and formatting

Modify reports in Layout view

Group and sort report data in Layout view, add calculated fields and totals, and format report sections, headers and footers for multilevel reports.

Key skills

Grouping and sorting, aggregate calculations, report headers and footers, page setup, conditional formatting

MO-500 practice test — quick questions

Is this MO-500 practice test free?

Yes — the 10 questions on this page are completely free, with no signup and no payment details needed.

How many questions are in the full MO-500 set?

78 questions. The 10 free questions above are a sample of that full set, in the same style and topic balance.

Does the free test show the answers?

Yes — every question shows the correct answer with an explanation, and Ask AI can explain the concept behind a question in plain words if you want to go deeper.

Practice Tests Related to MO-500