Access 2016 Intermediate

Access 2016

Lesson 6 – Using Advanced Query Wizards

Steps

Practice Data

11. Select the desired function from the Functions list. The function appears in the preview.

Click Sum

12. Select Next .

Click

The next page of the Crosstab Query Wizard appears, with the text in the What do you want to name your query? box selected.

13. Type the desired query name.

Type Product Sales by Rep

The name appears in the What do you want to name your query? box.

14. Select Finish .

Click

The Crosstab Query Wizard closes, and the Crosstab Query recordset appears in Datasheet view.

Close the Product Sales by Rep Datasheet view.

U SING THE F IND D UPLICATES Q UERY W IZARD



Discussion

Use the Find Duplicates Query Wizard to find duplicate records in a table. For instance, there may be identical records stored in a table, when only one record is necessary. The Find Duplicates Query Wizard will find the duplicate records so you can delete them from the table.



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 Find Duplicates Query Wizard .

4. Select

.

OFFICEPRO, Inc.

Page 109