Three Access Query Types
General Query Type
- Select Queries
- most frequently used type
- can select records, create new calculated (derived) fields, or summarize data
- Action Queries
- Make table
- Creates a new table from a dynaset
- Create backup copies of tables
- Save history table of old records being deleted from another table
- Create table for export