12.01. Access 2003 Introduction

1. Design Tables

1. Normalise Data
2. Establish Relationships
3. Work with Indexes 
4. Work with Data Types

2. Design Queries

1. Create Action Queries
2. Create Parameter Queries
3. Create Calculated Columns in Queries
4. Join Tables

3. Design Forms

1. Create Data Entry Forms
2. Work with Sub-Forms
3. Create Pop-Up Forms
4. Work with Switchboards

4. Design Reports

1. Work with Standard Reports
2. Work with Pop-Up Reports
3. Work with Sub-Reports
4. Work with Report Snapshots
5. Develop Data Access Pages

5. Work with Pivot Tables and Pivot Charts

1. Create Pivot Tables and Pivot Charts
2. Create Pivot Table Forms
3. Create Pivot Chart Forms

6. Import and export Data

1. Link to external Data sources
2. Import Data into Access
3. Export Data from Access

7. Build Expressions

1. Use the Expression Builder
2. Use common Built-in Functions

12.02. Access 2003 Intermediate

1. Navigate Access

1. Understand Access
2. Create Files
3. Open and close Database Files
4. Access the 2003 Workspace
5. Use the Database Toolbar
6. Use the Task Pane
7. Use the Database window

2. Create and work with Tables

1. Create Tables
2. Work with Tables

3. Create and work with Queries

1. Create Queries
2. Work with Queries

4. Create and manage Forms

1. Use and create Forms
2. Display and link Images

5. Create and manage Reports

1. Create and use Reports
2. Save maintain and print Reports