Attention: this is very old content, revived mostly for historical interest. Many of the pages on this site are still useful, but please bear in mind that they may be out of date. (Especially, do not try to use contact information, phone numbers, etc. found on these pages unless you couldn't find anything more recent.)
See here for more information.


ELM Computer Consulting


Title: Access 2.0
Code: AC20.W
Number of Pages: 156
Cost: $24.95 Canadian Funds (Shipping and Handling not included)
Estimated Time to Complete:12 hours
Practice Exercises: Yes
Review Exercises: Yes
Summary of Features: Yes
Exercise Disk: Yes
Review/Exam: No
Module 1: Introduction
 	What is a Database?
 	Loading Access 2.0
 	Overview of Menus and Toolbars
 	Overview of Dialog Boxes and Status Bar
 	Help Menu
 	Cue Cards

Module 2: Tables
 	Create a Database and Table
 	Table Design Window
 	Entering Data
 	Moving around a Datasheet
 	Closing a Datasheet
 	Closing a Database
 	Deleting a Table

Module 3: Data Types and Field Properties
 	Data Types
 	Field Size, Format, Decimal Places
 	Input Mask
 	Caption
 	Default Value
 	Validation Text, Validation Text
 	Required String; Allow Zero Length

Module 4: Modify a Table/Datasheet
 	Opening a Database and Table
 	Modifying Table Design
 	Selecting Text
 	Replacing and Editing Cell Contents
 	Moving and Copying Data
 	Copying a Table
 	Deleting a Table
 	Changing Row Height and Column Width
 	Freezing/Unfreezing Columns
 	Moving Columns
 	Changing Page Orientation and Margins
 	Hiding/Unhiding Columns

Module 5: Sort and Query
 	Finding Data
 	Find and Replace
 	Sort Data
 	Filters
 	Specifying Filter Criteria
 	Creating and Editing a Query
 	Printing and Deleting a Query
 	Query Wizard

Module 6: Forms
 	Autoform Wizard
 	Wizard Forms
 	Displaying and Finding Records
 	Editing and Adding Records
 	Previewing and Printing Form
 	Deleting a Form

Module 7: Customizing Forms
 	Form Design Screen
 	Moving, Resizing and Deleting Fields
 	Formatting Text
 	Using the Palette and Toolbox
 	Button Wizard

Module 8: Reports and Labels
 	Quick Report
 	Report Wizard
 	Previewing and Printing a Report
 	Deleting a Report
 	Report Layout
 	Sorting Data
 	Formatting Text
 	Creating and Printing Labels



Homepage Company Profile About the Authors List of Dos Manuals List of Windows Manuals Overview of Training Manuals Order Information and Form

HTML Editing by: [Coastal WebWorks]