Practical Database Management for SSS 1: How to Create Simple Databases, Run Queries, and Generate Reports
INTRODUCTION
Think about your school's student register. Every student has a name, admission number, class, and date of birth recorded somewhere. Now imagine if the school had over 2,000 students — keeping track of all that information in paper files would be a nightmare. That is exactly the problem databases were designed to solve.
In today's world, data is everywhere. Banks like GTBank and Access Bank store millions of customer records. The National Population Commission keeps records of every Nigerian citizen. WAEC and NECO manage examination results for hundreds of thousands of students every year. All of these are powered by database management systems working quietly in the background.
As an SSS 1 student, understanding how databases work is not just a subject requirement — it is a life skill. Whether you end up in business, medicine, law, or technology, you will interact with databases at some point. This lesson breaks it all down in a way that is simple, practical, and very much rooted in the Nigerian experience.
LEARNING OBJECTIVES
By the end of this lesson, students should be able to:
- Define a database and explain its importance in everyday life
- Identify the basic components of a database (tables, fields, records, and keys)
- Create a simple database using Microsoft Access or a similar tool
- Write basic queries to search and filter data from a database
- Generate simple reports from a database
- Describe ethical and responsible ways to manage data
WHAT IS A DATABASE?
A database is an organised collection of related data stored in a way that makes it easy to access, manage, and update. Think of it like a very well-arranged filing cabinet, except instead of paper files, everything is stored electronically.
A Database Management System (DBMS) is the software used to create, manage, and manipulate databases. Common examples include:
- Microsoft Access (commonly used in Nigerian secondary schools)
- MySQL (used by websites and applications)
- Oracle (used by large organisations and banks)
- SQLite (lightweight, used in mobile apps)
For your SSS 1 level, Microsoft Access is the standard tool recommended under the Nigerian NERDC curriculum.
Key Terms You Must Know
Before diving into the practical side, let us look at some important terms.
Table: A table is like a spreadsheet grid. It stores related data in rows and columns. For example, a table called "Students" might store student details.
Field: A field is a single column in a table. It represents one type of information. Examples include StudentName, AdmissionNumber, and DateOfBirth.
Record: A record is a single row in a table. It contains all the information about one entry. For example, one student's full details form one record.
Primary Key: This is a unique identifier for each record in a table. No two records can have the same primary key. An admission number is a good example — every student has a different one.
Query: A query is a question you ask the database. For instance, "Show me all students in JSS 2" is a query. The database searches through its records and returns matching results.
Report: A report is a formatted, printable summary of data from the database. Reports are used to present information in a clean, organised way — for example, a list of students who scored above 70 in Mathematics.
CREATING A SIMPLE DATABASE IN MICROSOFT ACCESS
Let us walk through the process of creating a simple student database step by step. This is the kind of database your school's administration office might use.
Step 1 — Open Microsoft Access
Open Microsoft Access on your computer. Select "Blank Database" and give it a name like "SchoolDatabase." Choose where to save it on your computer and click "Create."
Step 2 — Create a Table
Once the blank database opens, you will see a default table. You can build your table here. Click on "Click to Add" to start entering your field names. For a student database, you might add the following fields:
- StudentID (set this as the Primary Key — Access usually does this automatically with an ID field)
- FirstName
- LastName
- Class
- DateOfBirth
- State
- Gender
To change the data type of each field, click on the dropdown next to the field name. For example, DateOfBirth should be set to "Date/Time," while StudentID should be set to "AutoNumber."
Step 3 — Enter Records
Once your fields are set, switch to "Datasheet View" by clicking the View button at the top left. Now you can start entering student records. Enter at least five sample records so you have data to work with.
For example:
- StudentID: 1, FirstName: Amara, LastName: Okonkwo, Class: SSS1A, DateOfBirth: 12/03/2010, State: Enugu, Gender: Female
- StudentID: 2, FirstName: Babatunde, LastName: Adeyemi, Class: SSS1B, DateOfBirth: 04/07/2009, State: Ogun, Gender: Male
After entering your records, save the table by pressing Ctrl + S and name it "Students."
RUNNING QUERIES IN A DATABASE
Once your data is entered, queries help you find specific information quickly. Instead of scrolling through hundreds of records manually, you simply ask the database a question and it finds the answer for you.
How to Create a Query in Microsoft Access
Go to the "Create" tab at the top of the screen and click on "Query Design." A window will appear asking you to select which table to query. Select "Students" and click "Add," then close the window.
You will see a grid at the bottom of the screen. This is where you tell Access what you are looking for.
Example Query 1: Find all students in SSS 1A
In the field row, select "Class." In the criteria row, type SSS1A. Click "Run" (the red exclamation mark). Access will display only the students in SSS 1A.
Example Query 2: Find all female students
In the field row, select "Gender." In the criteria row, type Female. Click "Run." Only female students will appear.
Example Query 3: Find all students from Lagos State
Select "State" in the field row and type Lagos in the criteria row. Run the query and you will see all Lagos students.
Saving Your Query
After running a query, save it by pressing Ctrl + S. Give it a descriptive name like "Female Students" or "SSS1A Class List." You can run the same query again anytime without having to recreate it.
GENERATING REPORTS FROM A DATABASE
A report in database management is a polished, formatted output of your data. While a query shows raw results on screen, a report formats the same data in a way that is suitable for printing or sharing.
How to Create a Report in Microsoft Access
Go to the "Create" tab and click "Report Wizard." Select the query or table you want to base your report on. For example, select the "Students" table.
Choose which fields you want to appear in the report. You might choose FirstName, LastName, Class, and State. Click "Next."
You can choose to group the data — for example, group by Class so that all SSS 1A students appear together, followed by SSS 1B, and so on. Click "Next."
Choose a sort order if you want — for example, sort alphabetically by LastName. Click "Next."
Select a layout (Tabular is recommended for lists) and a style. Click "Finish."
Access will generate a neat report that you can print or save as a PDF. This is exactly the kind of report a school administrator would hand to the principal during a staff meeting.
PRACTICAL APPLICATIONS IN NIGERIA
Databases are not just things you learn in school and forget. They are used every day across Nigeria in ways that directly affect our lives.
Hospital Records: General Hospital Ikeja, LUTH, and other hospitals across Nigeria use databases to store patient information — names, blood groups, diagnoses, and medications. This ensures doctors can quickly access a patient's history.
Banking: Every time you check your GTBank or Opay account balance, a database is being queried in real time. Your transaction history, account number, and balance are all stored in a secure database.
JAMB and WAEC: When you register for UTME or WAEC, your details are entered into a massive national database. Your results are also stored and retrieved from these systems.
NIMC and NIN: The National Identity Management Commission uses a database to store the details of every Nigerian who has registered for a National Identification Number. This is one of the largest databases in Nigeria.
Supermarkets and Shops: Places like Shoprite, Spar, and many local Nigerian supermarkets use databases to track their inventory — knowing which products are in stock, how many units are left, and when to reorder.
ADVANTAGES AND DISADVANTAGES OF DATABASE MANAGEMENT
Advantages:
- Databases make it easy to store and retrieve large amounts of data quickly
- Data can be shared by multiple users at the same time (for example, a hospital with multiple departments)
- Databases reduce data duplication — the same information does not need to be stored in ten different places
- They improve data security by allowing administrators to set who can access what information
- Reports and queries save time compared to searching through paper records
Disadvantages:
- Setting up and maintaining a database requires technical knowledge, which can be a challenge for less skilled users
- If a database is not properly secured, sensitive data can be accessed by unauthorised people
- Databases require regular backup to prevent data loss in case of power failure or system crash
- Hardware failures can corrupt or destroy an entire database if there is no backup in place
ETHICAL AND SAFETY CONSIDERATIONS IN DATABASE MANAGEMENT
When managing a database, especially one that contains personal information about people, certain ethical rules must be followed.
Privacy: Do not collect more personal information than is necessary. If you are building a school database, you do not need to know a student's home address unless it is relevant.
Data Security: Always protect your database with a password. Sensitive databases — like those containing medical records or financial information — should be encrypted.
Accuracy: Make sure the data you enter is correct. Entering wrong information can lead to serious problems. For example, a wrong blood group in a hospital database could put a patient's life at risk.
Authorised Access Only: Only people who need to use the database should be given access. Do not share database passwords carelessly.
Data Backup: Always back up your database regularly. Save copies on an external hard drive or in the cloud using services like Google Drive or Microsoft OneDrive.
Responsible Use: Do not use a database to collect, store, or share information that could be used to harm or discriminate against others. This includes storing false records or manipulating data to deceive people.
CLASSROOM AND HOME ACTIVITIES
Activity 1 — Build a Class Database Using Microsoft Access (or even a paper-based format if a computer is not available), create a database of your classmates. Fields should include Name, Roll Number, State of Origin, and Favourite Subject. Enter at least ten records and save the table.
Activity 2 — Write Three Queries Using the database you created in Activity 1, write three different queries. For example: (a) Find all students from Kano State. (b) Find all students whose favourite subject is Mathematics. (c) Find all students whose roll number is below 15.
Activity 3 — Generate a Report Using the results of one of your queries, create a report in Microsoft Access. Print it out or save it as a PDF and bring it to class for review.
Activity 4 — Research Exercise Identify two organisations in Nigeria (other than those mentioned in this lesson) that use databases in their daily operations. Write a short paragraph about each organisation explaining what kind of data they store and why it is important.
ASSESSMENT QUESTIONS
Objective Questions:
-
Which of the following best describes a database? a) A type of computer hardware b) An organised collection of related data c) A word processing software d) A social media platform Answer: B
-
What is the purpose of a Primary Key in a database? a) To store passwords b) To uniquely identify each record in a table c) To format the report d) To run a query Answer: B
-
Which software is commonly used to manage databases at the SSS level in Nigeria? a) Microsoft Word b) CorelDraw c) Microsoft Access d) Photoshop Answer: C
-
A query is best described as: a) A printed summary of database records b) A question asked to retrieve specific information from a database c) A type of database table d) A method of entering data into a database Answer: B
-
Which of the following is NOT an advantage of database management? a) Easy data retrieval b) Reduced data duplication c) Guaranteed protection from all cyber attacks d) Ability to share data among multiple users Answer: C
Theory Questions:
-
Define the following terms as they relate to database management: (a) Table (b) Field (c) Record (d) Primary Key. Give one example of each.
-
Explain, with the help of a practical Nigerian example, how database management is used in the banking sector. What kinds of data are stored and why is it important for the data to be accurate?
-
A student created a database for her school's library. List four ethical or safety precautions she should take to ensure the database is used responsibly and kept secure.
SUMMARY
In this lesson, we covered the following key points:
- A database is an organised collection of related data managed by a DBMS such as Microsoft Access
- The basic components of a database include tables, fields, records, and primary keys
- Creating a database in Microsoft Access involves setting up tables, defining fields, and entering records
- Queries are used to search for and filter specific data from a database
- Reports are formatted outputs of database data, suitable for printing or sharing
- Databases are widely used in Nigeria in sectors like banking, healthcare, education, and national identity management
- Ethical and safety practices — such as password protection, data accuracy, and authorised access — are essential in database management
CONCLUSION
Practical database management is one of the most useful computer skills you can develop at this stage of your education. Whether you are organising information for a school project or one day managing records for a large Nigerian organisation, the skills you learn here form the foundation of that journey.
Data is described as the new oil, and Nigeria is sitting on a goldmine of it. Learning how to create, query, and report from databases puts you in a position to be part of the people who manage that resource responsibly and effectively. Keep practising, stay curious, and remember — every expert was once a beginner who simply refused to stop learning.
FREQUENTLY ASKED QUESTIONS (FAQ)
Q1: What is the difference between a database and a spreadsheet? A spreadsheet like Microsoft Excel is great for calculations and small amounts of data. A database, on the other hand, is designed to store, manage, and retrieve large volumes of related data efficiently. Databases also support multiple users at the same time and allow for complex queries that spreadsheets cannot easily handle.
Q2: Can I use Microsoft Excel as a database? Yes, for very small and simple data sets, Excel can function like a basic database. However, for larger or more complex data — especially if multiple people need to access it — a dedicated DBMS like Microsoft Access or MySQL is a much better choice.
Q3: What is a query and why is it important? A query is a request made to a database to find specific information. It is important because it saves time. Instead of manually scanning through thousands of records, a query returns exactly what you need in seconds.
Q4: Is database management only useful for ICT students? Not at all. Database management is relevant across almost every career field. Doctors use databases to track patient records, accountants use them to manage financial data, and teachers can use them to record student performance. Understanding databases is a life skill.
Q5: What happens if I do not back up my database? If your computer crashes, is stolen, or is affected by a virus and you have no backup, all your data could be lost permanently. Regular backups — saved on an external drive, USB stick, or cloud service like Google Drive — protect you from this kind of loss.
Q6: Is it ethical to collect personal data about people without telling them? No, it is not. Collecting someone's personal data without their knowledge or consent is considered a violation of their privacy. In many countries, including Nigeria under the Nigeria Data Protection Regulation (NDPR), organisations are required by law to inform people about what data is being collected and how it will be used.
.jpg)
0 Comments