how to create primary key in access database.

hi guys i have a simple project and there are used access database. but now i need to add primary key in my access database table. please guide me how to create primary key in access database table.

thanks.

Last updated:7/16/2020 5:36:15 AM

1 Answers

Anonymous User
Anonymous User

Add a field as a primary key

1. Open MS Access and select the Blank Desktop database.

See below image ->

how to create primary key in access database.

2. after clicking the Blank Desktop database a popup will be open.

    See below image ->

how to create primary key in access database.

3. In the Navigation Pane, right-click the table and click Design View. 

how to create primary key in access database.

4. now select the column to which you want to add the primary key and click the primary key button. 

see below image->

how to create primary key in access database.


i hope it will help to you

Answer