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.