Access 2003: Database queries

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

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.

 

 
tick
tick

download filedownload file

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.

 

 
tick
tick

download filedownload file

Task

download file

Answers

click here

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.

 

 
tick
tick

download filedownload file

Task

click here

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.

 

 
tick
tick

download filedownload file

Task

click here

queries3.mdb

 

         

 

 

 

 

 

 

 

Copyright © www.teach-ict.com