Question: 1 ) Create a new MS Access file and save it as Database Project _ Last Name, First Name . 2 ) Import all Excel
Create a new MS Access file and save it as Database ProjectLast Name, First Name Import all Excel files provided in the zip file into the new MS Access file and establish all necessary relationships. 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: Q Which customers are located in St Catharines? Q How many customers are located outside of Ontario? Q What is the name of the customer that purchased the highest amount of furniture in November? Q Which inventory type item generated the highest amount of sales revenue in the rd quarter of Q Based on the entire dataset, which salespersons earned more than $ commission? Q Which inventory category generated the highest gross profit in June? Q Which sales invoices had an outstanding balance as of September Include the invoice number, invoice amount, amount of cash received, and outstanding balance for each invoice in your output. Q Which bank accounts processed more than $ of deposits in the nd quarter of Q Which customer spent the most on Beds in May? Q 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
