Advertise with us

How do you set two primary keys in access?

Posted by  pooja singh
 276  View(s)
Ratings:
Rate this:

hi friends i am a junior developer i have assigned a project by my team leader. in this project use ms access database and i need to set two column primary keys in a table . please help me any one .

thanks.

  1. Re: How do you set two primary keys in access?

    Add a two field as a primary key

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

    See below image ->

    How do you set two primary keys in access?

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

     See below image -> 

    How do you set two primary keys in access?

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

    see below image->

    How do you set two primary keys in access?

    4. Now select two-column to which you want to add the primary key and click the primary key button.

    See below image->

    How do you set two primary keys in access?


    I hope it will help to you.

Answer