Henrico County Public Schools

Technology Integration Lesson Plan

Advanced Computer Information Systems 6613

Lesson Title: /

Creating Advanced Forms and Reports using Access

Teacher: Hunter Thomas / School: Godwin High 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.4
Task/Competency Number: / BUS6613.019 / SOL#
Task/Competency Number: / SOL#
Lesson Overview:
Students will create advanced forms and reports for the Henrico County Camp database. The reports will be created from advanced queries. The forms will also contain drop down boxes.
Objectives and Goals:
1.  To import the Henrico County Camp Database or the tables in the database.
2.  To create a query for a report.
3.  To create a report using the Report Wizard.
4.  To use the Report window to modify a report’s design.
5.  To create a report with groupings and subtotals.
6.  To create a form using the Form Wizard.
7.  To use the Form window to modify a form’s design.
8.  To put a calculated field on a form.
9.  To put a combo box on a form to both select values and look up items.
Approximate Time Required to Complete the Lesson:
60 minutes
Tools Needed:

Access, Henrico County Camp Database

Tasks/Activities:
1.  Import the Henrico County Camp Database or the tables in it.
2.  You have realized that the database you created for the Henrico County Camp, to store campers information, could be used for many more aspects of the camp. Open the Henrico County Camp Database.
3.  Create a query with a calculated field as shown below:

4.  Create the report below using the First Day of Camp Payment Query. Adjust the page header so the header looks like the one below:

5.  Create a second report using both the Camper Info and Counselors tables. Group the table by team and sort by first name within last name. You would also like to find the average age of each team. Use summary options to find the average. The report should look like the report below:

6.  Create a custom form called the Camper Update Form. On the form, move the fields so they are organized similar to the form below. The League field should be a combo box that selects values from a list. The Camper to Find field is also a combo box. It should be able to find a record in the table based on what is entered into the combo box. Use the rectangle tool on the toolbox toolbar to show grouping of fields.


Process:
Students should complete the assignment on their own.
Assessment:
Students will turn in reports and show form to teacher on computer. Base the grade on 100-point scale.
Total Amount of Points: 100
Additional Information:
This is where students start to like using databases. They start to see how databases can be used in the business world. 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 in these assignments is not the exact information that is in this database, but will work just the same.