skip navigation
Access 2016 Tutorials

Access 2016 Tutorials

Access 2016 Tutorials - Keys

 
 
Create a New Database Access 2016 Main Menu Table Relationships 

Primary Key

The primary key is a unique identifier for a record.  The primary key cannot be the same for two records.  This field can never be blank.

To set a table’s primary key:

  • Open the table is Design View, click the Fields tab from the Ribbon, and Choose Design view

 

 

  • Select the field (or fields) that you want to use and then on the ribbon, click Primary Key

 

Composite Key

A composite key is a primary key that is comprised of two or more fields.  It can also be called a compound or concatenated key.

Foreign Key

A foreign key is a field or combination of fields that are related to the primary key of another table.

 

 Create a New Database Access 2016 Main Menu Table Relationships