d. Create a query in Query Design view, using your Cap1 Inventory table to answer the question, For the supplier ID of SUPP-06, for each item name and retail price, what is the markup for each item if marked up 10%, and what is the final price? Name the first calculated field Markup and name the second calculated field Final Price All numeric fields should be formatted as Currency, 2 Decimal Places. For the Item Name of Snowboard, the Final Price is $282.69. Apply Best Fit to all of the fields, Save the query as Lastname Firstname Cap1 SUPP-06 Markup Query and then create a paper or electronic printout as directed. Click Close Print Preview, and then Close the query.