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_C5_P1a_FirstLastName_1.accdb

Open the file you just downloaded and save it with the name:

SC_Access2013_C5_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

Open the Reservations table in Design view. Use the Input Mask Wizard to create an input mask for the Phone field. Accept the default input mask for a Phone Number field. Store the data without the symbols in the mask. Save the change to the Reservations table.

With the Reservations table still open in Design view, add a new field named Waiver after the Deposit field. Use Attachment as the data type for the field. Save the change to the table and close it.

Open the Guides table and update the record for Ursula Grea-Mayers (who has a GuideID of UG01) as described below:

Using the input mask, enter 207-555-2833 in the phone number field.

Set the CPR Certified field to Yes.

Close the table.

Modify the Guide Data Entry Form to match Figure 1 by performing the following tasks:

Open the Guide Data Entry Form in Design view.

Open the field list for the form.

Add the PhoneNumber field to the form in the position shown in Figure 1.

Save and close the Guide Data Entry Form.

Select the States table and then create a new form in Design view. Update the form to match Figure 2 by performing the following tasks:

Add the State and StateName fields (from the States table) to the Detail section of the form, in the approximate location shown in Figure 2. If necessary, reposition the controls and their labels after adding them to the form.

Save the form with the name State Data Entry Form, but do not close the form.

Add a Title to the form. (Tip: The title of the form should be State Data Entry Form.)

Save and close the State Data Entry Form.

Open the Guides Master Form in Design view and ensure that the Use Control Wizards button is selected.

With the Guides Master Form still open in Design view, use the Subform/Subreport Wizard to add a subform with the following options:

Use the Trips table for the subform.

Select the TripID field, the TripName field, and the Type field from the Trips table to add to the subform.

Accept the default link (Show Trips for each record in Guides using GuideID) to link the main form to the subform.

Save the subform as Trips subform (which is the default name).

If necessary, reposition the subform to match the approximate location shown in Figures 3a and 3b.

Save and close the form.

Open the State-Trip Master Form in Design view and modify it to match Figures 4a and 4b by resizing the width of the subform as shown in Figures 4a and 4b. (Tip: The right edge of the subform is at the 5.5” ruler mark.) Save, but do not close, the form.

With the State-Trip Master Form still open in Design view, modify the form title to match Figures 4a and 4b by performing the following tasks:

Change the font color of the title to Red (2nd column, 7th row in the Standard Colors Palette).

Change the font size of the title text to 20 pts. 

Apply the Raised special effect to the title.

Save and close the form.

Open the Reservations Financial Form in Design view and modify the form by performing the following tasks:

Delete the GroupSize control and the accompanying label.

Change the label for the Address control to Street.

Save and close the form.

Open the Reservations Contact Form in Design view and modify the form to match Figure 5 by performing the following tasks:

Select the ContactFirst, ContactLast, Phone, TripDate, GroupSize, and WaiverReceived controls and labels simultaneously.

Adjust the spacing of these fields to have equal vertical spacing.

Save, but do not close, the form.

With the Reservations Contact Form still open in Design view, change the Tab Order so that users tab to the TripID field immediately after the

ReservationID field. (Hint: Move the TripID field upward in the tab order.) Save and close the form.