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.

(subscription only)

Queries 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.

(subscription only)

Queries 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.

(subscription only)

Cars database and queries (2007)

Here is an Access database based on cars. It contains 70 records.

There is an accompanying question sheet which will enable you to check whether students understand datatypes, validation rules and how to write a query in order to extract information from a database.

(subscription only)

Oregon Murder database

This database and full set of accompanying worksheets has been adapted from the original oregon murder database by Andy Longstaff.

Many thanks to Andy for letting us publish his work here.

This is a large file - approximately 3.5mb.