[Solved] TIM 50 Database Assignment 1

In this assignment, you will use Microsoft Access to generate reports using query. Pleasepay attention to every criteria when you do the selection. You can get the full credit onlyif everything is correct (Both the queries and the results). Please show and only show allthe attributes listed in brackets in the same order, missing or unexpected attributes orcriteria will cause you lose points. Import the data (DBHW1.xls) into MS Access and answerthe following questions:1. Generate a report showing the [order ID, order date, customer name, and theproduct subcategory] of all high priority orders shipped by express air in the yearof 2011. (Hint: representing date: #3/12/2016#)2. Generate a report showing the for the top 5 largest sales (Hint: rank by sales and then only show thetop 5).3. Generate a report showing the [region, customer segment, profit, and shipmentmode] for all furniture (product category) items in the region of Nunavut.4. Generate a report showing the total [profits] of technology products (productcategory) shipped with critical and high priorities.5. By using parameter query, generate reports that indicate [sales, profit, customersegment, and product category] for all high priority orders shipped by regular aircontaining furniture and technology (product category) with the profit greaterthan 1000 in home office. (Hint: parameter query for or: [] or []).Submission Instructions1. Make a screen shot (using snipping tool, alt+ctrl+prt sc, etc.) of each query form.2. Save each report as a .pdf file (Export report as PDF)3. Combine all screen shots and reports into a single PDF file and label it DB1.4. Submit your file via eCommons.