Using a query makes it easier to view, add, delete, or change data in your Access database. Some other reasons for using queries:
Find specific quickly data by filtering on specific criteria (conditions)
Calculate or summarize data
Automate data management tasks, such as reviewing the most current data on a recurring basis.
In a well-designed database, the data that you want to present through a form or report is usually located in multiple tables.
A query can
pull the information from various tables and assemble it for display in the form or report.
either be a request for data results from your database or for action on the data, or for both.
give you an answer to a simple question, perform calculations, combine data from different tables, add, change, or delete data from a database.
Since queries are so versatile, there are many types of queries and you would create a type of query based on the task.
There are two major types of queries
Select: To retrieve data from a table or tables, or to make calculations.
Action: Add, change, or delete data. Each task has a specific type of action query. Action queries are not available in Access web apps.
Behind every MS-Access query is Structured Query Language (SQL) . Interestingly it was developed in the 1970s and has been a mainstay for getting information out of databases since then. Microsoft (MS)-SQL, MySQL and Oracle are all based on this.
Microsoft Support (2022) Introduction to queries. https://support.microsoft.com/en-us/office/introduction-to-queries-a9739a09-d3ff-4f36-8ac3-5760249fb65c