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

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