MS Access Advanced

Course Content

Lesson 1: Organizing a Database

1. Data Normalization
2. Create a Junction Table
3. Improve Table Structure

Lesson 2: Joining Tables

1. Create Query Joins
2. Relate Data Within a Table
3. Work with Subdatasheets

Lesson 3: Creating Advanced Queries

1. Create Parameter Queries
Summarize Data Create Subqueries Create Action Queries Create Unmatched and Duplicate Queries

Lesson 4: Using Advanced Reporting Techniques

1. Include Control Formatting in a Report
2. Add a Calculated Field to a Report
3. Add a Subreport to an Existing Report

Lesson 5: Implementing Advanced Form Design

1. Add Controls to Forms
2. Enhance Navigation and Organization of Forms
3. Apply Conditional Formatting

Lesson 6: Using Data Validation

1. Use Field Validation
2. Use Form and Record Validation

Lesson 7: Using Macros to Improve User Interface Design

1. Create a Macro
2. Restrict Records Using a Condition
3. Validate Data Using a Macro
4. Automate Data Entry Using a Macro

Lesson 8: Managing Switchboards

1. Create a Database Switchboard
2. Modify a Database Switchboard
3. Set Startup Options

Lesson 9: Using Advanced Database Management

1. Manage a Database
2. Determine Object Dependency
3. Document a Database