If you are looking for software to use, go to Huajun Software Park! software release
Location: front pageTutorial strategyTutorialComputer software tutorials How about Access...

How to customize the primary key in Access? -Access custom setting primary key tutorial

Author: Qingchen Date: 2022-11-15

Access
Access-2007 official version

Encryption and decryption Storage size: 4.7MB Time: 2021-03-19

Software introduction: Access2007 official version is a database structure management tool that is often used by office workers. Access2007 PC version has a newly designed...

Download now

Many people don’t know how to customize the primary key in Access? Today’s article brought to you is the tutorial on customizing the primary key in Access. If you still don’t know, let’s learn about it with the editor.

Method 1:

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

Detailed operation screenshot of custom setting primary key in access report

​​ 2. In the drop-down menu of View, click Design View.

Detailed operation screenshot of custom setting primary key in access report

3. When we come to the design view panel, we right-click on the right side of the field where we want to set the primary key, which is where the red arrow is.

Detailed operation screenshot of custom setting primary key in access report

4. In the pop-up menu, we select the primary key. This creates a primary key for the ID field.

Detailed operation screenshot of custom setting primary key in access report

Method 2:

​ ​ 1. We select the field where the primary key will be established, and then click Primary Key on the menu bar.

Detailed operation screenshot of custom setting primary key in access report

​​ 2. Finally, click the save button in the upper left corner to save the primary key.

Detailed operation screenshot of custom setting primary key in access report

​​ 3. Click the View button to return to the data table view.

Detailed operation screenshot of custom setting primary key in access report

The above is the Access shared with everyoneCustomize primary keyTutorialAll the content, interested friends, please come and watch it!

Related articles