Resource

KS3

KS4

KS5

Click Here

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.

Task

Queries task 1 - cars

This task assumes that students are familiar with using an Access database.

They are given a prepared database and asked to find out the answers to a series of questions.

Task

Answers

cars.mdb

Queries task 2

This task assumes that students are familiar with using an Access database.

They are given a prepared database and asked to find out the answers to a series of questions.

Task

queries2.mdb

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.

Task

queries3.mdb