Question: ChocRepNum (Primary Key) LastName FirstName Street City State PostalCode StartDate 31 Rivera Haydee 325 Twiddy St. Avondale IN 60311 6/3/2013 35 Simson Mark 1467 Hartwell

ChocRepNum

(Primary Key)

LastName

FirstName

Street

City

State

PostalCode

StartDate

31

Rivera

Haydee

325 Twiddy St.

Avondale

IN

60311

6/3/2013

35

Simson

Mark

1467 Hartwell St.

Walker

IN

46004

5/19/2015

42

Lu

Peter

5624 Murray Ave.

Davidson

IN

46007

8/3/2015

58

Murowski

Karen

168 Truesdale Dr.

Carlton

IL

60313

11/9/2016

Part 3 Create the following three queries. Refer to the hard copy pages of the table to determine what should result BEFORE attempting your queries.

1) Find all companies that have a Chocolate Representative # of 58. Include Company ID, Company, and Phone #. Do not show the ChocRep# in the results. Save the query as Query 1.

2) Sort all the companies in alphabetical order. Include company, address, city, state, and zip code. Save the query as Query 2.

3) This one is challenging! Create a query that includes all of the companies in New England (New Hampshire, Vermont, Connecticut, Massachusetts, Rhode Island, and Maine. Save the query as Query 3.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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

Students Have Also Explored These Related General Management Questions!