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.