Loading demo links...
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.