MOS Study Guide for Microsoft Access Expert Exam MO-500

Objective group 1

Manage databases

The skills tested in this section of the Microsoft Office Specialist Expert exam for Microsoft Access 365 and Microsoft Access 2019 relate to managing database structure, relationships, printing, and exporting. Specifically, the following objectives are associated with this set of skills:

1.1 Modify database structure

1.2 Manage table relationships and keys

1.3 Print and export data

Every Access database exists within a larger ecosystem of objects, including tables, queries, forms, and reports. Mastering database management requires knowing not only how to import data into Access, but also how to work with and create sophisticated relationships between objects.

This chapter guides you in studying methods for ...