Access 97
 Inquire about Microsoft Office 2000 and XP Training
Teach your end-users all aspects of using Microsoft's database tool! From searching and replacing text, to advanced formatting techniques. Students will gain vital knowledge of the Access
environment. Our Access 97 Learning System is perfect for a successful migration or implementation to Microsoft's Office 97.
The CD-ROM include unique features such as Full Multi-Media, Bookmarking, Random Access Help Index, and Quizzes, and through the extensive use of software simulations the actual need
for the application software is not required. Covers training for MOUS certification.
Microsoft Office 97 Training Interactive CD-ROM - Access
INTRODUCING DISCOVER ACCESS 97
Welcome
Introduction
ACCESS BASICS
Introducing Access 97
Access 97
Screen Layout
Title Bar
Menu Bar
Toolbars
The Database Window
Status Bar
Scroll Bars
Getting Help
Office Assistant
Changing the Office Assistant
Character (exercise)
The Help Menu
PLANNING A DATABASE
Planning Basics
Planning Basics
Define Tables [EXP]
What is a Table?
Define Tables
Define Fields [EXP]
Define Fields
Identify Primary Keys
Define Relationships [EXP]
Tables & Relationships
One-to-Many Relationship
Many-to-many relationship
One-to-one relationship
Refine the Design [EXP]
Refine the design
BUILDING A DATABASE
Using a Database Wizard
Database Wizards
Using a Database Wizard
(exercise)
Using the Blank Database Option
Blank Database Option
Using the Table Wizard (exercise)
Entering Data into a Table [EXP]
Entering Data (exercise)
Editing Data (exercise)
Modifying a Database [EXP]
Opening a Database (exercise)
Modifying Layout (exercise)
Modifying Table Font
Modifying Field Properties
(exercise)
Building a Relational Database
[EXP]
Identifying & Creating
Relationships with the
Table Wizard (exercise)
Identifying and Creating
Relationships Manually
USING FORMS TO COLLECT DATA
What Is A Form?
Form Basics
Types Of Forms
Sub-Form Basics
Using An AutoForm
AutoForm
Create A Simple Form (exercise)
Using Form Wizard
Using Form Wizard (exercise)
Creating A Form For Internet Use [EXP]
Creating A Web Form
Creating A Form Manually [EXP]
Adding Controls To Your Form
Working With Form Controls
Entering Data Into A Form [EXP]
Form View & Datasheet View
Navigating A Form Add Records
Using A Form & Sub-Form
(exercise)
FIND, RETRIEVE & ANALYZE DATA
Sorting Data [EXP]
Sort on One Field
Sort on Multiple Fields (exercise)
Finding Data [EXP]
Find a Specific Record (exercise)
Filters Add Filters (exercise)
Using Queries to Retrieve Data [EXP]
Query vs. Filter
Query Types
Create a Simple Query (exercise)
Modify a Query (exercise)
Using Queries to Analyze Data [EXP]
Summary Queries
Create a Crosstab Query (exercise)
PRESENT DATA USING REPORTS
Create a Simple Report
Report Basics
Use AutoReport (exercise)
Save a Form as a Report
Use Report Wizards
Use an 'AutoReport' Wizard
Use the 'Report Wizard'
Use the Report Wizard (exercise)
Create a Report from Scratch [EXP]
Create a Report from Scratch
Create a Report from Scratch
(exercise)
Add Custom Pages
Use Reports to Analyze Data [EXP]
Make Calculations On A Report
Sort and Group Data (exercise)
Print Reports
Preview and Print a Report
ENHANCE FORMS AND
REPORTS
Introduction
Introduction
Format Forms & Reports [EXP]
Format a Report (exercise)
Use AutoFormats
Modify the Design of Forms
& Reports [EXP]
Add Controls Manually
Move or Size Controls
Add Command Buttons (exercise)
Modify Control Properties
Add Common Expressions
(exercise)
Add Pictures & Objects [EXP]
Introduction Add a Picture
(exercise)
Object Linking & Embedding
Link Data (exercise)
Add Hyperlinks to Forms
& Reports [EXP]
Add Hyperlinks to Forms
and Reports
Add Hyperlinks to Forms
and Reports (exercise)
Creating a Chart [EXP]
Charts, overview Creating a Chart
(exercise)
Modify a Chart
MAXIMIZE DATABASE PERFORMANCE
Table Analyzer Wizard
Table Analyzer Wizard
Performance Analyzer [EXP]
Use Performance Analyzer
(exercise)
Documenter [EXP]
Use Documenter (exercise)
Maintaining Data Integrity [EXP]
Overview Set Rules &
Field Properties (exercise)
Return to Main page
|
