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

Question

Quizplus · Accepted Answer

In Access, a query can be based on the results of other queries that have been saved. This is called a nested query. Option A is incorrect because results of a query can be operated on in Excel. Option B is incorrect because the Group By option is used to group data by a specific field, not to inform Access about the sameness of fields. Option D is incorrect because the Group By option is used within a query to group data, not when appending data to a table.

Which of the Following Statements Is True of Queries