Class: Senior Secondary School 1 (SSS 1)
Term: 3rd Term
Week: 9
Age: 15 years
Duration: 45 minutes
Subject: Data Processing
Curriculum Theme: Technology
Previous Lesson: Database Working Environment: MS Access and Data Types.
Topic: Database Objects and Table Creation in MS Access
Subject Matter: Definition of Access database objects, Table, Form, Report, Query, Macro, Creating a table in design view, Inserting fields, Declaring field data types, Practice creating tables.

Specific Objectives

By the end of the lesson, pupils should be able to:

Cognitive Domain:

Define MS Access database objects.
Identify the functions of various database objects such as Table, Form, Report, Query, and Macro.

Affective Domain:

Appreciate the importance of organizing data using database objects.
Show interest in practical database creation using MS Access.

Psychomotor Domain:

Create a table in design view using MS Access software.
Insert appropriate fields into a table.
Declare suitable data types for different fields.

Collaborate with peers to design a simple database table.

Reference Materials

The following resources were used in planning this lesson:

9 Years Basic Education Curriculum for Data Processing (Senior Secondary).
State Unified Scheme of Work for Data Processing.
Data Processing for Senior Secondary Schools by Hi-Tech.
Microsoft Access Official Website
Tutorials Point – MS Access Database Objects

Instructional Materials

The teacher will teach this lesson with the aid of:

Computer sets with MS Access software installed.
Projector (for demonstration).
Whiteboard and marker.

Rationale for the Lesson

This lesson helps pupils understand how data is organized and managed in a database system. Learning about database objects and creating tables enables them to structure information effectively, which is useful in various real-world applications and future career paths involving data management.

Prerequisite/Previous Knowledge

Pupils have basic computer literacy, an understanding of data and information, and familiarity with basic computer applications.

Lesson Content/Board Summary

Database Objects and Table Creation in MS Access

Definition of MS Access Database Objects

MS Access database objects are the main components or building blocks used to store, organize, display, and manage data within an Access database. Each object serves a specific purpose in making the database functional.

Types of MS Access Database Objects and Their Uses

The following are common types of MS Access database objects:

Table: This is the fundamental object used to store data in an organized way. Data is stored in rows (records) and columns (fields).
Form: This object provides a user-friendly interface for entering, viewing, and editing data in tables. It helps simplify data entry.
Report: This object is used to present data from your database in a formatted, organized, and printable way. It can display summaries or detailed information.
Query: This object is used to retrieve specific data from one or more tables based on criteria you specify. It can also be used to perform calculations or update data.
Macro: This object allows you to automate tasks and add functionality to your database without writing complex code. It is a set of actions that run in a specific order.

Creating a Table in Design View

Creating a table in Design View gives you precise control over the structure of your table. It allows you to define field names, data types, and other properties before entering any data.

Steps for Creating a Table in Design View

The following are the steps to create a table in Design View:

Open MS Access and create a new blank desktop database.
Click on the “Create” tab in the ribbon.
In the “Tables” group, click on “Table Design”.
The Table Design view will open, showing “Field Name”, “Data Type”, and “Description” columns.
In the “Field Name” column, type the name for each field (e.g., “StudentID”, “FirstName”, “LastName”, “DateOfBirth”).
In the “Data Type” column, select the appropriate data type for each field from the dropdown list (e.g., “AutoNumber”, “Short Text”, “Date/Time”).
(Optional) In the “Description” column, add a brief explanation for each field.
Right-click on the field that will uniquely identify each record (e.g., “StudentID”) and select “Primary Key”.
Save the table by clicking the “Save” icon or pressing Ctrl+S. Give the table a meaningful name (e.g., “Students”).

Declaring Field Data Types

A data type specifies the kind of data that a field can hold (e.g., text, numbers, dates). Choosing the correct data type helps ensure data integrity and efficient storage.

Common data types include:

Short Text: For short alphanumeric values (e.g., names, addresses).
Long Text (Memo): For longer alphanumeric text, such as comments or descriptions.
Number: For numerical values used in calculations (e.g., quantity, age).
Date/Time: For dates and times.
Currency: For monetary values.
AutoNumber: Automatically assigns a unique sequential number or random number to each new record.
Yes/No: For fields that contain only one of two values (e.g., True/False, On/Off).

Teaching Methods/Instructional Techniques

Discussion, Lecture, Demonstration, Question and Answer, Visual Aids

Instructional Procedures

Step 1: Introduction

Time: 5 minutes
Teaching Skill: Set Induction
Teacher’s Activity: The teacher greets the pupils and asks them to recall what they understand by “data” and “information”. The teacher then introduces the topic by asking how large amounts of data, like student records or library books, can be effectively organized on a computer.
Pupils’ Activity: Pupils respond to the questions and listen attentively to the introduction.
Learning Point: Pupils recall prior knowledge and are prepared for the new lesson.

Step 2: Definition of Database Objects

Time: 7 minutes
Teaching Skill: Explanation/Definition
Teacher’s Activity: The teacher defines MS Access database objects and explains that they are the fundamental components of a database. The teacher shows visual samples of different objects (e.g., a blank table, a simple form, a report layout) using a projector.
Pupils’ Activity: Pupils listen, take notes, and observe the samples shown by the teacher.
Learning Point: Pupils understand the concept of database objects and their purpose.

Step 3: Types of Database Objects and Their Uses

Time: 8 minutes
Teaching Skill: Explanation/Listing
Teacher’s Activity: The teacher explains each type of database object (Table, Form, Report, Query, Macro) in detail, highlighting their specific uses and importance in a database system. The teacher encourages questions.
Pupils’ Activity: Pupils listen, ask questions for clarification, and note down the types and uses of each object.
Learning Point: Pupils can identify and state the function of each major database object.

Step 4: Introduction to Table Creation in Design View

Time: 5 minutes
Teaching Skill: Demonstration/Instruction
Teacher’s Activity: The teacher demonstrates on a projector how to open MS Access, create a new blank database, and navigate to the “Table Design” view. The teacher explains why Design View is useful for structuring tables.
Pupils’ Activity: Pupils observe the demonstration carefully and follow the steps mentally.
Learning Point: Pupils understand the initial steps to create a table in Design View.

Step 5: Practical – Inserting Fields and Declaring Data Types

Time: 10 minutes
Teaching Skill: Guided Practice/Demonstration
Teacher’s Activity: The teacher guides pupils step-by-step through the process of creating a sample table (e.g., a “Students” table). The teacher demonstrates how to insert field names (e.g., StudentID, FirstName, DateOfBirth) and declare appropriate data types for each field. Pupils follow along on their individual computer systems.
Pupils’ Activity: Pupils actively follow the teacher’s instructions, inserting fields and assigning data types on their computers. They ask questions if they encounter difficulties.
Learning Point: Pupils gain practical experience in structuring a table, inserting fields, and declaring data types.

Step 6: Further Practice/Troubleshooting

Time: 5 minutes
Teaching Skill: Facilitation/Support
Teacher’s Activity: The teacher allows pupils to practice creating another simple table (e.g., “Courses” table) on their own or in pairs. The teacher moves around the classroom, providing assistance and clarifying any issues or errors pupils encounter.
Pupils’ Activity: Pupils continue practicing table creation, applying what they have learned, and seek help when needed.
Learning Point: Pupils reinforce their understanding and practical skills in table creation and data type declaration.

Step 7: Evaluation/Review

Time: 5 minutes

Teaching Skill: Questioning/Assessment

Teacher’s Activity: The teacher evaluates the learning by asking the following questions:

Define MS Access database objects.
List any three types of MS Access database objects and state their uses.
Mention two steps involved in creating a table in Design View.
State the appropriate data type for a field that will store a pupil’s date of birth.

Pupils’ Activity: Pupils answer orally and in writing.

Learning Point: Pupils demonstrate understanding of the lesson.

Step 8: Conclusion

Time: 5 minutes
Teaching Skill: Summarization/Assignment
Teacher’s Activity: The teacher summarizes the key points of the lesson, reiterating the importance of database objects and the steps for creating tables. The teacher assigns homework: “Create a database named ‘Library’ and design a table named ‘Books’ with fields like BookID, Title, Author, YearPublished, and QuantityAvailable, ensuring appropriate data types.”
Pupils’ Activity: Pupils listen to the summary and copy the homework assignment.
Learning Point: Pupils consolidate their learning and are given tasks to practice further.

Lesson Keywords

Database – An organized collection of structured information, or data, typically stored electronically in a computer system.
Object – A fundamental component or building block of an Access database.
Table – A database object used to store data in rows and columns.
Form – A database object used for entering, editing, or viewing records in a user-friendly layout.
Report – A database object used to present data in a formatted, organized, and printable way.
Query – A database object used to retrieve and manipulate specific data from tables.
Macro – A database object used to automate tasks and add functionality without programming.
Field – A column in a database table that contains a specific type of information (e.g., “Name” or “Age”).
Data Type – A characteristic of a field that determines what kind of data it can hold (e.g., text, number, date/time).
Design View – A view in MS Access used to define the structure of a database object, such as a table or form.

Differentiation

For pupils who grasp concepts quickly, the teacher can challenge them to explore field properties beyond data types, such as field size or input masks. For pupils who require more support, the teacher will provide additional one-on-one guidance during practical sessions and pair them with stronger peers for collaborative learning.

Note for teachers using this lesson plan

Ensure that all computer systems have MS Access installed and are in good working condition before the lesson. Plan for adequate time for practical sessions as hands-on experience is important for this topic. Encourage pupils to experiment and ask questions to foster a deeper understanding.