|
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
HTML Editing by: [Coastal WebWorks]