Access 2007: Database queries

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

Resource

KS3

KS4

KS5

Click Here

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