Microsoft Access 2010 Bible

Chapter 4: Selecting Data with Queries 133 FIGURE 4.4 The resulting datasheet of the query shown in Figure 4.3 In Figure 4.4, no ...

Part I: Access Building Blocks 134 What queries can do Queries are flexible. They allow you to look at your data in virtually an ...

Chapter 4: Selecting Data with Queries 135 When using an action query, the query’s recordset is gone when the query ends. Action ...

Part I: Access Building Blocks 136 The Show Table dialog box (refer to Figure 4.5) displays all tables and queries in your datab ...

Chapter 4: Selecting Data with Queries 137 The Query Designer consists of two sections: l The table/query pane (top): This is wh ...

Part I: Access Building Blocks 138 l (^) View: Switches between the Datasheet view and Design view in the query window. The View ...

Chapter 4: Selecting Data with Queries 139 FIGURE 4.8 Adding fields in the QBE grid. Clicking the down arrow in the field box re ...

Part I: Access Building Blocks 140 The fields are added to the QBE grid in the order in which they occur in the table. You can a ...

Chapter 4: Selecting Data with Queries 141 FIGURE 4.11 The datasheet view of the query Cross-Reference Working with records in D ...

Part I: Access Building Blocks 142 Selecting a field in the QBE grid Before you can move a field’s position, you must first sele ...

Chapter 4: Selecting Data with Queries 143 Figure 4.13 shows the Category field highlighted. As you move the selector field to t ...

Part I: Access Building Blocks 144 FIGURE 4.14 Resizing columns in the QBE grid Resizing cursor Removing a field Remove a field ...

Chapter 4: Selecting Data with Queries 145 Click to the left of the D in the Description column and enter ProductDescription: t ...

Part I: Access Building Blocks 146 could start a new query adding all the fields except State, or you could simply “turn off” th ...

Chapter 4: Selecting Data with Queries 147 Access still considers the State field because it contains the query’s criteria, but ...

Part I: Access Building Blocks 148 FIGURE 4.18 An ascending sort has been specified for the LastName and FirstName fields. Outer ...

Chapter 4: Selecting Data with Queries 149 FIGURE 4.19 The order of the fields in the QBE grid is critical when sorting on multi ...

Part I: Access Building Blocks 150 You specify criteria in the Criteria row of the QBE grid. You designate criteria as an expres ...

Chapter 4: Selecting Data with Queries 151 Figure 4.20 shows both the query design and the datasheet resulting from the query. T ...

Part I: Access Building Blocks 152 Run the query. Figure 4.21 shows how the query should look. FIGURE 4.21 Specifying text and ...