HBI College Course Outline - Access 2003

Microsoft Access 2003 - Level 1

COURSE DESCRIPTION

This database programming tool will help you simplify complicated frameworks. In this course you will learn the basics of the database environment, how to manage data, establish table relationships, query data, design forms and produce reports.

PREREQUISITES

Computer Basics

CORE TOPICS
An Overview of Access 2003		Designing Forms
Understand relational databases Examine the Access environment Open the database environment Examine an Access table		Examine form design guidelines Create a form using AutoForm Create a form using the Form Wizard Modify the Design of a Form
Managing Data		Producing Reports
Examine an Access form Add and delete records Sort records Display recordsets Update records Run a report		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
Establishing Table Relationships		Querying the Database
Identify table relationships Identify primary and foreign keys in the relationships windows Work with subdatasheets		Create a select query Add criteria to a query Add a calculated field to a query Perform a calculation on a record grouping

Your partner in customized corporate education.

Call 905 949 9900 Extension 2474
to talk about your training needs,
or email
corporatetraining@hbicollege.com

Microsoft Access 2003 - Level 1

PREREQUISITES

Designing Forms