Absolute Beginner’s Guide to Microsoft® Office Access 2003

Chapter 12. Getting Down to Business with Queries

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 ...