Microsoft Office Tutorials and References
In Depth Information
Changing Data with Update Queries
3. View the records that the query will act on by clicking the View button.
Check the datasheet displaying the records that the query will act on.
Make sure that you see all the records you want to change and none that
you don’t want to change.
4. Click one of the Query Type buttons — Make Table, Update, Append,
or Delete — to choose the type of action query you need.
You see the Query Type buttons when you view a query; they’re on the
Query Tools Design tab.
5. Add the information about what you want the query to do (update
data, append data, make a table, or delete data).
The details are covered in the following sections on each type of query.
6. Double-check that you’re asking Access to act on the correct data by
clicking the View button again.
7. Click the Run button to run the query.
Access warns you that you’re about to make changes that you can’t undo.
If you see a message that the action has been blocked, refer to the steps
at the end of the preceding section.
8. Click the Yes button to run the query.
Access runs the query. Keep breathing!
9. Check your results.
View the affected tables to make sure that the results are as desired.
Viewing the action query’s datasheet isn’t enough. If the action query
acts on a field that you use in a criterion, you may not see the records
that change after the query has run; you may have to look at the table
that holds the raw data or create a new query to view the results.
The make-table query creates a new table. View those results in the
affected tables, not in the query datasheet.
10. If you won’t be using the action query again, delete it.
Action queries are dangerous things to have lying around!
Changing Data with Update Queries
You can use an update query to change a pile of data at the same time — to
raise prices by 10 percent, for example, or to replace a product number with
a new product number.
Search JabSto ::




Custom Search