How to change the primary key in Access-How to change the primary key in Access

Recently, some friends have consulted the editor about how to change the primary key in Access. The following will bring you the method of changing the primary key in Access. Friends in need can come and learn more.

Step 1: After opening Access, find the table that has been set up on the left (as shown in the picture).

Step 2: Then right-click the mouse and select the [Design View] option (as shown in the picture).

Step 3: You can see that [student number] is the primary key (as shown in the picture).

Step 4: Click [Student ID] to study period (as shown in the picture).

Step 5: Then right-click the mouse and click [Primary Key] (as shown in the picture).

Step 6: At this time, the primary key of the student ID is canceled (as shown in the picture).

Step 7: Finally, select the academic period to be set as the primary key and set it (as shown in the picture).

The above is the entire content of how to change the primary key in Access brought to you by the editor. I hope it can help you.