Student? Switch to our Career Center Site →
Contact Us

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.
Select Class Date
Course Details

Price:

$590.00

Days:

2

Location:

Virtual

Course Overview

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.
  • Scroll right to view Objectives, Prerequisites, and Agenda

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 – Preparing Data & Creating PivotTables

  • Prepare Data
  • Create a PivotTable from a Local Data Source
  • Create a PivotTable from Multiple Local Data Sources
  • Create a PivotTable from an External Data Source

2 – Analyzing Data Using PivotTables

  • Summarize PivotTable Data
  • Organize PivotTable Data
  • Filter PivotTable Data
  • Format a PivotTable
  • Refresh and Change PivotTable Data

3 – Working with PivotCharts

  • Create a PivotChart
  • Manipulate PivotChart Data
  • Format a PivotChart
Select Class Date
Class Dates & Times
Filters Sort results
Reset Apply
02/16/2026 - 02/17/2026
Virtual
09:00:00 to 17:00:00 EST
Enroll Now
$590.00
04/07/2026 - 04/08/2026
Virtual
11:00:00 to 19:00:00 PST
Enroll Now
$590.00
06/11/2026 - 06/12/2026
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.