• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 2. Creating Databases and Tables > Setting the Primary Key

Setting the Primary Key

After you've opened the table for which you want to set a primary key in Design view, click the field that you want to use as the primary key to select it.

Click the Primary Key button on the Standard toolbar in the main Access window.

Access adds a key icon to the field to indicate that it is the primary key. Click the Save button on the Standard toolbar in the main Access window to save your changes to the table.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint