Access 97: Level 2

Course description

Overview: Students will learn how to enhance their database designs by using the principles of normalization and table relationships. Students also learn how to query multiple tables for data that is used in customized forms and reports.

Prerequisites: Access 97: Level 1 or equivalent knowledge.

Performance-based objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

• Normalize sample tables by identifying design problems.
• Establish relationships between tables by analyzing table relationships and enforcing referential integrity.
• Customize table designs by setting field properties to maintain data integrity and creating indexes.
• Design select queries by using multiple tables to calculate, group, average, and concatenate values and to show top values.
• Customize form designs by creating calculated fields, combo boxes, and unbound controls.
• Display table information that has a one-to-many relationship by creating forms that contain subforms.
• Customize report designs by grouping, sorting, and summarizing data, and by adding subreports.

Course Content

Lesson 1: Principles of table design

Normalizing data

Normalizing data for fourth and fifth normal forms

Lesson 2: Principles of table relationships

Analyzing table relationships

Establishing and testing referential integrity

Lesson 3: Table design techniques

Data validation techniques

Indexing techniques

Lesson 4: Designing select queries

Working with calculations

Creating advanced select queries

Lesson 5: Enhanced form design

Modifying the form design

Adding calculations to a form

Adding combo boxes to a form

Adding unbound controls

Lesson 6: Subform design

Creating a form that contains a subform

Using the Form Wizard to create a form that contains a subform

Lesson 7: Customizing reports

Customizing a report created by the Report Wizard

Subreports

Appendix A: Using the Chart Wizard

Appendix B: Mailing labels