Creating Other Types of Queries
Access enables you to create the following four basic types of queries to achieve different objectives:
Select. Select queries extract data from one or more tables and display the data in tabular form.
Crosstab. Crosstab queries summarize data from one or more tables in the form of a spreadsheet. Such queries are useful for analyzing data and creating graphs or charts based on the sum of the numeric field values of many records.
Action. Action queries create new database tables from query tables or make major alterations to a table. Such queries enable you to add or delete records from a table or to make changes to records based on expressions that you enter in a query design.
Parameter. Parameter queries repeatedly ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access