Which of the following statements is true of queries?
A) In Access, a query can be based on the results of other queries that have been saved.
B) To inform 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 Excel, they cannot be operated on.

Question

Quizplus · Accepted Answer

A query in Access can be based on the results of other queries that have been saved. This is known as a nested query. Option B is incorrect as selecting the Group By option for both fields does not inform Access that the fields of two tables are the same. Option C is also incorrect as the Group By option is used to group data in a query by one or more fields, and is not related to the Append function. Option D is incorrect as the results of a query can be imported by Excel and can be further operated on using Excel's tools.

Which of the Following Statements Is True of Queries