View the step-by-step solution to:

Could you please explain how to go through each step?

Could you please explain how to go through each step? The question below was on my midterms and I only got 80% so Id like to prepare for the finals!


You work for an adventure tour company that operates recreational hiking, biking, and walking tours in Colorado. The company uses a database to track information about tour guides, tours, tour schedules, clients, and sales. You'll create and modify several queries to answer specific questions about the data.


1.           Use the Simple Query Wizard to create a query based on the Tours table with the following options:

a.   Include all fields from the Tours table in the query.

b.   Select the option to show details in the query.

c.   Set the title of the query to TourMasterList.

Run the query, then save and close it.

2.           In Datasheet View, change the SalesListing query font to Times New Roman.

3.           In Datasheet View, change the SalesListing query font size to 12 pt. Save and close the SalesListing query.


 

4.           Create a new query in Query Design View based on the Tours and Schedule tables with the following options. (Hint: Resize the Tours field list so all fields are visible.)

a.   Add the following fields from the Tours table to the query grid in this order: TourName, Level, TrailheadCity, and Cost.

b.   Add the following field from the Schedule table to the query grid, after the Cost field: StartDate.

c.   Save the query with the title TourSchedule, then display it in Datasheet View.

5.           Use the Save Object As feature to save the TourSchedule query as a new query with the title TourBeginner.

6.           Open the TourBeginner query in Design View, then add criteria to select only those records where the Level field value equals Beginner. Switch to Datasheet View, confirm the proper records appear in the TourBeginner query, then save and close it. 

7.           Create a new query in Query Design View based on the Clients table with the following options. (Hint: Resize the Clients field list to see all of the fields.)

a.   Add the following fields from the Clients table to the query grid in this order: LastName, FirstName, City, and State.

b.   Add an ascending sort order to the LastName and FirstName fields.

c.   Save the query with the name ClientList, then display it in Datasheet View. 

8.           Use the Save Object As feature to save the ClientList query as a new query with the title ClientListTXCO.

9.           Switch to Design View for the ClientListTXCO query, then enter criteria to select only those records with a State field value of TX (Texas) or CO (Colorado). Switch to Datasheet View, confirm the proper records appear in the ClientListTXCO query, then save and close it.

10.        Create a new query in Query Design View based on the Tours table with the following options. (Hint: Resize the Tours field list to see all of the fields.)

a.   Add the following fields from the Tours table to the query grid in this order: TourName, MinimumAge, TrailheadCity, and Cost.

b.   Add criteria to select only those tours where the MinimumAge field value is greater than or equal to 10 and the Cost field value is less than or equal to 100. (Hint: Remember that all records appearing in the query will fulfill both criteria—not just one or the other.)

c.   Save the query with the name LowCostTours, display the query in Datasheet View, then close it.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question