Henrico County Public Schools

Technology Integration Lesson Plan

Advanced Computer Information Systems 6613

Lesson Title: /

Creating Forms with Subforms

Teacher: Hunter Thomas / School: GodwinHigh School
Grade Level: 9-12
List specific tasks and related SOLs which will be taught during this lesson:
Task/Competency Number: / BUS6613.016 / SOL# / C/T 12.2
Task/Competency Number: / BUS6613.018 / SOL# / C/T 12.3
Task/Competency Number: / SOL#
Task/Competency Number: / SOL#
Lesson Overview:
Students will create a form with a subform. The form will also contain a memo, hyperlinks, and OLE fields.
Objectives and Goals:
  1. To create a form with a subform.

  1. To create a form which includes an OLE field.
  2. To create a form which includes a hyperlink field.

  1. To create a form which includes a memo field.

Approximate Time Required to Complete the Lesson:
40 minutes
Tools Needed:

Access, HenricoCountyCampDatabase

Tasks/Activities:
  1. Import the HenricoCountyCampDatabase or the tables in it.
  2. Add Supervisors Qualifications, Supervisor’s E-mail address, and Supervisors Picture to the Counselors Table.

  3. Add the following information to three new fields:

  1. Create a form with a subform using the Form Wizard. When using the Form Wizard, the Form Wizard will create both the form and subform simultaneously. You need to select the fields you would like from both the counselors table and camper info table. On the form, move the field so they are organized similar to the form below. You will probably need to change the properties of the OLE object size mode to Zoom to allow the picture to fit. Use the rectangle tool on the toolbox toolbar to show grouping of fields.

Process:
Students should complete the assignment on their own.
Assessment:
View form on computer or have student print out copy of form to grade. Base the grade on 100-point scale.
Total Amount of Points: 100
Additional Information:
The pictures used for the OLE objects were gotten through the clip art gallery. You could also have students take pictures of each other and have them use these pictures as the counselor’s picture. If you want to make the assignment last longer, you can have the students create the database from scratch. Can get information such as camper applications from the Developing and Managing Databases. Creating a Database Activity 2-3. Activity 3-3 and 4-3 will build up to this assignment. The information is not the exact information that is in this database, but will work just the same.