Parent Camper Form

Parent Camper Form 150 150 Affordable Capstone Projects Written from Scratch

Shelly Cashman Access 2016 | Modules 4–7: SAM Capstone Project 1a

Carpenter Family Camp

enhancing forms and reports

 

GETTING STARTED

  • Open the file SC_AC16_CS4-7a_FirstLastNameaccdb, available for download from the SAM website.
  • Save the file as SC_AC16_CS4-7a_FirstLastNameaccdbby changing the “1” to a “2”.
    • If you do not see the .accdbfile extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
  • Open the _GradingInfoTabletable 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. Carpenter Family Camp operates summer camps for youth as well as families on a lake in Maine situated near the coast. The camp offers activities for families as well as separate activities for adults and children. Optional adventures to nearby attractions are also available.

    Open the Counselortable in Design View. Using the Input Mask Wizard, add an input mask to the CellPhone Use the Phone Number input mask with the Input Mask format !(999) 000-0000 and the underscore (_) as the placeholder character. The input mask should store the values without symbols in the mask. Save and close the table.

  2. Use the Form Wizard to create a new form based on the Activitytable using the following options:
    1. Select all of the fields in the Activity (Hint: The form should contain five fields.)
    2. Use the Columnar
    3. Use the title Activity Informationfor the form.

View the Activity Information form in Form View, and then save and close it.

  1. Open the Parent Camper Formin Design View and update the form as follows:
    1. Add the HomePhonecontrol and label in the approximate locations shown in Figure 1 on the following page.
    2. Select the HomePhoneand CellPhone controls and their associated labels, and then align them using the Top

Figure 1: Parent Camper Form in Design View

 

 

  1. Select the LastNameand HomePhone controls and align them using the Left
  2. Select the LastNameand HomePhone labels, and then align them using the Left
  3. Change the tab order so that users tab to the HomePhonecontrol directly after the LastName

Save but do not close the form.

  1. With the Parent Camper Formstill open in Design View, ensure that the Use Control Wizards button is selected. Use the Subform/Subreport Wizard to add a subform with the following options:
    1. Use the Camper-Child Queryfor the subform.
    2. Select the CamperID, ParentID, FirstName, LastName, Gender, and Agefields (in that order) from the Camper-Child Query to add to the subform.
    3. Accept the default link (“Show Camper-Child Query for each record in Parent using ParentID”) to link the main form to the subform.
    4. Save the subform as Children subform. (Hint: Do not include the period.)
    5. If necessary, reposition the subform to match the approximate location shown in Figure 1.

Save the Parent Camper Form, but do not close it.

  1. With the Parent Camper Formstill open in Design View, add a title to the form. Change the title text to read Parent Camper Information Form. (Hint: Do not include the period.) Save and close the form.
  2. Open the Counselor Entry Formin Design View and ensure that the Use Control Wizards button is selected. Add a combo box to the right side of the Form Header section as described below:
    1. The combo box should find a record in the form.
    2. The CounselorID, LastName, and FirstNamefields (in that order) should be selected for the combo box.
    3. The key column should be hidden.
    4. Add the text Go to Counselor:as the combo box label.
    5. Resize and reposition the combo box control and label to be in the approximate location shown in Figure 2 on the following page.

Save the Counselor Entry Form, but do not close it.

  1. With the Counselor Entry Formstill open in Design View, add a command button to the right side of the Form Footer section with these options:
    1. The command button action should close the form (using the Close Form action).
    2. The button should display the text Closeand no picture.
    3. The meaningful name for the command button should be Close Button. (Hint: Do not include the period.)
    4. The command button should be positioned in the Form Footer section with the left edge at approximately the 5”mark on the horizontal ruler, as shown in Figure 2 on the next page.

Save the Counselor Entry Form, but do not close it.

  1. With Counselor Entry Formstill open in Design View, add a rectangle control to enclose the Specialty and CPR labels and controls as shown in Figure 2 on the next page. The upper-left corner of the rectange should be located at approxmiately the 5” mark on the horizontal ruler, and the lower-right corner of the rectangle should be located at approximately the 3.1” mark on the horizontal ruler. Save the Counselor Entry Form, but do not close it.

Figure 2: Counselor Entry Form in Design View

 

  1. With the Counselor Entry Formstill open in Design View, make the following formatting updates:
    1. Use the Format Painter to copy the formatting from the Counselor IDlabel to the other six labels in the Detail section of the form.
    2. In the Detail section of the form, change the fore color of the CounselorID, FirstName, LastName, CellPhone, HireDate, and Specialtycontrols to Dark Blue (last row, 9th column of the Standard Colors palette).

Save the Counselor Entry Form, compare the form to Figure 2, and then close the form.

  1. Use the Report Wizard to create a multi-table report as described below:
    1. Add the FirstNameand LastName fields (in that order) from the Parent table to the report.
    2. Add the SessionID, ReservationID, and LodgingFeefields (in that order) from the Reservation table to the report.
    3. The data should by viewed by Parentwith no additional grouping levels.
    4. Sort the report in ascendingorder by the SessionID
    5. Use the Steppedlayout and Landscape orientation for the report.
    6. Use Parent Reservationas the report title.

Compare your report to Figure 3 below, and then save and close the report.

 

Figure 3: Parent Reservation Report  in Print Preview View

 

  1. Use the Label Wizard to create mailing labels for the Parenttable using the following options:
    1. Use the Avery 5160label size.
    2. Use Arialfont, 12 pt. font size, Normal font weight, and Black font color (6th row, 1st column in the Basic Colors palette) with no special font styles for the labels. (Hint: These formatting options may be the default settings for your labels.)
    3. On the first line of the label, include the FirstNamefield, a space, and the LastName
    4. On the second line of the label, include the Address
    5. On the third line of the label, include the Cityfield, a comma (,), a space, the State field, a space, and the PostalCode Your label should match the label in Figure 4 on the following page.
    6. Sort the labels first by the LastNamefield and then by the FirstName
    7. Name the report Parent Mailing Labels. (Hint: Do not include the period. If you received a message indicating all information may not be displayed, click OK.)

Preview the mailing labels and confirm that they match Figure 5 below. Save and close the Parent Mailing Labels report.

Figure 4: Parent Prototype Label

 

Figure 5: Parent Mailing Labels Report in Print Preview View

 

 

  1. Open the Reservations by Sessionreport in Layout View. Open the Group, Sort, and Total Pane, and then add an ascending sort order on the ReservationID field within the SessionID Save but do not close the report.
  2. With the Reservations by Sessionreport still open in Layout View, add subtotals and a grand total to the LodgingFee column using the SUM function. Save but do not close the report.
  3. With the Reservations by Sessionreport still open in Layout View, apply conditional formatting to the values in the Child Total Price column so that if the field value is greater than or equal to 600, the field’s font color is set to Green (1st row, 7th column in the Standard Colors palette) and the font weight is Bold. Compare the report to Figure 6 below, and then save and close the Reservations by Session

 

Figure 6: Reservations by Session Report in Layout View

 

  1. Open the Counselor Contact Reportin Design View, and then set the Record Source property to the Counselor Contact Query. Save and close the Counselor Contact Report.
  2. Open the Children by Parentsreport in Design View, and then add a grouping field to the report as described below:
    1. Open the Group, Sort, and Total Pane, and then add the LastNamefield as a grouping field.
    2. Select the LastNameheader, and then change the Repeat Section property value to Yes.
    3. With the LastNameheader still selected, modify the Force New Page property so that a new page should be created after each section (using the After Section option).

Save the Children by Parents report, but do not close it.

  1. With the Children by Parentsreport still open in Design View, add a field to the LastName Header as described below:
    1. Add the LastNamefield to the LastName Header. (Hint: Use the Add Existing Fields button to open the field list.)
    2. Delete the label associated with the LastName
    3. Select the LastNamecontrol, and then modify it to display with a font size of 14 pt. and a font weight of Bold.
    4. Move the control so that the left edge of the LastNamecontrol is touching the left edge of the report as shown in Figure 7 below.
    5. Resize the LastNamecontrol so that the right edge of the control is at the 5″ mark on the horizontal ruler.

Save but do not close the Children by Parents report.

 

Figure 7: Children by Parents Report in Design View

 

 

  1. With the Children by Parentsreport still open in Design View, add page numbers and dates to the report as described below:
    1. Add the date to the report using the Short Date(e.g., 12/12/2017) format. Do not include the time in the report.
    2. Add page numbers to the report, using the Page N of Mformat, at the bottom of the page, with the Right alignment option.

Save the report and compare it to Figure 7. Close the Children by Parents report.

  1. Open the Session Chartsform in Design View. In the tab control, make the following updates:
    1. Use Adultsas the name of the first tab.
    2. Use Childrenas the name of the second tab.

Save but do not close the Session Charts form.

  1. With the Session Chartsform still open in Design View, switch to viewing the pie chart in the first tab control. Modify the chart type so that it appears as a Bar Compare the chart on the first tab control to the chart in Figure 8 below. Save but do not close the Session Charts form.

 

Figure 8: Session Charts Form – Adults Tab in Design View

 

  1. With the Session Chartsform still open in Design View, switch to viewing the second tab control. Insert a chart into the second tab control as described below:
    1. Insert a chart in the upper left corner of the tab based on the Session Totals
    2. Use the SessionIDand SumOfChildTotPrice fields (in that order) in your chart.
    3. Use 3-D Pie Chartas the chart type for your chart.
    4. The SessionIDfield should be the field for series, and the SumofChildTotPrice (which will be renamed SumofSumofChildTotPrice) field should be the field for data in the graph. (Hint: These fields should automatically be assigned to the correct areas in the Chart Wizard.)
    5. Use Total Children Fees by Sessionas the name of your chart.
    6. Display a legend in the chart.

Save the form, compare it to Figure 9 below, and then close the form. (Hint: If your chart appears different from the one shown in Figure 9, switch to Layout View and then back to Design View to refresh the form.)

 

Figure 9: Session Charts Form – Children Tab in Design View

 

  1. Open the Parents and Childrenreport in Design View. Remove the page header and footer from the report. Save but do not close the report.
  2. With the Parents and Childrenreport still open in Design View, add a text box control to the ParentID header as described below:
    1. Add the text box control to the ParentIDheader in the approximate location shown in Figure 10 below. (Hint: The left edge of the control should align with the left edge of the ParentID)
    2. Enter the following expression into the text box control:
      =[FirstName]&” “&[LastName]
    3. Reposition and resize the text box control so that it is approximately as long as the ParentIDcontrol above it and it appears in the approximate location shown in Figure 10.
    4. Set the Border Style property of the text box control to Transparent.
    5. Change the label associated with the text box to Parent Name. (Hint:Do not type the period.)
    6. Reposition and resize the label as necessary so that all text in the label is visible and the label appears in the approximate location shown in Figure 10.

 

Figure 10: Parents and Children Report in Design View

 

 

  1. With the Parents and Childrenreport still open in Design View, ensure that the Use Control Wizards button is selected. Insert a subreport into the Detail section of the report as described below:
    1. Add the subreport to the Detail section at approximately the 5″mark on the horizontal ruler and the 0.5″ mark on the vertical ruler.
    2. Base your subreport on the Parent-Child Query.
    3. Include the ParentID, FirstName, Age, and Genderfields (in that order) in the subreport.
    4. Accept the default link (“Show Parent-Child query for each record in parent using ParentID”) for each record in the Parenttable using the ParentID
    5. Use the default name Parent-Child Query subreportas the name of the subreport.
    6. In Design View, delete the label associated with the subreport.
    7. Reposition and resize the subreport to the approximate location shown in Figure 10.
    8. If necessary, resize the Detail section to the approximate size shown in Figure 10.

Save the report and compare it to Figure 10. Close the Parents and Children report.

Save and close any open objects in your database. Compact and repair your database, close it, and then exit Access. Follow the directions on the SAM website to submit your completed project.

Parent Camper Form

 

TO GET THIS OR ANY OTHER ASSIGNMENT DONE FOR YOU FROM SCRATCH, PLACE A NEW ORDER HERE

 

2018 © Copyright - All Rights Reserved | Capstone Project Writers

Start Typing