Queries are used to retrieve and display specific records in a table. They can also be used to display specific fields of specific records, which meet the condition specified. A query displays a subset of all or specific fields and records in a table. When a change is made to the data, which is displayed by the query, this change is reflected in the table also. Because of this dynamic relationship between the query and the tables, the subset of the data displayed by the query is called a Dynaset.

An auto Report is the quickest way to create a report for a table or query. It enerates the report with the table name as the heading and page number as the footer.

If the conditions of the query should be entered at the time of execution of query, we specify the query parameter instead of criteria value or constant. Query parameters are specified inside large braces. Thus, when the query is run, the values of parameters are asked and accordingly the records will be presented.
To set query parameter, type the message inside large brackets in the criteria box of required field. To specify data type of parameter you can select Parameter option from Query menu. In the parameter column, type the message entered in Criteria box then, selects the type of the value that the user has to enter when query is executed in the Data Type column from the drop down list.

It is easy to append records from one table to another using an append query. There is no need for the tables to have the same number of fields or same field names. However, the two tables must have matching fields and the data for primary key field should be unique and non-empty.

A wizard that helps us to present the data in a 2-dimensional tabular format is the crosstab query wizard. You can use this to create queries that will depict the data in particular fashion, i.e. item wise sales made or customer wise sales made etc.