Skip to content
GK24
Computer AwarenessEasy

In MS Access, the field that uniquely identifies each record in a table is called the ______.

  1. A.Foreign key
  2. B.Primary key
  3. C.Index field
  4. D.Lookup field

Correct answer

B. Primary key

Explanation

The correct answer is B, primary key. A primary key is a field, or a combination of fields, whose value is different in every record and never left empty, so it can be used to pick out one record with certainty; an AutoNumber field is the usual choice because Access fills it in by itself. Option A, foreign key, is a field in one table that stores the primary key value of another table, and it is the device that creates a relationship between two tables, but it need not be unique. Option C, an index field, is one on which an index is built to make searching and sorting faster; an index may allow duplicates and is not the same as a key. Option D, a lookup field, shows a list of values drawn from another table or a fixed list to make data entry easier. A table may have only one primary key but many indexes and many foreign keys.

Read the full article: MS Access, Outlook and Office Tools: Exam Notes

View all