Action queries are not available in Access web apps. Each task has a specific type of action query. To retrieve data from a table or make calculations.Īdd, change, or delete data. Since queries are so versatile, there are many types of queries and you would create a type of query based on the task. A query can give you an answer to a simple question, perform calculations, combine data from different tables, add, change, or delete data from a database. A query can either be a request for data results from your database or for action on the data, or for both.
A query can pull the information from various tables and assemble it for display in the form or report.
In a well-designed database, the data that you want to present through a form or report is usually located in multiple tables. Queries help you find and work with your data Note: If you want to try out the queries in the examples, use an Access desktop database.
0 kommentar(er)
