How to Create Access Queries?

1. Create a query to show the total orders (in dollars) to customers headquartered in London (excluding freight). The query should include Order ID, Customer ID, City, and Total Order.

• • What is the total amount of order ID 10484?
• • Answer: _______________

2. Create a query to show the total gross margin (in dollars) on products shipped outside the United States by Order ID. Assume the unit price in the Products table is the selling price and the unit price in the Order Details table is the cost of goods sold. Calculate the total gross margin per Order ID. The query should include Order ID, Ship Country, and Gross Margin.

• • What is the total gross margin of Order ID 10264?
• • Answer: ________________

3. Create a query to show the total gross margin generated by sales in each country (i.e., total gross margin for sales shipped to Brazil, Canada, etc.) by OrderID. Assume the unit price in the Products table is the selling price and the unit price in the Order Details table is the cost of goods sold. Calculate the total gross margin per Order ID. The query should include Ship Country and Gross Margin.

• • What is the total gross margin for Mexico?
• • Answer: ________________

Answer rating: 100% (QA)

1 SELECT oOrderID cCustomerID cCity SUModUnitPriceodQuantity AS Total ... View the full answer