Microsoft Office Access 2019: Part 2 Training in Calexico, California

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 Tables

 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

Appendix A: Mapping Course Content to Access Expert (Office 365 and Office 2019): Exam MO-500

Appendix B: Microsoft Office Access 2019 Common Keyboard Shortcuts