Know Your Data: tblReceipt
The
Receipt Form will store data in a simple Table, tblReceipt. Our
discussion always begins by reviewing the data.
1.
Try it: Review the Receipt Table
Go to
All Access Objects ->Table.
Open a
Table: tblRecipt.
Try This,
Too: Change the View
Go to
Home->Views->View.
Select a
View: Design View.
What Do
You See? This Table, tblReceipt, has
numbers only:
ReceiptID
(the Primary Key)
CustomerID
(a Foreign Key)
DateRented
(Date/Time)
This Table
is in Third Normal Form: the Key, the whole Key and nothing but the
Key. Please Close tblReceipt.
Keep
going...