Access 2003 Essentials CBT Course

Scroll down to: Intermediate Level | Advanced Level

Access 2003:Beginning Level

1.0 Introduction
1.1 Starting Access
1.2 The Access Window, Menu Bar, Tool Bars and Task Pane
1.3 Help in Access
1.4 Creating a Database – Fields, Properties, and Datasheet View
1.5 Copying Databases

2.0 Working with an Existing Database
2.1 Viewing & Navigating Table Data
2.2 Widening Datasheet Columns and Editing Table Data
2.3 Adding Records to a Table
2.4 Selecting & Deleting Records
2.5 Find & Replace
2.6 Modifying the Appearance of a Datasheet
2.7 Spell-Check & Auto-correct

3.0 Form Basics
3.1 Using a Form Wizard and Moving from Record to Record
3.2 Finding Data
3.3 Sorting Data
3.4 Filtering Data
3.5 AutoForms

4.0 Report Basics
4.1 AutoReports & the Report Wizard
4.2 Zooming In & Out
4.3 Moving from Page to Page
4.4 Viewing Multiple Pages
4.5 Printing

Access 2003:Intermediate Level

1.0 Planning & Designing a Database
1.1 Evaluating Inputs & Outputs
1.2 Normalization
1.3 Creating a Database Using a Wizard
1.4 Creating a Database from Scratch

2.0 Building & Modifying Tables
2.1 Creating Tables Using a Wizard
2.2 Creating Tables without the Use of a Wizard
2.3 Setting Primary Keys
2.4 Field Properties
2.5 Input Masks
2.6 The Lookup Wizard
2.7 Indexes

3.0 Working with Relationships
3.1 Introduction to Relationships
3.2 Types of Relationships
3.3 Referential Integrity
3.4 Indexes & Relationships
3.5 Printing Relationships

Access 2003:Advanced Level

1.0 Designing Simple Queries
1.1 Selecting Fields
1.2 Ordering the Query Result & Refining Queries with Criteria
1.3 Updatability of Query Results
1.4 Queries Based on Multiple Tables

2.0 Building & Modifying Forms
2.1 Adding Controls
2.2 Selecting Controls
2.3 Moving, Sizing, & Deleting Controls
2.4 Aligning Controls
2.5 Changing Control Properties
2.6 Changing the Tab Order Controls
2.7 Form Properties
2.8 Working with Combo Boxes & List Boxes

3.0 Building & Modifying Reports
3.1 Understanding Report Bands

3.2 Working with Controls
3.3 Creating Groups & Total Reports
3.4 Working with Report Properties
3.5 Modifying Selection Criteria

4.0 Managing Databases
4.1 Identify Object Dependencies
4.2 View Objects and Object Data in Other Views
4.3 Import Data to Access
4.4 Export data from Access
4.5 Create and Modify Calculated Fields and Aggregate Functions
4.6 Create a Data Access Page
4