Access 2016 Intermediate

Access 2016

Lesson 6 – Using Advanced Query Wizards

E XERCISE

U SING A DVANCED Q UERY W IZARDS



Task

Use advanced query wizards.

1. Open QWIZARD1X.ACCDB . 2. Create a crosstab query from the existing Sales by Rep query. Use the Client ID field for the row headings and the Sales Rep field for the column headings. Have the calculated value be the sum of the Total Sales field. 3. Name the query Total Sales by Sales Rep and select the option to view the query. After you have viewed the recordset, close the query. 4. Use the Find Duplicates Query Wizard to locate any duplicate records in the Client table. Select the Client Name , Address , and City fields as possible duplicate-value fields. Do not select any additional fields to show in the query. 5. Name the query Find Duplicate Clients and select the option to view the query. Notice that two duplicate records were found. Close the query. 6. Use the Find Unmatched Query Wizard to find any projects in the Project table that have no record of payment in the Payment table. Select the Project ID field as the matching field for the two tables, if necessary. Then, have the Client ID , Course Name , and End Date fields also display in the query. 7. Name the query No Record of Payment and select the option to view the results. After you have viewed the recordset, close the query. 8. Close the database file.

OFFICEPRO, Inc.

Page 115