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