Access 2003 Level 1

1 Day Course
Hands On
Code DAC03L1

This course has been retired. Please view currently available User Microsoft Office Training Courses.

Modules

Hide all

An Overview of Access 2003 (4 topics)

  • Relational Databases
  • Access Environment
  • The Database Environment
  • Examine an Access Table

Establishing Table Relationships (3 topics)

  • Identify Table Relationships
  • Identify Primary and Foreign Keys in the Relationships Window
  • Working with Subdatasheets

Querying the Database (4 topics)

  • The Select Query
  • Add Criteria to a Query
  • Add a Calculated Field to a Query
  • Perform a Calculation on a Record Grouping

Managing Data (6 topics)

  • Examine an Access Form
  • Add and Delete Records
  • Sort Records
  • Display Record Sets
  • Update Records
  • Run a Report

Designing Forms (4 topics)

  • Form Design Guidelines
  • Create AutoForms
  • Create a Form Using the Form Wizard
  • Modify the Design of a Form

Producing Reports (7 topics)

  • Create an AutoReport
  • Create a Report by Using the Wizard
  • Examine a Report in Design View
  • Add a Calculated Field to a Report
  • Modify the Format Properties of a Control
  • AutoFormat a Report
  • Adjust the Width of a Report

Prerequisites

To ensure the successful completion of Microsoft Access 2003: Level 1 we recommend completion of one of the following or equivalent knowledge from another source: Windows 2000: Introduction, Windows XP: Introduction, Windows XP: Level 1, Windows XP: Level 2

Sections