Your role is that of an intern at a large online retailer. You have been requested to run the following queries about their external hard drive sales against 3011 Access Assign 2 Spring 2021.aacdb data file. You should rename the data file using your Argonet name and post in the Access Assign 2 drop box in Canvas no later than the due data. The data has already been loaded and the correct relationships set.
How many sales and what was the total of the LaCie rugged 2TB drive? Show the Description, total of Price, and the count of the number of sales. Save as Query1
How many of each external hard drive were sold? Show the Description, and the count of the sales. Save as Query 2
What are the total sales for a selected supplier? Show the Supplier code, the name of the supplier and count for each supplier. Save as Query 3
Modify query 3 so it requests the code of the supplier and displays only that supplier. Save as Query 4
Did any customers over 75 years old purchase a hard drive? Show their First Name, Last Name, Age, and Description of the toy sorted in descending order by age. Save as Query 5
For online sales within the state of Georgia there is a 7% sales tax. Show the Invoice, Price, Sales Tax and Total including the Tax. Save as Query 6
Which day of the week had the highest sales? Show the Day, the number of sales and Price. The results should be sorted in descending order by total sales. Save as Query 7
Which customers bought a WD Passport 2TB or a WD Easystore 4TB? Show the First Name, Last Name, and the Description. Save as Query 8
Due to a recall you need to identify the individuals who bought a LaCie rugged 5TB from Lion Direct. Show the First Name, Last Name, Description, and the Name of the supplier. Save as Query 9
Is there a difference in the average age and the average amount spent between men and women? Show the Sex, Average Age and Average Price. Save as Query 10
Such a cheap price for your free time and healthy sleep
All online transactions are done using all major Credit Cards or Electronic Check through PayPal. These are safe, secure, and efficient online payment methods.