Access 2003 Working with Table Relationships
Objective
Learn to set up database relationships correctly and how these
relationships affect the storage and retrieval of data.
Prerequisite Skills
Comfortable creating Access databases and tables.
(Suggested courses: Access
2003 Getting Started with Databases & Tables and Access
2003 Making the Most of Tables)
Course Description
When data in your database displays in more than one table, do
you know how the information is related? Do you know how to properly
modify the relationships when necessary?
Attend this course if you want to:
-
Understand the different types of relationships (One-to-One,
One-to-Many, and Many-to-Many).
-
View existing relationships in a table.
-
Create relationships using lookup fields or the Table Wizard.
-
Manually create relationships.
-
Enforce referential integrity to ensure records in related
tables are updated properly.
-
Delete existing relationships.
-
Understand and change join types.
-
Work with subdatasheets to view related information in a
nested table.
Class Length
90 minutes
Delivery Options
-
Virtual classroom - public
($70 per student; check times and register here)
-
Virtual classroom - dedicated (up to ten
people from the same organization)
($480 per class; contact us for
more details)
-
Virtual classroom - one on one
(Register for a 45-minute 1-on-1
Application Support session. Cost is $70 per student per
session.)
-
On-site instructor-led
(Contact us for details)
