Microsoft Office Access 2019: Part 1

Lesson 1: Getting Started with Access 2019

 Topic A: Launch Access and Open a Database

 Topic B: Use Tables to Store Data

 Topic C: Use Queries to Combine, Find, Filter, and Sort Data

 Topic D: Use Forms to View, Add, and Update Data

 Topic E: Use Reports to Present Data

 Topic F: Get Help and Configure Options in Microsoft Access

Lesson 2: Creating Tables

 Topic A: Plan an Access Database

 Topic B: Start a New Access Database

 Topic C: Create a New Table

 Topic D: Establish Table Relationships

Lesson 3: Creating Queries

 Topic A: Create Basic Queries

 Topic B: Perform Calculations in a Query

 Topic C: Sort and Filter Data in a Query

Lesson 4: Creating Forms

 Topic A: Start a New Form

 Topic B: Enhance a Form

Lesson 5: Creating Reports

 Topic A: Start a New Report

 Topic B: Enhance Report Layout

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