Access 97
Expert Specialist
|
 |
Course Length/Prerequisites
This three-day course requires Windows 95, Windows NT 4.0 Introduction
or equivalent experience. Students should be familiar with at least
one software application, such as a word-processing or spreadsheeting
program. Knowledge of database terminology is not assumed.
Course Objectives
This course is designed for students who wish to prepare for the Access
97 Expert Specialist exam. The Expert Specialist exam of the Microsoft
Office User certification program covers the following skills:
create a relational database and design tables
define relationships between tables
import and export data
modify the information in a table
sort and find records
create filters and queries
create multi-table and other types of queries
enhance database design
utilize web capability
design forms and reports
Upon completion of this hands-on workshop, students will be able to
perform the required tasks listed above. Students who wish to achieve
certification in the MS Office User program will be prepared to challenge
the User Specialist exam.
Course Content
Access Overview
Creating a Database
Creating a Database File
Planning a Database
Creating a Table
Defining a Table’s Structure
Entering Data in Datasheet View
Importing and Linking Tables
Modifying a Table’s Structure
Copying, Deleting, and Renaming a Table
Modifying Fields and Data Types
Setting Field Properties
Maintaining Data
Navigating in Datasheet or Form View
Sorting Records
Modifying Data Manually
Changing Column Widths
Freezing Columns
Finding Data
Find and Replace
Filters, Queries
Creating Multi-Table Queries
Relational Databases
Table Relationships
Creating Two-Table Queries
Creating Multi-Table Queries
Creating More Powerful Queries
Parameter Queries
Calculating and Concatenating Fields
Using Statistical Functions
Calculations on Groups of Records
Crosstab Queries
Enhancing Table Design
Lookup Fields
Setting Field Properties
Designing Forms
Using the Form Wizard
Modifying a Form in Design View
Selecting, Moving, and Sizing Controls
Changing the Color, Font, and Alignment of Controls
Adding and Deleting Controls
Control Properties
Enhancing Forms
Creating a Chart on a Form
Creating a Main/Subform
Adding Combo Boxes to Forms
Adding a picture to a form
Creating Hyperlinks
Designing Reports
Printing from the Database Window
Using the Report Wizard
Modifying a Report in Design View
