Extend Microsoft Access Applications to the Cloud: Creating Data Sources by Using Queries

Summary

In this chapter, you saw how to create queries that can then be used to construct views that display your data. You can use queries to bring together data from several tables or other queries and construct calculated expressions. A query can contain criteria to filter the data, provide totals to summarize the data, use unique values to remove duplicate data, and limit the results using the Top property.

The most complex feature of working with queries is in using parameters to supply values to a query at runtime. This technique requires both the construction of a parameterized query and the use of a macro to supply the runtime parameters.

In Chapter 7, we will look at further examples of working with macros and queries to enhance your applications.