Access 2016 Intermediate

Access 2016

Lesson 6 – Using Advanced Query Wizards



Procedures

1. Display All Access Objects in the Navigation Pane.

2. On the Create tab in the Queries group, select the Query Wizard button

.

3. Select Crosstab Query Wizard .

4. Select . 5. Select the a table or query from the Which table or query contains the fields you want for the crosstab query results? list.

6. Select . 7. Add the field you want to use as row headings to the Selected Fields list.

8. Select . 9. Add the field you want to use as column headings from the Which field’s values do you want as column headings? list. . 11. Select the field on which you want to calculate from the Fields list. 12. Select the desired function from the Functions list. 10. Select

13. Select . 14. Type the desired query name.

15. Select

.



Step-by-Step

From the Student Data directory, open QWIZARD.ACCDB . Create a crosstab query.

If necessary, display the All Access Objects in the Navigation Pane.

OFFICEPRO, Inc.

Page 107