ALEX Lesson Plans
Subject: Business, Management, and Administration (7 - 12), or Technology Education (6 - 8)
Title: Introduction to Database Management
Description: This lesson introduces students to the concept of organized information in a database. This is an introduction, so there are no computer exercises. A PowerPoint presentation is used as a visual aid for discussion and explanation. Students will receive presentation handouts to refer to during the presentation and to use afterward while completing a worksheet to assess what they have learned.
Subject: Business, Management, and Administration (9 - 12)
Title: Protecting Your Identity
Description: Students will create a database of Identity (ID) Theft Protection Services. Students will create a database report with recommendation regarding individual companies' that provide identity theft protection services and which company has the best product for the price. This is a Commerce and Information Technology lesson plan.
Access Database Reports
This podcast was created to demonstrate how to create a Microsoft Access Database Report and the different ways to create and manipulate the report. An Access Report can be created from a table or a query and this podcast demonstrates both.
Access Database Query
This podcast was designed as a tutorial on how to create a Microsoft Access Database Query. This podcast defines a query and why it is useful. There are several ways to create a query and this podcast covers each.
This podcast was created to demonstrate how to create a form in MicroSoft Access. Forms display one database record at a time. There are several ways to create a form from a table. This podcast discusses three ways to create a form from a table.
What is a Database?
This podcast was created to discuss the basic applications of a database. Because many are intimidated by the different features of a database, this podcast highlights the 4 major objects in an Access database, such as tables, forms, reports, and queries. This podcast also highlights what a database would be used for.
Access Database Tables
This podcast was created to demonstrate how to create a basic table in MicroSoft Access. Each step in creating a blank database is demonstrated with examples of formatting features that will help to simplify the database creation process.