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

Microsoft Access Queries: An Action Query

By Author: Microsoft Access
Total Articles: 6

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

Computer Programming Articles

1. Energy Bill Calculator Helps To Estimate And Take Measures To Cut Down Costs On Electricity Bill
Author: Splendergy

2. Tally Gst Traning Course By Cs-it Desk
Author: Rajveer Singh

3. Cross Platform Is The Best Choice To Develop Mobile Application?
Author: Amit Tiwari

4. How To Get Quickbooks Online Help For Banking Issues?
Author: Igor Mohan

5. Top 9 Open Source Devops Tools
Author: Sanjana D

6. Is A Computer Programming Career Suitable For You?
Author: Edmund Brunetti

7. 5 Steps To Find The Best Ios App Developer
Author: Manish Shrimal

8. Progressive Web Apps
Author: Brilliant Infosys

9. Agency To Adapt Your Inventory
Author: XIN

10. Web Development Company In Madurai | Spiegel Technologies | Web Developers In Madurai
Author: lucymicheal

11. Golang Services At Scalent
Author: Nehal Shah

12. Exceptional Advance For Rocket
Author: XIN

13. Powerful Tips To Fight Rscit Exams
Author: Rajveer Singh

14. Date Criteria May Not Always Work With Ms Access Query
Author: Ben Beitler

15. What To Do If, Office Is Showing The Busy Message While Opening Any Office Program
Author: James Smith

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