102k views
4 votes
What is the difference between a crosstab query and a subquery?

A crosstab query is a query within a query, and a subquery summarizes large amounts of data.
A crosstab query summarizes large amounts of data, and a subquery is a query within a query.
A crosstab query transfers large amounts of data to another table, while a subquery is the term for the other table.
A crosstab query connects tables with unrelated data to one another, and a subquery manipulates the data to be error-free.

2 Answers

3 votes

Answer:

A crosstab query is a type of select query. ... When you create a crosstab query, you specify which fields contain row headings, which field contains column headings, and which field contains values to summarize. You can use only one field each when you specify column headings and values to summarize.

Step-by-step explanation:

User IMSoP
by
7.1k points
4 votes

Answer:

The Answer is B.

Step-by-step explanation:

A crosstab query summarizes large amounts of data, and a subquery is a query within a query.

User Ozden
by
6.7k points