Hour 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