Each question should be attempted after you have completed Exercise Requirement $3.$ Move the Excel data to Microsoft Access and prepare queries to answer the following questions. Answers in dollars should be rounded to two decimal places. Differences in rounding may produce slightly different totals, so select the closest answer when your exact answer is not shown in multiple choice scenarios. When you summarize information by store, be sure to include all stores and convert and blanks $($NULL values$)$ to zeroes.

Required:

Use the Purchases Fabric table to create a query in design view. Include the following fields in the query: Purchase Order #$,$ Purchase Order Date, Date Received, Vendor Number, Fabric Color Code, Quantity $($Qty$)$ Yards, and Amount. Constrain the Date Received to the period between $\frac{4}{1}\frac{?}{22}$ and $\frac{6}{30}\frac{?}{22}.$ Go to Datasheet View. How many records $($rows$)$ appear in your query? $($Save the query as "Purchases in $2$nd Quarter."

Records in your query