Lesson Plan for MS Access: An Overview of Database Objects
written by: Curt Smothers•edited by: Rebecca Scudder•updated: 9/3/2009
Show your students the constituent parts an MS Access 2007 database for a quick overview of course learning objectives. This lesson plan introduces adult students to database objects and how the parts work together. Download the accompanying PowerPoint presentation from the public media gallery.
slide 1 of 6
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.
slide 2 of 6
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.
slide 3 of 6
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.
slide 4 of 6
slide 5 of 6
Downloadable PowerPoint Presentation
A downloadable PowerPoint presentation with notes is available in the Windows Public Media Gallery at Objects in a Database.