Action queries create new tables or modify the data in existing tables. Access offers the following four types of action queries:
Note
This chapter shows you how to create each of the four types of Jet action queries and how to use Access's cascading deletions and cascading updates of related records. Cascading deletions and cascading updates are covered here because these referential-integrity features are related to delete and update action queries, respectively. Tip Always make a backup copy of a table that you intend to modify with an action query. Changes made to table data with action queries are permanent; an error can render a table useless. Invalid changes made to a table with an action query containing a design error often are difficult to detect. |