There are four ACTION Queries that can be used in your Microsoft Access database; Make-Table, Append, Update and Delete.
This video tutorial covers two of them; Append and Delete wrapped with a macro to similuate how to delete a record but first archive the record elsewhere.
Microsfoft Access Video Tutorial: Archive System in Access using Queries
Access Database Tutorial – My Additional Points
As the author of this video correctly points out, it’s not a perfect way to archive record as there is room for mis-use and errors and coupled in a macro only highlights the inperfections.
This example also uses a Parameter query which is a very popular query in Microsoft Access and makes this more flexible but again the discipline is with the user making sure they enter a valid and correct ID or code value as it has no error checking functionality.
The ultimate solution in Microsoft Access?
Learn to use VBA code – a programming language which is not difficult but requires a little effort. Here, you can control logical workflows and handle unknown records and errors.
What else do you need to know in your Access Database?
How to build queries whether it’s a collection of ACTION queries or other powerful and essential queries that is required for your Microsoft Access database application.
My two eBooks; “How to Access Database Queries” and “More Access Database queries” covers all the queries you will need to know. The added benefit with my eBooks (which there are more!) is that they come with a 30 day free email support to help you as you learn Microsoft Access plus, there’s a money back guarantee too!