graphic3

Exam 77-424: Microsoft Access 2013
1.0 Create and Manage a Database
1.2 Manage Relationships and Keys: Set Primary Key Fields

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...

 
graphic2

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

graphic1