O'Reilly logo

Absolute Beginner’s Guide to Microsoft® Access 2002 by Mike Gunderloy, Susan Sales Harkins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required