Integrity Training – Microsoft Office Access 2016 Intermediate

Using Data Validation (1:58)

Topic A: Use Field Validation (0:10)

Field Validation (1:50)

Field Properties (0:54)

Input Masks (0:37)

Input Mask Wizard (0:30)

Demo – Validating Data by Using a Field Property (6:10)

Demo – Validating Data by Using an Input Mask (4:03)

Topic B: Use Form and Record Validation (0:08)

The Combo Box Wizard (0:55)

List Box Control (0:41)

Option Group Control (1:09)

Demo – Using a Combo Box Control to Limit Option Values (5:59)

Demo – Using a Record Validation Rule (4:48)

Chapter 03 Review (0:31)

Chapter 03 Quiz

Creating Advanced Queries (1:25)

Topic A: Create Parameter Queries (0:09)

A Parameter Query Displays a Prompt (1:59)

Demo – Creating a Parameter Query (3:05)

Demo – Using Wildcards in a Parameter Query (3:18)

Demo – Creating a Query with Multiple Parameters (2:05)

Topic B: Summarize Data (0:06)

Crosstab Query Wizard (1:50)

Analyzing Customer Payments (0:56)

Demo – Creating a Crosstab Query (3:07)

Topic C: Create Subqueries (0:09)

Subquery Example (1:22)

Subquery Expression Example (0:56)

Demo – Creating Subqueries (4:45)

Topic D: Create Action Queries (0:08)

Action Query Update Expression (1:07)

Demo – Creating Action Queries (4:09)

Topic E: Create Unmatched and Duplicate Queries (0:05)

Find Unmatched Query Wizard (1:08)

Find Duplicates Query Wizard (0:17)

Demo – Creating Queries to Search for Unmatched and Duplicate Records (3:56)

Chapter 04 Review (0:48)

Chapter 04 Quiz

Organizing a Database for Efficiency (0:36)

Topic A: Data Normalization (0:09)

First Normal Form (2:01)

Second Normal Form (1:07)

Third Normal Form (0:56)

Denormalization (0:59)

Table Analyzer Wizard (0:25)

Demo – Running the Table Analyzer Wizard (3:18)

Topic B: Create a Junction Table (0:08)

Junction Table (1:15)

Demo – Using a Junction Table to Resolve a Many-to-Many Relationship (2:56)

Topic C: Improve Table Structure (0:07)

Demo – Improving Table Structure (4:52)

Chapter 05 Review (0:35)

Chapter 05 Quiz

Using Advanced Reporting Techniques (0:32)

Topic A: Include Control Formatting in a Report (0:06)

Data Bars (0:57)

Demo – Adding Data Bars to a Report (2:34)

Topic B: Add a Calculated Field to a Report (0:08)

Demo – Adding a Calculated Field to a Report (4:25)

Topic C: Add a Subreport to an Existing Report (0:09)

Demo – Adding a Subreport to an Existing Report (6:48)

Chapter 06 Review (0:29)

Chapter 06 Quiz

Course Closure (1:19)