MOS Study Guide for Microsoft Access Expert Exam MO-500

Advance your everyday proficiency with Access 2019. And earn the credential that proves it!
Demonstrate your expertise with Microsoft Access! Designed to help you practice and prepare for Microsoft Office Specialist (MOS): Access 2019 certification, this official Study Guide delivers:

• In-depth preparation for each MOS objective
• Detailed procedures to help build the skills measured by the exam
• Hands-on tasks to practice what you’ve learned
• Practice files and sample solutions

Sharpen the skills measured by these objectives:

• Create and manage databases
• Build tables
• Create queries
• Create forms
• Create reports

About MOS
A Microsoft Office Specialist (MOS) certification validates your proficiency with Microsoft Office programs, demonstrating that you can meet globally recognized performance standards. Hands-on experience with the technology is required to successfully pass Microsoft Certification exams.

Table of Contents

1 Manage databases

Objective 1.1: Modify database structure

Objective 1.2: Manage table relationships and keys

Objective 1.3: Print and export data

2 Create and modify tables

Objective 2.1: Create tables.

Objective 2.2: Manage tables

Objective 2.3: Manage table records

Objective 2.4: Create and modify fields

3 Create and modify queries

Objective 3.1: Create and run queries

Objective 3.2: Modify queries

4 Modify forms in Layout view

Objective 4.1: Configure form controls

Objective 4.2: Format forms

5 Modify reports in Layout view

Objective 5.1: Configure report controls

Objective 5.2: Format reports

If you find an error, you can report it to us through our Submit errata page.