Access 97
Introduction
|
 |
Course Length/Prerequisites
This two-day course requires Windows 95, Windows 3.X Introduction or
equivalent experience. Students should be familiar with at least one
software application, such as a word-processing or spreadsheeting program.
Who Should Attend?
This course is designed for personnel who wish to use Access in the
workplace and have little or no experience. It focuses on the use of
Access to create databases or to query existing databases. It is not
a course in programming and system development.
Course Objectives
Upon completion of this hands-on workshop, students will be able to:
create a database and design tables
import a table
modify the information in a table
sort and find records
create filters and queries
create multi-table and other types of queries
design forms and reports
Course Content
Access Overview
What is a Database?
The Database Window
Creating a Database
Creating a Database File
Planning Tables
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
Adding New Fields
Deleting a Field
Changing the Field Order
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
Designing Two-Table Queries
Creating Multi-Table Queries
Creating More Powerful Queries
Parameter Queries
Calculating Fields
Concatenating Fields
Using Statistical Functions
Calculations on Groups of Records
Enhancing Table Design
Lookup Fields
Setting Field Properties
Designing Forms
Using the Form Wizard
Modifying a Form in Design View
Changing the Color, Font, and Alignment of Controls
Adding and Deleting Controls
Control Properties
Designing Reports
Printing from the Database Window
Using Report Wizard
Modifying a Report in Design View
Manual Page Count : 268
