Question

If the query design grid contains three fields named ProductName, Price, and DateOrdered, how does the datasheet list records if you add a descending sort to the Price field?

Answer 1

Answer:

from the highest to lowest Price

Explanation:

Design grid is useful in adding fields to the query. And a query can be described as SQL statement which removes rows that matches the criteria which has been specified from one or more tables.

Examples of query are

* Parameter query.... This allows the creation of a query that can be updated easily to reflect a new criterion

* Find duplicate query....... This helps to find all duplicate records in your database so you can delete them.

In this case, the datasheet which is showing the specification, i.e the list records, will show the price from the highest to lowest.