All Practice Exams
100+ Free MOS Access Expert Practice Questions
Microsoft Office Specialist: Access Expert (Office 2019) (Exam MO-500) practice questions are available now; exam metadata is being verified.
✓ No registration✓ No credit card✓ No hidden fees✓ Start practicing immediately
100+ Questions
100% Free
1 / 100
Question 1
Score: 0/0
A delete query is about to run against the Orders table with a criterion of OrderDate < #1/1/2020#. What is the effect when you run it?
A
B
C
D
to track
Same family resources
Explore More Microsoft Certifications
Continue into nearby exams from the same family. Each card keeps practice questions, study guides, flashcards, videos, and articles in one place.
More From This Family
Videos and articles for deeper review.
VideoFREE MD-102 Exam Guide 2026: Pass Microsoft Endpoint Administrator (Intune, Autopilot, Windows 11)VideoFREE MD-102 Exam Guide 2026: Pass Microsoft Endpoint Administrator (Intune, Autopilot, Windows 11)VideoFREE MS-102 Exam Guide 2026: Pass Microsoft 365 Administrator (Entra, Defender XDR, Purview)VideoFREE MS-102 Exam Guide 2026: Pass Microsoft 365 Administrator (Entra, Defender XDR, Purview)ArticlePL-900 Exam Guide 2026: Current Outline and Free Prep17 min readArticleFREE PL-400 Power Platform Developer Exam Guide 2026: Pass First Try16 min readArticlePL-200 2026: Pass Power Platform Functional Consultant FREE16 min readArticleIs PL-300 Worth It in 2026? Power BI Salary & Career Reality11 min read
2026 Statistics
Key Facts: MOS Access Expert Exam
~$104
Exam Voucher Fee (USD)
Certiport (varies by region)
700/1000
Passing Score
Microsoft / Certiport
50 minutes
Exam Duration
Certiport
Performance-based
Exam Format (live Access tasks)
Certiport
5 skill areas
Objective Domains (MO-500)
Certiport blueprint
Does not expire
Credential Validity
Microsoft Office Specialist program
Certiport lists Exam MO-500 (Microsoft Office Specialist: Access Expert, Office 2019) as a performance-based exam with a 700/1000 passing score, a ~$104 USD voucher fee, and a 50-minute time limit. Candidates complete live in-application tasks inside Microsoft Access rather than multiple-choice questions, and the credential does not expire. The five skill areas are Manage databases (15-20%), Create and modify tables (25-30%), Create and modify queries (25-30%), Modify forms in Layout view (10-15%), and Modify reports in Layout view (10-15%).
Sample MOS Access Expert Practice Questions
Try these sample questions to test your MOS Access Expert exam readiness. Each question includes a detailed explanation. Start the interactive quiz above for the full 100+ question experience with AI tutoring.
1In a relational database such as Microsoft Access, what is the purpose of enforcing referential integrity on a relationship between two tables?
A.It prevents creating records in a related table that reference a primary key value that does not exist in the primary table
B.It automatically compacts the database file each time it is closed
C.It encrypts the data stored in the foreign key field
D.It forces every field in both tables to be set as required
Explanation: Referential integrity ensures that relationships between records in related tables remain valid. When enforced, Access prevents adding a record to a related (child) table unless a matching value exists in the primary key of the primary (parent) table, and it blocks deletions or key changes that would orphan related records.
2Which Access feature should you use to view and edit the join lines and connections between all tables in a database at once?
A.The Navigation Pane
B.The Relationships window
C.The Object Dependencies pane
D.The Field List pane
Explanation: The Relationships window, opened from the Database Tools tab, is where you display tables and the join lines between them, set or change relationship types, and enforce referential integrity. It provides a visual map of how primary and foreign keys connect the tables.
3You want to bring data from an Excel worksheet into an existing Access database while keeping a live connection so changes in Excel are reflected in Access. Which option on the External Data tab accomplishes this?
A.Import the source data into a new table in the current database
B.Append a copy of the records to an existing table
C.Link to the data source by creating a linked table
D.Export the Access table to the Excel workbook
Explanation: Creating a linked table keeps the data in its original Excel file and maintains a live connection, so updates made in the source are visible in Access. Importing or appending copies the data into Access once, with no ongoing link.
4A field that uniquely identifies each record in a table and cannot contain duplicate or null values is known as the:
A.Foreign key
B.Lookup field
C.Index field
D.Primary key
Explanation: A primary key uniquely identifies each record in a table and cannot contain duplicate values or nulls. Access often uses an AutoNumber field as the primary key by default, and the primary key is required on the parent side of an enforced relationship.
5In a one-to-many relationship between a Customers table and an Orders table, the CustomerID stored in the Orders table is called the:
A.Foreign key
B.Primary key
C.Composite key
D.Candidate key
Explanation: The CustomerID in the Orders table is a foreign key because it refers to the primary key (CustomerID) in the Customers table. The foreign key on the many side can repeat across many order records, which is what creates the one-to-many relationship.
6You want a table object to remain in the database but no longer appear in the Navigation Pane for everyday users. What is the most direct way to do this without deleting the object?
A.Delete the object and restore it later from the Recycle Bin
B.Right-click the object and choose Hide in this Group
C.Rename the object with a leading underscore
D.Export the object to another database
Explanation: Right-clicking an object in the Navigation Pane and choosing Hide in this Group conceals it from view while keeping it in the database. You can later show hidden objects by enabling Show Hidden Objects in Navigation Options.
7Which relationship type in Access requires that you enforce referential integrity AND ensure the linking fields are uniquely indexed (or primary keys) on both sides?
A.One-to-many
B.Many-to-many
C.One-to-one
D.Self-join
Explanation: A one-to-one relationship links a single record in one table to a single record in another, which requires the joining field to be unique (a primary key or a uniquely indexed field) on both sides. Access infers the relationship type from how the joined fields are indexed.
8When enforcing referential integrity, which option allows Access to automatically update the foreign key values in related records whenever the primary key value in the parent record changes?
A.Cascade Delete Related Records
B.Require Foreign Key
C.Enforce Referential Integrity only
D.Cascade Update Related Fields
Explanation: Cascade Update Related Fields tells Access to propagate a change in the parent table's primary key to all matching foreign key values in related records. This keeps the relationship valid without manually editing every child record.
9You need to export an Access report so that the recipient sees the exact layout, fonts, and page breaks even though they do not have Access installed. Which export format best preserves the report's printed appearance?
A.PDF document (.pdf)
B.Comma-separated text file (.txt)
C.Excel workbook (.xlsx)
D.XML data file (.xml)
Explanation: Exporting a report to PDF preserves its exact layout, formatting, fonts, and page breaks, and it can be opened without Access. The PDF or XPS export option is available on the External Data tab for reports and forms.
10Before printing a datasheet, you want to set the orientation to landscape and adjust the margins. Where do you configure these settings in Access?
A.In the Relationships window
B.On the Print Preview tab via Page Setup
C.In the Navigation Options dialog
D.On the Create tab
Explanation: Opening Print Preview gives you a Print Preview tab where Page Setup lets you change orientation, margins, columns, and paper size before printing records, forms, or reports. These print options control the output without changing the underlying data.
About the MOS Access Expert Practice Questions
Verified exam format metadata for Microsoft Office Specialist: Access Expert (Office 2019) (Exam MO-500) is pending. The practice questions above remain available while official exam length, timing, passing score, fee, and administrator details are reviewed.