A ready-to-teach ICT lesson (Grade/KS3 level) using a “stolen FA Cup” crime mystery to teach database query skills in Microsoft Access. Students use a pre-built Suspects database and witness ...

Queries are the database equivalent of filters in a spreadsheet. Just as a filter can limit and reorganize the information displayed in a spreadsheet, so a query limits and reorganizes the information ...