Demo: Set the relationship between two tables

Access tables showing relationship Demo button

(Or Down arrow download the demo.)

(You may experience a delay while the demo is loading.)

Relational databases use table relationships to ensure that records are accurate and complete and to avoid storing redundant data. If you use table relationships in your Office Access 2007 database, you can enter new data once and then use this data in the other tables of your database. You won't have to worry about updating other tables when you change the data in a record that is related to those tables.

Watch this video to learn about table relationships and to see how easy it is to set them up.

How to do it (text version):

Help Button Problems watching the video? Try our troubleshooting tips.

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