Special Edition Using Microsoft® Office Access 2003

Chapter 13. Creating and Updating Jet Tables with Action Queries

In this chapter

• Getting Acquainted with Action Queries

• Creating New Tables with Make-Table Queries

• Creating Action Queries to Append Records to a Table

• Deleting Records from a Table with an Action Query

• Updating Values of Multiple Records in a Table

• Testing Cascading Deletion and Cascading Updates

• Troubleshooting

• In the Real World—Alternatives to Action Queries

Getting Acquainted with Action Queries

Action queries create new tables or modify the data in existing tables. Access offers the following four types of action queries:

• Make-table queries create new tables from the data contained in query ...