 |
Training |
Access Level 2
Course Description
Students will learn
how to enhance database designs by using the principles of data normalization,
table relationships, and referential integrity; by querying multiple tables for
data used in customized forms, reports, and sub reports; and by creating data
access pages.
Prerequisites
Access Level 1 or equivalent knowledge.
Study Method:
Flexible
Learning: Group Training
What Next?
Access
Level 3
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
Using
Calculated Fields in Queries
Creating
Multiple-Table Queries
Lesson
5: Customizing Form Designs
Customizing
the Form Design
Performing
Calculations on a Form
Adding
Combo Boxes to a Form
Adding
Unbound Controls
Lesson
6: Working with Data Access Pages
Creating
Data Access Pages
Integrating
with Other Applications
Lesson
7: Customizing Reports
Customizing
a Report Created by the Report Wizard
Working
with Sub reports
Creating
a Report in Design View