Henrico County Public Schools

Technology Integration Lesson Plan

Advanced Computer Information Systems 6613

Lesson Title: /

Creating an Application System

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# / C/T 12.4
Task/Competency Number: / SOL#
Lesson Overview:
Students will create an Application Program using macros and the Switchboard manager. By creating the switchboard system you will no longer have to use the database window to change from table to forms and reports. You will have buttons on the screen that will allow you to use these items.
Objectives and Goals:
  1. To create a macro and modify it

  1. To create a switchboard
  2. To modify switchboard items and pages

  1. To use a switchboard

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

Access, HenricoCountyCampDatabase

Tasks/Activities:

Henrico County Public Schools

Technology Integration Lesson Plan

Advanced Computer Information Systems 6613

  1. Open the HenricoCountyCampDatabase or the tables in it. (You will need to have done the Creating Forms with Subforms and Creating Advanced Forms and Reports using Access assignments in order to do this assignment.)
  2. Create the Macros. You need to create macros to open all forms and tables and to print all items in your database. In the table below are the macros that you will need.

Open Camper Info Table Macro:
Action / Action Argument
Open Table / Table Name = Camper Info Table
View = Datasheet
Open Counselors Table Macro:
Action / Action Argument
Open Table / Table Name = Counselors Table
View = Datasheet
Open Team Update Form Macro:
Action / Action Argument
Echo / Echo on = No
Hourglass / Hourglass on = Yes
Open Form / Form Name = Team Update Form
Maximize
Hourglass / Hourglass on = No
Echo / Echo on = Yes
Open Camper Update Form Macro:
Action / Action Argument
Echo / Echo on = No
Hourglass / Hourglass on = Yes
Open Form / Form Name = Camper Update Form
Maximize
Hourglass / Hourglass on = No
Echo / Echo on = Yes
Preview First Day of CampPayment Report Macro:
Action / Action Argument
Open Report / Report Name = First Day of CampPayment Report
View = Print Preview
Preview Team Distribution Report Macro:
Action / Action Argument
Open Report / Report Name = Team Distribution Report
View = Print Preview
Print First Day of CampPayment Report Macro:
Action / Action Argument
Open Report / Report Name = First Day of CampPayment Report
View = Print Preview
Print Team Distribution Report Macro:
Action / Action Argument
Open Report / Report Name = Team Distribution Report
View = Print
  1. Create Switchboard Pages. You will need a switchboard page for the Main Switchboard, View Reports, Print Reports, and Forms. Use the switchboard manager to set this up. Example shown below:

  1. Now you can create the individual switchboard pages. The main switchboard should be able to go to all other switchboard pages and exit the application. Example shown below:

  1. The other switchboard pages should run macros for that page and then be able to return to the main switchboard. Example shown below:

  1. When you have finished setting up you Switchboard, close the switchboard manager and use the Switchboard you just created. It should look like the ones below:


Process:
Students should complete the assignment on their own.
Assessment:
View switchboard on the student’s computer to grade. Base the grade on 100-point scale.
Total Amount of Points: 100
Additional Information:
Again you need to have done the Creating Forms with Subforms and Creating Advanced Forms and Reports using Access assignments in order to do this assignment. The more advanced students can go into the switchboard form design and edit it. They can change the background, colors in the form, and add pictures.