Chapter 13

I Was Just Asking … for Answers


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

Get Access 2019 For Dummies 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.