Microsoft Office Access 2019: Part 2 Training

We offer private customized training for groups of 3 or more attendees.

Course Description

 
In this course, you will optimize an Access 2019 database.
Course Length: 1 Days
Course Tuition: $250 (US)

Prerequisites

To ensure your success in this course, it is recommended you have completed Microsoft Office Access 2019: Part 1 or possess equivalent knowledge.

Course 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 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

Course Directory [training on all levels]

Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.