Assignment

Reports:

For each Region, show the sum of Sales, grouped by Product Container. You can include the

sums using the "Summary Options" button in the third Report Wizard window, where you select

ascending or descending order $-$ choose the summary $($sum$)$ only, not summary and details. Use

the Layout View to expand any text boxes too small to display the Sales values $-$ these will

display as

Show the sum of Profit for each combination of $\{$Province$,$ ProductCategory, OrderPriority$\}.$ Group

the records by Province, then ProductCategory, then OrderPriority, and only show the sum of

Profit, not other details.

Queries:

Show the ID$,$ OrderDate and ShipDate fields $($only$)$ of any records where the Region is West and

the OrderDate is in $2019.$

Show the ID and OrderDate fields of any records with Sales at least $$100$ AND the ShipMode is

Express Air AND the ProductContainer is Large Box

For each Region, show the sum of Sales from the months of January through March $($use

ShipDate$).$ The sum should be for the entire three$-$month range, with separate totals for each

year.

Show all fields of any records with Sales below $$4000$ AND the ShipMode is Express Air.

For each Region, show the sum of Sales for each OrderPriority. You should have one sum for

each $\{$Region$,$ OrderPrioritys pair.

Show average Sales for each Province, using all records with a $2020$ ShipDate. You should only

have one average value per province.

Show all fields of any records where the ShipMode is Delivery Truck and the ProductContainer is

not Jumbo Box $($in the query criteria, you can use the $""$ operator for "not equal to$").$