How to Create an Update Query in Microsoft Access

In this tutorial, we will teach you how to create an update query in Access.

To alter the existing values simply create an update query in Microsoft Access. This allows you to alter the math behind the values. You can make changes to your data in the table using the update query.
In this tutorial, we will update the prices of all the products without opening the products table.

Step 1 -- Go to the create tab

To create an ms access update query, move to the create tab and then click on the query design button. Add the product tables and close the show table window.

Step 2 -- Click the Update button

From the products table, let's select the price field. Now click on the Update button from the query type group.

You will notice a new update row will be added over here. In the update line, put in a square bracket and type in price. With that done, let's put another square bracket to close the keyword, followed by an asterisk sign for multiplication. After that, let's type in the percentage by which you want to increase the price. Over here we have multiplied the price by 1.2 indicating a 20% increase in the prices of all the products.

Step 3 -- View the original list

Now let's click on the view button and you will notice the present prices of all the products.

Step 4 -- Select the run button

To toggle back, click on the view button and now press the run button. A dialogue box will appear telling you that prices will be changed. Let's click on Yes to proceed and view the changes made through the ms Access update theory.

Step 5 -- View the updated list

To view the changed prices, open up the products table and you will notice that the prices are now 20% more than they were before.

And that's it, by following these steps you can learn how to create an update query in Access.

[howtechoffice]

❗ Subscribe To Our Main YouTube Channel

[vishnudrajan]

Professor needed 2 months to complete this and this guy did it under 1 min

[nelsonalexandercorrea]

I cant believe I forgot how to do this. im so good. Thank God Im not an IT major.

[Fliplove]

Do you have chapter 6 Access Grader Project - Northwind Product Analysis?

[carlosguerra]

Will it affect the existing sales table having the old product price?

[dominiqueabigail]

will it update all table with the similar data ?

[mism]

what if you want to increase the price of only some products, and you want increase another % for the other products

[sebbyshoopala]

what if i want to update certain numbers in a single record

[civilEngineering]

hello sir, i want to replace the empty cells to any text, how to do that?

[angeldsouza]

Can I update one table record in another

[susmitamazumder]

if in quantity field how to add certain number

[joshuamonaro-adams]

Hi, im trying to create an update query basically exactly as is shown in this tutorial, im increasing prices in a field by 3.6%, but when i run the query i get an error telling me i have a type conversion failure. please help.

[Brian-fzxj]

Just a warning - I was updating a column in a table by decreasing it by a certain percent. If I had the update query in with two others in a saved update query (they updated columns in a different table), the results were just simply wrong... no error msg ... just wrong. If I ran the update query by itself it worked fine. Glitch in Access.