Access Intermediate
Course length: 1 day
Prerequisites: Access Introduction or equivalent knowledge.
Overview: You will learn how to enhance your database designs by using
the principles of normalization and table relationships. You will also learn how
to query multiple tables for data that is used in customized forms and reports.
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
Lesson 7: Customizing reports
- Customizing a report created by the Report Wizard
- Working with subreports
Return to Courses