More results...

Generic filters
Filter by Brands/Technologies

Access – Part 2 training course

Instructor‑Led: $560 | Duration: 2 Days

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.

Reserve your seat in an upcoming class date or select a Learning Method below:

Start Date End Date CLASS TIMES (EST) DELIVERY/LOCATION Status Price Enroll Now
4/7/2026 4/8/2026
11:00AM - 7:00PM
star GTR

Guaranteed-to-Run
$560.00
6/11/2026 6/12/2026
9:00AM - 5:00PM
star GTR

Guaranteed-to-Run
$560.00
START DATE : 4/7/2026
END DATE : 4/8/2026
CLASS TIMES (EST) : 11:00AM - 7:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run
PRICE : $560.00
START DATE : 6/11/2026
END DATE : 6/12/2026
CLASS TIMES (EST) : 9:00AM - 5:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run
PRICE : $560.00

Course Highlights

LEVEL: 
  • Intermediate

Access – Part 2 Course Outline

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.

PREREQUISITES

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

Related Job Roles

This course builds skills and demonstrates qualifications for the job roles and average base salaries below. 

Technical Communicator

Requirements Analyst

Narrative Writer

Medical Writer

Information Developer

Engineering Writer

Related products

  • Windows Server

    50255 Managing Windows Environments With Group Policy
    In this course, you will learn how to reduce costs and increase efficiencies in your network. You will discover how to consolidate the administration of an enterprise IT infrastructure with…Read more.
    5 days
    $595.00 - $2,795.00
    Classroom Live
    On-Demand Learning (ODL)
    Virtual Classroom
    Live, Instructor-Led (ILT)
  • SQL Server
    Data & Analytics

    55123 Writing Reports With Report Builder And SSRS Level 1
    In this course, students will continue their learning on the foundations of report writing with Microsoft SQL Server Report Builder and SSRS.Read more.
    2 days
    $595.00 - $1,230.00
    Classroom Live
    On-Demand Learning (ODL)
    Virtual Classroom
    Live, Instructor-Led (ILT)
  • SharePoint
    Apps & Infrastructure

    55238 SharePoint Online For Administrators
    Did you know that over 85% of Fortune 500 companies use SharePoint for internal collaboration? The 55238 SharePoint Online for Administrators course is your gateway to mastering SharePoint Online administration…Read more.
    3 days
    $595.00 - $1,795.00
    Classroom Live
    On-Demand Learning (ODL)
    Virtual Classroom
    Live, Instructor-Led (ILT)
  • Windows Server

    55341 Installation, Storage, And Compute With Windows Server
    This five-day course is designed primarily for IT professionals who have some experience with Windows Server. It is designed for professionals who will be responsible for managing storage and compute…Read more.
    5 days
    $595.00 - $2,795.00
    Classroom Live
    On-Demand Learning (ODL)
    Virtual Classroom
    Live, Instructor-Led (ILT)
  • Windows 11

    55342 Supporting And Troubleshooting Windows 11
    This is a 4-day ILT course that is designed to provide you with the knowledge and skills required to support and troubleshoot Windows 11 PCs and devices in an on-premises…Read more.
    4 days
    $595.00 - $2,375.00
    Classroom Live
    On-Demand Learning (ODL)
    Virtual Classroom
    Live, Instructor-Led (ILT)
  • Agile & Scrum

    Agile Fundamentals
    Agile methodologies have transformed the way organizations approach project management and product development, enabling teams to deliver value faster and more efficiently. According to recent studies, organizations that implement Agile…Read more.
    1 day
    $755.00
    Virtual Classroom
    Live, Instructor-Led (ILT)