By using our website you agree to our use of cookies.

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.
User ECDL Training Courses

Course PDF

Print

Sections