Page 1 of 10PREVNEXT

Build relationships for a new Access 2007 database

Learn database relationships
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 self-paced lesson and one practice session for hands-on experience. The practice requires Access 2007.
  • A short test at the end of the lesson; the test is not scored.
  • 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

Design tables for a new Access 2007 database
Create tables for a new Access 2007 database

In the first two courses in this series, you planned and built a set of tables for an asset-tracking database. The database replaces a spreadsheet that's too big to use easily. This course teaches you how to build relationships between your new tables.

Why relationships? Because they're an essential component of your database. They bring the data in your tables together so you can extract meaningful information.

This course explains the different types of relationships you can use in a database, and shows you how to create the most common type, called a one-to-many relationship. You'll also learn how to use referential integrity to make sure you don't accidentally remove information.

If you haven't taken the first two courses in this series, you need to be familiar with primary and foreign keys. And remember, this is a course for beginners, so if you're feeling intimidated, give it a try.

To learn more about this course, read the text in Goals and About this course, or look at the table of contents. Then click Next to start the first lesson.

Page 1 of 10PREVNEXT