MOS Study Guide for Microsoft Access Expert Exam MO-500

Contents

Introduction

Taking a Microsoft Office Specialist exam

About the Author

Exam MO-500 Microsoft Access Expert (Access and Access 2019)

Prerequisites

1 Manage databases

Objective 1.1: Modify database structure

Import objects or data from other sources

Delete database objects

Hide and display objects in the Navigation Pane

Objective 1.2: Manage table relationships and keys

Set primary keys

Understand relationships

Set foreign keys

Understand relational database models

Set relationships

Enforce referential integrity

Objective 1.3: Print and export data

Configure print options for records, forms, and reports

Export objects to alternative formats

2 Create and modify tables

Objective 2.1: Create tables

Import data into a new table

Append records ...