Computer Basics
Windows
Word
Excel

Web
PowerPoint
Access

Jan's Working with Databases

Tables & Queries: Queries: Action Queries

An action query selects certain records and fields and then does something with them. There are four kinds of action queries:

• Make-Table: Creates a new table with copies of selected records and fields. The table's records do not change when the original records change.

• Append: Adds (appends) copies of the selected records/fields to an existing table.

• Delete: Deletes the selected whole records.

• Update: Updates values to new values in the selected records.

No Undo: You cannot "undo" an action query's action.

Backup first: Before running an action query, be sure you have a current backup of the database or an extra copy of the table that will change.

Verify selection first: Be sure you have selected the records that you thought you did! View query's datasheet before running the query. This is why there is a datasheet button AND a Run button. Check the records carefully. Then run the action query with the Run button .