Project Description

MS Access

Total Course Duration:60 Hours
Per Class Duration: 3 Hours

Course Overview

In this course Microsoft Access, students will learn how to use Access 2019 to manage data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

Part 1

Orientation to Microsoft Access

Create a Simple Access Database

Get Help in Microsoft Access

Modify Table Data

Sort and Filter Records

Create Lookups

Join Data from Different Tables in a Query

Sort and Filter Data in a Query

Perform Calculations in a Query

Create Parameter Queries

Create Action Queries

Create Unmatched and Duplicate Queries

Summarize Data

Create a Report

Add Controls to a Report

Enhance the Appearance of a Report

Prepare a Report for Print

Relational Database Design

Create a Table

Create Table Relationships

Create Query Joins

Join Tables That Have No Common Fields

Relate Data within a Table

Work with Subdatasheets

Create Subqueries

Data Normalization

Create a Junction Table

Improve Table Structure

Import Data into Access

Export Data to Text File Formats

Export Access Data to Excel

Create a Mail Merge

Organize Report Information

Format Reports

Include Control Formatting in a Report

Add a Calculated Field to a Report

Add a Subreport to an Existing Report


In this course, students learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access and more.

Part 2

Add Controls to Forms

Create Subforms

Organize Information with Tab Pages

Enhance Navigation of Forms

Apply Conditional Formatting

Field and Record Validation

Form Validation

Create a Macro

Restrict Records Using a Condition

Validate Data Using a Macro

Automate Data Entry Using a Macro

Convert a Macro to VBA

Link Tables to External Data Sources

Manage a Database

Determine Object Dependency

Document a Database

Analyze the Performance of a Database

Splitting a Database for Multiple User Access

Implement Security

Set Passwords

Convert an Access Database to an ACCDE File

Package a Database with a Digital Signature

Create a Database Switchboard

Modify a Database Switchboard

Set Startup Options

register now



View Profile