SQLConfiguration SQLConfiguration


Refining Queries  «Prev 

Various Access Query Types

Microsoft 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.