Create a new parameter query in Design view based on the Trainers table with the

Question

Create a new parameter query in Design view based on the Trainers table with the following options:

Add the FirstName, LastName, Phone, Street, City, State, and PostalCode fields (in that order) from the Trainers table to the query.

Add the criterion [Enter City] (including brackets) to the City field.

Save the query with the name City Trainer Query.

Run the City Trainer Query to confirm it works (Note: If you use Charlotte for the parameter value, the query should return 2 records.) Save and close your query.

Trainers TrainerID FirstName LastName Street City State PostalCode Phone HourlyRate YearsExperience 101 Amy Johnson 32 Carter Street Pineville NC 28134 704-333-2222 $28.50 2 103 Michael Beach 245 Murray Street Fort Mill SC 29707 803-555-6767 $31.75 5 104 Noelle Gross 242 Tryon Street Charlotte NC 28273 704-778-8888 $27.50 1 106 Rick Stevens 105 College Street Charlotte NC 28282 704-345-1111 $28.50 2 107 Henry Rosen 342 Mission Avenue Matthews NC 28105 704-987-3451 $33.00 6 108 Lisa Bennett 778 Hartwell Street Fort Mill SC 29707 803-356-7863 $24.75 0

Explanation / Answer

Answer:

USE DatabaseName Trainers;

SELECT FirstName,LastName,Phone,Street,City,State,PostalCode FROM Trainers WHERE
City = "Pineville" or
City = "Fort Mill" or
City = "Charlotte" or
City = "Matthews"
ORDER BY FirstName

Hope this works...HAPPY ANSWERING!!!!!!!

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.