Access – Part 2

In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users. Focuses on optimization of an Access database, including optimizing performance and normalizing data; data validation; usability; and advanced queries, forms, and reports.

Course Details

Price:

$590.00

Days:

Location:

Virtual

Course Overview

Provide input validation features to promote the entry of quality data into a database. Organize a database for efficiency and performance, and to maintain data integrity. Improve the usability of Access tables. Create advanced queries to join and summarize data. Use advanced formatting and controls to improve form presentation. Use advanced formatting and calculated fields to improve reports.

Access – Part 1 or equivalent experience.

1 – IMPROVING TABLE USABILITY

Topic A: Create Lookups Within a Table
Topic B: Work with Subdatasheets

2 – CREATING ADVANCED QUERIES

Topic A: Create Query Joins
Topic B: Create Subqueries
Topic C: Summarize Data

3 – IMPROVING FORM PRESENTATION

Topic A: Apply Conditional Formatting
Topic B: Create Tab Pages with Sub forms and Other Controls

4 – 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

5 – IMPORTING AND EXPORTING TABLE DATA

Topic A: Import and Link Data
Topic B: Export Data
Topic C: Create a Mail Merge

6 – USING QUERIES TO MANAGE DATA

Topic A: Create Action Queries
Topic B: Create Unmatched and Duplicate Queries

7 – CREATING COMPLEX REPORTS AND FORMS

Topic A: Create Sub reports
Topic B: Create a Navigation Form
Topic C: Show Details in Sub forms and Popup Forms

8 – 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

9 – USING VBA TO EXTEND DATABASE CAPABILITIES

Topic A: Getting Started with VBA
Topic B: Using VBA with Form Controls

10 – MANAGING A DATABASE

Topic A: Back Up a Database
Topic B: Manage Performance Issues
Topic C: Document a Database

11 – 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

Class Dates & Times


07/28/2025 - 07/29/2025 Virtual 09:00:00 to 17:00:00 EST Enroll Now $590.00
09/11/2025 - 09/12/2025 Virtual 09:00:00 to 17:00:00 EST Enroll Now $590.00
10/27/2025 - 10/28/2025 Virtual 09:00:00 to 17:00:00 EST Enroll Now $590.00
12/11/2025 - 12/12/2025 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 →