BCCC Capstone Access Carpenter Family Camp Computer Programming Task

Description

 complete capstone access carpenter family camp.   

4 attachmentsSlide 1 of 4attachment_1attachment_1attachment_2attachment_2attachment_3attachment_3attachment_4attachment_4

Unformatted Attachment Preview

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_FirstLastName_1.accdb, available for
download from the SAM website.

Save the file as SC_AC16_CS4-7a_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.
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.
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 Counselor table in Design View. Using the Input Mask Wizard, add an
input mask to the CellPhone field. 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 Activity table using the
following options:
a.
Select all of the fields in the Activity table. (Hint: The form should contain
five fields.)
b.
Use the Columnar layout.
c.
Use the title Activity Information for the form.
View the Activity Information form in Form View, and then save and close it.
3.
Open the Parent Camper Form in Design View and update the form as follows:
a.
Add the HomePhone control and label in the approximate locations shown
in Figure 1 on the following page.
b.
Select the HomePhone and CellPhone controls and their associated labels,
and then align them using the Top option.
Shelly Cashman Access 2016 | Modules 4–7: SAM Capstone Project 1a
Figure 1: Parent Camper Form in Design View
c.
Select the LastName and HomePhone controls and align them using the
Left option.
d.
Select the LastName and HomePhone labels, and then align them using
the Left option.
e.
Change the tab order so that users tab to the HomePhone control directly
after the LastName control.
Save but do not close the form.
4.
With the Parent Camper Form still 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:
a.
Use the Camper-Child Query for the subform.
Shelly Cashman Access 2016 | Modules 4–7: SAM Capstone Project 1a
b.
Select the CamperID, ParentID, FirstName, LastName, Gender, and Age
fields (in that order) from the Camper-Child Query to add to the subform.
c.
Accept the default link (“Show Camper-Child Query for each record in
Parent using ParentID”) to link the main form to the subform.
d.
Save the subform as Children subform. (Hint: Do not include the
period.)
e.
If necessary, reposition the subform to match the approximate location
shown in Figure 1.
Save the Parent Camper Form, but do not close it.
5.
With the Parent Camper Form still 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.
6.
Open the Counselor Entry Form in 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:
a.
The combo box should find a record in the form.
b.
The CounselorID, LastName, and FirstName fields (in that order) should
be selected for the combo box.
c.
The key column should be hidden.
d.
Add the text Go to Counselor: as the combo box label.
e.
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.
7.
With the Counselor Entry Form still open in Design View, add a command
button to the right side of the Form Footer section with these options:
a.
The command button action should close the form (using the Close Form
action).
b.
The button should display the text Close and no picture.
c.
The meaningful name for the command button should be Close Button.
(Hint: Do not include the period.)
d.
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.
8.
With Counselor Entry Form still 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 0.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.
Shelly Cashman Access 2016 | Modules 4–7: SAM Capstone Project 1a
Figure 2: Counselor Entry Form in Design View
9.
With the Counselor Entry Form still open in Design View, make the following
formatting updates:
a.
Use the Format Painter to copy the formatting from the Counselor ID label
to the other six labels in the Detail section of the form.
b.
In the Detail section of the form, change the fore color of the
CounselorID, FirstName, LastName, CellPhone, HireDate, and Specialty
controls 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.
10.
Use the Report Wizard to create a multi-table report as described below:
a.
Add the FirstName and LastName fields (in that order) from the Parent
table to the report.
b.
Add the SessionID, ReservationID, and LodgingFee fields (in that order)
from the Reservation table to the report.
c.
The data should by viewed by Parent with no additional grouping levels.
Shelly Cashman Access 2016 | Modules 4–7: SAM Capstone Project 1a
d.
Sort the report in ascending order by the SessionID field.
e.
Use the Stepped layout and Landscape orientation for the report.
f.
Use Parent Reservation as 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
11.
Use the Label Wizard to create mailing labels for the Parent table using the
following options:
a.
Use the Avery 5160 label size.
b.
Use Arial font, 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.)
c.
On the first line of the label, include the FirstName field, a space, and the
LastName field.
d.
On the second line of the label, include the Address field.
e.
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
the label in Figure 4 on the following page.
f.
Sort the labels first by the LastName field and then by the FirstName
field.
Shelly Cashman Access 2016 | Modules 4–7: SAM Capstone Project 1a
g.
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
Shelly Cashman Access 2016 | Modules 4–7: SAM Capstone Project 1a
12.
Open the Reservations by Session report in Layout View. Open the Group, Sort,
and Total Pane, and then add an ascending sort order on the ReservationID
field within the SessionID group. Save but do not close the report.
13.
With the Reservations by Session report 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.
14.
With the Reservations by Session report 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 report.
Figure 6: Reservations by Session Report in Layout View
15.
Open the Counselor Contact Report in Design View, and then set the Record
Source property to the Counselor Contact Query. Save and close the Counselor
Contact Report.
16.
Open the Children by Parents report in Design View, and then add a grouping
field to the report as described below:
Shelly Cashman Access 2016 | Modules 4–7: SAM Capstone Project 1a
a.
Open the Group, Sort, and Total Pane, and then add the LastName field
as a grouping field.
b.
Select the LastName header, and then change the Repeat Section
property value to Yes.
c.
With the LastName header 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.
17.
With the Children by Parents report still open in Design View, add a field to the
LastName Header as described below:
a.
Add the LastName field to the LastName Header. (Hint: Use the Add
Existing Fields button to open the field list.)
b.
Delete the label associated with the LastName control.
c.
Select the LastName control, and then modify it to display with a font size
of 14 pt. and a font weight of Bold.
d.
Move the control so that the left edge of the LastName control is touching
the left edge of the report as shown in Figure 7 below.
e.
Resize the LastName control so that the right edge of the control is at the
1.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
Shelly Cashman Access 2016 | Modules 4–7: SAM Capstone Project 1a
18.
With the Children by Parents report still open in Design View, add page
numbers and dates to the report as described below:
a.
Add the date to the report using the Short Date (e.g., 12/12/2017)
format. Do not include the time in the report.
b.
Add page numbers to the report, using the Page N of M format, 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.
19.
Open the Session Charts form in Design View. In the tab control, make the
following updates:
a.
Use Adults as the name of the first tab.
b.
Use Children as the name of the second tab.
Save but do not close the Session Charts form.
20.
With the Session Charts form 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 chart. 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
Shelly Cashman Access 2016 | Modules 4–7: SAM Capstone Project 1a
21.
With the Session Charts form still open in Design View, switch to viewing the
second tab control. Insert a chart into the second tab control as described
below:
a.
Insert a chart in the upper left corner of the tab based on the Session
Totals query.
b.
Use the SessionID and SumOfChildTotPrice fields (in that order) in your
chart.
c.
Use 3-D Pie Chart as the chart type for your chart.
d.
The SessionID field 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.)
e.
Use Total Children Fees by Session as the name of your chart.
f.
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
Shelly Cashman Access 2016 | Modules 4–7: SAM Capstone Project 1a
22.
Open the Parents and Children report in Design View. Remove the page header
and footer from the report. Save but do not close the report.
23.
With the Parents and Children report still open in Design View, add a text box
control to the ParentID header as described below:
a.
Add the text box control to the ParentID header 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 control.)
b.
Enter the following expression into the text box control:
=[FirstName]&” “&[LastName]
c.
Reposition and resize the text box control so that it is approximately as
long as the ParentID control above it and it appears in the approximate
location shown in Figure 10.
d.
Set the Border Style property of the text box control to Transparent.
e.
Change the label associated with the text box to Parent Name. (Hint: Do
not type the period.)
f.
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
Shelly Cashman Access 2016 | Modules 4–7: SAM Capstone Project 1a
24.
With the Parents and Children report 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:
a.
Add the subreport to the Detail section at approximately the 0.5″ mark
on the horizontal ruler and the 0.5″ mark on the vertical ruler.
b.
Base your subreport on the Parent-Child Query.
c.
Include the ParentID, Camper.FirstName, Age, and Gender fields (in that
order) in the subreport.
d.
Accept the default link (“Show Parent-Child query for each record in
parent using ParentID”) for each record in the Parent table using the
ParentID field.
e.
Use the default name Parent-Child Query subreport as the name of
the subreport.
f.
In Design View, delete the label associated with the subreport.
g.
Reposition and resize the subreport to the approximate location shown in
Figure 10.
h.
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.
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_FirstLastName_1.accdb, available for
download from the SAM website.

Save the file as SC_AC16_CS4-7a_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.
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.
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 Counselor table in Design View. Using the Input Mask Wizard, add an
input mask to the CellPhone field. 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 Activity table using the
following options:
a.
Select all of the fields in the Activity table. (Hint: The form should contain
five fields.)
b.
Use the Columnar layout.
c.
Use the title Activity Information for the form.
View the Activity Information form in Form View, and then save and close it.
3.
Open the Parent Camper Form in Design View and update the form as follows:
a.
Add the HomePhone control and label in the approximate locations shown
in Figure 1 on the following page.
b.
Select the HomePhone and CellPhone controls and their associated labels,
and then align them using the Top option.
Shelly Cashman Access 2016 | Modules 4–7: SAM Capstone Project 1a
Figure 1: Parent Camper Form in Design View
c.
Select the LastName and HomePhone controls and align them using the
Left option.
d.
Select the LastName and HomePhone labels, and then align them using
the Left option.
e.
Change the tab order so that users tab to the HomePhone control directly
after the LastName control.
Save but do not close the form.
4.
With the Parent Camper Form still 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:
a.
Use the Camper-Child Query for the subform.
Shelly Cashman Access 2016 | Modules 4–7: SAM Capstone Project 1a
b.
Select the CamperID, ParentID, FirstName, LastName, Gender, and Age
fields (in that order) from the Camper-Child Query to add to the subform.
c.
Accept the default link (“Show Camper-Child Query for each record in
Parent using ParentID”) to link the main form to the subform.
d.
Save the subform as Children subform. (Hint: Do not include the
period.)
e.
If necessary, reposition the subform to match the approximate location
shown in Figure 1.
Save the Parent Camper Form, but do not close it.
5.
With the Parent Camper Form still 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.
6.
Open the Counselor Entry Form in 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:
a.
The combo box should find a record in the form.
b.
The CounselorID, LastName, and FirstName fields (in that order) should
be selected for the combo box.
c.
The key column should be hidden.
d.
Add the text Go to Counselor: as the combo box label.
e.
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.
7.
With the Counselor Entry Form still open in Design View, add a command
button to the right side of the Form Footer section with these options:
a.
The command button action should close the form (using the Close Form
action).
b.
The button should display the text Close and no picture.
c.
The meaningful name for the command button should be Close Button.
(Hint: Do not include the period.)
d.
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.
8.
With Counselor Entry Form still 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 0.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.
Shelly Cashman Access 2016 | Modules 4–7: SAM Capstone Project 1a
Figure 2: Counselor Entry Form in Design View
9.
With the Counselor Entry Form still open in Design View, make the following
formatting updates:
a.
Use the Format Painter to copy the formatting from the Counselor ID label
to the other six labels in the Detail section of the form.
b.
In the Detail section of the form, change the fore color of the
CounselorID, FirstName, LastName, CellPhone, HireDate, and Specialty
controls 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.
10.
Use the Report Wizard to create a multi-table report as described below:
a.
Add the FirstName and LastName fields (in that order) from the Parent
table to the report.
b.
Add the SessionID, ReservationID, and LodgingFee fields (in that order)
from the Reservation table to the report.
c.
The data should by viewed by Parent with no additional grouping levels.
Shelly Cashman Access 2016 | Modules 4–7: SAM Capstone Project 1a
d.
Sort the report in ascending order by the SessionID field.
e.
Use the Stepped layout and Landscape orientation for the report.
f.
Use Parent Reservation as 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
11.
Use the Label Wizard to create mailing labels for the Parent table using the
following options:
a.
Use the Avery 5160 label size.
b.
Use Arial font, 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.)
c.
On the first line of the label, include the FirstName field, a space, and the
LastName field.
d.
On the second line of the label, include the Address field.
e.
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
the label in Figure 4 on the following page.
f.
Sort the labels first by the LastName field and then by the FirstName
field.
Shelly Cashman Access 2016 | Modules 4–7: SAM Capstone Project 1a
g.
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
Shelly Cashman Access 2016 | Modules 4–7: SAM Capstone Project 1a
12.
Open the Reservations by Session report in Layout View. Open the Group, Sort,
and Total Pane, and then add an ascending sort order on the ReservationID
field within the SessionID group. Save but do not close the report.
13.
With the Reservations by Session report 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.
14.
With the Reservations by Session report 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 report.
Figure 6: Reservations by Session Report in Layout View
15.
Open the Counselor Contact Report in Design View, and then set the Record
Source property to the Counselor Contact Query. Save and close the Counselor
Contact Report.
16.
Open the Children by Parents report in Design View, and then add a grouping
field to the report as described below:
Shelly Cashman Access 2016 | Modules 4–7: SAM Capstone Project 1a
a.
Open the Group, Sort, and Total Pane, and then add the LastName field
as a grouping field.
b.
Select the LastName header, and then change the Repeat Section
property value to Yes.
c.
With the LastName header 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.
17.
With the Children by Parents report still open in Design View, add a field to the
LastName Header as described below:
a.
Add the LastName field to the LastName Header. (Hint: Use the Add
Existing Fields button to open the field list.)
b.
Delete the label associated with the LastName control.
c.
Select the LastName control, and then modify it to display with a font size
of 14 pt. and a font weight of Bold.
d.
Move the control so that the left edge of the LastName control is touching
the left edge of the report as shown in Figure 7 below.
e.
Resize the LastName control so that the right edge of the control is at the
1.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
Shelly Cashman Access 2016 | Modules 4–7: SAM Capstone Project 1a
18.
With the Children by Parents report still open in Design View, add page
numbers and dates to the report as described below:
a.
Add the date to the report using the Short Date (e.g., 12/12/2017)
format. Do not include the time in the report.
b.
Add page numbers to the report, using the Page N of M format, 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.
19.
Open the Session Charts form in Design View. In the tab control, make the
following updates:
a.
Use Adults as the name of the first tab.
b.
Use Children as the name of the second tab.
Save but do not close the Session Charts form.
20.
With the Session Charts form 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 chart. 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
Shelly Cashman Access 2016 | Modules 4–7: SAM Capstone Project 1a
21.
With the Session Charts form still open in Design View, switch to viewing the
second tab control. Insert a chart into the second tab control as described
below:
a.
Insert a chart in the upper left corner of the tab based on the Session
Totals query.
b.
Use the SessionID and SumOfChildTotPrice fields (in that order) in your
chart.
c.
Use 3-D Pie Chart as the chart type for your chart.
d.
The SessionID field 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.)
e.
Use Total Children Fees by Session as the name of your chart.
f.
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
Shelly Cashman Access 2016 | Modules 4–7: SAM Capstone Project 1a
22.
Open the Parents and Children report in Design View. Remove the page header
and footer from the report. Save but do not close the report.
23.
With the Parents and Children report still open in Design View, add a text box
control to the ParentID header as described below:
a.
Add the text box control to the ParentID header 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 control.)
b.
Enter the following expression into the text box control:
=[FirstName]&” “&[LastName]
c.
Reposition and resize the text box control so that it is approximately as
long as the ParentID control above it and it appears in the approximate
location shown in Figure 10.
d.
Set the Border Style property of the text box control to Transparent.
e.
Change the label associated with the text box to Parent Name. (Hint: Do
not type the period.)
f.
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
Shelly Cashman Access 2016 | Modules 4–7: SAM Capstone Project 1a
24.
With the Parents and Children report 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:
a.
Add the subreport to the Detail section at approximately the 0.5″ mark
on the horizontal ruler and the 0.5” mark on the vertical ruler.
b.
Base your subreport on the Parent-Child Query.
c.
Include the ParentID, Camper.FirstName, Age, and Gender fields (in that
order) in the subreport.
d.
Accept the default link (“Show Parent-Child query for each record in
parent using ParentID”) for each record in the Parent table using the
ParentID field.
e.
Use the default name Parent-Child Query subreport as the name of
the subreport.
f.
In Design View, delete the label associated with the subreport.
g.
Reposition and resize the subreport to the approximate location shown in
Figure 10.
h.
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.

Purchase answer to see full
attachment

User generated content is uploaded by users for the purposes of learning and should be used following Studypool’s honor code & terms of service.

Reviews, comments, and love from our customers and community:

Article Writing

Keep doing what you do, I am really impressed by the work done.

Alexender

Researcher

PowerPoint Presentation

I am speechless…WoW! Thank you so much!

Stacy V.

Part-time student

Dissertation & Thesis

This was a very well-written paper. Great work fast.

M.H.H. Tony

Student

Annotated Bibliography

I love working with this company. You always go above and beyond and exceed my expectations every time.

Francisca N.

Student

Book Report / Review

I received my order wayyyyyyy sooner than I expected. Couldn’t ask for more.

Mary J.

Student

Essay (Any Type)

On time, perfect paper

Prof. Kate (Ph.D)

Student

Case Study

Awesome! Great papers, and early!

Kaylin Green

Student

Proofreading & Editing

Thank you Dr. Rebecca for editing my essays! She completed my task literally in 3 hours. For sure will work with her again, she is great and follows all instructions

Rebecca L.

Researcher

Critical Thinking / Review

Extremely thorough summary, understanding and examples found for social science readings, with edits made as needed and on time. Transparent

Arnold W.

Customer

Coursework

Perfect!

Joshua W.

Student

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>