Warren Township High School
Business Education Department
 Business Computer Applications II
Access Projects> Summer Camp

SUMMER CAMP
ACCESS PROJECT I
Creating customized forms:
sub-forms, labels, combo boxes & pictures.
Summer Camp-PART A

In table design view, add a new field for the campers photo id's.  *Add pictures from the Summer Camp, Campers Photos, to the the Campers table.  Be sure to update your form.

*Resize as needed.  It should fit vertically in the box, not necessarily horizontally.
 

Create a combo box on the Counselors form for the CounselorID field  Replace the old CounselorID field.   Find a record on the  form based on the value selected in the combo box.  See below.

After completing the combo box, select it. Go to the property sheets. Go to the Data Tab. Select Counselor ID as control source.

 

Create a new form that includes a sub-form.
Use all the fields from the Campers.
Use all the fields from the Schedules.
View your data by Campers and finish the form.  Name it Campers1.
Modify the form design so that the entire sub-form is viewable.

See below:

Using your new form, Campers1, input the following records.

New Camper:

JS11
Joseph
Stephenitch
11
Alligator

SW12
Sue
Walker
8
Panther

Using your Activities form, input the following records.

New Activity:

Swimming
LW01
Lake
10

Using your new form, Campers1, input the following records.

New Activity:

JS11
Pottery
Scavenger Hunt
Rafting

SW12
Beading
Rafting
Canoeing

Update all the forms in Summer Camp by adding a picture to them from the Summer Camp folder, form photos.  Format the forms attractively.  You may decide which photo goes on each form.

Add to the header of every form a label that reads SUMMER CAMP.  Format the font, font size and font color of the label.

Attractively format the background of the form.

Attractively format the items on the form. 

Summer Camp-PART B

  • Enforce Referential Integrity for all relationships in your Summer Camp Database.
  • Create a report that includes all the fields from the cabins table.
  • Format the report attractively; adjust label headings and contents of each report.
  • Add a calculated control to the report.
  • Format the Title of the report with the calculated control to a bright green
  • Create a parameter query.  Add all the fields from the Campers table.  Enter in Camper ID as the parameter criteria.  Save the Parameter Query as:  Campers Query.   Test it.
  • Create a parameter query.  Add all the fields from the Schedules table.  Enter in Day 1, 2 or 3 as the parameter criteria.  Save the Parameter Query as:  Schedules Query.   Test it.
  • Create a parameter query.  Add Camper ID and FirstName and LastName from the the Campers table, add Counselor ID from the Counselor table and ActivityName from the Schedules table.
    -Key in Enter Camper ID in the criteria field.
    -Save the query as:  Camper ID Schedule Information.  Test it.
  • Create a parameter query.  Add all the fields from the Campers table.
    -Key in     Enter first age in the first criteria field and Enter second age in the second criteria field.
    -Save the query as campers ages.
  • Use the Campers Ages query to create a new table of 8 and 9 year olds.  Name it 8 and 9 year old campers.  (make-table query)
  • On the Counselors table, add a hyperlink for Mr. Stocks Email Address.  Include this on each counselors record. 
  • On the Counselors table, add a hyperlink to the Business Education HomePage.  Include this on each counselors record.  Update the form.  Test the link.