Class: Senior Secondary School 1 (SSS 1)
Term: 3rd Term
Week: 8
Age: 15 years
Duration: 45 minutes
Subject: Data Processing
Curriculum Theme: Technology
Previous Lesson: Introduction to DBMS: Uses, Components and Examples.
Topic: Database Working Environment, Loading MS Access, Data Types, and Local Templates
Subject Matter: opening MS Access, navigating the Access environment and components, data types such as text and memo, using local templates such as Northwind, loading and exiting MS Access

Specific Objectives

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

Cognitive Domain:

Identify key parts of the MS Access environment.
List and explain common data types used in MS Access.

Affective Domain:

Appreciate the importance of understanding the database working environment.
Show interest in exploring different data types and templates.

Psychomotor Domain:

Open and exit MS Access correctly.
Navigate the MS Access environment effectively.
Practice using a local template database such as Northwind.

Collaborate with peers during practical sessions.

Reference Materials

The following resources were used in planning this lesson:

9 Years Basic Education Curriculum for Data Processing
State Unified Scheme of Work for Senior Secondary Schools
Data Processing for Senior Secondary Schools by Hi-Tech Publishers

Instructional Materials

The teacher will teach this lesson with the aid of:

Computer sets with MS Access software installed
Projector (optional, for demonstration)
Whiteboard and markers

Rationale for the Lesson

This lesson enables pupils to gain practical skills in using database software, which is widely applied in various fields for organizing information. Understanding the working environment and data types helps pupils manage data efficiently and effectively in real-world scenarios.

Prerequisite/Previous Knowledge

Pupils should have basic computer literacy, including how to turn on a computer and launch simple applications.

Lesson Content/Board Summary

Database Working Environment in MS Access

Opening and Exiting MS Access

Opening MS Access involves locating the application icon and double-clicking it. Exiting MS Access means closing the application window, which can be done by clicking the ‘X’ button or using the File menu.

The following are steps to open and exit MS Access:

Opening MS Access: Click the Start button > All Programs > Microsoft Office > Microsoft Access.
Exiting MS Access: Click the ‘X’ button at the top-right corner of the window or go to File > Close/Exit.

Navigating the MS Access Environment

The MS Access environment consists of several components that allow users to create and manage databases.

The following are key components of the MS Access environment:

Ribbon: Contains tabs with groups of commands for various tasks.
Navigation Pane: Displays a list of all objects (tables, queries, forms, reports) in the current database.
Object Tabs: Show open database objects in separate tabs.
Status Bar: Displays information about the current object or task.
Datasheet View: Displays table data in rows and columns.
Design View: Allows users to define the structure of tables, forms, or reports.

Data Types in MS Access

Data types define the kind of data that can be stored in a field, such as text, numbers, or dates. Choosing the correct data type helps in efficient storage and accurate data manipulation.

The following are common data types in MS Access:

Short Text: Used for text or combinations of text and numbers, up to 255 characters. (e.g., Names, addresses, phone numbers)
Long Text (Memo): Used for longer blocks of text, up to 65,535 characters. (e.g., Descriptions, notes)
Number: Used for numerical data.
Date/Time: Used for dates and times.
Currency: Used for monetary values.
Yes/No: Used for Boolean (true/false) values.

Using Local Templates in MS Access

MS Access provides pre-designed database templates that can be used as a starting point for creating new databases. These templates include pre-built tables, forms, and reports for specific purposes.

An example of a local template is:

Northwind Database: A classic sample database often used for learning and demonstrating MS Access features, containing data for a fictional company.

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 what they know about databases and how information is organized in a computer. The teacher then introduces the topic: “Database Working Environment, Loading MS Access, Data Types, and Local Templates.”
Pupils’ Activity: Pupils respond to the teacher’s questions and listen attentively to the introduction.
Learning Point: Pupils recall prior knowledge and are introduced to the lesson’s topic.

Step 2: Opening and Exiting MS Access

Time: 10 minutes
Teaching Skill: Demonstration/Practical
Teacher’s Activity: The teacher demonstrates how to open MS Access from the Start menu and how to exit the application. The teacher guides pupils to practice opening and exiting MS Access on their individual computer sets.
Pupils’ Activity: Pupils observe the demonstration and then practice opening and exiting MS Access.
Learning Point: Pupils learn the practical steps for launching and closing MS Access.

Step 3: Navigating the MS Access Environment

Time: 10 minutes
Teaching Skill: Explanation/Identification
Teacher’s Activity: The teacher displays the MS Access interface and points out key components such as the Ribbon, Navigation Pane, Object Tabs, and Status Bar. The teacher explains the function of each component.
Pupils’ Activity: Pupils observe the interface on their screens, identify the components, and listen to the explanations.
Learning Point: Pupils become familiar with the layout and functions of the MS Access working environment.

Step 4: Data Types in MS Access

Time: 5 minutes
Teaching Skill: Explanation/Questioning
Teacher’s Activity: The teacher explains what data types are and their importance. The teacher then discusses common data types like Short Text (Text) and Long Text (Memo), giving examples of when to use each.
Pupils’ Activity: Pupils listen to the explanation, ask questions, and take notes on the different data types.
Learning Point: Pupils understand the concept and practical application of data types.

Step 5: Using Local Templates in MS Access

Time: 5 minutes
Teaching Skill: Demonstration/Guided Practice
Teacher’s Activity: The teacher demonstrates how to open a new database using a local template, specifically the Northwind sample database, if available. The teacher guides pupils to explore the pre-built tables and forms within the template.
Pupils’ Activity: Pupils observe the demonstration and follow along to open and explore a local template.
Learning Point: Pupils learn how to use existing templates to quickly set up a database.

Step 6: Practical Session/Reinforcement

Time: 5 minutes
Teaching Skill: Supervision/Support
Teacher’s Activity: The teacher moves around the classroom, observing pupils as they practice opening/exiting Access, identifying environment components, and exploring the template. The teacher provides support and answers questions.
Pupils’ Activity: Pupils continue practicing the skills learned, asking for clarification where needed.
Learning Point: Pupils reinforce their practical skills and understanding through hands-on activity.

Step 7: Evaluation/Review

Time: 5 minutes

Teaching Skill: Questioning/Assessment

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

How do you open MS Access on a computer?
List three components of the MS Access working environment.
Define a data type in the context of databases.
Mention two common data types in MS Access and give an example of data for each.
What is the purpose of using a local template in MS Access?

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 understanding the Access environment and data types. The teacher assigns homework for pupils to research other data types in MS Access.
Pupils’ Activity: Pupils listen to the summary and copy down the homework assignment.
Learning Point: Pupils consolidate their learning and are given a task to extend their knowledge.

Lesson Keywords

Access – A database management system from Microsoft.
Database – An organized collection of structured information, or data, typically stored electronically in a computer system.
Data Type – A classification that specifies the kind of value that a variable can hold (e.g., text, number, date).
Short Text – A data type for text or combinations of text and numbers, up to 255 characters.
Long Text (Memo) – A data type for longer blocks of text, up to 65,535 characters.
Template – A pre-designed database that can be used as a starting point for a new database.
Northwind – A classic sample database often used with Microsoft Access for learning purposes.

Differentiation

For pupils who grasp concepts quickly, the teacher can provide additional challenges, such as asking them to identify more advanced components of the Access interface or explore other templates. For pupils needing more support, the teacher will provide one-on-one guidance during practical sessions and simplify explanations of data types with more basic examples. Peer-to-peer learning will also be encouraged during practical activities.

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 potential technical issues by having a backup demonstration method or pre-prepared screenshots. Encourage active participation during practical sessions to ensure all pupils gain hands-on experience. Emphasize safety protocols when using computer equipment.