|
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
HTML Editing by: James Lepard, ELM Computer Consulting (March/98)