Access 2010 In Pictures

What is the key field?

A table's key field can't contain any duplicates.

Every table should have a key field.

For example, if a hospital keeps a database, each patient can have a unique ID number in the key field.

That way, if the hospital has more than one patient named John Baker, it can easily distinguish the John Baker in for a checkup (ID# 386) from the John Baker who needs his gall bladder removed (ID# 298).

3 Type:

First Name