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

Part 2: Building a Microsoft Access Desk... > Modifying Data with Action Queries

Chapter 9. Modifying Data with Action Queries

Updating Groups of Rows337
Creating a New Table with a Make-Table Query346
Inserting Data from Another Table352
Deleting Groups of Rows356
Troubleshooting Action Queries360


In Chapter 7, “Creating and Working with Simple Queries,” you learned how to insert, update, and delete single rows of data within a datasheet. In Chapter 8, “Building Complex Queries,” 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 quickly change, insert, create, or delete sets of data in your database.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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