Build mastery in advanced database capabilities, including table relationship management, sophisticated query development, data validation processes, field computation, data type configuration, field settings optimization, and system maintenance best practices. Learn input mask application, form control utilization, lookup functionality, and comprehensive approaches to queries and reporting.
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
