Access 2002: Getting Started

« back to previous page

Description:	This course is designed to familiarize you with Access for Windows. It includes tasks such as creating, saving and printing Access tables. The student will also learn how to add records, query the database, delete records, and design a simple report.
Prerequisites:	Windows 2000 or equivalent experience
Length:	One day

Working with a Relational Database
• Identify Uses of a Relational Database
• Define Database Terminology
• Explore an Access Database
• Create a New Database Based on a Template
• Examine the New Database

Planning a Database
• Identify Database Purpose
• Review Existing Data
• Determine Fields
• Group Fields into Tables
• Normalize the Data
• Designate Primary and Foreign Keys
• Identify Table Relationships

Building the Basic Structure
• Create a Blank Database
• Create a Table using a Wizard
• Compare Datasheet and Design Views
• Create Tables in Design View
• Create Relationships between Tables

Working with Tables
• Modify a Table Design
• Work in Datasheet View
• Work with Subdatasheets

Creating and Working with Select Queries
• Examine a Query
• Create a Query using a Wizard
• Create a Query in Design View
• Select Records
• Edit Values in a Query Datasheet
• Add a Calculated Field to a Query
• Perform a Calculation for a Group of Records
• Join Tables in a Query

Creating and using Forms
• Create AutoForms
• Create a Form using a Wizard
• Modify the Design of the Form
• Work with Controls
• Use a Form to Work with Data

Creating and Using Reports
• Create an AutoReport
• Create a Report Using a Wizard
• Examine a Report in Design View
• Create a Report that Includes a Summary Calculation
• Create a Calculated Field
• Change the Format of a Control
• Change the Format of a Report
• Adjust Report Width

Summary and Review