PROJECT DESCRIPTION
Great Outdoors Tours is a small business that organizes day-long, guided trips of Massachusetts, Maine, New Hampshire, and Vermont. The company provides customers with a wide variety of hiking, biking, and paddling trips for all levels of experience. With a recent growth in business, Great Outdoors Tours has developed a database in Access 2013 to organize its records. The company would like your help in creating forms that highlight certain information.
GETTING STARTED
Download the following file from the SAM website:
SC_Access2013_C7_P1a_FirstLastName_1.accdb
Open the file you just downloaded and save it with the name:
SC_Access2013_C7_P1a_FirstLastName_2.accdb
Hint: If you do not see the .accdb file extension in the Save file dialog box, do not type it. Access will add the file extension for you automatically.
Open the _GradingInfoTable table and ensure that your first and last name is displayed as the first record in the table. If the table does not contain your name, delete the file and download a new copy from the SAM website.
PROJECT STEPS
Create a new form in Design view using the following options:
Open the property sheet for the new form and set the record source for the form to the States and Trips query.
Add the following fields to the form: TripName, StateName, Distance, Type, Level, Season (in that order) in the approximate location shown in Figure 1.
Adjust the sizing of the controls to approximately match those shown in Figure 1.
Add the TripID field to the form and move the control and its label to the approximate location shown in Figure 1.
Figure 1: Record Source Form
Open the State Master form in Design view and make the following updates:
Add a Title to the form as shown in Figure 2.
Expand the Form Header Section to the approximate location shown in Figure 2.
Save and close the State Master form.
Figure 2: State Master Form
Open the Trip Master Form in Design view. Add a Combo Box control to the form in the position shown in Figure 3. Use the following options when creating the combo box using the Combo Box Wizard:
Ensure that the ‘I want the combo box to get the values from another table or query.’ option button is selected.
Select the Guides table as the table providing the values.
Add the GuideID, FirstName, and LastName fields to the combo box.
Sort the combo box by the GuideID field in ascending order.
Remove the checkmark from the ‘Hide key column (recommended)’ check box.
Ensure that GuideID is selected as the field in which to store a value.
Select the ‘Store that value in this field:’ option button and select the GuideID field.
Assign GuideID as the name of the combo box.
If necessary, move the combo box control and label to match the approximate location show in Figure 3.
Confirm that your form matches Figure 3. Save the form and close the Trip Master Form.
Figure 3: Trip Master Form
Modify the Guides and Trips Form to match Figure 4 by performing the following tasks:
Open the Guides and Trips Form in Design view.
Add a Text Box control to the form in the position shown in Figure 4.
Create a calculated control that concatenates the FirstName field, a space, and the LastName field. (Tip: Your control should contain the formula =[FirstName]&’ ‘&[LastName])
Change the label to Name as shown in Figure 4.
If necessary, move the text box control and label to match the approximate location show in Figure 4.
Save and close the Guides and Trips Form.
Figure 4: Guides and Trips Form
Open the Reservations and Trips Form in Design view and use the Subform/Subreport Wizard to add a subform with the following options:
Use the Trips table for the subform.
Select the TripID field, and the TripName field from the Trips table to add to the subform.
Accept the default link (Show Trips for each record in Reservations using TripID).
Save the subform as Trips subform (which is the default name).
Resize the width of the subform to match that shown in Figure 5. (Tip: The right edge of the subform is at the 6 inch ruler mark.)
If necessary, move the subform to match the approximate location shown in Figure 5.
Confirm that the form matches Figure 5 and then save and close the form.
Figure 5: Reservations and Trips Form
Open the Reservations Master Form in Design view. Use the Command Button Wizard to add a command button with the following options:
Select Form Operations as the category and Close Form as the action.
Select the text option button with the text Close Form.
Assign the name Close Form to the button.
Position the button as shown in Figure 6.
Save and close the form.
Figure 6: Reservations Master Form
Open the Guide Search Form in Design view and modify the form by performing the following tasks:
Select the Name to Find control. (Tip: Select the control not the label.)
Open the property sheet for the control and change the name of the control to NametoFind
Save and close the form.
Open the Trip Search Form in Design view and place a rectangle around the Trip to Find label and control as shown in Figure 7. Save the change to the form and close the form.
Figure 7: Trip Search Form
Open the Trips by State Form in Design view and complete the following actions:
Add a Tab Control to the form in the approximate position shown in Figure 8, resizing it to match the Figure.
Change the name of the first tab to Datasheet.
Change the name of the second tab to Chart.
Save the change to the form and close the form.
Figure 8: Trips by State Form
Open the Reservations for Guides Form in Design view and make the following changes.
Delete the GuideID control and label.
Save the form and switch to Datasheet view.
Resize the ReservationID, Deposit, and Balance columns to best fit the data they contain. Save and close the form.
Open the Guide Reservation Data Form in Design view and select the Datasheet tab control. Resize the subform to the approximate size shown in Figure 9. Save, but do not close, the Guide Reservation Data Form.
Figure 9: Guide Reservation Data Form – Datasheet tab
With the Guide Reservation Data Form still open in Design view, modify it to match Figure 10 by performing the following tasks:
Select the Chart tab control and select the chart.
Edit the chart object and change the chart type to Clustered Bar as shown in Figure 10.
Save and close the form.
Figure 10: Guide Reservation Data Form – Chart tab
Open the Reservations Search Contact Form in Design view. Add a Combo Box control to the form in the position shown in Figure 11. Use the following options when creating the combo box using the Combo Box Wizard:
Ensure that the ‘Find a record on my form based on the value I selected in my combo box.’ option button is selected.
Add the ContactLast field as the field to include in the combo box.
Ensure that there is a checkmark in the ‘Hide key column (recommended)’ check box.
Assign the label Name to Find to the combo box.
If necessary, move the combo box control and label to match the approximate location show in Figure 11.
Confirm that your form matches Figure 11. Save and close the form.
Figure 11: Reservations Search Contact Form
Close and save any open database object. Compact and repair your database, and then exit Access. Follow the directions on the SAM website to submit your completed project.
