ALL >> Computer-Programming >> View Article
Microsoft Access Queries: An Action Query
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!
My name is Ben Beitler (based in London, UK) and I have been building, consulting & training with Microsoft Access databases for over 20 years.
Add Comment
Computer Programming Articles
1. Enhancing Your App’s User Interface With React Native Ui LibrariesAuthor: matthew brain
2. Navigating The Divide: Data Security Management Vs Cloud Security Management
Author: Karmai
3. Hire Expert Mern Stack Developers | Top-rated Development Team
Author: Ambika Rawat
4. Why Scrape Car Rental Prices: Exploring The Benefits And Challenges?
Author: #CarRentalPricesDataScraping
5. A Step-by-step Guide To Building Your First Website: From Html To Deployment
Author: Vishal Khant
6. Navigating The Digital Currents: How Digital Transformation Is Reshaping Business In 2024
Author: Cliff
7. Github: Revolutionizing Collaboration In Software Development
Author: Adam Scott
8. Hiring Dedicated C# Developers In India: A Guide
Author: Quickway Infosystems
9. Unleashing Viral Techniques In Mobile App Development
Author: Backend Brains
10. 8 Ux Design Tips For Mobile E-commerce App With Examples
Author: goodcoders
11. 8 Simple Ways To Drive Traffic To Website
Author: goodcoders
12. 8 Questions You Must Ask To Find A Good Flutter App Development Company
Author: goodcoders
13. Outsourcing Data Entry Services
Author: evertechbpo
14. Mearastech | Data Modernization: Challenges, Strategies And Best Practices
Author: Mearastech
15. How To Deal With A Damaged Computer Screen? What Should You Do?
Author: Joshua Kirby