Access Intermediate – Class Outline
Unit 1: Designing a Relational databases
- Topic A: Relational database design
- Topic B: Create a table
- Topic C: Create table relationships
Unit 2: Joining tables
- Topic A: Create Query joins
- Topic B: Relate data within a table
- Topic C: Work with Subdatasheets
Unit 3: Using data validation
- Topic A: Use field validation
- Topic B: Use form and record validation
Unit 4: Creating Advanced Queries
- Topic A: Create parameter queries
- Topic B: Summarize data
- Topic C: Create subqueries
- Topic D: Create Action queries
- Topic E: Create unmatched and duplicate queries
Unit 5: Organizing a database for efficiency
- Topic A: Data normalization
- Topic B: Create a junction table
- Topic C: Improve table structure
Unit 6: Using Advanced Reporting Techniques
- Topic A: Including control formatting in a report
- Topic B: Add a calculated field to a report
- Topic C: Add a subreport to an existing report