Access 2016 Intermediate

Lesson 5 – Creating Action Queries

Access 2016

If the fields in both tables have the same names, the copied data is automatically appended. If the fields have different names, however, you must specify the fields to which you want to append the data.

Use criteria to select the records you want to append. Only those records that meet the criteria are appended to the table.



Procedures

1. Display All Access Objects in the Navigation Pane. 2. Select the Create tab on the Ribbon .

3. Select the Query Design button . 4. Add the desired tables to the query. 5. Close the Show Table dialog box.

6. Select the Append button . 7. Type the name of the table to which you want to append data in the Table Name field.

8. Select . 9. Add the fields you want to append to the design grid. 10. Select the Append To row under an unmatched field, if necessary.

11. Select the Append To list. 12. Select the matching field. 13. Select the desired Criteria row. 14. Type the desired criteria. 15. Run the query.

16. Select

.



Step-by-Step

Create an append query.

Page 96

OFFICEPRO, Inc.