Chapter 9. Create Your Own Queries

IN THIS CHAPTER:

  • 48 Create Queries

  • 49 Order a Query Result

  • 50 About Refining a Query with Advanced Criteria

  • 51 Update Query Results

  • 52 About Building Queries Based on Multiple Tables

  • 53 Create Calculated Fields

  • 54 Get Help from the Expression Builder

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 or end user. The time and effort that you take to learn how to effectively build queries will pay for itself many times ...

Get Microsoft Office Access 2003 in a Snap 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.

Start your free trial