Access 2016 Intermediate

Lesson 4 – Designing Advanced Queries

Access 2016

Steps

Practice Data

6. Drag the multivalued field into the query grid. The multivalued field is selected.

Drag the Color field into the query grid

7. Release the mouse button.

Release the mouse button

The multivalued field is added to the query grid.

8. Drag any other desired fields into the query grid. The desired field is selected.

Drag Product Description into the query grid

9. Release the mouse button.

Release the mouse button

The desired field is added to the query grid.

10. Select the Design tab on the Ribbon . The Design tab is displayed. 11. Select the Run button in the Results group. The query result is displayed.

Click Design , if necessary

Click

The query result appears with one column displaying the multivalued field ( Color ), and the second column displaying Product Description field.

Close the Query.

C REATING A C ONCATENATION IN A Q UERY



Discussion

A concatenation query allows you to combine two or more text fields into one field. In other words, concatenation enables you to append one text string to another. In addition, you can insert characters between the text strings as needed. For example, you can concatenate the City , State , and Postal Code fields and store the concatenated text string in a fourth field, the Address field, adding commas and spaces between the text strings as needed.

When typing a concatenation expression, the first part of the expression defines the name of the new field and the second part of the expression defines the fields which are to be concatenated. All field names must be surrounded by brackets. The

Page 82

OFFICEPRO, Inc.