CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

APAC031 - Microsoft Office Access 2003 Introduction

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

Students will be introduced to the features of the Access 2003 application and will design and create a new Access database; improve queries, forms, and reports; and integrate Microsoft Office Access 2003 with other applications.

Click here for a printer-friendly version of this page

Prerequisites

Basic knowledge of Windows

Detailed Class Syllabus

Lesson 1: An Overview of Access 2003

Understand Relational Databases

Examine the Access Environment

Open the Database Environment

Examine an Access Table

Lesson 2: Managing Data

Examine an Access Form

Add and Delete Records

Sort Records

Display Recordsets

Update Records

Run a Report

Lesson 3: Establishing Table Relationships

Identify Table Relationships

Identify Primary and Foreign Keys in the Relationships Window

Work with Subdatasheets

Lesson 4: Querying the Database

Create a Select Query

Add Criteria to a Query

Add a Calculated Field to a Query

Perform a Calculation on a Record Grouping

Lesson 5: Designing Forms

Examine Form Design Guidelines

Create a Form Using AutoForm

Create a Form Using the Form Wizard

Modify the Design of a Form

Lesson 6: Producing Reports

Create an AutoReport

Create a Report by Using the Wizard

Examine a Report in Design View

Add a Calculated Field to a Report

Modify the Format Properties of a Control

AutoFormat a Report

Adjust the Width of a Report

Lesson 7: Planning a Database

Design a Relational Database

Identify Database Purpose

Review Existing Data

Determine Fields

Group Fields into Tables

Normalize the Data

Designate Primary and Foreign Keys

Lesson 8: Building the Structure of a Database

Create a New Database

Create a Table Using a Wizard

Create Tables in Design View

Create Relationships between Tables

Lesson 9: Controlling Data Entry

Restrict Data Entry with Field Properties

Create an Input Mask

Create a Lookup Field

Lesson 10: Finding and Joining Data

Find Data with Filters

Create Query Joins

Join Unrelated Tables

Relate Data Within a Table

Lesson 11: Creating Flexible Queries

Set Select Query Properties

Create Parameter Queries

Create Action Queries

Lesson 12: Improving Your Forms

Enhance the Appearance of a Form

Restrict Data Entry in Forms

Add Command Buttons

Create a Subform

Lesson 13: Customizing Your Reports

Organize Report Information

Set Report Control Properties

Control Report Pagination

Summarize Information

Add a Subreport to an Existing Report

Create Mailing Labels

Lesson 14: Expanding the Reach of Your Data

Publish Access Data as a Word Document

Analyze Access Data in Excel

Export Data to a Text File

Merge Access Data with a Word Document