Question: Shirt Orders.mdb is an Access database file with three related tables: Customers, Orders, and Products. Import the database in Excel and create a table that

Shirt Orders.mdb is an Access database file with three related tables: Customers, Orders, and Products. Import the database in Excel and create a table that contains the order date, customer name, and product description for all orders that satisfy conditions on orders, products, and customers. Proceed as follows:

  1. Use Power Query to import all three tables into Excel as tables (not a Data Model). The only use for Query Editor is to remove the columns not used for this problem: Street, City, State, Zip, Phone for customers, Discount for orders, and UnitPrice for products.
  2. Add three new fields, Customer, Product, and Gender, to the Orders table in Excel and use VLOOKUP functions to fill them.
  3. Filter the Orders table as necessary. For this problem, use a ">75" filter for units ordered, Both for gender, and both A Shirts Life and Rags to Riches for customer.

What is the total number of orders for the selected filters?

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 General Management Questions!