Advertise with us

how to create primary key in access database.

Posted by  Disha nagpal
 148  View(s)
Ratings:
Rate this:

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.

  1. Re: how to create primary key in access database.

    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