Asked by Mercy Ikediuba on Jul 11, 2024

verifed

Verified

If you want to sort records in the query results first by City and then by LastName,where should you insert the LastName field in the query design grid?

A) to the right of the City field
B) to the left of the City field
C) in the first column of the query design grid
D) below the City field

Query Design Grid

A tool used in database applications to visually create and edit queries by specifying tables, fields, and criteria for data selection and filtering.

Sort Records

The process of arranging data in a specified order, typically ascending or descending, based on one or more fields.

  • Learn how to sort and filter records in queries.
verifed

Verified Answer

JS
Jasmin SandhuJul 15, 2024
Final Answer :
A
Explanation :
To sort by City and then by LastName, you need to have City as the first field in the sorting order. Therefore, City should be placed in the leftmost column of the query design grid, and LastName should be placed to the right of the City field, as the second field in the sorting order. This means that the correct choice is A, to the right of the City field.