Define the Primary Key

2. Try This, Too: Create a Primary Key

Select a Field: RentalPriceID

Go to Table Tools ->Design->Tools.

Click on Primary Key.

What Do You See? The RentalPriceID Field has the symbol for the Key. In the Field Properties, the values are Indexed (yes), so that there will be no duplicates.

 

Do This, Now: Save the Table

Go to File->Save.

Enter a Name: tblRentalPrices.

 

Click OK. Keep going.

 

Table Tools ->Design->Tools->Primary Key

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.4. Set relationships: Define the Primary Key