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 |