Question

To sort records in a query, specify the sort order in the ____ row of the design grid below the field that is the sort key.

A) Show
B) Criteria
C) Order
D) Sort

Answer 1

D i took the test and got it right Hope this helps

Answer 2

Option (D) i.e., Sort is the correct option.

Step-by-step explanation:

When the data is sorted in the query then, a particular sort order is in the sorted row of the grid after the field of that key which is sorted. In other words, the sort key is used to sort the data in the query and also used to sort the row or column. So, that's why the following option is correct.

Option A i.e., Show is false because it is not used to show row of the design grid.

Option B i.e., Criteria is false because the specific sort order is not in the criteria row of the design grid.

Option C i.e., Order is false because it is not according to the question.