Lesson Plan for MS Access Database Objects

Background

The first article in this series, "All About Databases," is a basic lesson plan for introducing students to the general concepts of databases. This lesson plan continues that introduction and presents students with sample database objects that they will encounter as they learn Microsoft Access 2007 database design.

Learning Objectives

After completing this lessons, students should be able to:

♦ Recognize the constituent parts of a database.

♦ Learn how the following database objects relate to each other:

Tables are the foundation of the database. They contain the fields and records.

Forms enter and store data into tables.

Queries restrict the types of data displayed by tables.

Reports group or display the data in tables in user-specified ways.

Macros embed user-specified command within the database.

Lecture Notes

Areas of Discussion for the Class Session:

♦ What are the principal objects of a database?

◊ Discuss and define database tables. (See slide 1 following this section.) Tables are the foundation of the database. A table is a collection of related fields (columns) and records (rows). Data in the fields and records are related; for example a table could be a list of customers. The customers’ names would be in one field, their phone numbers in another.

◊ Discuss and define database forms. (See slide 2 following this section.) Database forms are layouts of the fields in the table on which they are based. Forms provide an orderly way of accessing and maintaining the table. Changes made in the form are reflected in the table (and vice versa). This is an important concept for new database users. Its early mastery will result in a quick understanding of database object relationships.

◊ Discuss and define database queries. (See slide 3 following this section.) Database queries can sort, filter and display data in ways that make the database more manageable.

◊ Discuss and define database reports. (See slide 4 following this section.) Database reports are the output product of the database. Reports list, group, and can calculate numerical data in databases.

◊ Discuss and define database macros. (See slide 5 following this section.) Database macros allow us to store steps or series of steps to make our database work more smoothly.

♦ Why is learning database "object integration" so important?

◊ Efficient database design depends on tables that will store the data in a way it can be accessed, grouped and reported in useful ways.

◊ The objects that support (or are supported by) tables — i.e., forms, queries and reports — must be designed using the underlying field and record structure of the database table. Conversely, database table design must take into account ways the database is accessed and what output (reports) are desired.

PowerPoint Slides

Slide 1 - Table
Slide 2 - Form
Slide 3 - Query
Slide 4 - Report
Slide 5 - Macro

Downloadable PowerPoint Presentation

A downloadable PowerPoint presentation with notes is available in the Windows Public Media Gallery at Objects in a Database.

Related Bright Hub Articles

Lesson Plan for MS Access: All About Databases

MS Database Objects

MS Access Databases: Tables are the Foundation

MS Access Databases: Using the Power of Forms

MS Access Databases: Data Mining Through Queries

Microsoft Access: The Power of Database Reports

MS Access Databases: Creating and Using Macros

This post is part of the series: 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