Course length:  1-day

Course Description

Microsoft’s Office Access is Microsoft’s popular database program.  Microsoft Access is an information management tool that allows you to store, report, and analyze information within a relational database. If you're trying to use Excel to manage large amounts of information, then chances are Microsoft Access will be helpful to you. Access makes it easy to keep track, organize, and sort your data.

The Foundation (Level 1) Course is designed to help all novice computer users get up to speed on the program quickly. The class will also help more experienced users with previous Access versions to understand the ribbon interface.

Highlights of the course include a complete overview of the ribbon interface; information on getting started with databases; creating and using tables, forms, queries, and reports; and information on printing and viewing data in different ways.

 

Prerequisites

Before attending this course, students must have:

Basic computer knowledge

Basic file management skills

Basic Excel knowledge is helpful

 

Course Outline

The Basics

Navigating in an Access Database

Understanding Table Relationships

Working with Tables and Records

Formatting Tables in Datasheet View

Creating Forms

Creating Reports

Creating Basic Queries

Customizing the Interface

Certification

Before testing you will need:

  • Access Level 1 Foundation
  • Access Level 2 Intermediate
  • Access Level 3 Advanced

Wondering if you should start with Level 1?

Take our class placement self-assessment to help you decide.