Which of the following statements does NOT hold true for the Top Values property? A. The Top Values property displays only the highest values from the query. B. The Top Values property requires the fields to have a defined sort order. C. The Top Values property finds a specified number of records. D. The Top Values property finds a specified percentage of records.

The Top Values property displays only the highest values from the query.
The Top Values property requires the fields to have a defined sort order.
The Top Values property finds a specified number of records.
The Top Values property finds a specified percentage of records.

The correct answer is: D. The Top Values property finds a specified percentage of records.

The Top Values property finds a specified number of records, not a percentage. The Top Values property is used to return a specified number of the highest or lowest values from a query. The fields to be used in the sort order must be specified, and the sort order must be defined.

Here is a more detailed explanation of each option:

  • Option A: The Top Values property displays only the highest values from the query. This is true. The Top Values property returns a specified number of the highest values from a query.
  • Option B: The Top Values property requires the fields to have a defined sort order. This is true. The fields to be used in the sort order must be specified, and the sort order must be defined.
  • Option C: The Top Values property finds a specified number of records. This is true. The Top Values property returns a specified number of the highest values from a query.
  • Option D: The Top Values property finds a specified percentage of records. This is false. The Top Values property returns a specified number of the highest values from a query, not a percentage.
Exit mobile version