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: 461Word Count: 205See All articles From Author

Add Comment

Computer Programming Articles

1. Custom Snowflake Data Solutions
Author: brainbell10

2. Sketch Digital Design & Product Experience Services
Author: brainbell10

3. Artificial Neural Network Tutorial: Step-by-step Guide To Understanding Neural Networks
Author: Tech Point

4. Sitecore Development Top App Development
Author: brainbell10

5. Learn Mern Stack Online: Tcci Ahmedabad Hub
Author: TCCI - Tririd Computer Coaching Institute

6. Deep Learning Tutorial: Master Deep Learning Basics And Applications Easily
Author: Tech Point

7. Redis Database Development & Integration Services
Author: brainbell10

8. What Is Dynamics 365 Customer Engagement?
Author: davidjohansen

9. Market Forecast: Data Preparation Tools
Author: Umangp

10. Sharepoint Tutorial: Learn Microsoft Sharepoint Basics To Advanced With Examples
Author: Tech Point

11. Is Your Crush Really Crushing On You? Find Out With The Love Tester Online
Author: Katie Heffron

12. Wpf Tutorial For Beginners: Step-by-step Guide To Build Desktop Applications
Author: Tech Point

13. Dynamics 365 Sharepoint Integration Guide
Author: davidjohansen

14. Transparent Managed It: Why Regulated Businesses Are Moving To Productized Service Tiers
Author: ECF Data

15. Quick & Reliable Otdr & Splicing Machine Service In Mumbai
Author: bdean

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