Jan's Illustrated Computer Literacy 101 Logo:Jegsworks Jan's Illustrated Computer Literacy 101


Home > Jan's CompLit 101 > Working with Databases > Tables & Queries > Queries> Action Queries
Icon: Arrow - Previous pagePrevious    NextIcon: Arrow - Next page

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:

  • Icon:  Make-Table Query 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.

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

  • Icon: Delete Query Delete: Deletes the selected whole records.

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

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

TipIcon: Back Up diskBackup 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.

TipVerify 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 Icon: Run.