One Day Courses - Microsoft Access 2003 Level 1

Microsoft Access 2003 Module I

Course Length

Access 2003 Module I is a one day course.

Prerequisites

This course assumes a basic knowledge of the Microsoft Windows operating environment and the fundamental skills validated by the Internet and Computing Core
Certification (IC3).

Brief Description

This course
provides competency in creating databases and tables, working with table
data and field properties, working with related tables and using filters
and queries.

Guided,
step-by-step labs provide opportunities to practice new skills. You can
challenge yourself and reinforce your skills after each lesson in the Lesson
Summary and Lesson Review sections, and the Activities and Optional Labs.
Additional skill review is provided in Lesson Quizzes and a Course Assessment
that are available from your instructor.

Cost:

The cost of this course is just £125 per person

Topics

Creating Databases and Tables

Introduction to Access

Database Components

Relational Database Design

Starting Access

Database Window Layout and Features

Database Creation

Creating Tables

Modifying Table Design

Working with Table Data and Field Properties

Overview of Table Data and Field Properties

Modifying Datasheet Layouts

Working with Table Records

Importing Data into Tables

Modifying Field Properties

Working with Related Tables

Overview of Table Relationships

Establishing Relationships

Enforcing Referential Integrity

Creating Lookup Fields

Using Lookup Fields to Add Data

Using Filters and Queries

Overview of Filters and Queries

Using Comparison Operators

Using Filters

Creating Select Queries

Refining Query Results

Using Criteria in Select Queries

Modifying Select Queries

Performing Calculations in Queries

Creating and Modifying Crosstab Queries

Creating and Modifying Unmatched Queries

Creating and Modifying Duplicate Queries