MOS Access Expert

Microsoft's exam page describes the exam as measuring competency in database design principles and expects candidates to demonstrate the correct application of Access features and complete tasks independently. The page does not publish a question count or an item-type breakdown, so plan to work hands-on in Access rather than only answering recall questions.

Microsoft states that price is based on the country or region in which the exam is proctored and does not include applicable taxes, and advises confirming exact pricing with the exam provider before registering. Neither a duration nor a question count is published on the exam page, so treat those figures as unconfirmed.

Create and modify tables (25-30%) and Create and modify queries (25-30%) are the two heaviest objective groups. Manage databases is 15-20%, and Modify forms in layout view and Modify reports in layout view are 10-15% each. Build your study schedule around tables and queries first.

Start with tables and relationships, because queries, forms, and reports all depend on a sound table design. Move to multi-table queries next, then layout-view form edits, then layout-view report edits, including multilevel reports. Finish with database-management tasks such as maintaining objects and relationships.

Microsoft lists English, Japanese, French, Chinese (Simplified), Chinese (Traditional), German, Korean, and Spanish. If you plan to take the exam in a non-English language, check that the delivery language you need is offered in your region when you schedule.

Microsoft's exam page lists the retirement date for MO-500 as none, so the exam is not currently scheduled for retirement. Microsoft still advises completing an exam before any retirement date to ensure it applies toward your certification, so recheck the page before booking.

MO-500 is listed as part of the requirements for Microsoft Office Specialist: Access Expert (Office 2019). Microsoft's page also states there are no related exams for this credential, meaning this single exam is the assessed requirement listed for that certification.

Weak table design is the usual root cause: poorly defined relationships and keys break multi-table queries, forms, and multilevel reports downstream. Since tables and queries together account for roughly half the objectives, practice building normalized tables and multi-table queries until you can complete them independently and accurately.

Microsoft's page directs candidates to schedule the exam through its scheduling link and points to exam policies and FAQs for policy questions, but it does not publish a retake policy. Review those policy pages and confirm retake terms with your test provider before you sit the exam.

The exam page offers self-paced and instructor-led preparation options and states that all objectives are covered in depth in its preparation materials. Download the exam skills outline, map each objective to hands-on practice in Access, and note that no current instructor-led courses were listed for this exam.