In this chapter
Find duplicate records and unmatched data and summarize data using special query wizards
Modify and delete large groups of records at one time using Delete and Update action queries
Interact with a parameter query
Use a Totals view to summarize groups of data
So far, you’ve learned how to create and use almost every Access object. That means you can probably do quite a lot now. However, there’s more to learn.
There’s a lot more to queries than just retrieving data. As your data and your needs grow, your queries will probably become more complex.
Occasionally, you might need more help than the Simple Query Wizard provides. When this happens you have several options:
The Find Duplicates Query ...