Which of the following statements is true of queries?
A)In Microsoft Access, a query can be based on the results of other queries that have been saved.
B)To inform Microsoft Access that the fields of two tables are the same, select the Group By option for both fields.
C)The Group By option becomes available when Append is clicked under the Design tab.
D)When the results of a query are imported by Microsoft Excel, they cannot be operated on.

Question

Quizplus · Accepted Answer

In Microsoft Access, a query can be based on the results of other queries that have been saved. This is known as a "nested query." The other statements are incorrect. The Group By option is used to group data and calculate aggregate functions, not to inform Access that fields are the same. The Group By option is available under the Query Type category, not when Append is clicked. Results of a query can be operated on in Excel using functions and formulas.

Which of the Following Statements Is True of Queries