MS Access - Lesson 7: Lock

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

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.