Introduction
Presentation
Courses

Introduction
Module 1
Module 2
Module 3
Module 4
Module 5
Module 6
Module 7

Access 2000 Introduction:

Course Code: ECDLLSL05

Duration: 1day

 

Course aimed at:

This course is designed for new users of Access 2000 who have some PC and windows experience.

 

Previous knowledge required:

Knowledge of Windows environment is assumed.

 

 

Course Contents:

Using the Office Assistant

 

The Access Environment

  • Understanding the Database Concept
  • The Access Screen Layout
  • Using Menus and Toolbars

 

Table Design

  • Working With Tables
  • Using the Table Wizard
  • Switching Between Table Views
  • Editing the Table Design
  • Using the Undo Feature

 

Entering and Editing Table Data

  • Entering Data in the Datasheet
  • Moving Around a Table
  • Selecting Fields and Records
  • Editing Table Data
  • Using the AutoCorrect Feature
  • Spell Checking Feature
  • Changing the Table Appearance
  • Searching for and Replacing Information
  • Sorting and Filtering Data in a Table

 

Importing Objects and Data into Tables

  • Inserting an OLE Object
  • Adding Records from Another Access Table
  • Importing and Linking Data

File Procedures

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

 

Queries

  • Querying in Access 2000
  • Creating a Query
  • Using Query Wizards
  • Using Query Examples
  • Calculated Fields
  • Summary Calculations
  • Using the Expression Builder Action Queries
  • Joining tables in Queries

 

Forms

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

 

Reports

  • Using, Creating and Viewing Reports
  • Editing and Enhancing Reports
  • Creating Calculated Fields