Asking Questions: Simple Queries
Uncover the power of queries to search for and retrieve specific information from your database by setting clear criteria.
About This Topic
Uncover the power of queries to search for and retrieve specific information from your database by setting clear criteria.
Key Questions
- Explain what a query is and how it helps you find specific information in a large database.
- Analyse a request for information, such as 'Find all members who live in Dublin', and outline the criteria needed for the query.
- Compare the information you get from viewing a whole table versus the specific information you get from running a query.
Active Learning Ideas
See all activities→Activities & Teaching Strategies
See all activities
More in Databases
What is a Database?
Learn what a database is, why it's a powerful tool for organising information, and explore examples of databases you use every day.
8 methodologies
Building Blocks: Fields, Records, and Tables
Discover the core components of a database: tables, records, and fields. Learn how to define the structure for storing specific types of information.
8 methodologies
Entering and Managing Data
Practise adding, editing, and deleting information in a database. Explore how to use forms for easier data entry and the importance of keeping data accurate.
8 methodologies
Presenting Your Findings: Creating Reports
Learn to design and generate professional-looking reports to present and summarise the information from your database tables and queries.
8 methodologies