Microsoft Office Access 2019: Part 3 Training in Montpelier

Enroll in or hire us to teach our Microsoft Office Access 2019: Part 3 class in Montpelier, Vermont by calling us @303.377.6176. Like all HSG classes, Microsoft Office Access 2019: Part 3 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 3 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 manage an Access 2019 database and add complex database features to improve its usability, efficiency, performance, and security.
Course Length: 1 Days
Course Tuition: $250 (US)

Prerequisites

To ensure your success in this course, you should have experience working with Access 2019, including a working knowledge of database design and creation, form design and creation, report design and creation, and a working knowledge of database querying and the various table relationships.

Course Outline

 

Lesson 1: Importing and Exporting Table Data

 Topic A: Import and Link Data

 Topic B: Export Data

 Topic C: Create a Mail Merge

 

Lesson 2: Using Queries to Manage Data

 Topic A: Create Action Queries

 Topic B: Create Unmatched and Duplicate Queries

 

Lesson 3: Creating Complex Reports and Forms

 Topic A: Create Subreports

 Topic B: Create a Navigation Form

 Topic C: Show Details in Subforms and Popup Forms

 

Lesson 4: Creating Access Macros

 Topic A: Create a Standalone Macro to Automate Repetitive Tasks

 Topic B: Create a Macro to Program a User Interface Component

 Topic C: Restrict Records by Using a Condition

 Topic D: Create a Data Macro

 

Lesson 5: Using VBA to Extend Database Capabilities

 Topic A: Getting Started with VBA

 Topic B: Using VBA with Form Controls

 

Lesson 6: Managing a Database

 Topic A: Back Up a Database

 Topic B: Manage Performance Issues

 Topic C: Document a Database

 

Lesson 7: Distributing and Securing a Database

 Topic A: Split a Database for Multiple-User Access

 Topic B: Implement Security

 Topic C: Convert an Access Database to an ACCDE File

 Topic D: Package a Database with a Digital Signature

 

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.