|
SYNOPSIS:
This course introduces the skills necessary to use the querying, analyzing,
and reporting capabilities of Access. It includes tasks such as creating
relationships, using simple queries, modifying query results, and creating
basic forms and reports. Students will also learn how to use the Table
Analyzer Wizard and online Help.
PREREQUISITES:
Access users who want to learn how to effectively query, analyze, and
report information contained in databases.
OBJECTIVES:
l Creating
Relationships
l Using Simple Queries
l Modifying Query Results
l Using Table Analyzer Wizard
l Creating Basic Forms
l Creating Basic Reports
l Online Help
DURATION:
Day Two of Two
|
THIS MODULE INCLUDES:
Creating Relationships
Using related tables, creating a relationship, setting referential integrity,
adding a table to the Relationships window.
Using Simple Queries
Using queries, RecordSets, and the Simple Query Wizard; creating a query
in Design view; opening and running a query; adding a table to a query;
joining tables in a query.
Modifying Query Results
Sorting and printing a query, adding criteria to and hiding a field in
a query, adding a record using a query.
Using the Table Analyzer Wizard
Analyzing a table, using relationships in splits and the Table Analyzer
Wizard.
Creating Basic Forms
Using forms, the Form Wizard, and AutoForm; viewing and printing records
in a form; basing a form on a query; adding records using a form.
Creating Basic Reports
Using reports, the Report Wizard, AutoReport, and Print Preview;
printing pages of a report; basing a report on a query.
Using Online Help
Using Help, Contents, the Index, and Find; viewing ScreenTips.
|
