Question: what is the difference between select queries and action queries?
Answer: A select query never alters the contents of a table. An action query is different from a select query in that an action query changes the contents of a table. In Access, you create action queries in much the same way you create select queries. ... Change multiple fields and records within a table.