Question: 1 ) Create a new MS Access file and save it as Database Project _ Last Name, First Name . 2 ) Import all Excel

1) Create a new MS Access file and save it as Database Project_Last Name, First Name.2) Import all Excel files provided in the zip file into the new MS Access file and establish all necessary relationships. 3) In the new MS Access file, use either the MS Access query design tools or SQL to create a query for each of the following questions: Q1. Which customers are located in St. Catharines? Q2. How many customers are located outside of Ontario? Q3. What is the name of the customer that purchased the highest amount of furniture in November? Q4. Which inventory type (item) generated the highest amount of sales revenue in the 3rd quarter of 2023? Q5. Based on the entire dataset, which salespersons earned more than $2,000 commission? Q6. Which inventory category generated the highest gross profit in June? Q7. Which sales invoices had an outstanding balance as of September 30,2023? Include the invoice number, invoice amount, amount of cash received, and outstanding balance for each invoice in your output. Q8. Which bank account(s) processed more than $10,000 of deposits in the 2nd quarter of 2023? Q9. Which customer spent the most on Beds in May? Q10. Based on the entire dataset, who are the top three most valuable customers in terms of the gross profits earned?

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 Accounting Questions!