Creating an update query


show more Creating an update query provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts show less
please wait ...

Creating an update query

When you want to make changes to your data, you don't have to update all the records individually one at a time. You can use an Update action query to make the changes all at once. Right now, I am in my Customers table. If I scroll over to my right-hand side, I can see my SalesReps. When I click on any SalesRep and use the dropdown, I can see their name. Now let's say that my SalesRep Collins is leaving the company. We're going to give all of her customers to Pearl Davenport, SalesRep number 10. So we need to update all of the 8s to a 10.

I'll go up to my Create Ribbon, and then to Query Design. I'll add my Customers table to the grid and close the window. I'll scroll down to find my SalesRep field, and double-click on it to add it to the grid. Now I'll go up to the Ribbon, and change my Query Type to an Update query, and now I have a new row in my grid, Update To. So my Criteria is that I'm looking for SalesRep number 8, and I'm going to update it to Sa...

Creating an update query
Video duration: 2m 55s 3h 43m Intermediate

Viewers:

Creating an update query provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts

Subject:
Business
Software:
Access
Author:
please wait ...