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
MS Access - Lesson 7: Lock Picture 1MS Access - Lesson 7: Lock Picture 1 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.

4.5 ★ | 2 Vote