Build relationships for a new Access 2007 database

Learn to create database relationships in Access 2007

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.

Start course button

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.

Before you begin

Topics in this course

  1. Create relationships

  2. Types of relationships

  3. Create a relationship

  4. Set referential integrity

  5. A look at one-to-one relationships

  6. A look at many-to-many relationships

  7. Practice

  8. Quick reference card

Applies To: Access 2007

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language