Question: Create select queries for What SUP. (Use the Ch11-02 student file, or use the file you used in answering the previous question.) a. Create and

Create select queries for What SUP. (Use the Ch11-02 student file, or use the file you used in answering the previous question.)
a. Create and print a select query that lists the product name, quantity, supplier contact name, and supplier phone number for any Inflatable SUPs. Save this query as Ch 11 Assignment 2a before you print it.

b. Create and print a select query that lists the supplier name, city, and phone number for any supplier located in the state of New York. Save this query as Ch 11 Assignment 2b before you print it

Step by Step Solution

3.48 Rating (155 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a b Product Name Shu... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

1512_605d88e15f4e1_680057.pdf

180 KBs PDF File

Word file Icon

1512_605d88e15f4e1_680057.docx

120 KBs Word File

Students Have Also Explored These Related Using Microsoft Excel Questions!