O'Reilly logo

Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills by Bob Schneider

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

“You use a query to answer questions about your database” is a catchy phrase sometimes used in Access training materials. It's helpful as a starting point for discussing queries—but only as a starting point. As a definition, it leaves out action queries, which don't answer questions but rather change your database. More important, it doesn't embrace the extraordinary breadth of a query's powers, which extend to viewing, integrating, editing, and analyzing data in a multitude of ways. Indeed, it might be more appropriate to ask which Access tasks a query can't do than what it can.

In this chapter, I cover select queries, the most common query and probably what you think of when you hear “query.” I begin by discussing some basic ...

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