|
The
Receipt Form has two Forms, two Tables, two Combo Boxes and three
links. Always begin with the Tables. This lesson begins with a short
explanation of database design and normalization: There are
some really good guidelines for designing Tables. Create
a Table for the Receipt Form Make a
Receipt Table, tblReceipt. Create a
Primary Key, ReceiptID a Add a
Foreign Key (Primary Key to another Table): CustomerID. The
Receipt Table also includes the date, which we will use in several
reports. Make a
MovieRented Table, tblMovieRented. Create a
Primary Key, ReceiptID Add the
following Foreign Keys: ReceiptID CustomerID. MovieID This Table
will inherit the DateRented from tblReceipt. That's the
plan.
Microsoft Access: Example of the
Completed Tables in Datasheet View |
|
| |
