Review the Data

What Was All That About? Why would someone take the trouble to create a Table and position the Key Controls, then just make them invisible? Follow me to find out...


The data from the Receipt Form and Subform is saved in a Table: tblMovieRented.

 

7. Try it: Review the Data in the Table

Go to All Access Objects ->Tables

Open a Table: tblMovieRented.

 

What Do You See? This is what you should see if a database is designed well: the Key, the Whole Key, and nothing but the Key.

 

Try This, Too: Proof the Data in the Table CustomerID2 has 5 movies.

CustomerID3 has 2 movies.

 

How does that compare to the data you entered into the Receipt Form?

 

Keep going...

All Access Objects ->Tables