Question: please i need the answer through microsoft access app' Customer Customer # - Customer Name - 1000 Smith 1001 Jones 1002 Jeffries 1003 Gilkey 1004

Customer Customer # - Customer Name - 1000 Smith 1001 Jones 1002 Jeffries 1003 Gilkey 1004 Lankford 1005 Zeile 1006 Pagnozzi 1007 Arocha 0 City Phoenix St. Louis Atlanta Phoenix Phoenix Chicago Salt Lake City Chicago State AZ MO GA AZ AZ IL UT IL Inventory Item # Description - Unit Cost Unit Price 1010 Blender $14.00 $29.95 1015 Toaster $12.00 $19.95 1020 Mixer $23.00 $33.95 1025 Television $499.00 $699.95 1030 Freezer $799.00 $999.95 1035 Refrigerator $699.00 $849.95 1040 Radio $45.00 $79.95 1045 Clock $79.00 $99.95 Sales-Inventory Invoice Number - Item Number - Quantity 101 1025 101 1035 102 1045 103 1010 1 103 1015 1 103 1025 2 104 1025 1 104 1045 1 105 2035 106 1045 1 107 1030 1 107 1035 107 1040 107 1045 208 1025 108 1045 NH 33 Sales Invice Nur 101 102 103 104 105 106 107 108 Dale - Salesperson - Customer Numbes + 10/3/2018 Wilson 1000 10/5/2018 Mahomet 1003 10/5/2018 Jackson 1002 10/15/2018 Drezen 1000 10/15/2018 Martinez 2005 10/16/2018 Martinez 1007 10/29/2018 Mahomet 1002 11/3/2018 Martinez 1000 Requirement: 1. Create the four tables (3 marks) 2. Edit all the necessary relationships (2 marks) 3. Create the following queries: (5 marks) a. What are sales invoice numbers, salesperson for the customer Smith? b. What are items number, description, quantity and price sold to customer Jeffries? c. Who are salespersons, invoices date and number, for customer number 1000? d. What are sales invoice numbers, the name, city and state for customer number 10057 e. Who are customers (name and number) who bought item number 1025
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
