Microsoft Access 2002 (XP) - Core

Overview

Create databases using Microsoft Access 2002 (XP) and learn and understand the concepts of database design.

Target Audience

This course is aimed at users who have little or no experience using Microsoft Access 2002 (XP), users who have used other database applications (like FileMaker) and wish to convert to Access or users who have used previous version of Access and wish to brush up on the new features in this version.

Prerequisites

It is essential that course participants have successfully completed a Windows Introductory course, or have gained a similar level of knowledge within the work environment. Specifically participants need to be fully conversant in:

  • Basic Keyboarding (Shift, Caps Lock, Ctrl etc).
  • Basic Windows Operating System Navigation.
  • Mouse Skills.

Objectives

Upon completion users will be able to:

  • Understand the concepts of a database and create, edit and view a database.
  • Interrogate the database to extract specific information.
  • Produce standard Forms and Reports.

Duration

2 days.

Course Content

Introduction to Access

  • Understanding Database Concepts
  • Working with the Access Screen Layout
  • Using Menus and Toolbars
  • Opening, Saving and Closing Databases
  • Using the Office Assistant

Table Design

  • Working with Tables
  • Using the Table Wizard
  • Switching between Table Views
  • Editing the Table Design
  • Using the Undo Feature
  • Using the Lookup Wizard
  • Using the Input Mask Wizard

Entering and Editing Table Data

  • Entering and Editing Data in the Datasheet
  • Moving Around a Table
  • Selecting Fields and Records in a Datasheet
  • Spell Checking and Table Formatting
  • Finding and Replacing Information
  • Sorting and Filtering Data

Relationships

  • Understanding and Creating Relationships
  • Understanding Referential Integrity and Normalisation
  • Printing Database Relationships

Importing Data into Tables

  • Adding Records from Another Access Table
  • Importing and Exporting Data

Understanding File Procedures

  • Database and Object File Operations
  • Printing Database Objects
  • Creating a Shortcut

Querying Data

  • Understanding Queries
  • Creating a Query
  • Calculating Fields and Summary Calculations
  • Using Expression Builder

Working with Forms

  • Using , Viewing and Editing Forms
  • Creating a Form with Multiple Pages or Tabs
  • Using Filters

Working with Reports

  • Using, Viewing, Editing and Enhancing a Report

Back



 
 
 

Download

Download this profile here.
 

What's Next?

Learn to automate databases with Macros and create custom Reports and Forms for more impact
Microsoft Access 2002 (XP) Expert
 

Also Available

Microsoft Access 2002 (XP) VBA