Microsoft Access 2013 Plain & Simple

Chapter 7. Modifying data using queries

In this section:

• Creating a table by using a Make Table query

• Adding data to an existing table with an Append query

• Changing data in a table with an Update query

• Deleting data in tables with a Delete query

• Adding only new data that is not already in a table

• Updating a column based on an expression

• Resetting an AutoNumber with an Append query

The queries described in this section are a special type called action queries, which differ from the select queries previously discussed in that they are used to change data in the database. For example, rather than doing a search and replace, you can create a query to do that work for you. However, the power of these queries is greater than a simple search and replace because ...