View Class

Overview:  Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft Office Access 2007 relational database application.

Course Duration: 1 day (9am - 5pm)

Prerequisites: A basic understanding of PCs and familiarity with the layout of a PC style keyboard, mouse and Windows is required, gained either by previous experience or by attendance of Computer Fundamentals.

Examine Database Concepts

Explore the User Interface

Use an Existing Access Database

Customizing the Access Environment

Obtain Help

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

Create a New Database

Create a Table

Manage Tables

Create a Table Relationship

Save a Database as a Previous Version

Modify Table Data

Sort Records

Work with Subdatasheets

Filter Records

Create a Query

Add Criteria to a Query

Add a Calculated Field to a Query

Perform Calculations on a Record Grouping

View Data Using an Access Form

Create a Form

Modify the Design of a Form

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

Sign Up