Access 7 Intmd

Access 7.0: Level 2 (Windows 95)

Course Description

Overview: Students will learn to normalize table data; establish relationships between tables; change table properties and create indexes; use queries to calculate, average, and concatenate values; design forms that include calculated fields, combo boxes, list boxes, and unbound controls; customize reports by grouping, sorting, and summarizing data, and adding a subreport; create mailing labels.

Prerequisites: Students should understand how to create and use the objects in Access 7.0 (Windows 95), including tables, queries, forms, and reports.

Benefits: Students will learn how to enhance their database designs by using the principles of data normalization and table relationships, and by querying multiple tables for data to be used in customized forms and reports.

Objectives

Upon successful completion of this course, students will be able to:

Normalize sample tables by identifying design problems.
Create table relationships and enforce referential integrity between two tables.
Customize table designs by changing properties and creating indexes.
Design queries that calculate, group, average, and concatenate values, and that show top values.
Customize form designs by creating calculated fields, combo boxes, list boxes, and image controls.
Customize report designs by grouping, sorting, and summarizing data, and adding a subreport.
Create a report for mailing labels that can be used with data from different tables.

Course content

Principles of table design
Analyzing table relationships
Establishing and testing referential integrity
Working with field properties
Indexing techniques
Working with calculations
Creating advanced select queries
Using properties to enhance form design
Adding bound and calculated controls
Adding combo boxes and list boxes
Adding unbound controls
Customizing a report created by the Report Wizard
Creating mailing labels