A. Required when a table does not have any unique fields in it
B. The primary key with AutoNumber as the field type
C. Made up of two or more fields to uniquely identify records
D. Is a foreign key that uniquely identifies records

A. A relationship establishes the association between common fields in two tables.
B. An AutoNumber field can be related to a field of either type AutoNumber or type Text.
C. Joins specify that each pair of rows that satisfy the join conditions will be combined in the results to form a single row.
D. Access will automatically create a join only if the field names in both tables are the same.