dont even know how to start. CWID is 11428982, but from there dont know how to start steps 1 and 2 ... and the rest

Instructions Student ID # 0 0 0 0 0 0 0 0 Before doing anything, enter your student number (one digit per cell) in cells B2 through I2!!!! The project is due by the beginning of class on April 27th at 11:59pm. The project will not be accepted after April 27th 11:59pm. NO EXCEPTIONS READ THIS, OR YOU MAY FRITTER AWAY MANY HOURS MIRED IN A MORASS OF FUTILITY! 1) Link cash receipt or cash disbursement to inventory in the E-R diagram (do not create a cash resource). If this is not done, some queries will not work. 2) Two questions require the use of more than one query to get the desired output (i.e., query within a query). 3) Three questions require the inclusion of tables that, at first glance, do not appear to be needed in the query. For these queries, enough tables need to be open to match transactions on both event number and item number. A query with odd looking results may be a situation more tables are needed. Requirements (Steps to complete project): 1) use the flat file to construct an E-R diagram and design a database 2) build the database in Access 3) use the database to construct queries for the questions below 4) use the flat file in the Data tab below to construct pivot tables for the questions below 5) Create a Microsoft Word document with the following: a. A coversheet with your name, CWID, the Access relationship window (make sure every field in every table is visible in the window) b. Pivot table (with grand total) followed by the corresponding Access query (datasheet view with grand total) followed by the query language for each query. For example, pivot table 1, access query 1, Design View 1 , pivot table 2, access query 2, Design View 2, etc. Note: When submitting output that requires multiple queries, please submit the final Query Design View. 6) HOW TO TURN IT IN: Upload the following files all three of your file (word, access, and excel) to blackboard under Project 3 assignments. 2. DO NOT PRINT, UPLOAD 3 FILES ONLY, FILES MUST BE SAVED AND CLOSED TO UPLOAD 3. FAILING TO INCLUDE GRAND TOTALS OR QUESTIONS IN THE ORDER REQUESTED WILL RESULT IN A PENALTY. NOT FALLING BEHIND IS IMPORTANT. ON THE WORKDAY, I WILL BE AVAILABLE TO ADDRESS QUESTIONS BY WORKING WITH YOU PERSONALLY ON THE COMPUTER. ON THAT DAY YOU NEED TO BE FAR ENOUGH ALONG TO KNOW WHAT YOUR QUESTIONS ARE. MY ABILITY TO ANSWER QUESTIONS AFTER THE WORK DAY IS LIMITED BECAUSE; 1) MANY OF THE QUESTIONS ARE TOO COMPLEX FOR EMAIL, AND 2) WITHOUT ACCESS TO YOUR DATABASE I WILL NOT HAVE THE INFORMATION REQUIRED TO ANSWER YOUR QUESTIONS (I DON'T OPEN STUDENT DATABASES ON MY COMPUTER BECAUSE OF VIRUSES). TO CREATE AN INCENTIVE TO NOT FALL BEHIND, QUESTIONS THAT ARE PRELIMINARY IN NATURE WILL NOT BE ANSWERED AFTER THE WORK DAY. Questions: 1) Item desc, item#, total shipping quantity and total receivable amount by item (sort by desc). 2) Ship#, receivable amount and (shipping quantity x list_price) for each shipping transaction (pivot table will not match query). 3) Empl_name, empl#, item#, total sales quantity for all sales of item 200. 4) The average quantity per shipping transaction displayed at 2 decimals. Your answer should be one number (pivot table will not match query). 5) Item desc, item#, smallest shipping quantity, largest shipping quanity, smallest receivable amount and largest receivable amount for each item. 6) Cust_name, cust# and sales quantity for all sales handled by employee 50. 7) Total sales quantity and total receivable amount for all sales to customers 102 and 103. One set of totals for the two customers combined. 8) The number of sales transactions, the number of shipping transactions and the number of cash receipt transactions. 9) Cust_name, cust#, receivable amount and cash receipt amount for all customers with total cash receipts of less than $60,000. 10) Remit# and (amount - receivable) for all cash receipt transactions where (amount - receivable) 0. item# desc 200 bamboo 201 maple 202 cherry 203 beech 204 pine 205 birch 201 maple 200 bamboo 202 cherry 204 pine 203 beech 205 birch 200 bamboo 201 maple 205 birch 202 cherry 201 maple 200 bamboo 204 pine 201 maple Sales Data list_price invoice# 250 3000 306 903 405 68 603 306 250 903 68 405 603 250 306 603 903 306 250 68 306 3001 3001 3002 3002 3003 3004 3005 3005 3006 3007 3008 3009 3010 3011 3012 3013 3014 3015 3016 date1 quantity1 empl# empl_name 1/1/2017 65 50 David 1/4/2017 1/4/2017 1/10/2017 1/10/2017 1/16/2017 1/19/2017 1/22/2017 1/22/2017 1/28/2017 1/31/2017 2/3/2017 2/6/2017 2/9/2017 2/12/2017 2/15/2017 2/18/2017 2/21/2017 2/22/2017 2/23/2017 73 49 56 36 33 28 79 31 41 71 44 76 26 66 57 55 71 50 77 55 McGee 55 McGee 50 David 50 David 50 David 50 David 50 David 50 David 55 McGee 55 McGee 55 McGee 55 McGee 50 David 50 David 50 David 50 David 55 McGee 55 McGee 50 David Shipping Data Cash Receipt Data ship# date2 quantity2 receivable empl# empl_name remit# date3 amount empl# empl_name 4000 1/2/2017 65 $ 16,413 65 Gibbs 5000 1/9/2017 $ 16,413 70 Shepard 4001 4001 4002 4002 4003 4004 4005 4005 4006 4007 4008 4009 4010 4011 4012 4013 4013 4014 4015 1/5/2017 1/5/2017 1/11/2017 1/11/2017 1/17/2017 1/20/2017 1/23/2017 1/23/2017 1/29/2017 2/1/2017 2/4/2017 2/7/2017 2/10/2017 2/13/2017 2/16/2017 2/22/2017 2/22/2017 2/23/2017 2/24/2017 73 49 56 36 33 28 79 31 41 71 44 76 26 66 57 55 71 50 77 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 22,338 43,805 22,680 2,472 19,899 8,482 19,750 28,273 2,788 28,755 26,532 19,000 7,956 39,798 51,471 16,830 17,750 3,400 23,562 60 Mallard 60 Mallard 60 Mallard 60 Mallard 65 Gibbs 65 Gibbs 60 Mallard 60 Mallard 65 Gibbs 65 Gibbs 60 Mallard 65 Gibbs 65 Gibbs 60 Mallard 60 Mallard 60 Mallard 60 Mallard 65 Gibbs 65 Gibbs 5001 5001 5002 5002 5003 5004 5005 5006 5007 5008 5009 5010 5011 5012 5013 5014 5014 5015 5015 1/12/2017 1/12/2017 1/18/2017 1/18/2017 1/24/2017 1/27/2017 1/30/2017 1/31/2017 2/6/2017 2/8/2017 2/11/2017 2/14/2017 2/18/2017 2/21/2017 2/23/2017 3/1/2017 3/1/2017 3/3/2017 3/3/2017 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 22,032 43,805 22,275 2,472 19,296 8,482 19,500 28,273 2,720 28,755 26,532 19,000 7,956 39,798 51,471 16,830 17,750 3,400 23,562 75 Fornell 75 Fornell 70 Shepard 70 Shepard 75 Fornell 75 Fornell 75 Fornell 75 Fornell 75 Fornell 70 Shepard 70 Shepard 70 Shepard 75 Fornell 75 Fornell 70 Shepard 70 Shepard 70 Shepard 75 Fornell 75 Fornell cust# cust_name 100 Acme 101 Initech 101 Initech 103 Kamekona 103 Kamekona 105 Oscorp 104 Wayne 102 Stark 102 Stark 105 Oscorp 105 Oscorp 103 Kamekona 103 Kamekona 100 Acme 104 Wayne 102 Stark 101 Initech 101 Initech 100 Acme 100 Acme