Learn how to add and remove Primary Keys from an Access database table. The primary key's purpose is to promptly associate data from multiple tables and combine that data.

A primary key is a guaranteed way of uniquely identifying each record. In the school example, the primary key used to identify each member of staff in the teacher table is Staff ID.