Access 2016 Intermediate

Access 2016

Lesson 4 – Designing Advanced Queries

3. Select the Sort list. 4. Select the desired sort order. 5. Select the Return list on the Design tab. 6. Select the desired option.



Step-by-Step

From the Student Data directory, open ADVQUE1.ACCDB . Set top values in a query.

Display All Access Objects , if necessary. Open the CSales Query query in Design view.

Steps

Practice Data

1. Select the Sort row for the desired field. A drop-down arrow appears in the Sort field.

Scroll as necessary and click in the Sort row for the Sales to Date field

2. Select the Sort list.

Click Sort

A list of available sort orders is displayed.

3. Select the desired sort order.

Click Descending

The sort order appears in the Sort row .

4. Select the Return list on the Design tab. A list of available options is displayed.

Click Return

5. Select the desired option.

Click 5

The top value appears in the Top Values box.

Run the query. If necessary, scroll to view the Sales to Date field. Notice that the top five sales to date are listed in descending order.

Practice the Concept: Return to Design view. Set the top values back to All and remove the sort from the Sales to Date field. Then, close the query, saving the changes.

OFFICEPRO, Inc.

Page 71