access-database-training - Create action query

Hi Janice

Thanks for your question - one way to create an action query is to first build your query as a regular Select Query. Once you are happy that the query is returning the correct records you can then change it to the Action Query type you require.

To do this switch to design view and select the appropriate action query (such as update, append or delete) from the Query menu.

Hope this helps - do let us know if you have any further questions.

Thanks

Andrew