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