Access 2000 - Level 1 Training Class

Lesson 1: Overview of Access 2000

Introduction to Database Concepts and Terminology
Introduction to Access 2000
Database Planning and Design

Lesson 2: Creating tables

Examining a Table
Creating a Table With the Table Wizard
Creating a Table in Design View
Types of Primary Keys

Lesson 3: Working with tables

Modifying a Table Using Design View
Finding and Editing Records
Filtering and Sorting Records

Lesson 4: Creating and Using Select Queries

Creating a Select Query to View Specific Fields
Specifying Criteria in a Query to View Specific Records
Using Queries to Perform Calculations
Joining Tables in a Query

Lesson 5: Creating and Using Forms

Creating a Form With the Form Wizard
Modifying the Form Design
Using a Form to Locate and Organize Information
Multiple-Table Forms

Lesson 6: Creating and Using Reports

Creating a Report With the Report Wizard
Creating a Report That Contains Totals

Lesson 7: Creating and Maintaining a Database

Creating a Database
Managing a Database and Its Objects
Database Maintenance

Lesson 8: Principles of Table Design

Normalizing Data
Normalizing Data for Fourth and Fifth Normal Forms

Lesson 9: Principles of Table Relationships

Analyzing Table Relationships
Establishing and Testing Referential Integrity

Lesson 10: Table Design Techniques

Data Validation Techniques
Indexing Techniques

Lesson 11: Designing Select Queries

Using Calculated Fields in Queries
Creating Multiple-Table Queries

Lesson 12: Customizing Form Designs

Customizing the Form Design
Performing Calculations on a Form
Adding Combo Boxes to a Form
Adding Unbound Controls

Lesson 13: Working with Data Access Pages

Creating Data Access Pages
Integrating with Other Applications

Lesson 14: Customizing Reports

Customizing a Report Created by the Report Wizard
Working with Subreports
Creating a Report in Design View