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 4

Modify forms 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 forms. Specifically, the following objectives are associated with this set of skills:

4.1 Configure form controls

4.2 Format forms

The datasheet is a reasonable tool if you are entering only one or two records, but if you are entering a dozen records or even a hundred, you need to leave the datasheet behind and use the Access data-entry tool of choice: the form. A form is a collection of controls—usually labels and text boxes, but also lists, check boxes, and option buttons—each of which represents either a field or the name of a field. ...