Microsoft Access 2013 Inside Out

Chapter 5. Working with queries in web apps

Selecting data from a single table

Working in query preview Datasheet view

Selecting data from multiple tables

Summarizing information with totals queries

Building a query on a query

Using query parameters

Selecting specific groups

Working with unique values

Using the Top Values query property

IN the last two chapters, you learned how to create tables, modify them, and link or import tables from other data sources in web apps and to create data macros attached to table events. Although you can certainly build views that get their data directly from your tables, most of the time you will want to sort or filter your data or display data from more than one table. For these tasks, you need queries.

When you define ...