Demo: Set the relationship between two tables
(Or 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):
Problems watching the video? Try our troubleshooting tips.