Item Number: SNR-PLANNER

Technology Integration: Business Studies

Technology Skill: Database, Word Processing

Program: Access, Word

Includes: High School Database Lesson Plans, Teacher Guide, Printable Student Workbook, Paperless Worksheets, Review Questions, Extension Activities, TechnoPlanner Parent Letter, TechnoPlanner Certificate, Summary of Skills Checklist, Form Marking Sheet, Unconfirmed Events Marking Sheet, Upcoming Events Marking Sheet, TechnoPlanner Database (database includes customer and event records for a party planning business)

Session 1: About Databases

Gain an understanding of database structure by studying a sample database.

Session 2: Build Tables

Plan and create tables and field properties to improve data entry.

Session 3: Create Data Entry Forms

Create a subform to display client event history on the main form.

Session 4: Enter, Sort, and Filter Data

Locate customer records efficiently. Organize, sort, and filter data.

Session 5: Confirmation of the Event

Create a report for follow-up from a query of unconfirmed events.

Session 6: About Upcoming Events

Summarize upcoming events from a query. Create a report in Design View.

Optional High School Database Lesson Plans

Database Designer: Plan and design a database.
Organize Movies: Build a table to organize a product.
My Favorite Songs: Make a form to categorize music.
Mailing Labels: Create address labels from a database.
Mail Merge: Create a personalized advertisement.

Become an Event Planner
Introduce Students to Access
Teach Advanced Database Skills
Organize Business Data

High School Database Lesson Plans

Include TechnoPlanner in a computer application, marketing, or business studies course. Students operate a party planning business, building a database to organize clients and events.

  • Construct a database
  • Make a table in a database to store data
  • Set the field properties in a table
  • Establish a relationship between tables
  • Create simple data entry forms
  • Add a subform to a main form
  • Sort, find, and filter records
  • Produce a query to filter data
  • Design and format a report
  • Evaluate the design of database objects

Customer Reviews

High school students start a business to plan occasions such as parties, proms, or weddings. Microsoft Access is used to create a database to organize information. TechnoPlanner high school database lesson plans teach advanced skills in an engaging, real world application.

Write a Review


Just finished TechnoPlanner. Imagine teaching this to 50 eight graders.  All were successful.

C. Andrews, MS, USA, Starkville Academy


I was really happy to use Planner for Access. It is very hard to find lessons that support Access and this is perfect. Thanks for all you do with the project based curriculum.

A. Vetter, WA, USA, Napavine High School

I was really happy to use Planner for Access. It is very hard to find lessons that support Access and this is perfect. Thanks for all you do with the project based curriculum.

database activities reviewer

A. Vetter,
Napavine High School,

Other TechnoKids Senior Projects

Microsoft Plus Package

Computer lessons include project based activities that use Microsoft Office. Make learning meaningful.

View Details

Microsoft Complete Package: Microsoft Plus + Office 365 Projects

Project based activities for Microsoft Office and Office 365 Online. More than 50 projects that integrate technology into curriculum.

View Details

Photo of SNR-PHOTOSHOP - TechnoPhotoshop


Retouch, crop, adjust, and superimpose images using Photoshop lessons. Photo editing activities for beginners.

View Details


Promote an amusement park. Design posters in Word, surveys in Excel, ads in PowerPoint, and more!

View Details

Senior Projects