Home > DeveloperSection > Articles > Set Primary key in Access table

Set Primary key in Access table

MS Access MS Access 
0 Comment(s)
 2919  View(s)
Rate this:

Set Primary key in Access table

Microsoft Access table has a field or set of fields that uniquely identify each record stored in the table, it can be set as the primary key. The selection of a primary key is one of the most critical decisions you’ll make in the design of a new database. In this article I have explained how to set primary key in table.

Set Primary key


Step 1: Open a table in Design view.

Step 2: Select the field or fields you want to define as the primary key or click the row selector for the desired field.

Step 3: Click Primary Key on the toolbar.

Figure 1:

Set Primary key in Access table

After clicking on primary key, selected column will be look as below image

Figure 2:

Set Primary key in Access table

Note: - When you save a new table without setting a primary key, Access prompts you to create one. If you choose Yes, Access creates an ID field that uses the AutoNumber data type to provide a unique value for each record. If your table already includes an AutoNumber field, Access uses that field as the primary key.

Don't want to miss updates? Please click the below button!

Follow MindStick