Access: Now Playing Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

Home -> Design View

Table Design

When a table is in Design View, you should see: the Field Name, the Data Type, and the Description.

 

Try it: Investigate the Data Types.

Click on the Movie Field.

Do you see the Field Properties at the bottom of the screen?  The Movie field is a Text Data Type.

 

Click on the RentalID. The RentalID is a Number, an Integer. An Integer is a Counting number-no decimals or fractions. More on this in a minute...