Access File

Shirt$\_$Orders.accdb is an Access database file with three related tables: Customers, Orders, and Products. The goal here is to create a table

Excel that contains the order date, customer name, and product description for all orders that satisfy conditions on orders, products, and

customers. Proceed as follows:

a$.$ 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 columr

not used for this problem: Street, City, State, Zip, Phone for customers, Discount for orders, and UnitPrice for products.

b$.$ Add three new fields, Customer, Product, and Gender, to the Orders table in Excel and use VLOOKUP functions to fill them.

c$.$ Filter the Orders table as necessary. For this problem, use a $">75"$ filter for units ordered, "Both" for gender, and both "Threads" and "Shi

R Us$"$ for customer.

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