Chapter 10. Creating Queries

Although tables act as the ultimate foundation for any application you build, queries are very important as well. 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 hour you'll learn the following:

  • The basics of working with queries

  • How to build queries

  • How to add tables and fields to the queries you create

  • How to sort query output

  • How to limit the data that appears in the query output

  • Tips and tricks related to working with queries

Query Basics

Creating a basic query is easy because Microsoft has provided a user-friendly, ...

Get Sams Teach Yourself Microsoft® Office Access 2003 in 24 Hours 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.