MOS1.4. Access Advanced (English)

---

1 Create and manage databases

Objective 1.1 Create and modify databases

• 1.1.1 Create databases
• 1.1.2 Import database objects and data
• 1.1.3 Delete database objects

Objective 1.2 Manage relationships and keys

• 1.2.1 Create and modify relationships
• 1.2.2 Set key fields

Objective 1.3 Navigate through a database

• 1.3.1 Navigate specific records
• 1.3.2 Create and modify navigation forms
• 1.3.3 Set a form as the startup option
• 1.3.4 Display objects in the Navigation Pane
• 1.3.5 Change object views

Objective 1.4 Protect and maintain databases

• 1.4.1 Compact and repair databases
• 1.4.2 Back up and restore databases
• 1.4.3 Split a database
• 1.4.4 Encrypt database files

Objective 1.5 Print and export data

• 1.5.1 Print reports and records
• 1.5.2 Save a database as a template
• 1.5.3 Export data

---

2 Build tables

Objective 2.1 Create tables

• 2.1.1 Create tables
• 2.1.2 Create linked tables
• 2.1.3 Create a table from a template by using application parts

Objective 2.2 Manage tables

• 2.2.1 Hide fields in tables
• 2.2.2 Add Total rows
• 2.2.3 Add table descriptions
• 2.2.4 Rename tables

Objective 2.3 Manage records in tables

• 2.3.1 Add, update, and delete records
• 2.3.2 Append records from external data
• 2.3.3 Find, sort, and filter data

Objective 2.4 Create and modify fields

• 2.4.1 Add and delete fields
• 2.4.2 Add validation rules to fields
• 2.4.3 Modify field properties
• 2.4.4 Automate field values and formatting

---

3 Create queries

Objective 3.1 Create queries

• 3.1.1 Run queries
• 3.1.2 Create select queries
• 3.1.3 Create crosstab queries
• 3.1.4 Create parameter queries
• 3.1.5 Create action queries
• 3.1.6 Create multiple-table queries
• 3.1.7 Save queries

Objective 3.2 Modify queries

• 3.2.1 Rename queries
• 3.2.2 Change the fields in a query
• 3.2.3 Show and hide query fields
• 3.2.4 Specify the sort order for queries
• 3.2.5 Format fields in a query

Objective 3.3 Create calculated fields and grouping within queries

• 3.3.1 Use calculated fields
• 3.3.2 Set filter criteria
• 3.3.3 Group and summarize query records
• 3.3.4 Group data by using operators

---

4 Create forms

Objective 4.1 Create forms

• 4.1.1 Create quick forms
• 4.1.2 Create forms by using the Form Wizard
• 4.1.3 Create forms from scratch
• 4.1.4 Create forms from templates by using application parts
• 4.1.5 Save forms

Objective 4.2 Configure form controls

• 4.2.1 Move controls
• 4.2.2 Add and remove controls
• 4.2.3 Set control properties
• 4.2.4 Modify data sources
• 4.2.5 Manage labels
• 4.2.6 Create subforms

Objective 4.3 Format forms

• 4.3.1 Set tab order
• 4.3.2 Configure print settings
• 4.3.3 Sort records
• 4.3.4 Apply themes to forms
• 4.3.5 Control form positioning
• 4.3.6 Modify the background of a form
• 4.3.7 Insert form headers and footers
• 4.3.8 Insert images

---

5 Create reports

Objective 5.1 Create reports

• 5.1.1 Use the Report Wizard
• 5.1.2 Create reports from scratch

Objective 5.2 Configure report controls

• 5.2.1 Group and sort records
• 5.2.2 Modify data sources
• 5.2.3 Add controls to a report
• 5.2.4 Add and modify labels

Objective 5.3 Format reports

• 5.3.1 Apply page setup options
• 5.3.2 Add a calculated field
• 5.3.3 Format report elements
• 5.3.4 Add information to report headers and footers

---