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