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, ...
Get Sams Teach Yourself Microsoft Access 2002 in 21 Days now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
