Create relationships for a new database

Learn how to create table relationships Learn how to create table relationships for a new Access 2010 database. Relationships are essential because they bring the data in your tables together so you can extract meaningful information. This course explains the different types of relationships and shows you how to create them. This is the third course in a series that teaches beginners how to use Access 2010.

Start course button

About this course

This course includes:

  • One self-paced lesson.

  • One practice session for hands-on experience. The practice requires Access 2010.

  • A Quick Reference Card you can print at the end of the course.

Goals

After completing this course you will be able to:

  • Create a one-to-many relationship.

  • Set referential integrity.

  • Create lookup fields.

  • Create a one-to-one relationship.

  • Create a many-to-many relationship.

Before you begin

Topics in this course

  1. Create relationships

  2. Types of relationships

  3. Relationships have “sides”

  4. Create table relationships

  5. Set referential integrity

  6. Create lookup fields

  7. Create a one-to-one relationship

  8. Create a many-to-many relationship

  9. Practice

  10. Quick Reference Card

Applies To: Access 2010



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!

Support resources

Change language