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

Add Comment

Computer Programming Articles

1. Which Is The Best Programming Language To Build A Mobile App?
Author: DianApps

2. Explore Career Growth With The Best Business Analytics Courses In Bhopal
Author: Rohan Rajput

3. From Zero To Hero: Python Pygame Tutorial For Aspiring Game Developers
Author: Tech Point

4. Beginner’s Python Pytorch Tutorial: Start Your Ai Journey Today
Author: Tech Point

5. Top 10 Cloud Security Threats And How To Prevent Them
Author: GIGABITTechnologies

6. Error Code 30174-45 In Office 365/2019/2021 In Windows 10/11
Author: jamess

7. Complete Python Tkinter Tutorial: Master Gui Programming Easily
Author: Tech Point

8. Unlock Your Data Skills With The Best Business Analytics Courses In Bhopal
Author: Rohan Rajput

9. Clinic Management Software: Features, Benefits, And How To Choose The Right One
Author: Agness Ruth

10. Top Training Institutes For The Best Business Analytics Courses In Bhopal
Author: Rohan Rajput

11. Why Is The Cloud Networking Solution Important For Any Business?
Author: GIGABITTechnologies

12. Pros And Cons Of Having A Design System
Author: brainbell10

13. Discover The Best Business Analytics Courses In Bhopal To Elevate Your Career
Author: Rohan Rajput

14. Exploring Decentralized Exchange Development
Author: davidbeckam

15. How Decentralized Exchanges Make Crypto Trading Better
Author: davidbeckam

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