Extend your knowledge of relational databases with our Access 2 course. See how data relationships are formed and learn how to optimize your database. Gain exposure to more advanced techniques to locate the data you want and build reports to display it.
Recommended Preparation: Access 1
Module 1: Data Structure and Integrity
- Restrict Data Input through Field Validation
- Restrict Data Input through Forms and Record Validation
- Data Normalization
- Associate Unrelated Tables
- Enforce Referential Integrity
- Create Lookups within a Table
- Work with Subdatasheets
Module 2: Intermediate Data Retrieval
- Create Query Joins
- Create Subqueries
- Summarize Data
- Apply Conditional Formatting
- Create Tab Pages with Subforms and Other Controls
- Apply Advanced Formatting to a Report
- Add a Calculated Field to a Report
- Control Pagination and Print Quality
- Add a Chart to a Report
“Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.”
