Types of Queries

Types of Queries

1. Select Query – selects a group of records from one or more tables and displays the result in a datasheet where you can update records.
2. Cross-tab Query – group data into categories and displays values in a compact, spreadsheet-like format with summary totals.
3. Parameter Query – a query that when run displays a dialog box prompting you for information such as criteria for retrieving records or a value.
4. Action Query – makes changes to many records in just one operation. There are four types of action queries: make table, delete, append and update.
5. SQL Query – query you create using an SQL statement.

1. Select -Select Query
2. Crosstab -Cross-tab Query
3. Make Table - Action Query
4. Append - Action Query
5. Update - Action Query
6. Delete - Action Query
7. Union - SQL Query
8. Pass-Through - SQL Query
9. Data Definition - SQL Query
10. Parameters - Parameter Query