3.5k views
3 votes
With the Revenues query in Design view, create and run a Top Values query to select the top 5 records.

a. (Query Setup) > Click Return > Click 5 > RUN!
b. (Query Setup) > Enter Top Values: 5 > Execute!
c. (Query Setup) > Choose: Top 5 > Execute!
d. (Query Setup) > Set Top Values: 5 > Execute!

User TMBT
by
8.1k points

1 Answer

3 votes

Final answer:

To select the top 5 records in a Top Values query in Design view, you would typically enter 5 in the Top Values option in the Query Setup group and then execute the query.

Step-by-step explanation:

You use a top value query when you need to find records that contain the top or bottom values in a table field. The creating a Top Values query in a database management system using a design view interface. To select the top 5 records from the Revenues query in Design view, you typically adjust the query's property to specify the number of records to return.

The correct step to achieve this would be: Open the Revenues query in Design view. Locate the Query Setup group on the ribbon or toolbar, depending on the database software you are using. Select or enter the number 5 in the Top Values option. Execute or run the query to see the top 5 records.

Assuming we are working with Microsoft Access or a similar database program, the correct option to select the top 5 records would be: (Query Setup) > Enter Top Values: 5 > Execute!

User Alberto Cerqueira
by
7.7k points