Microsoft Office Access 2019: Part 1 Training in Sterling Heights

Enroll in or hire us to teach our Microsoft Office Access 2019: Part 1 class in Sterling Heights, Michigan by calling us @303.377.6176. Like all HSG classes, Microsoft Office Access 2019: Part 1 may be offered either onsite or via instructor led virtual training. Consider looking at our public training schedule to see if it is scheduled: Public Training Classes
Provided there are enough attendees, Microsoft Office Access 2019: Part 1 may be taught at one of our local training facilities.
We offer private customized training for groups of 3 or more attendees.

Course Description

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

Prerequisites

To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites.

Course Outline

 

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

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