Course details

Access Level 1

Exploring the Microsoft® Office Access™ 2007 Environment

Examine Database Concepts

Explore the User Interface

Use an Existing Access Database

Customize the Access Environment

Obtain Help

Designing a Database

Describe the Relational Database Design Process

Define Database Purpose

Review Existing Data

Determine Fields

Group Fields into Tables

Normalize Data

Designate Primary and Foreign Keys

Determine Table Relationships

Building a Database

Create a New Database

Create a Table

Manage Tables

Create a Table Relationship

Save a Database as a Previous Version

Managing Data in a Table

Modify Table Data

Sort Records

Work with Subdatasheets

Querying a Database

Filter Records

Create a Query

Add Criteria to a Query

Add a Calculated Field to a Query

Perform Calculations on a Record Grouping

Designing Forms

View Data Using an Access Form

Create a Form

Modify the Design of a Form

Generating Reports

View an Access Report

Create a Report

Add a Custom Calculated Field to a Report

Format the Controls in a Report

Apply an AutoFormat Style to a Report

Prepare a Report for Print