Database Queries

The ticks indicate the suitability of resources for each Key Stage.

Resource

KS3

KS4

KS5

Click Here

Video Tutorials
tick
tick
tick
Introduction to queries

This workbook assumes that student know how to set up a simple one table database in Access.

They are then taken step by step through creating different types of query.

Students can work at their own pace by following the instructions given in the workbook.

 
tick
tick
Queries Task 2

This task provides students with a pre-prepared database.

They are asked to write specific queries using the database.

Assumes some knowledge of Access and writing queries.

 
tick
tick

 

 

Queries Task 3

This task provides students with a pre-prepared database.

They are asked to write specific queries using the database.

Assumes some knowledge of Access and writing queries.

 
tick
tick

 

 

 

 

 

 

 

 

 

 

Copyright © www.teach-ict.com