• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 34. Using Queries > Updating Table Records Using an Update Query

Updating Table Records Using an Update Query

Four kinds of action queries will be covered on the next few pages: update, delete, append, and make-table. The first of these, the update query, makes changes to all records in the selected fields of one or more tables. You can create a new update query or you can adapt an existing select query.

To start an update query:

1.
Create a query containing the records you want to update in one or more tables, and select the fields you want to use for the criteria.

2.
With the query open in Design view, choose Update Query from the Query Type pull-down menu (Figure 34.26).

Figure 34.26. Choose Update Query from the Query Type pull-down menu…


or

Choose Update Query from the Query menu.

3.
Type information in the Criteria cells, if necessary.

4.
Type an expression or a value in the Update To cell in the query design grid (Figure 34.27).

Figure 34.27. The query increases all fees by 25 percent.


5.
Click the Datasheet view button to see the fields that will be updated.

6.
Click the Design View button to return to Design view.

7.
Run the query.

8.
Access gives you an opportunity to change your mind (Figure 34.28). Click Yes to continue.

Figure 34.28. Click Yes to continue.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint