13. Creating Advanced Queries

IN THIS CHAPTER

Creating a Totals Query

Creating Queries That Make Decisions

Case Study: Calculating a Customer Discount Rate

Running Parameter Queries

Running Action Queries

From Here

The query techniques you studied in the first three chapters of the book add powerful new weapons to your Access arsenal. From expressions to functions to multiple-table setups, you’ve seen that you can perform some sophisticated and powerful querying. So when I tell you that this chapter covers “advanced” queries, am I talking about obscure features that will be rarely used in a business environment? Are these complex techniques that require a math degree to comprehend? The answer is a firm “No” on both counts. The queries you’ll ...

Get Business Solutions Microsoft® Office Access 2007 Forms, Reports, and Queries 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.