A relationship between Access tables that is a relationship between one record in the first table and zero, one, or many records in the second table, and at least one record in the second table matches at most one record in the first table, is defined as a(n) ____ relationship.
A) One-to-One
B) One-to-Many
C) One-to-Most
D) Many-to-One

Question

Quizplus · Accepted Answer

A One-to-Many relationship is where one record in the first table can relate to zero, one, or many records in the second table, and each record in the second table relates to at most one record in the first table.

A Relationship Between Access Tables That Is a Relationship Between