Add a Primary Key

1. Insert a new row

Select the first row in your table.

Go to Design and look in the Tools Group

Click on Insert Rows.

 

2. Enter the new Field

Type the Field Name: CustomerID

Select the Data Type: AutoNumber

 

3. Add the Primary Key

Look on the toolbar for the Gold Primary Key button. Click it.

 

4. Review the Field Properties

The Primary Key is an AutoNumber. It is a Long Integer. Each new number increments automatically and the field is Indexed so that there are no duplicates.