Contents – 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 from external data

Create linked tables from external sources

Import tables from other databases

Objective 2.2: Manage tables

Hide fields in tables

Add Total rows

Add table descriptions

Objective 2.3: Manage table records

Find and replace data

Sort records

Filter records

Objective 2.4: Create and modify fields

Add and delete fields

Add validation rules to fields

Modify field properties

Automate field values and formatting

3 Create and modify queries

Objective 3.1: Create and run queries

Run queries

Create select queries

Create crosstab queries

Create parameter queries

Create action queries

Create multiple-table queries

Save queries

Objective 3.2: Modify queries

Show and hide query fields

Sort data within queries

Use operators

Filter data within queries

Format fields within queries

4 Modify forms in Layout view

Objective 4.1: Configure form controls

Add and remove controls

Move controls

Set control properties

Manage labels

Objective 4.2: Format forms

Set tab order

Sort records

Control form positioning

Insert form headers and footers

Insert images

5 Modify reports in Layout view

Objective 5.1: Configure report controls

Group and sort records

Add controls to a report

Add and modify labels

Objective 5.2: Format reports

Format a report into multiple columns

Modify report positioning

Format report elements

Change report orientation

Insert information in report headers and footers

Insert images on reports

Index