This course provides competency in creating databases and tables, working with table data and field properties, working with related tables and using filters and queries. Guided, step-by-step labs provide opportunities to practice new skills. You can challenge yourself and reinforce your skills after each lesson in the Lesson Summary and Lesson Review sections, and the Activities and Optional Labs. Additional skill review is provided in Lesson Quizzes and a Course Assessment that are available from your instructor.

This coursebook includes a supplemental CD-ROM containing the lab files used in class. To practice the skills presented in class or to try any labs that were not completed, refer to the Classroom Setup section for information about system requirements and using the lab files.

Topics

Creating Databases and Tables
Introduction to Access
Database Components
Relational Database Design
Starting Access
Database Window Layout and Features
Database Creation

Creating Tables
Modifying Table Design
Working with Table Data and Field Properties
Overview of Table Data and Field Properties
Modifying Datasheet Layouts

Working with Table Records
Importing Data into Tables
Modifying Field Properties

Working with Related Tables
Overview of Table Relationships
Establishing Relationships
Enforcing Referential Integrity

Creating Lookup Fields
Using Lookup Fields to Add Data

Using Filters and Queries
Overview of Filters and Queries
Using Comparison Operators
Using Filters

Creating Select Queries
Refining Query Results
Using Criteria in Select Queries
Modifying Select Queries
Performing Calculations in Queries
Creating and Modifying Crosstab Queries
Creating and Modifying Unmatched Queries
Creating and Modifying Duplicate Queries