MS Access - Lesson 7: Lock

Primary key is a unique identifier for a record. Primary key cannot coexist on both records.

Main courses

TipsMake.com - Key is a unique identifier for a record. Primary key cannot coexist on both records. This field may never be left blank
Picture 1 of MS Access - Lesson 7: Lock Joint lock

A composite key is a primary key that consists of two or more fields. It can also be called a binding key.

Foreign key

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

« PREV POST
READ NEXT »