Item Number: SNR-PLANNER

ADVANCED DATABASE PROJECT: Hook student interest. Play the role of an event planner. Organize data and learn database skills in a unique and personally meaningful project.

STUDENT-CENTERED AND ENGAGING: Promote active learning as students solve real-life challenges. As a company owner who plans special occasions such as birthday parties and proms, teens create a database to track clients and event details.

EASY TO IMPLEMENT RESOURCES: Everything you need is included. Teacher Guide in PDF format includes comprehensive instructions for getting started, helpful strategies, lesson plans, marking sheets, and learning objectives. Student Workbook may be used digitally or printed. Illustrated, step-by-step instructions support differentiated instruction, chunking of activities, and independent learning. Checklists encourage organizational skills. Sample party planning database fosters creativity.

STEM, CTE, AND ICT INTEGRATION: Advance technology competence for career readiness. Students require essential computer skills for the job opportunities of the future.

PERPETUAL SITE LICENCE: TechnoKids projects have no expiry date. Use the materials on an unlimited number of devices in your school. Download a project today, buy a complete set for high school grades, or purchase a package of all projects for K – 12.

Technology Integration: Business Studies

Technology Skill: Data Management, Database, Word Processing

Version: Microsoft 365, Office 2019, Office 2016, Office 2013

Program: Access, Word

Assignment 1 What is a Database?

Recognize the purpose of a database.

Assignment 2 About Microsoft Access

Label the parts of the program window.

Assignment 3 Examine Tables in a Database

Study fields in a table. Add a record in datasheet view.

Assignment 4 Examine Forms in a Database

Study fields on a form. Add a record in form view.

Assignment 5 Examine a Query in a Database

Identify the fields and source table used in a query.

Assignment 6 Examine a Report in a Database

Consider benefits to generating reports.

Assignment 7 The Event Planning Industry

Read about event planning to learn about services.

Assignment 8 Become an Event Planner

Launch a business. Plan a database for customer data.

Assignment 9 Build the Customers Table

Construct a table in datasheet view. Set field properties.

Assignment 10 Build the Events Table

Construct a table in design view. Include an input mask.

Assignment 11 Create a Relationship Between the Tables

Join customer and event information.

Assignment 12 Create a Customers Form with the Wizard

Design a form. Customize layout.

Assignment 13 Create the Events Form in Design View

Arrange controls on a form. Adjust tab order.

Assignment 14 Add the Events Form to Customers Form

Use a subform to view customer events.

Assignment 15 Enter Records

Add customer information and book events.

Assignment 16 Sort Records

Order records numerically, alphabetically, or chronologically.

Assignment 17 Search, Find, and Filter Records

Locate records that match criteria.

Assignment 18 Which Customers Need to Confirm Plans?

Use the Query Wizard to filter records.

Assignment 19 Create a Calling List

Generate a report from a query in design view. Sort the data.

Assignment 20 What Events are Upcoming?

Create a query in design view to filter records.

Assignment 21 Create a Report of Upcoming Events

Produce a report from a query in design view.

Optional Database Project 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.

Terms of Use
Use TechnoPlanner with unlimited users at your site. A site is a physical location such as classroom, school, learning center, daycare, library, or home. If you teach at multiple sites, you will need to purchase one set for each location. Access everything you need from TechnoHub, and transfer the files to all devices at your site. View the PDF teacher guides and workbooks digitally or print as many as you need. Files CANNOT be posted in public domain.

Become an Event Planner
Introduce Students to Access
Teach Advanced Database Skills
Database Project for High School

Advanced Database Skills for High School

Include TechnoPlanner database project 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

Includes multiple versions for Office 2016 | 2013
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 database project teaches 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

Photo of SNR-COLL - Senior Curriculum Collection

Senior Curriculum Collection

Activities emphasize real-world applications of technology. Prepare students for higher learning and career readiness.

View Details


Promote an amusement park. Solve a variety of challenges with Microsoft Office lessons.

View Details


Create a digital scrapbook. Retouch, crop, adjust, warp, recolor, and superimpose images with Photoshop lessons for beginners.

View Details

Photo of SNR-ANIMATE - TechnoAnimate


Create an animated space story with Adobe Animate CC lessons. Animation for beginners.

View Details

Senior Projects