Learn how to use action queries, use calculated fields, adjust data types, set field properties, and perform database maintenance. You will also use input masks, use controls in forms, learn the lookup feature, and work further with queries and reports.
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