How To Create Statistical Queries In Access 2010


show more Creating statistical queries provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training show less
please wait ...

Creating statistical queries

If you'd like to run statistical analysis on your database, you can use a Totals Query. Create a new query by clicking on the Create tab and then on Query Design. Add the Products table and the Orders table, and click Close. We sell olive oils in 8, 16, 32, 64 and 128-ounce bottles. We're going to analyze our products, grouped by size. Double-click on Size, and then on Price, and then on Profit, and then double-click on Profit a second time.

On the Orders table, double- click on OrderID and Quantity. Up on the Ribbon, there is a Totals button. Click on it, and you'll get an additional row down here on the grid. It defaults to Group By. We'll leave Size as Group By. This will group the bottles by size, no matter what kind of oil it is. Under Price, choose Average. Under Profit, click the dropdown and choose Min. On the second Profit from the dropdown, choose Max.

From the OrderID, choose Count. Under Quantity, select Sum. Now click on the View. We can see, by size: our average pr...

Creating statistical queries
Video duration: 3m 1s 3h 30m Beginner

Viewers:

Creating statistical queries provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training

please wait ...