Create a new table named Hiking that includes all columns in the Reservation table where the trip type is Hiking. The owner of Colonial Adventure Tours knows that being able to run queries is one of the most important benefits of using a DBMS. In the following exercises, you will use the data in the Colonial Adventure Tours database shown in Figures in Chapter 1. (If you use a computer to complete these exercises, use a copy of the Colonial Adventure Tours database so you will still have the original data when you complete Chapter 3.) In each step, use QBE to obtain the desired results. You can use the query feature in a DBMS to complete the exercises using a computer, or you can simply write a description of how you would complete the task. Check with your instructor if you are uncertain about which approach to take.
Consider the following steps to create table Hiking from the tables Reservation, using all the fields of it where the criteria “=Hiking” for the field Type of the table Trip is true.
• At first click on the Query Design option from the Queries group in Create tab.
• Now, add Reservation and Trip table from show Table dialog box.
• Now, click in the “Field” list and select Reservation.* from Reservation Table, Type from Trip table.
• Now, check all the checkbox in Reservation.*.
• Select criteria “Hiking” in a row label as “Criteria” in Type Column as shown in Figure-1 in order to fulfill the above criteria.
• At the end click on RUN button in the Results group to display the query result.
Consider the following Design view to create table Hiking from the tables Reservation, using all the fields of it where the criteria “=Hiking” for the field Type of the table Trip is true.
Figure1: Design View of Query
By executing the query the new table named Hiking would be created with the same attributes as the table Reservation has. The new table with some records from starting is shown below: