for coffee or tea inventory and whether these items are flavored or not. The prompt text of each parameter should make clear to the user what input values are possible. The resulting dynaset should be sorted in ascending order by OnHand quantity and make sure only the three fields mentioned display in the dynaset.

Save the query as gryProblem$2.$

HINT: to understand how to handle the Yes$/$No data type in this query, first open tblinventory and click into a few cells in the Flavored column to see how this data type works.

Problem $3$: The sales manager has decided to check the quality of customer service for

all sales associates $($Title ID $=2)$ by calling and interviewing customers. Write a make$-$

table query that will create a new table called blSales AssociateCallList. This table should contain the following fields: last name of the sales associate, InvoicelD for all sales made by each sales associate, first and last name of customer $($in one field called Customer$\_$Name$),$ and customer phone number. The table should be sorted first by sales associate last name $($ascending$)$ and then by InvoiceID $($ascending$).$ Save the query as qmakProblem$3.$ Run it once and create tb$/$Sales Associate CallList.

Problem $4$: Management wants in inventory listing that shows the retail dollar value of each inventory item in stock. Build a query that produces a dynaset containing the following fields: InventoryID, UnitPrice, UnitsOnHand, and Retail Value, a calculated field. Format the RetailValue field as "Currency". Save the query as gry Problem$4.$

Problem $5$: Create a query that shows the total retail value of the entire inventory in in stock. This query should return a dynaset with a single number, which is that total value.

Save the query as gryProblems.

CONTINUED ON BACK

Problem $61$ The inventory manager wants to know the wholesale cost of all the backerders, displayed by item number. The baekorders were made to the suppliers with the lowest cost offered for each inventory item. He wants a dynaset that shows each backordered item with the following columns from left to right: the inventory ID$,$ the name the item, the negative quantity on hand $($which is the same as the quantity ordered$),$ the lowest supplier cost of that item, and a last column called BackOrderTotal, which is the quantity on backorder multiplied by the lowest cost for that item, which should be displayed as a positive, not negative, dollar figure. Name this query gryProblem$6.$

HINT: Try nesting queries. ThAproblem can be solved with just two queries. Name the first query gryProblem$6$A and name the final query gry Problem$6,$ which shows the dynaset described above.