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
Get step-by-step solutions from verified subject matter experts
