Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Business Research Methods

Authors: Emma Bell, Bill Harley, Alan Bryman

5th Edition

0198809875, 9780198809876

More Books

Students also viewed these General Management questions

Question

When is the deadline?

Answered: 1 week ago

Question

1. To generate a discussion on the concept of roles

Answered: 1 week ago