In a query of two or more tables Access will will show
A)only records in the parent table
B)every record in one table joined to each record in the other table.
C)only records the have matching values in all the tables.
D)only records that do not have matching records in all the tables.
E)all the relevant records in both/all tables.

Question

Quizplus · Accepted Answer

Access will show all the relevant records in both/all tables. This is because when two or more tables are joined, Access creates a new table that combines all the fields from the original tables, and includes all the matching records from both/all tables. Therefore, all the relevant records from both/all tables will be displayed in the query result.

In a Query of Two or More Tables Access Will