Access: Level 2
Overview: In this course, you will learn how to enhance your database
designs by using the principles of normalization and table relationships.
You'll also learn how to query multiple tables for data that is used in
customized forms and reports, and how to create data access pages to share
data over an intranet or the Internet. In addition, you'll be able to
take the guesswork out of creating databases by learning to use data-normalization
techniques. See how to take advantage of relational database efficiency
to maintain data. You will also learn techniques to save time by controlling
data entry and automating tasks. Benefit by becoming familiar with Access
features that will enable you to customize forms and reports.
Table of Contents
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
· Subdatasheets and Lookup List Fields
· 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