O'Reilly logo

Access 2019 For Dummies by Ken Cook, Laurie A. Ulrich

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 17

Take Charge with Action Queries

IN THIS CHAPTER

check Updating multiple records that match specific criteria

check Adding records from one table into another table

check Deleting multiple records that match specific criteria

Ever have to update multiple records in a table with the same information? How about copying data from a linked spreadsheet into an existing Access table? What about deleting a certain group of records from a table? If you answered yes to any of these questions, then you’ve come to the right place. Action queries perform a specific task on a group of records in a table, all in one fell swoop, so you don’t have to add or update each record manually. (Now, try to control your excitement! If you ever get into the situation where an action query is needed, I know you’ll thank me for writing this.)

The three most common action queries are:

  • Update: This query updates the value in a field for the records you select via the Criteria row. For example, if an employee keys in the wrong order date of 11/2/2019 on 25 orders, an update query would allow you to easily update all 25 order dates to the correct date of 11/3/2019.
  • Append: Use this query type to add records from one ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required