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 with presenting data in attractive reports and forms that highlight certain information.
GETTING STARTED
Download the following file from the SAM website:
SC_Access2013_C4_P1a_FirstLastName_1.accdb
Open the file you just downloaded and save it with the name:
SC_Access2013_C4_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 Basic Trips List report in Layout View. Group the report by the State field, and then sort the report by the TripID field in ascending order. Do not add any additional grouping or sorting options to the report. Save and close the Basic Trips List report.
Modify the Reservations Financial Report to match Figure 1 on the following page by performing the following tasks:
Open the Reservations Financial Report report in Layout View.
Sum the values in the Trip Cost column and the Deposit column for each state’s reservations and for all reservations.
Switch to Print Preview to view the report and to check that the values in the subtotal control and the total control are displayed completely.
Return to Layout View and, if necessary, expand the size of the subtotal control and the total control so that they appear completely.
With the Reservations Financial Report report still open in Layout View, apply conditional formatting to the Trip Cost column. If the cost of the trip is greater than $1,000, display the value in bold, Green font (7th column, 1st row in the Standard Colors palette).
Save the report again and close the Reservations Financial Report report.
Open the Reservations by Trips Report report in Layout View, and then create a summary report. (Hint: To create a summary report, hide the detail lines.) Save and close the report.
Open the Guide Phone List report in Layout View. Apply the Facet theme to this object only. Save and close the report.
Use the Label Wizard to create mailing labels for the Guides table, and include the following options:
Use Avery C2163 as the label size.
Use Arial font, 11 pt. font size, Light font weight, and Black (1st column, 6th row in the Basic Colors palette) font color with no special font styles for the labels. (Hint: These formatting options may be the default settings for your label.)
On the first line of the label, include the FirstName field, a space, and the LastName field.
On the second line of the label, include the Address field.
On the third line of the label, include the City field, a comma (,), a space, the State field, a space, and the PostalCode field. Your label should match Figure 2 below.
Sort the labels by the PostalCode field.
Save the labels as Labels Guides (which is the default name).
Confirm that your labels match Figure 3 on the following page, and then close the Labels Guides report.
Use the Report Wizard to create the report shown in Figure 4 on the following page. The report is based on the Guides and Trips tables and should include the following options:
Include the GuideID and LastName fields from the Guides table.
Include the TripID, TripName, and Type fields from the Trips table.
The data will automatically be grouped by the GuideID field but do not add any additional grouping levels.
Sort the report by the TripID field in ascending order.
Use a Stepped layout and Landscape orientation.
Save the report as Guides and Trips.
Preview the report, and then close it.
|
Open the Guide Contact Form form in Layout View, and then modify the form by performing the following tasks:
Select all the labels and controls in the Detail section of the form. (Hint: Do not select the form title label in the Form Header section.)
Place the selected controls in a Stacked control layout.
Add the YearsExperience control after the Phone Number control, as shown in Figure 5 on the following page.
Open the Guide Experience Form form in Layout View, and then bold the Date control. Save and close the form.
Open the States Entry Form form in Layout View, and then add the current date to the form. Use the option button for the second date format. Do not include the time on the form. Save and close the form.
Open the Trip Guide Form form in Layout View, and then use the Advanced Filter/Sort option to create a filter with the following properties:
The records in the form should be sorted in ascending order by the Distance field.
The form should only return records where the State field value is equal to NH.
Toggle the filter to confirm it is working. (Hint: There should only be 19 records included in the form.)
Use the Form Wizard to create a form based on the Trips table with the following options:
Include the TripID, TripName, StartLocation, State, Type, Level, and Season fields (in that order) on the form.
Select the Columnar layout for the form.
