2 Using Queries to Retrieve the Data You Need
Using Access 2010 queries, you can view the data you want when you want to view it.
In this chapter, you will learn what queries are and why they are important. You’ll learn how to work with queries in both Datasheet view and Design view. We’ll explore the basics of working with queries such as selecting fields, ordering the query result, and using basic criteria. Finally, you’ll see the real power of queries when we work with queries based on data in multiple tables.
What Is a Query and When Should You Use One?
A Select query is a stored question about the data stored in a database’s tables. Select queries are the foundation of much of what you do in Access. They underlie most forms and reports, ...
Get Using Microsoft® Access® 2010 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.
