Access 2003: Getting Started

« back to previous page

Description:	This course is designed to familiarize you with Access for Windows. It includes learning such tasks managing data in a database, examining existing table relationships, querying the database and designing simple forms. In addition, you will learn how to create and modify Access reports.
Prerequisites:	Basic Windows knowledge or equivalent experience
Length:	One day

An Overview of Access 2003
• Relational Databases
• The Access Environment
• The Database Environment
• Examine an Access Table

Managing Data
• Examine an Access Form
• Add and Delete Records
• Sort Records
• Display Record Sets
• Update Records
• Run a Report

Establishing Table Relationships
• Identify Table Relationships
• Identify Primary and Foreign Keys in the Relationships
Window
• Working with Subdatasheets

Querying the Database
• The Select Query
• Add Criteria to a Query
• Add a Calculated Field to a Query
• Perform a Calculation on a Records Grouping

Designing Forms
• Form Design Guidelines
• Create AutoForms
• Create a Form Using the Form Wizard
• Modify the Design of a Form

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