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:
- 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.
- Add three new fields, Customer, Product, and Gender, to the Orders table in Excel and use VLOOKUP functions to fill them.
- 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
