O'Reilly logo

Microsoft Access 2013 Inside Out by Jeff Conrad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required