Microsoft Access Level 2

Course Length

1 Day

Target Student

Prerequisites

Participants should have taken Access Level 1 or have equivalent knowledge.

Delivery Model

Hands-on, instructor led, group-paced, classroom learning. The pace of class is based on the participants' previous computer experience and class expectations. Questions are welcome and encouraged!

Course Outline

Queries
Creating a Query
Query Join Properties
Summarizing Groups of Records
Expressions and the Expression Builder
Display Top or Bottom Values
Find Duplicate Records
Find Unmatched Records
Crosstab Queries
Update Queries
Delete Queries
Append Queries
Make-Table Queries
Other Topics
Back up a Database
Import Data
Export Data
Linking Data from an External Source
Display Database Object Dependencies
Set a Database Password
Add a Folder to a Trusted Location
Compact and Repair a Database

Also Includes

  • Detailed class/reference book
  • Certificate of completion