In Microsoft Access 2016, a(n) _________ exists between two tables when one record in the first table matches zero, one, or many records in the second table, and when each record in the second table matches at most one record in the first table.
A. one-to-many relationship
B. many-to-many relationship
C. one-to-one relationship
D. many-to-one relationship
Fill in the blank(s) with the appropriate word(s).
one-to-many relationship
Rationale: In Microsoft Access 2016, a one-to-many relationship exists between two tables when one record in the first table matches zero, one, or many records in the second table, and when each record in the second table matches at most one record in the first table. The two tables that form a relationship are referred to as the primary table and the related table. See 18-4: Defining Table Relationships
You might also like to view...
________ are the conditions that users can set in a query to identify the specific records they want to return
A) Selection B) Search C) Criteria D) Sort
In a report, group headings should be formatted exactly the same as the details within the group
Indicate whether the statement is true or false