Exam 77-424: Microsoft Access 2013
2.0 Build Tables
2.4 Create and Modify Fields: Create and Modify Fields

Add the Foreign Key

We want to link the Rental Price to the Movie Table. So, we need to add a Field for the RentalPriceID to the Movie Table.

 

5. Try This: Add a New Field

Field Name: RentalPriceID

Data Type: Number

 

What Do You See? Look at the Field Properties.

Field Size: Long Integer (Integers are Whole numbers, "Counting Numbers." )

 

Indexed: Yes. Duplicates are OK. Many movies will have the same Rental Price.

 

Do This, Please: Save the Table.

Go to File->Save.

Close tblMovies.

 

Memo to Self: RentalPriceID is still a Key, but it is not the Primary Key for tblMovies. So, RentalPriceID is considered a Foreign Key, because it belongs to another Table.

 
graphic2
graphic3

Table Tools ->Design

graphic1