Question: Create a query in Design view, using the Cap 1 Inventory table to answer the question For each item name, display the cost and calculate

Create a query in Design view, using the Cap1 Inventory table to answer the question For each item name, display the cost and calculate the markup for each item if marked up 36% of cost. In addition, calculate the retail price by adding the cost and markup? Add the fields in that order. Name the first calculated field Markup and name the second calculated field Retail Price. Run the query and apply Best Fit to all of the fields. All numeric fields should be formatted as Currency, with 2 Decimal Places. Save the query as Cap1 Markup Query and close it.6

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!