|
Exam 77-424: Microsoft Access
2013 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: tblReceipt. 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... All Access Objects ->Tables
|
|
| |
