Various Access Query Types
| 1) | Select query Used for viewing and updating data manually through forms and reports. |
| 2) | Crosstab query Presents a cross-tabulation of data. This view is read–only. |
| 3) | Make-Table query Creates a new table from the results set. |
| 4) | Update query Updates existing data in the results set. |
| 5) | Append query Adds new records in an existing table. |
| 6) | Delete query Deletes records in the results set. |