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.
Use TechnoPlanner with unlimited users at your site. A site is a physical location such as classroom, school, learning center, daycare, library, or home. If you teach at multiple sites, you will need to purchase one set for each location. Individual projects are downloadable. Order 5 or more projects or a set and receive a USB drive. Transfer the files to all devices at your site. View the PDF teacher guides and workbooks digitally or print as many as you need. Files CANNOT be posted in public domain.