O'Reilly logo

Microsoft® Access® 2010 Inside Out by Jeff Conrad and John Viescas

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 11. Modifying Data with Action Queries

In Chapter 9, you learned how to insert, update, and delete single rows of data within a datasheet. In Chapter 10, you discovered that you can use queries to select the data you want—even from multiple tables. You also learned under what conditions you cannot update a field in a query. Now, you can take the concept of queries one step further and use action queries to change, insert, create, or delete sets of data in your database quickly.

The four types of queries you’ll study in this chapter are

  • Update query. Allows you to update the fields in one ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required