Microsoft Office Access 2003 Level 1

Most organizations maintain and manage large amounts of information. One of the most efficient and powerful information management computer applications is the relational database. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will be introduced to the concept of the relational database by using the Microsoft® Office Access 2003 relational database application and its information management tools.

Our reputation speaks for itself! See what others are saying... Testimonials

Package Includes:

1 DVD-ROM or 2 CDs featuring live instructor-led classroom sessions with full audio, video and demonstration components
Printable courseware
Exclusive LearningZone Live Mentor Click for Details Help whenever you need it! Exclusive LearningZone - Why wait for email support? Chat Live with our Certified Instructors anytime around the clock (24x7)
Free 1 Year Upgrade Policy

Erin Olsen - MCAS
Erin Olsen has been involved in the computer training industry for over 15 years. Erin has helped thousands of students worldwide receive quality computer training in a wide range of software titles and subject matter. Erin is a Microsoft Office Specialist Master Instructor and is MCAS certified. As a frequent Microsoft Office user as well as a trainer, Erin utilizes a practical approach in her instruction.

Course Features:

Explore our Training Features

Click on a Feature for more information! (popups must be enabled)

This slideshow requires Adobe Flash Player 9.0 (or higher). JavaScript must be enabled.

Course Introduction

Lesson 1 - An Overview of Access 2003

An Overview of Access 2003
Understanding Relational Database
Relational Databases
Access Environment Componets
Access Objects
Naming Conventions
Table Datasheet View
Table Design View
Demo - Access Tour
Lesson 1 Review

Lesson 2 - Managing Data

Managing Data
Forms
Navigation in an Access Form
Add and Delete Records
Sort Records
Display Recordsets
Update Records
Demo - Navigation
Run a Report
Demo - Reports
Lesson 2 Review

Lesson 3 - Establishing Table Relationships

Establishing Table Relationships
Identify Table Relationships
Identify Primary and Foreign Keys in the Relationships Window
Work with Subdatasheets
Example of a Subdatasheet
How to Find Data is Subdatasheets
Demo - Relationships
Lesson 3 Review

Lesson 4 - Querying the Database

Querying the Database
Create a Select Query
How to Create a Select Query
Demo - Query
Comeparison Operators
Conditional Operators
How to Add Selection Conditions to the Query
Arithmetic Operators
Access Expressions
The Expression Builder
How to Add a Calculated Field to the Query
Perform a Calculation on a Record Grouping
Demo - Conditions
Lesson 4 Review

Lesson 5 - Designing Forms

Designing Forms
AutoForms
The Form Wizard
Create a Form Using AutoForm
Create a Form Using the Form Wizard
Demo - Create Forms
Demo - Edit Forms
Controls
Lesson 5 Review

Lesson 6 - Producing Reports

Producing Reports
AutoReport
How to Create an AutoReport
How to Create a Report with Wizard
Demo - Create Reports
Report Design View
How to Examine a Report Displayed in Design View
The Toolbox
How to Apply an AutoFormat Style to a Report
Lesson 6 Review
Course Closure