123ArticleOnline Logo
Welcome to 123ArticleOnline.com!
ALL >> Computer-Programming >> View Article

Microsoft Access Queries: An Action Query

Profile Picture
By Author: Microsoft Access
Total Articles: 4
Comment this article
Facebook ShareTwitter ShareGoogle+ ShareTwitter Share

You use this type of query to change data in tables, saving the need to manually edit records or use any of the manual tools namely, Find and Replace. Examples for this action could be to reset data, change prices, increase volume and correct data migration and population issues.

One of the more commonly used examples is to carry out some sort of calculation and change prices for a range of products.

Ms Access Query

The above example increases all products for UK suppliers by 10% using the [Unit Price] field containing the original price value multiplied by 1.1 (an increase by 110%).

Just remember, this is an action query which means changes to any data values cannot be reversed once actioned which is why you should normally see a warning first.

However, it is always a good idea to take a copy or back up of your data files before running Microsoft Access queries of this nature.

There are many other types of queries too and the more you know about Access queries, the more flexible your database will be and produce more effective reports.

I have a couple eBooks about MS Access queries ...
... which may be of interest – why not check these and other Microsoft Access database eBooks out!

More About the Author

My name is Ben Beitler (based in London, UK) and I have been building, consulting & training with Microsoft Access databases for over 20 years.

Total Views: 573Word Count: 205See All articles From Author

Add Comment

Computer Programming Articles

1. Helping Travel Leaders Deploy Hotel Rate Comparison Automation
Author: webfusion

2. Drive Automated Website Data Collection For Profitable Roi
Author: webfusion

3. How To Monitor Competitor Stock Availability Across Online Retailers
Author: KVETOIQ

4. How Professional It Consultants In Nyc Help Businesses Improve Technology
Author: Sam Vohra

5. How Do You Choose A Commercial Display Fridge For A Supermarket?
Author: Sanjiv Chaudhary

6. Product Matching At Scale: How Retailers Match Exact Products, Variants & Comparable Items Across Marketplaces
Author: KVETOIQ

7. Enterprise Web Crawling At Scale: 10 Requirements For Reliable, Continuously Refreshed Web Data
Author: KVETOIQ

8. Quick Commerce Data Scraping: How Businesses Can Turn Real-time Market Data Into A Competitive Advantage
Author: KVETOIQ

9. Best Data Extraction Companies In India (2026): 8 Managed Providers For Custom Business Data
Author: KVETOIQ

10. Ecommerce Assortment Intelligence: How Retailers Track Product Gaps, New Launches & Category Changes
Author: KVETOIQ

11. Simple Google Maps Business Data Scraping For Global Reach
Author: webfusion

12. Amazon Price Monitoring: How Brands Track Competitor Prices, Discounts & Stock Changes
Author: KVETOIQ

13. Product Engineering Solutions In The Usa: Building Scalable And Innovative Digital Products
Author: John Smith

14. How An Emergency Assembly Point Helps Organize Workplace Evacuations
Author: How an Emergency Assembly Point Helps Organize Wor

15. How To Improve Workplace Safety Awareness Through Daily Practices
Author: scrum

Login To Account
Login Email:
Password:
Forgot Password?
New User?
Sign Up Newsletter
Email Address: