TechnoPlanner

Item Number: SNR-PLANNER

Technology Integration: Business Studies

Technology Skill: Database, Word Processing

Program: Microsoft Office, Word, Access

Includes: Database Project: 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

STEM Integration Lessons: business studies with database technology skills


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.
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

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



5.0

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

C. Andrews, MS, USA, Starkville Academy

5.0

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,
WA, USA


Other TechnoKids Senior Projects


TechnoPhotoshop

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


View Details

TechnoWonderland

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


View Details

Photo of SNR-ANIMATE - TechnoAnimate

TechnoAnimate

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


View Details

Photo of SNR-ADVERTISE - TechnoAdvertise

TechnoAdvertise

Build advanced word processing skills using Microsoft Word. Compose a resume to get hired. Design publications for an Ad Agency.


View Details


Senior Projects