what is query in ms access

what is query in ms access

1 year ago 34
Nature

In Microsoft Access, a query is a request for data results and for action on data. It can be used to answer a simple question, perform calculations, combine data from different tables, or even add, change, or delete table data. Queries can be used to retrieve data from a table or make calculations, which are called select queries, or to add, change, or delete data, which are called action queries. Queries can also be used to supply data for a form or report. In a well-designed database, the data that you want to present through a form or report is often located in several different tables, and a query can pull the information from various tables and assemble it for display in the form or report. Queries can be saved and used later, and someone with little Access knowledge can run them. There are many types of queries, and the type of query created depends on the task.

Read Entire Article