|
Access: Now Playing
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.
Memo to self: each table has separate information:
the movie table does not include customer phone numbers. The rating
table does not have rental prices.
This is a Third Normal database.
Each table has specific data. The data is referenced
by unique integers: no duplicates. More on this, later... |
|||
|
| |||
Microsoft Access 2007 Exam 77-605 Topic: 1. Structuring a Database
1.1.2. Define appropriate table field data types for fields in each table: Select a text or number field