Query is an object of database that is used to view, retrieve, change and analyze records from a table based on specified condition.
- When a user changes data in the query, the data in the table also changes. It can be used as a source of records for forms and reports.
The types of queries in Ms-Access are:
- Select query
- Parameter query
- Cross tab query
- Action query
- Append query
- Update query
- Delete query
- Make-Table query
Query can be created in:
- Design view
- Simple query wizard
- Crosstab query wizard
