O'Reilly logo

Business Solutions Microsoft® Office Access 2007 Forms, Reports, and Queries by Paul McFedries

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

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

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