Microsoft Access

In this course, students examine database objects in Microsoft Access and learn to manage data in a database.

myAOLCC Hub (Online)
Beginner, Intermediate
Access Level 1: 27 Hours
Access Level 2: 30 Hours
What you'll learn
  • Defining Access Databases
  • Exploring the Access Environment
  • Introducing Objects and Exiting
  • Designing and Normalizing
  • Linking Tables
  • Creating Tables
  • Retrieving Data
  • Form Design and Creation
  • Modifying Form Controls
  • Printing and Using Help
  • Modifying Form Layout
  • Creating Select Queries
  • Setting Query Criteria
  • Sorting and Performing Calculations
  • Creating Special Types of Queries
  • Designing Reports
  • Modifying Reports
  • Exploring Other Report Tools
  • Printing Reports
  • Creating and Modifying Relationships
  • Modifying Table Structures
  • Formatting A Table Datasheet Layout
  • Setting Field Properties
  • Setting Lookup Fields With the Lookup Wizard
  • Creating a Main Form with a Subform
  • Adding Calculations to Forms
  • Setting Properties to Assist and Control Data Entry
  • Identifying Advanced Query Features
  • Creating a Calculated Field in a Query
  • Creating and Running Parameter Queries
  • Creating and Running Action Queries
  • Customizing Reports
  • Adding a Subreport to a Main Report
  • Creating a Report from a Subreport
  • Numbering Items in a Report
  • Creating Calculated Controls on a Subreport
  • Setting Page Breaks and Customizing Controls
  • Analyzing Report Performance
  • Set Access Options
  • Splitting a Database
  • Customizing the Database Interface
  • Integrating Access with Excel and Word
  • Displaying Access Data on the Web
  • Compacting and Repairing
  • Database Security
  • Creating Macros

Course Introduction

The Microsoft Access course teaches students the fundamentals of the Microsoft Access application.

In this course, students examine database objects and learn to manage data in a database. They learn to sort and filter data, display and format data, and use simple queries to retrieve data. Students learn to create and modify databases and tables and work with simple forms and reports.

Students accomplish the learning objectives for each module through a series of hands-on tasks, for which they are given step-by-step instructions and desired result checkpoints. The tasks provide ample opportunity for students to practice, apply, and develop the skills covered in the course.

A practice exercise and review questions are included at the end of each module to measure progress and reinforce the skills learned. There is also a lab exercise at the end of the course to provide further practice and review to reinforce the topics learned throughout the course, and to help prepare students for the exam.

Course Prerequisites

Introduction to Windows course, or equivalent.

Course Outline

Microsoft Access Level 1

Lesson 1:

Defining Access Databases; Exploring the Access Environment; Introducing Objects and Exiting

Lesson 2:

Designing and Normalizing; Linking Tables; Creating Tables; Retrieving Data

Lesson 3:

Form Design and Creation; Modifying Form Controls; Printing and Using Help; Modifying Form Layout

Lesson 4:

Creating Select Queries; Setting Query Criteria; Sorting and Performing Calculations; Creating Special Types of Queries

Lesson 5:

Designing Reports; Modifying Reports; Exploring Other Report Tools; Printing Reports

Microsoft Access Level 2

Lesson 1:

Creating and Modifying Relationships; Modifying Table Structures; Formatting A Table Datasheet Layout; Setting Field Properties; Setting Lookup Fields With the Lookup Wizard

Lesson 2:

Creating a Main Form with a Subform; Adding Calculations to Forms; Setting Properties to Assist and Control Data Entry

Lesson 3:

Identifying Advanced Query Features; Creating a Calculated Field in a Query; Creating and Running Parameter Queries; Creating and Running Action Queries

Lesson 4:

Customizing Reports; Adding a Subreport to a Main Report; Creating a Report from a Subreport; Numbering Items in a Report; Creating Calculated Controls on a Subreport; Setting Page Breaks and Customizing Controls; Analyzing Report Performance

Lesson 5:

Set Access Options; Splitting a Database; Customizing the Database Interface

Lesson 6:

Converting Files; Attaching Files; Integrating Word; Integrating Access on the Excel; Displaying Access Data on the Web

Lesson 7:

Improving and Maintaining; Database Objects; Analyzing and Documenting; Compacting and Repairing; Database Security; Cloud Storage; Creating Macros

Course Notes

There is a final exam upon completion of the course. Participants who receive 75% or higher on their exam will receive a certificate.

Get Started Today!
Request FREE Information

Have Questions?

Click the button below to schedule an online info session with an Admissions Advisor.

Online Info Session

Ready to Start?

Apply Now