Absolute Beginner's Guide to MicrosoftR Access 2002

The relationships between tables are the cornerstones on which all relationship database systems thrive. As you saw in this chapter, relationships can help you find related data from one table to another. Coupled with referential integrity, they can also help protect your data from accidental changes or deletions. In this chapter, you learned how to

  • Create a lookup field and run the Table Analyzer

  • Create a relationship between two tables

  • Enforce referential integrity and why you should

  • Display subdatasheets for browsing related records

Категории