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 97 |
| Code: | AC97.W |
| Number of Pages: | 164 |
| Cost: | $24.95 Canadian Funds (Shipping and Handling not included) |
| Estimated Time to Complete: | 15-18 hours |
| Practice Exercises: | Yes |
| Review Exercises: | Yes |
| Summary of Features: | Yes |
| Exercise Disk: | Yes |
| Review/Exam: | No |
Module 1: Introduction What is a Database? Database Components The Keyboard - Typewriter Keyboard - Function Keys Using the Mouse Run Access 97 Access 97 Screen Menu Bar Scroll Bars Database Toolbar Dialog Boxes Status Bar Help Menu - Index - Contents Office Assistant Exit Access 97 Exit Windows 95 Exercises Module 2: Tables Create Database - Create New Database Inside Access Open Database - Open Database Inside Access - File List Create Table Table Design Window - Maximize/Restore Screen - Table Design Toolbar - Close Table Design Window The Datasheet - Table Datasheet Toolbar - Enter Data - Column Width - Close Table - Open Table - Move Around the Datasheet Close Database Database Management - Display Database Information - Favorites - Copy a Database - Rename a Database - Delete a Database Exercises Module 3: Data Types And Field Properties Data Types Field Properties Text Field - Field Size - Format - Input Mask - Caption - Default Value - Validation Rule - Validation Text - Required - Allow Zero Length - Indexed Memo Field Number Field - Field Size - Format - Decimal Places Date/Time Field - Format Currency Field - Format - Decimal Places Autonumber Field - Field Size - New Values Yes/No Field - Format Ole Object Field Exercises Module 4: Modify Datasheet Find Data Find and Replace Select Text - Replace/Edit Cell Contents - Select Row(S) Move/Copy Data Move/Copy Rows of Data Copy Table Delete a Table - Undelete a Table Change Row Height Change Column Width Freeze Columns - Unfreeze Columns Move Columns Print Preview Print Datasheet Paper Size/Orientation Page Margins/Header and Footer Hide Columns - Unhide Columns Rename Column Exercises Module 5: Modify Table Design Display Table Design Modify Table Design - Table Conversion Error Message - Select Text - Select Fields - Change Field Name - Change Data Type - Change Description - Change Field Size - Add Field - Move Field - Delete Field Exercises Module 6: Forms What Is a Form? Autoform Open Form Display Datasheet Display Records Find Record Edit Records Preview Form Print Form - Print Each Form on Separate Page Delete Form Wizard Forms - Autoformat Wizards - Form Wizard Exercises Module 7: Customizing Forms Display Form Design Save Form Design Changes The Form Design Screen Select Controls (Label And Text Boxes) - Select Group of Controls - Deselect Controls Move Controls Resize Controls - Make Controls Same Size Change Label Name Delete Control Formatting Text - Font and Font Size - Text and Fill Color - Border Line and Style - Align Text - Align Control Boxes Form Background Color Add Header/Footer Tab Order Keep Record Together Command Button Wizard - Add Command Button to a Form - Run Command Button - Delete Command Button Exercises Module 8: Sort and Query Sort Data Filters - Redisplay All Records - Filter By Form - Save As Query - Compound Conditions - "Or" Conditions - Filter Window - Specify Criteria Query - Create a Query - Run a Query - Edit a Query - Print a Query - Rename a Query - Delete a Query Query Wizard Exercises Indexes Module 9: Reports and Labels What Is a Report? Quick Report Wizards - Create Customized Report - Create Autoreport Columnar or Tabular Table Preview Report Page Setup Print Report - Print Each Record on Separate Page Delete Report Labels - Print Labels Exercises Module 10: Customizing Reports Display Report Design Report Layout Save Changes to Report Select Controls - Select Group of Controls - Deselect Controls Move Control Resize Control - Resize Report Sections Automatically Expand/Compress Text Box Sort Data Change Label Name Enter Parameter Value Keep Record Together Add Page Number Add Date Add Page Header/Footer Text Delete A Report Control Formatting Text Exercises Summary
| Homepage | Company Profile | About the Authors | List of Dos Manuals | List of Windows Manuals | Overview of Training Manuals | Order Information and Form |