|
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
2 has one customer: CustomerID 4. In the
Subdatasheet for ReceiptID 2: 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
Exam 77-885: Microsoft Access 2010
2. Building Tables
2.1.1. Create tables in Design View:
Create Tables that do not have repeating groups |
|
| |
