ECDL Module 5 Database Using Access 2000

2 Day Course
Code ECDLMI10

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

Modules

Course contents include: (44 topics)

  • The Access 2000 Environment
  • Understanding the Database Concept
  • Using the Office Assistant
  • Working with the 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 in Datasheet View
  • Editing Table Data
  • Using the AutoCorrect Feature
  • Spell Checking
  • Changing the Table Appearance
  • Finding 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
  • Understanding File Procedures
  • Working with Database File Operations
  • Using Object File Operations
  • Printing Database Objects
  • Creating a Shortcut
  • Querying in Access 2000
  • Understanding Queries
  • Creating a Query
  • Using Query Examples
  • Working with 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
  • Working with Reports
  • Using, Creating and Viewing Reports
  • Editing and Enhancing Reports
  • Creating Calculated Fields

Prerequisites

A knowledge of the Windows 95 environment is assumed. Delegates with no knowledge of Windows 95 should attend Windows 95 Introductory Level prior to this course.

or call:408-759-5074

Course PDF

Print

Sections