Querying Databases

Overview

In this 60-minute lesson, Year 10 GCSE students will develop practical skills and theoretical understanding in querying databases using Microsoft Access. Building on prior knowledge of database fundamentals, they will learn to extract data through simple queries using operators such as <, >, =, and logical connectors like AND, OR, BETWEEN. This aligns with the National Curriculum goals for KS4 Computing and Design and Technology, focusing on developing computational thinking and data handling.

---

National Curriculum Links

• Computing: Key Stage 4

  • Understand and apply the fundamental principles and concepts of computer science, including abstraction, logic, algorithms, and data representation.
  • Use and interpret Boolean logic such as AND, OR, and NOT to solve problems.
  • Understand how data can be collected, stored, and used to support decision-making.

• Design and Technology: Key Stage 4

  • Develop the capability to use ICT, including databases and spreadsheets, to support design and technological activities.
  • Analyse problems and design current solutions using digital technologies.

---

Learning Objectives

By the end of the lesson, students will be able to:

1. Define what a query is and explain its importance in database management.
2. Construct simple select queries in Microsoft Access to retrieve specified data.
3. Use comparison operators (<, >, =, BETWEEN) to filter records effectively.
4. Apply logical operators (AND, OR) in query design to refine data extraction.
5. Interpret and explain the results of queries generated.

---

Resources

• Computers with Microsoft Access installed (1 per student ideally)
• Sample database file (e.g., "SchoolLibrary.accdb") preloaded with student-related tables
• Projector and whiteboard
• Printed query construction worksheet with step-by-step instructions and challenge tasks
• Assessment rubric for queries (teacher use)

---

Lesson Timeline

Time	Activity	Details & Differentiation
0–5 mins	Introduction & Recap	Briefly review previous lesson content on database tables and relationships. Recall record, field, and table concepts. Use questioning to activate prior knowledge.
5–15 mins	Explain Query Concepts	Tutor-led explanation of:

• What is a query?
• Types of queries (focus on select queries).
• Operators in queries (<, >, =, BETWEEN).
• Logical operators (AND, OR).
  Use real-world examples (e.g., filtering library books by publication date and genre). Display syntax examples in Access query design grid and SQL view. | | 15–35 mins | Guided Practical Task | Students open "SchoolLibrary.accdb" and perform step-by-step tasks on worksheet:
• Create select query filtering books published after 2010.
• Modify query using BETWEEN for a date range.
• Combine filters using AND to find books by a certain author and genre.
• Create separate query using OR to include two or more genres.
  Teacher circulates providing one-to-one support, scaffolding for lower ability learners by using query design grid, and extension prompts for higher-attaining students to write SQL code directly. | | 35–50 mins | Independent Challenge | Students given real-life scenario: "A librarian wants to list books either published before 2000 or by a particular author."
• Students design an appropriate query using logical operators.
• Ask students to screenshot or export their query result for evaluation.
• Pair-share to discuss variations in query design and optimisation. | | 50–58 mins | Assessment & Feedback | Quick formative assessment:
• Short quiz (5 questions) on operators and query logic (multiple choice and true/false).
• Teacher provides immediate feedback, addresses misconceptions. | | 58–60 mins | Plenary & Homework Setting | Recap key learning points verbally.
  Set homework: Research another operator or query type (e.g., calculated fields, parameter queries) and prepare to share in next lesson. |

---

Assessment Criteria

• Correct construction of queries using at least two comparison operators.
• Effective use of at least one logical operator (AND or OR) in a query.
• Ability to explain the logic behind queries and interpret results.
• Engagement in practical tasks and accuracy of outputs.

---

Teaching Tips: Wow Moments & Engagement

• Visualise logic with traffic lights: Use red, amber, and green cards to represent logical operators AND (red), OR (amber), and NOT (green). Students physically arrange cards to represent query logic statements.
• Real-world context: Connect queries to students’ interests (e.g., filtering music playlists, video game scores) to contextualise why queries are valuable.
• Use SQL view toggle: Show students both design grid and SQL syntax side by side to demystify query code and build confidence for exam topics that require understanding of query language commands.
• Peer teaching: Encourage students who grasp concepts early to support peers, facilitating collaborative learning.

---

Differentiation

• SEN/Lower ability: Use pre-made templates for queries and step-by-step checklists. Provide extra time and smaller tables.
• Higher ability: Challenge to use nested queries or parameter queries as extension activities. Explore impact of query optimisation.

---

Homework / Extension

Prepare a one-slide presentation or poster explaining a more complex query concept explored independently (e.g., parameter queries, aggregate functions). Include an example query with explanation.

---

This lesson plan ensures students not only develop hands-on ICT skills consistent with the National Curriculum, but also engage with logical thinking and computational concepts critical for GCSE assessment success in Technology and Computing subjects.