Lomonox

All of the queries that you have created to this point have been variations of “select” queries. Select que-ries are used to display data but do not actually change the data in any way.


Queries, in contrast, are used to change the data in existing tables or make new tables based on the querys results set. The primary advantage of action queries is that they allow you to modify a large number of records without having to write Visual Basic programs. Access provides four different types of action que-ries:

1. Make table— creates a new table based on the results set of the query;
2. Append— similar to a make-table query, except that the results set of the query is appended to an existing table;
3. Update— allows the values of one or more fields in the result set to be modified; and,
4. Delete— deletes all the records in the results set from the underlying table.