Question

Which of the following is NOT true about sorting query results on multiple fields?

1) You can have one field sorted in ascending order and another in descending order.
2) The first field you choose to sort by is called the primary sort field.
3) The second and subsequent fields are called secondary sort fields.
4) In datasheet view, you can sort multiple fields by selecting all the fields at one time and using the Sort Filter group sorts.

Answer 1

Statement 4 is incorrect because in most database interfaces, you cannot sort multiple fields by selecting all of them at once; sorting is usually done by specifying the order for each field individually.

Step-by-step explanation:

The student is asking about sorting query results on multiple fields in a database context. The question presents four statements and asks which one is incorrect:

1. You can have one field sorted in ascending order and another in descending order.
2. The first field you choose to sort by is called the primary sort field.
3. The second and subsequent fields are called secondary sort fields.
4. In datasheet view, you can sort multiple fields by selecting all the fields at one time and using the Sort Filter group sorts.

All the statements except the fourth one are generally true when sorting data in databases. The ability to sort different columns in different orders (ascending or descending) is standard, and the terms "primary sort field" and "secondary sort fields" are often used to describe the hierarchy of sorting.

However, the fourth statement is not accurate in most database interfaces, including spreadsheets or database management systems. You generally cannot sort on multiple fields by selecting them all at once; instead, you would sort by the primary field and then specify the sorting order for secondary fields individually.