Summary

Relationships enable you to normalize a database. By using relationships, you can divide data into separate tables and then once again combine the data at runtime. This hour begins by explaining relational database design principles. It describes the types of relationships that you can define. It also covers the details of establishing and modifying relationships between tables and describes all the important aspects of establishing relationships.

The capability to easily establish and maintain referential integrity between tables is an important strength of Microsoft Access. This hour describes the referential integrity options and highlights when each option is appropriate. Finally, this hour summarizes the benefits of relationships.