Microsoft Office Tutorials and References
In Depth Information
Creating a Query with the Simple Query Wizard
Now that you have the hang of what a query is, you’re probably ready for
more: getting summary data out of a query, sorting the results, limiting
results with criteria, and so on. Read on!
Creating a Query with the Simple Query Wizard
The Simple Query Wizard does a great deal of the work of creating a query
for you. It’s most useful when you want to use fields from different tables
and when you want a query that summarizes your data by calculating totals.
The Simple Query Wizard gives you the option of creating a summary query
or a detail query. A detail query lists every record that meets your criteria. A
summary query (also called a totals query) performs calculations on your data
to summarize it. You can create a summary query if the fields you choose for
the query include both of the following:
A field with values
A field with repetitions or a field with dates, used to group the values
A summary query gives you the option of totaling (summing), averaging, or
counting the number of values in a field, or finding the minimum or
maximum value in a field. A summary query creates new calculated fields that
you can use in other queries or in reports.
Need an example? Here’s one: If you have a field that lists the amount spent
and a field that lists the dates on which the money was spent, the Simple
Query Wizard creates a summary query for you that sums the amount spent
by date. Pretty neat, huh?
Ready to give the Simple Query Wizard a spin? Just follow these steps to use
the wizard to create a query:
1. Click the Query Wizard button on the Create tab of the Ribbon.
2. Select Simple Query Wizard in the New Query dialog box and then
click OK.
Access displays the first window of the Simple Query Wizard, shown in
Figure 1-4.
3. From the Tables/Queries drop-down menu, choose the first table or
query that contains fields you want to use in this query.
Many queries are based on tables, but you also have the option of
basing a query on another query. Maybe you’ve already created a query
to select sales data only from 2013. Now, without modifying the original
query, you want to create a query that lists 2013 sales by state or limits
the analysis to just a few salespeople.
Search JabSto ::

Custom Search