In general, what should be in place before you select fields from more than one table in Access Query Design View?
A)The tables should not contain fields with the same field name.
B)The tables should be merged into one table.
C)The join line between the tables should be deleted.
D)The tables should be related in a proper one-to-many relationships.

Question

Quizplus · Accepted Answer

The tables should be related in a proper one-to-many relationship to ensure that the query can correctly combine the data from the two tables based on a common field. This relationship is typically represented by a join line in the query design view.

In General, What Should Be in Place Before You Select