Free MO-500 practice test
MO-500 is the Microsoft Access Expert (Office 2019) certification exam. This page gives you the full exam breakdown, how scoring works, and free unlimited practice weighted to the official skills outline. No paywall, no attempt caps.
MO-500 exam at a glance
| Fact | Detail |
|---|---|
| Certification | Access Expert (Office 2019) (MO-500) |
| Level | Expert |
| Track | Office |
| Format | About 50 questions in 50 minutes |
| Passing score | 700 out of 1000 (scaled) |
| Typical prep time | 8–12 weeks of consistent study |
| Question types | Multiple choice, drag-and-drop, case studies, and short scenarios |
Advanced, for subject-matter experts with deep real-world experience. Most candidates who pass spend 8–12 weeks mixing official Microsoft Learn reading with hands-on practice. The MO-500 practice test on this page mirrors the real exam's domain weights, so your score here is a good estimate of your readiness.
How the MO-500 exam is scored
Microsoft scores every certification exam on a scale of 1 to 1000, and you need 700 to pass. This is a scaled score, not a percentage: the number of questions you must answer correctly shifts slightly with each exam form so that a 700 always represents the same level of ability. There is no penalty for guessing, so answer every question even if you are unsure. Unanswered questions are always marked wrong.
Your score report groups results by the skill areas below. A fail in one area with strong scores elsewhere still fails the exam overall, so use your report to target the weakest area first before rebooking.
Skills measured on MO-500
Microsoft publishes an official skills outline that lists every MO-500 topic area and its exam weight. The practice test here draws questions from each area in proportion to these weights.
| Skill area | Exam weight | Questions in a 50-question exam | What to expect |
|---|---|---|---|
| Manage databases | ~17% | 9 of 50 | Expect governance, identity, and protection tasks that show up as scenario questions. |
| Create and modify tables | ~27% | 14 of 50 | Expect core feature knowledge and day-to-day configuration skills. |
| Create and modify queries | ~27% | 14 of 50 | Expect core feature knowledge and day-to-day configuration skills. |
| Modify forms in layout view | ~12% | 6 of 50 | Expect core feature knowledge and day-to-day configuration skills. |
| Modify reports in layout view | ~12% | 6 of 50 | Expect core feature knowledge and day-to-day configuration skills. |
What the MO-500 exam covers
In plain terms, the exam checks whether you can do the job the certification describes. MO-500 covers Manage databases — about 17% of the exam; Create and modify tables — about 27% of the exam; Create and modify queries — about 27% of the exam; Modify forms in layout view — about 12% of the exam; Modify reports in layout view — about 12% of the exam. Treat this as a study checklist: work through each area until you can explain its tasks to a colleague without notes.
How to study for MO-500
A simple four-step plan works for most candidates and fits inside 8–12 weeks:
- Read one domain at a time. Work through the official Microsoft Learn content for that domain before touching anything else. The weights above tell you where to spend the most time.
- Check yourself with untimed practice. Take a free MO-500 Readiness Check on this page. It asks questions from every domain in official proportion, so your domain-by-domain score shows exactly where you are weak.
- Drill the weak domains. Repeat short practice sets on your two weakest areas until both score comfortably above 70%.
- Finish with a timed simulation. Rehearse the real format — 50 questions in 50 minutes — so pacing holds no surprises on test day.
Repeat the cycle until every domain is green. Candidates who follow it usually reach passing level inside 8–12 weeks of part-time study.
Start your free MO-500 practice
The MO-500 practice page offers unlimited free practice weighted to this exact outline. No signup is needed to take a Readiness Check; a free account saves your history so you can watch your domain scores improve over time.
Frequently asked questions about MO-500
What topics are on the MO-500 (Access Expert (Office 2019)) exam?
The exam is weighted to Microsoft's official skills outline and covers: Manage databases, Create and modify tables, Create and modify queries, Modify forms in layout view, Modify reports in layout view. MS Exam Lab generates practice questions for each domain so your score reflects real readiness.
How hard is the MO-500 exam?
Advanced, for subject-matter experts with deep real-world experience. Most candidates study 8–12 weeks of focused, hands-on prep.
How long does it take to study for MO-500?
Plan for roughly 8–12 weeks of consistent study, mixing official Microsoft Learn material with hands-on practice on MS Exam Lab.
What is the pass score for MO-500?
Microsoft uses a scaled score of 700 out of 1000 to pass MO-500. Practice with domain-weighted questions on MS Exam Lab to find and close gaps before test day.
Is there free MO-500 practice on MS Exam Lab?
Yes. MS Exam Lab offers free, unlimited MO-500 practice weighted to the official skills outline, with no paywall and no attempt caps. Timed exam simulations are available on the low-cost Pro tier.
More Microsoft certifications to practice
Sources: compiled from Microsoft's official skills outlines (Microsoft Learn). Maintained and kept current by the MS Exam Lab team.