More results...

Generic filters
Filter by Brands/Technologies

Access – Part 2

Instructor‑Led: $590 | Duration: 2 Days

Upgrade your tech skills with this , training course from TechSherpas 365!

Select a Learning Method Below

Start Date End Date CLASS TIMES (EST) DELIVERY/LOCATION Status Price Enroll Now
2/16/2026 2/17/2026
9:00AM - 5:00PM
star GTR

Guaranteed-to-Run
$590
4/7/2026 4/8/2026
11:00AM - 7:00PM
star GTR

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

Guaranteed-to-Run
$590
START DATE : 2/16/2026
END DATE : 2/17/2026
CLASS TIMES (EST) : 9:00AM - 5:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run
PRICE : $590
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 : $590
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 : $590

Course Highlights

LEVEL: 
  • Intermediate
TOPICS & JOB ROLES: 
BRANDS/TECHNOLOGIES: 

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. 

No results found.

Explore Related Training Courses

Related products

  • End User Application

    Visio – Part 2
    Microsoft Apps
    Intermediate
    Microsoft? Visio? stands out among similar applications because of its unique ability to draw a wide variety of diagrams, flowcharts, workflows, and organization structures?anything that can be represented by shapes…
    1 Day(s)
    $395
    Virtual Classroom
    Live, Instructor-Led (ILT)
  • End User Application

    Word – Part 1
    Microsoft Apps
    Beginner
    In this course, you’ll learn how to use Word on the desktop to create and edit simple documents; format documents; add tables and lists; add design elements and layout options;…
    1 Day(s)
    $295
    Virtual Classroom
    Live, Instructor-Led (ILT)
  • End User Application

    Word – Part 2
    Microsoft Apps
    Intermediate
    Creating professional-looking documents can help you give your organization a competitive edge. Implementing time-saving features such as document templates and automated mailings helps your organization reduce expenses. Mastering these techniques…
    1 Day(s)
    $295
    Virtual Classroom
    Live, Instructor-Led (ILT)
  • End User Application

    Word – Part 3
    Microsoft Apps
    Advanced
    Microsoft Word enables you to do far more than simple word processing. Word includes advanced image manipulation tools, collaboration features, cross-referencing and linking tools, entry forms and data collection, security…
    1 Day(s)
    $295
    Virtual Classroom
    Live, Instructor-Led (ILT)

What Our Students Are Saying

IT Certification Training Course Reviews