Extend Microsoft Access Applications to the Cloud

Chapter 6. Creating data sources by using queries

In this chapter:

Creating basic queries

Adding criteria to queries

Adding calculations to queries

Adding parameters to queries

Totals and queries

TOP value queries

Unique values in queries

Summary

In this chapter, we will look at how to create queries in a web app. These queries can then be used either with views to display information or with data macros to process information. If you are familiar with this subject, you will notice that in the contents there are no topics on creating queries to modify data. Queries that modify data are not supported in a web app; instead, you use data macros to perform equivalent operations.

In Chapter 5, “Displaying data in views,” I demonstrated creating ...