Exam 77-424: Microsoft Access 2013 1.0 Create and Manage a Database 1.2 Manage Relationships and Keys: Create and Modify Relationships

Consider the Relationships In the previous lesson, we added a Subdatasheet between two Tables and Access prompted us to define a relationship. We also created relationships between the rest of the Tables with the Relationship Tools.   Why Does This Matter? This is a relational database. tblReceipt is related (joined) to tblMovieRented by a common Key: ReceiptID.   Here is a preview of how the data in the Tables will look when we complete the designs: ReceiptID 3 has one customer: CustomerID 4.   In the Subdatasheet for ReceiptID 3: CustomerID 4, has many movies.    This is an example of a database that is in Third Normal Form. Preview of the Completed tblReceipt with tblMovieRented as a Subdatasheet