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.
how to create primary key in access database.
72516-Jul-2020
Anonymous User
27-Jul-2020Add a field as a primary key
1. Open MS Access and select the Blank Desktop database.
See below image ->
2. after clicking the Blank Desktop database a popup will be open.
See below image ->
3. In the Navigation Pane, right-click the table and click Design View.
4. now select the column to which you want to add the primary key and click the primary key button.
see below image->
i hope it will help to you