Access tutorial How to define a primary key in a field

Usually the data table to define the primary key, otherwise the system will prompt you to create a primary key, then how to build it? Let's make the Nineth software small series to show you how to do it again!

The specific steps are as follows:

1. Open your access and open the datasheet where you want to set the primary key, then click Start-View.

2. In the Drop-down menu of the view, click Design View.

3, came to the Design view panel, we want to set the primary key field to the right, that is, the position of the Red Arrow right-click

4, in the pop-up menu, we select the primary key. This gives the primary key to the field of the ID.

5, another method is that we choose to create a primary key field, and then click the Primary key on the menu bar.

6, the last click on the left corner of the Save button, the primary key to save.

7. Click the View button to return to Datasheet view.