O'Reilly logo

Access 2019 For Dummies by Ken Cook, Laurie A. Ulrich

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 13

I Was Just Asking … for Answers

IN THIS CHAPTER

check Defining what queries are and what they can do

check Posing questions (and getting answers) with filter and sort queries

check Asking deep questions with queries

check Making query magic with the Query Wizard

You know the old saying, “The only stupid question is the one you didn’t ask.” It’s supposed to mean that if you have a question, ask it — because if you don’t, you’ll be operating in the dark, and that’s far sillier than your question could ever have been. Although you don’t ask “meaning of life” questions of a database, you do pose questions such as, “How many customers in London do we have?” or “What’s the phone number of that guy who works for Acme Explosives?” Either of those questions, if you didn’t ask it, would require you to scroll through rows and rows of data to find the information. (That’s the silly approach, obviously.)

This chapter introduces you to the art of asking questions about the information in your database using queries. You discover how to use the Query Wizard to pose simple questions, and then you find out about ...

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