Course Code:12.01
Course Subject:Access Introduction
Course Title:Access 2003 Introduction
Aims:To provide the student with the skills to create sophisticated Access Databases.
Introduction:This course builds on the basics of Database creation and management, extending knowledge of Tables, Queries, Forms and Reports. New topics include Pivot Tables, Pivot Charts, importing and exporting data and using the Expression Builder.
  

Objectives

The learner will be able to:

Assessment Criteria

The learner has achieved this objective because he/she can:

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. Work with Standard Reports

  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