GETTING STARTED
 Open the file SC_AC19_6b_FirstLastName_1.accdb, available for download from the
SAM website.
 Save the file as SC_AC19_6b_FirstLastName_2.accdb by changing the “1” to a “2”.
o If you do not see the .accdb file extension in the Save As dialog box, do not type it.
The program will add the file extension for you automatically.
 To complete this SAM Project, you will also need to download and save the following data
files from the SAM website onto your computer:
o Support_AC19_6b_Tours.txt
 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

1. City Tours Ltd. is a company that provides tours in a city that attracts tourists from
   around the country. As a customer service manager for the company, you need to be
   able to create professional reports for employees and for entities outside the company.
   Import the data from the file Support_AC19_6b_Tours.txt, and then append the
   records to the Tours table. The text file is a delimited file with a comma separating each
   of the four fields. Do not create a new table, and do not save the import steps.
2. Open the State Customer List Report in Design View, and then complete the following
   tasks:
   a. Add the current date and time to the Report Header section.
   b. In the Date and Time dialog box, use the option button to select the third date
   format (e.g., 7/16/2019) and the third time format (e.g., 16:09).
   c. Resize the report so that the right boundary of the report is approximately at the
   8″ mark on the horizontal ruler.
   Save the report without closing it.
3. With the State Customer List Report still open in Design View, complete the following
   tasks:
   a. Select the State Header, and then display the Property Sheet for this section.
   b. Change the Repeat Section property to Yes.
   c. Change the Force New Page property to Before Section.
   Save and close the report.

4. Modify the Confirmation by Tours Report by completing the following tasks:
   a. Open the Confirmation by Tours Report in Design View.
   b. Open the field list for the report.
   c. Add the TourName field to the TourNumber Header section of the report so that
   the left edge of the control is at approximately the 3.2″ mark on the horizontal
   ruler. The left edge of the label is at the 2″ mark on the horizontal ruler. (Hint: You
   may need to reposition and resize the TourName control and its label after
   inserting into the report.)
   Confirm that the report matches Figure 1, and then save the report without closing
   it.
5. With the Confirmation by Tours Report still open in Design View, complete the following
   tasks:
   a. Select the ConfirmationID, CustomerID, FirstName, LastName, and TotalTourCost
   controls simultaneously.
   b. Group the controls.
   c. Resize the controls by dragging their right edge to the 4.5″ mark on the ruler.
   d. Bold the controls.
   Confirm that the report matches Figure 1, and then save and close the
   Confirmation by Tours Report.
   Figure 1: Confirmation by Tours Report—Design View
6. Modify the DrivingTours Totals Report by completing the following tasks:
   a. Open the DrivingTours Totals Report in Design View.
   b. Change the Text13 label in the Page Header section using TotalChildCost as the
   new text.
   c. Format the text box control in the Detail section containing the
   =[NumChild]*[ChildCost] calculation so that it displays with the Currency number
   format and two decimal places.
   Save the DrivingTours Totals Report, switch to Report View, confirm your report
   matches Figure 2, and then close the report.
   Figure 2: DrivingTours Totals Report—Report View
7. Open the Basic Guide List Report in Design View, and then change the Alternate Back
   Color property for the Detail section to No Color. Save and close the report.

8. Open the Confirmation-Customer-Tour Report in Design View, and then use the
   Subform/Subreport Wizard to add a subreport with the following options:
   a. Add the subreport below the ConfirmationID label in the Detail section, at
   approximately the 1″ mark on the vertical ruler.
   b. Use the Tours table as the source of the subreport.
   c. Select the TourNumber, TourName, and BasicCost fields (in that order) from the
   Tours table to add to the subreport.
   d. Ensure that the Choose from a list option button is selected, and accept the
   default link Show Tours for each record in Confirmations using TourNumber
   for the subreport.
   e. Save the subreport as Tours subreport (which is the default name). (Hint: The
   width of the subreport may expand the width of the report. Do not manually adjust
   the width.)
   f. Delete the label associated with the subreport.
   Save the Confirmation-Customer-Tour Report, switch to Report View, confirm your
   report matches Figure 3, and then close the report.
   Figure 3: Confirmation-Customer-Tour Report—Report View
9. Open the Tours and Customers Report in Design View, then modify the report by
   completing the following tasks:
   a. Resize the width of the report as shown in Figure 4. (Hint: The right border of the
   report is at the 8″ mark on the horizontal ruler.)
   b. Move the Length label and control so that it appears under the LastName control in
   the approximate location shown in Figure 4. (Hint: Align the bottom of the label and
   control with the 2″ mark on the vertical ruler.)
   c. Select the State and Mobile controls simultaneously. Do not select the labels.
   d. Align the controls to the left as shown in Figure 4.
   Confirm that the report matches Figure 4, and then save and close the Tours and
   Customers Report.
   Figure 4: Tours and Customers Report—Design View

10. Open the Guide Skills Report in Design View, and then modify the report by completing
    the following tasks:
    a. Select all the labels in the Page Header section.
    b. Bold the labels.
    c. Select the SpecialSkills control in the Detail section, and then change the Can Grow
    property to Yes.
    d. Resize the Detail section of the report by dragging the lower boundary of the
    section to just below the controls in the report, at approximately the .5″ mark on
    the vertical ruler for the Detail section.
    Confirm that the report matches Figure 5, and then save and close the Guide Skills
    Report.
    Figure 5: Guide Skills Report—Design View
11. Modify the CustomerTour Totals Report by performing the following tasks:
    a. Open the CustomerTour Totals Report in Design View.
    b. Use the Group, Sort, and total pane to add a footer section to the Group on
    CustomerID section.
    c. Add a text box control in the CustomerID Footer section.
    d. Convert the text box control into a calculated control that sums the TotalTourCost
    field. (Hint: Your control should contain the formula =Sum([TotalTourCost]).)
    e. Format the control so that it displays with the Currency number format and two
    decimal places.
    f. Change the text in the label using Total Price as the new text.
    g. Reposition the control and its label to the approximate location shown in Figure 6.
    (Hint: The left edge of the text box should be located at the 5.5″ mark on the
    horizontal ruler.)
    Confirm that the report matches Figure 6, and then save and close the
    CustomerTour Totals Report.
    Figure 6: CustomerTours Totals Report—Design View

12. Create a new blank report in Design View, and then complete the following tasks:
    a. Open the Property Sheet for the report, and then apply the Record Source for the
    report to the SegwayTours table.
    b. Save the report with the name Basic Segway Report, but do not close the report.
    c. Add the CustomerID, TourNumber, and TourDate fields to the report and then
    reposition them so that the left edges of the three controls are at the 3″ mark on
    the horizontal ruler and only a single dotted line separates the labels and controls
    vertically.
    d. Add the title Basic Segway Report to the Report Header section.
    e. Add page numbers to the report at the Top of Page (Header) position, using the
    Page N of M format and Right alignment.
    Confirm that the report matches Figure 7, and then save and close the Basic
    Segway Report.
    Figure 7: Basic Segway Report—Design View
13. Open the NewEngland Customers by State Report in Design View. Group the report by
    the State field, and then sort the report by the CustomerID field in ascending order. Do
    not add any additional grouping or sorting options to the report. Save and close the
    NewEngland Customers by State Report. (Hint: This report does not contain any fields.)
14. Modify the HomeTour Totals Report by performing the following tasks:
    a. Open the HomeTour Totals Report in Design View.
    b. Add a text box control to the Report Footer section.
    c. Convert the text box control into a calculated control that sums the TotalCost field.
    (Hint: Your control should contain the formula =Sum([TotalCost]).)
    d. Format the control so that it displays with the Currency format and 0 decimal
    places.
    e. Change the label using Total as the new text.
    f. If necessary, reposition the control and its label so that the left edge of the text box
    is located at the 6″ mark on the horizontal ruler.
    Confirm that the report matches Figure 8, and then save and close the HomeTour
    Totals Report.
    Figure 8: HomeTour Totals Report—Design View