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...

All Access Objects ->Tables