7 Enhancing the Queries That You Build

Using Access 2010, you can build queries that allow you to view just the data that you need.

Although tables act as the ultimate foundation for any application you build, queries are very important, too. Most of the forms and reports that act as the user interface for an application are based on queries. Having an understanding of queries—what they are and when and how to use them—is imperative for your success as an Access application developer. In this chapter, you will learn all the basics of working with a query. The chapter covers many topics, including how to add tables to a query, how to add and remove fields, and how to sort on multiple fields. You’ll learn how to add formulas to the queries you ...

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.