Access Intermediate – Class Outline
Lesson 1: Promoting Quality Data Input
- Topic A: Restrict Data Input Through Field Validation
- Topic B: Restrict Data Input Through Forms and Record Validation
Lesson 2: Improving Efficiency and Data Integrity
- Topic A: Data Normalization
- Topic B: Associate Unrelated Terms
- Topic C: Enforce Referential Integrity
Lesson 3: Improving Table Usability
- Topic A: Create Lookups Within a Table
- Topic B: Work with Subdatasheets
Lesson 4: Creating Advanced Queries
- Topic A: Create Query Joins
- Topic B: Create Subqueries
- Topic C: Summarize Data
Lesson 5: Improving Form Presentation
- Topic A: Apply Conditional Formatting
- Topic B: Create Tab Pages with Subforms and Other Controls
Lesson 6: Creating Advanced Reports
- Topic A: Apply Advanced Formatting to a Report
- Topic B: Add a Calculated Field to a Report
- Topic C: Control Pagination and Print Quality
- Topic D: Add a Chart to a Report