Access 2016 Intermediate

Lesson 4 – Designing Advanced Queries

Access 2016



Step-by-Step

Create a concatenation query.

Open the Rep Orders query in Design view.

Steps

Practice Data

1. Select any blank Field row in the design grid. The insertion point appears in the corresponding Field row. 2. Type the desired concatenation expression.

Click in the blank Field row to the right of Customer ID

Type Sales Rep: [first_name]&" "& [last_name]

The concatenation expression appears in the Field row.

3. Press [Enter] .

Press [Enter]

The concatenation field is added to the design grid.

Run the query. Widen the Sales Rep column as necessary to display all the characters in it. Notice that the Sales Rep column displays the first and last name, separated by a space.

Close and save the query.

F ILTERING A Q UERY



Discussion

You can filter a query in the same way you filter a table or form. Since the data you want to filter sometimes appears in two or more tables, you might need to create a multiple table query. Once the query has been created, you can apply a filter to temporarily isolate the records you want to view.

The Filter By Selection feature allows you to quickly and easily filter a query to display only those records in which the selected value appears. Conversely, the Filter Excluding Selection feature filters out the selected value, leaving only those records that do not contain the selected value.

Page 84

OFFICEPRO, Inc.