Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
please i need the answer through" microsoft access app'
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Information Systems

Authors: Marshall RomneyPaul Steinbart

11th Edition

136015182, 978-0136015185

More Books

Students also viewed these Accounting questions

Question

d. Is the program accredited?

Answered: 1 week ago

Question

What are the three types of Efficient Market Hypothesis ??

Answered: 1 week ago

Question

How can either be made stronger?

Answered: 1 week ago