Self-Study QuickSkill Course Access 2002 (Office XP): Level 2
Series: Office XP - Access 2002
Platform: Windows NT 4 Workstation, 95, 98, 2000, ME, XP, Mac OS 8
Course Type: Self-Study QuickSkill Course

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. You’ll 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: Parameter and Action Queries
  Creating Parameter Queries
  Creating Action Queries
Lesson 6: Customizing Form Designs
  Customizing the Form Design
  Performing Calculations on a Form
  Adding Combo Boxes to a Form
  Adding Unbound Controls to a Form
Lesson 7: Working with Data Access Pages
  Creating and Modifying Data Access Pages
  Integrating with Other Applications
Lesson 8: Customizing Reports
  Customizing a Report Created by the Report Wizard
  Creating a Report in Design View