Access – Part 1

Professionals using advanced query design techniques complete complex data retrieval tasks up to 40% faster and with greater accuracy than those relying only on basic tools. The Microsoft Access Training – Access Part 2 course equips you with the advanced features, queries, reports, and relational design practices, that make this level of efficiency possible. In this course, you will expand your knowledge of relational database design, promote quality input from users, and learn how to improve database efficiency while strengthening data integrity. You’ll also implement advanced features in tables, queries, forms, and reports, giving you the ability to build databases that are more reliable, usable, and scalable. The training focuses on optimization of Access databases, including performance tuning, normalizing data, applying data validation rules, and improving usability.

Course Details

Price:

$590.00

Days:

Location:

Course Overview

After completing this Microsoft Access training course, you will be able to: Navigate within the Access environment, create a simple database, and customize options. Organize and manage data stored within Access tables. Use queries to join, sort, and filter data across multiple tables. Design forms to simplify data entry and review. Create and format custom reports for professional output. Apply validation techniques to ensure data accuracy and integrity.

Basic computer literacy Basic PC operating system navigation skills Basic Internet usage skills Basic IP address knowledge

Getting Started with Access

Launch Access and open a database
Use tables to store data
Use queries to combine, find, filter, and sort data
Use forms to view, add, and update data
Use reports to present data

Creating Tables

Plan an Access database
Start a new Access database
Create a new table
Establish table relationships

Creating Queries

Create basic queries
Perform calculations in a query
Sort and filter data in a query

Creating Forms

Start a new form
Enhance a form

Creating Reports

Start a new report
Enhance report layout

Promoting Quality Data Input

Restrict data input through field validation
Restrict data input through forms and record validation

Improving Efficiency and Data Integrity

Data normalization
Associate unrelated tables
Enforce referential integrity

Microsoft Copilot Chat in Action

What Is Microsoft Copilot Chat?
The Magic Prompt Formula
Work Smarter with AI

Class Dates & Times


06/01/2026 - 06/02/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $590.00
08/06/2026 - 08/07/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $590.00
10/01/2026 - 10/02/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $590.00
11/30/2026 - 12/01/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $590.00

— Questions?

Information Request

— Empower Change

Invest in Skills & Equality

Support Diversity, Equity, and Inclusion with Every Purchase.

Great Horizons is a North Carolina Certified HUB Vendor and WOSB. By becoming a patron of our organization, you are not only supporting a historically underutilized business, but a woman-owned small business as well.

Student? Switch to our Career Center Site →