The TechnoPlanner course has 21 assignments divided into six sessions.

Session 1: About Databases

Students use Microsoft Access to study the Planner database. It organizes customer and event information for an event planning company. Students study the stable, form, query, and report to gain an understanding of the purpose and structure of a database.

Session 2: Build Tables

Students become event planners. To make business operations run smoothly they begin construction of a database to store customer and event details. Students complete a planning sheet to organize the content of their database. Afterwards, they create the Customers table by adding the fields and setting the field properties. Next, students use their skills to build the Events table. Upon completion, students create a relationship between the tables to allow the event planner to connect customers to their booked events.

Session 3: Create Data Entry Forms

Students produce forms that allow for easy data entry. To begin, they create a Customers form using the Form Wizard. The layout of the form is modified to create a customized design. Afterwards an Events form is made in Design View. Upon completion, the forms are combined so that when a customer record is displayed, any events that are related to that client are also displayed. This is a great way to not only enter data but also easily look up client history.

Session 4: Enter, Sort and Find Data

Students add records to their database. They then learn how to organize data by sorting it alphabetically, numerically, and chronologically. Next students retrieve information from their database using the Search Box, Selection, and Find features. Afterwards, they consider how an event planner would use each search method to find information FAST!

Session 5: Confirmation of the Event

Students follow up on potential leads. They have several clients who have contacted them to plan an event but have not yet confirmed. Event planners design a query by combining data from the Customers and Events tables. This allows them to locate only customers who have not yet confirmed the event. Students produce a report that displays a printout of clients and their telephone numbers. Now event planners can call potential customers to confirm the possibility of working together.

Session 6: About Upcoming Events

Students create a report that summarizes upcoming events. To start, they produce a query in Design View that filters the records to list only those that are scheduled for the upcoming month. This information is summarized in a report created in Design View. This professional document can be used at a staff meeting to discuss job duties, as a guide when booking other events, or as a reference document for scheduling services.

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.