Sorting, filtering & queries in Microsoft Access – with Pokémon

In this lesson, students will learn how to interrogate a large data set using sorting, filtering and queries in Microsoft Access.

This lesson was developed for use with year 9 ICT students (age 13-14).

Students will learn:
• how to use ascending and descending sorts to find data in a large data set
• how to use filters to narrow down search results
• how to construct simple and complex queries in a database

Resources included:
• Lesson presentation
• Data set (Microsoft Access database of 721 Pokemon)
• Video tutorial demonstrating how to create a query
• Quizlet stack of vocab
• Teacher version of lesson presentation (complete with answers)
• Teacher version of Access database (complete with queries)