Getting to Know Microsoft Access, Part 6: Advanced Queries and SQL - Update Queries
(Page 3 of 5 )
To create an update query, begin with a new query design, just as you did when you made your first parameter query. Then, select your table(s) and/or query(ies) from which to base your new query from the dialog box, and choose the Query | Update Query menu option in design view. Drag the fields you want to update from the list of fields in the table to the query grid. Enter the expression you wish to use to limit the records you will update in the Criteria cell. Then enter the expressions you’ll use to update the records in the "Update To:" cells. Finally, save and run your query. When you create an insert query the design view looks similar to the following:
You’ll notice that the Queries tab shows your new query with a exclamation point attached to it, as a warning, to let you know the query is an action query and as such will produce changes to your data. All the action queries you create are shown in the Queries tab with an exclamation point.
Append Queries
Append queries are used to copy fields from one selected table to another table. To create an append query you first need to select the fields you want to copy, and then select the table to copy those fields to, making sure, of course, that the target field has corresponding fields. To create the append query, first start a new query in design view by choosing the table from which you want to take the data, and choose the Query | Append Query menu option. You’ll be prompted to enter a table name. Next, choose the table to which you want to append the data. Select the fields you want to append to the table by dragging and dropping them into the query design grid. Add criteria as you like. Save and run the query. When you create an append query the design view looks similar to the following:
Next: Delete Queries >>
More Microsoft Access Articles
More By Sage Adams
