Microsoft Access 4C: Action Queries: Delete Query, Append Query, Update Query

Action Queries:

• Action queries do work for the user such as deleting specific records, updating specific records or moving specific records to another table

• You create an action query from a regular query by selecting one of the Query Types from the Design Tab

Delete Query:

• A delete query will delete records that you specify in the query

Example

You may want to delete all student's records who are in grade 12 at the end of the school year as these students have graduated

Updating Query:

• An update query will update certain records specified in a query

Example

You may want to update the grade of all grade 11 students to grade 12 automatically in a large database instead of changing each one individually

Append Query:

• An append query makes a copy of certain records into a different table of your choice

Example

• Before you delete all student records in grade 12 you may want to move them into a different table that isn't part all of your other queries and reports but still can be accessed in the future to look up a student who graduated in a certain year

Danger:

• Action queries can be very dangerous if a mistake is made

Example

Let's assume that you want to update 3,000 customer records from a 780 area code to a new area code 416, but you accidentally update all 60,000 records in your database (if you didn't have a backup copy you would be in big trouble as the other 57,000 customers may have had any one of 10 different area codes that has now been replaced)

• Making regular backups is essential to good data management

This website is copyright protected see contact page for details.