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

HTML Editing by: James Lepard, ELM Computer Consulting (March/98)