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
.