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

Selecting data from a single table

One advantage of using queries is that they allow you to find data easily in multiple related tables. However, queries are also useful for sifting through the data in a single table. All the techniques you use for working with a single table apply equally to more complex multiple-table queries. This section shows you how to build a query to select data from a single table. Later in this chapter, we’ll create more complex queries with multiple tables, totals, parameters, and more.

To start building a query on a single table in a web app, click the Advanced button on the Home ribbon tab and then click Query in the drop-down list of options, as shown in Figure 5-3.

Figure 5-3. Click Advanced, and then click Query ...

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