book

MOS Study Guide for Microsoft Access Expert Exam MO-500

by Paul Maloo

April 2020

Intermediate to advanced

192 pages

3h 55m

English

Microsoft Press

Read now

Unlock full access

Who this book is forHow this book is organizedDownload the practice filesAdapt procedure stepsEbook editionErrata, updates, & book supportStay in touch
Microsoft Office Specialist certificationSelecting a certification pathTest-taking tipsCertification benefitsFor more information
Prerequisites
Objective 1.1: Modify database structureObjective 1.2: Manage table relationships and keysObjective 1.3: Print and export data
Objective 2.1: Create tablesObjective 2.2: Manage tablesObjective 2.3: Manage table recordsObjective 2.4: Create and modify fields

Objective 3.1: Create and run queriesObjective 3.2: Modify queries
Objective 4.1: Configure form controlsObjective 4.2: Format forms
Objective 5.1: Configure report controlsObjective 5.2: Format reports

Content preview from 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 ...