Actions Query

Action queries are a way to make corrections to database. They can make an enormous mess of database if used incorrectly. Action queries differ from select queries: A select query shows you data that meet your criteria. An action query looks for the data that meets your criteria, and then does something with it, such as making changes to the data or moving records to a new table.