How to Create an Update Action Query in Microsoft Access

Next Video:
How to Define a Date Format for a Microsoft Access Field....5

In Microsoft Access, creating an update action query means starting with a table that contains data and changing the query type from "Select" to "Update." Create an update action query, and rerun the query with help from a computer programming teacher in this free video on Microsoft Access.

Part of the Video Series: Microsoft Access Tutorial
Promoted By Zergnet


Video Transcript

Hi, my name is Chip Browne. I teach computer programming in Microsoft Office Applications at Steven Henagar Business College here in Utah. I also create practice tests for Microsoft Office Applications Special Certifications. Today we're going to learn how to create an update action query in Microsoft Office Access 2007. Microsoft Access is a registered trademark of Microsoft Corporation. I'm not affiliated with Microsoft Corporation. To perform an update action query, you need to begin with a table with data in it. Here's a table that has two columns, string id and string data. We'll modify string id 115 and have a different string data. To do this, we need to go into the query design tool. Click on create tab and to the other group, click on create design. Add the table that will be updating. Next, change the query type from select which is the default to update. Now add the field that will contain the criteria of the record. Now add the field that has a new value. Now rerun the query. You're prompted that one will be updated and that this is irreversible. Now let's look at the table. Here's string id 115 and here is the new string. This is how you create an update action query. For more information and videos, visit me Chip Browne at; that's brown with an e.


Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!