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. 2.Choose the New button. 3.Choose the Query Wizard that you desire. 4.Follow the directions as they are presented to you on the Cue Cards to create the type of query you want. 1.In the Database window, click the Query button.