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

Chapter 4. Taming Access Data > Running Action Queries

Running Action Queries

All the queries you’ve worked with to date have been select queries. A select query is one in which Access uses the query criteria to select the matching rows from a table or join. However, Access has several other query types that are designed to perform actions on the data, such as changing values, adding records, deleting records, and writing records to a new table. These so-called action queries are the subject of the next four sections.

Modifying Table Data with an Update Query

Access, like many programs, has a Replace command that enables you to substitute one piece of text for another either in certain records or throughout a table. Although this command often comes in handy, there are some jobs it simply can’t handle. For example, what if you want to replace the contents of a field with a new value, but only for records that meet certain criteria? Or what if your table includes price data and you want to increase all the prices by 5%?


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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