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 5

Modify reports in Layout view

The skills tested in this section of the Microsoft Office Specialist Expert exam for Microsoft Access 365 and Microsoft Access 2019 relate to modifying and formatting reports. Specifically, the following objectives are associated with this set of skills:

5.1 Configure report controls

5.2 Format reports

You can use reports to create a filtered view of your data, to group and summarize data, and to provide data in a format that’s suitable for sharing, printing, and presentations. You configure reports and report elements by grouping and sorting records, adding controls, and adding and modifying labels. You format a report by displaying its data in multiple columns, positioning and formatting report ...