A select query may simply provide too much information. If the data can be numerically summarized, then a crosstab query can help access the data more sensibly. For example, to see how much money each of the recipients on a mailing list were spending when ordering from your catalog. Use Design View to create and modify the design of a new or existing query, using graphical tools. In Datasheet View look at the data retrieved by a query in a spreadsheet-like format.
View allows examination and modification of the statements that underlie the query.
Use Print Preview to see how query data will look in print. Crosstab Query organizes data for a summary appearance. Find Duplicates Query finds duplicate records in a table or query. Find Unmatched Query finds all the records in one table that don't have related records in another table. In the Database window, click the Query button.