What must you do before you can create a crosstab query that references more than one table?
A)Run an append query to combine the records from the various tables.
B)Run a make table query and use that as the source for the crosstab query.
C)Make sure the relationships have been properly created in the Relationships window.
D)Create a select query which includes the fields from the various tables you want included in the crosstab query.

Question

Quizplus · Accepted Answer

Before creating a crosstab query that references more than one table, it is important to ensure that the relationships between those tables have been properly established in the Relationships window. This will ensure that the query can accurately match related records from each table. Running an append query, make table query, or creating a select query are not necessarily required before creating a crosstab query.

What Must You Do Before You Can Create a Crosstab