Learn how to create relationships among your database tables. Relationships bring the data in your tables together. That enables you to find information and make sound business decisions, and that makes your data powerful. This course is the third in a series that explains how to use Access 2007 to build a database from the ground up.
About this course
This course includes:
One practice session for hands-on experience. The practice requires Access 2007.
A Quick Reference Card you can take away from the course.
After completing this course you will be able to:
Create one-to-many relationships between database tables.
Set referential integrity for each relationship and prevent accidental data removal.
Set cascading updates and deletes, a move that walks any changes through your data.
Turn indexing on or off for primary and foreign key fields, a move that helps speed your database and create a type of relationship called a one-to-one relationship.