Pin Me

Lesson Plan for MS Access: All About Databases

written by: Curt Smothers•edited by: Rebecca Scudder•updated: 8/25/2009

Microsoft Office Access is the most commonly used desktop database. This is a basic lesson plan for training adult students in Microsoft Access 2007. Students are introduced to the concept of databases in general and how databases affect so much in our everyday lives.

  • slide 1 of 8


    Of all the computer applications, Microsoft Access poses the biggest challenges to new students. Before involving students in the at-first overwhelming learning tasks, an introductory lesson about databases in general would ease the class into database immersion. This lesson plan is a general outline for introducing students to databases.

  • slide 2 of 8

    Learning Objectives

    After completing this lesson, students should be able to:

    ♦ Know the basic purpose and structure of databases

    ♦ Identify at least two everyday examples of database

    ♦ Be able to describe the concept of relational databases

    ♦ Understand the instructional approach in learning Microsoft Access

  • slide 3 of 8

    Lecture Notes:

    Areas of Discussion for the Class Session:

    ♦ What is a database?

    ◊ Define a database as a collection of related records. Talk about the evolution and history of databases. (See link in reference section at the end of the article.)

    What are some examples?

    Talk about the everyday examples of databases everyone knows about: the telephone book, the IRS and State tax databases, and some commercial products like Money and Tax Cut.

    ♦ What are the Most Common Types of Databases?

    ◊ Discuss flat-file, hierarchical, relational databases and object-oriented databases. A Microsoft Excel spreadsheet table can be used as a flat-file data base. Microsoft's Encarta Encyclopedia is hierarchical, and Microsoft Access is relational.

    ♦ How do databases differ from spreadsheets?

    ◊ Discuss how a database and a spreadsheet both share the table architecture, but both have different uses and applications.

    ♦ What can databases do?

    ◊ Emphasize the data storage and management role of the database. Return to everyday examples of the phone book. Mention how database fields can be merged with other files for marketing and advertising.

    ♦ Why should you learn database programming?

    ◊ Emphasize the advantages of learning database from the point of increasing skills and qualifications. People who know database operation tend to be more competitive in the job market.

    ♦ In this course, what, specifically will we learn?

    ◊ Describe Microsoft Access as a data management system with distinct “objects": fields, tables, queries, forms, reports and macros. Learning will be through a “stair-step" approach to mastering database learning.

  • slide 4 of 8

    Downloadable Lesson Plan

    A downloadable expanded version of the lesson plan described above is available at Lecture Notes for MS Access Lesson Plan: All About Databases.

  • slide 5 of 8

    Click on the images below for a preview of the expanded lesson plan:

    Page 1Page 2Page 3
  • slide 6 of 8

    Suggested Classroom and Homework Assignments

    Following the lecture and discussion, distribute the “Ice Breaker" exercise and allow students to circulate. Collect the sheets for future reference. Click on the image below for an example:

    Ice Breaker Assign the following homework essay assignment:

    Essay Assignment 

Lesson Plans for MS Access 2007

This is a series of MS Access database lesson plans for adult students. The plans were prepared by Curt Smothers, who is a former community college database applications instructor.
  1. Lesson Plan for MS Access: All About Databases
  2. Lesson Plan for MS Access: An Overview of Database Objects