What are the query types supported by access?

The query types supported by access are selection query, crosstab query, parameter query, SQL query and operation query; in Access, operation query, crosstab query and parameter query can all be created based on the selection query. Multi-table queries and single-table queries are not types of Access queries.

The operating environment of this article: Windows 7 system, Dell G3 computer, Microsoft Office Access 2019 version.

(Recommended tutorial: access database learning)

The query types supported by access are selection query, crosstab query, parameter query, SQL query and operation query.

In Access, operation queries, crosstab queries and parameter queries can all be created based on selection queries. Multi-table queries and single-table queries are not types of Access queries.

A query can be created with one table or query as the data source, which is called a single table query; a query can also be created with multiple tables or queries as the data source, which is called a multi-table query: Statistical query is not Type of Access query.

In the query, statistical calculations can be performed, including sum, average, maximum, minimum, etc.

The above is the detailed content of What are the query types supported by access?. For more information, please follow other related articles on the PHP Chinese website!