|
4. Try
This: Review the Movie Table Go to
All Access Objects->Tables. Select a
Table: tblMovies. Go to
Home->Views->View->Design View. What Do
You See? The Movie Table does not have a Field that indicates
the rental price. There are Fields for the Movie, Year,
Rating, Genre, and even the Stars. No money. No Rental Price. Sooooo,
since most businesses are in business to make money, we should
probably do a little more programming in the Front Row Video
database, hmmm? Tables can
work together when they share a common Field. The best Field to
create a relationship between two Tables is the Primary Key. It is
an AutoNumber (each number is unique) and it is Indexed so it is
very fast.
Home->Views->View->Design View.
Exam 77-885: Microsoft Access 2010
2. Building Tables
2.4. Set relationships: Use Primary
Keys to create Relationships |
|
| |
