zakruti.com » IT - Software » Geeks Tutorial

How to Create an Update Query in Microsoft Access

video description

Rating: 4.0; Vote: 1

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
Date: 2023-07-08

← How to Create a Calculation Query in Microsoft Access

How to Format Date and Time Values in Access →

Related videos

After 10yrs of Testing, This is the BEST Upscaler. Period.

• PiXimperfect

How to Create a Windows 11 Bootable USB Flash Drive Using Rufus

• Geeks Tutorial

HW News - AMD Says AI Definitely, Absolutely Not A Bubble, New Chinese CPUs, RAM Rip-Off Continues

• Gamers Nexus

Private DIY Servers Are Illegal Black Markets of Piracy - The ESA's Shady Ties

• Gamers Nexus

Windows Recall Is Too Risky, Turn It Off

• PC World

How to Delete Google Account Permanently (Quick & Easy)

• Geeks Tutorial

Comments and reviews: 3

Brian
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.
reply

Joshua
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.
reply

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

Add a review, comment