Access 2016 Intermediate

Access 2016

Lesson 4 – Designing Advanced Queries

3. Select the Query Design button

in the Other group.

4. Select the table that contains the multivalued field.

5. Select

.

6. Select . 7. Drag the multi-valued field into the query grid. 8. Release the mouse button. 9. Drag any other desired fields into the query grid. 10. Release the mouse button. 11. Select the Design tab on the Ribbon .

12. Select the Run button

in the Results group.



Step-by-Step

Create a multivalued field in a query.

Steps

Practice Data

1. Select the Create tab on the Ribbon , if necessary. The Datasheet tab is displayed. 2. Select the Query Design button in the Other group. The Show Table dialog box opens.

Click Create

Click

3. Select the table that contains the multivalued field. The desired table is selected.

Click Items 2

4. Select Add .

Click

The desired table is added to the query.

5. Select Close .

Click

The Show Table dialog box closes.

OFFICEPRO, Inc.

Page 81