Item Number: SNR-PLANNER

Technology Integration: Business Studies

Technology Skill: Database, Word Processing

Program: Access, Microsoft Office, Word


Advanced Database Skills: Teacher Guide, Printable Student Workbook, Paperless Worksheets, Review Questions, Extension Activities

Handouts and Assessment Tools: TechnoPlanner Parent Letter, TechnoPlanner Certificate, Summary of Skills Checklist, Form Marking Sheet, Unconfirmed Events Marking Sheet, Upcoming Events Marking Sheet

Sample: 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 Advanced Database Skills Activities

  • 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

Advanced Database Skills for High School

Include TechnoPlanner lesson plans in a computer application, marketing, or business studies course. Students operate a party planning business, building a database to organize clients and events. They produce forms for data entry, add records, organize data, design a query, and create a summary report.

  • 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

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 lesson plans teach advanced database skills in an engaging, real world application that is motivating and meaningful for high school students.

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

Project based activities for Microsoft Office. More than 40 projects that integrate technology into curriculum.

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


Create a digital scrapbook. Retouch, crop, adjust, warp, recolor, and superimpose images with Photoshop lesson plans.

View Details


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

View Details

Senior Projects