O'Reilly logo

Sams Teach Yourself Microsoft Access 2002 in 21 Days by Craig Eddy, Paul Cassel, Jon Price

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 14. Special Query Uses

In earlier days you learned all about how to create queries and use their results. Today, you’ll explore some of the more advanced query capabilities available in Access 2002. You won’t use these types of queries every day, but at some point you’ll find the need for them.

Today You Will Learn

  • How to create and use action queries

  • How to analyze data with crosstab queries

  • What SQL-specific queries accomplish

  • How to parameterize your queries

  • How to reference form entries in your queries

  • How queries can be useful for refining data

  • Everything you ever wanted to know about query properties

Action Queries

As the name implies, an action query performs an action on your database. These actions can be taken on data within your tables, ...

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