Worksheet 1

These questions can be used with the mini-website from the student zone.

This worksheet asks questions about databases and database terminology

Worksheet 2

A paper based exercise which could be given to students to check their understanding of databases or as a piece of homework.

Students are presented with a small table of data about animals in a zoo. They are asked to use the data in the table to answer some questions.

Worksheet 3

A paper based exercise which could be given to students to check their understanding of databases or as a piece of homework.

Students are asked to identify the fields that would be needed in a school database about pupils. They are then asked to design the layout of an appropriate data capture form to collect this data.

Worksheet 4

A paper based exercise which could be given to students to check their understanding of databases or as a piece of homework.

Students are presented with a small table of data where the data has been coded. Students are asked to consider the usefulness of codes and to answer a set of questions based on the data.

Worksheet 5

What am I?

Students are given descriptions related to this topic and asked to identify what is being referred to.

Worksheet 6

This worksheet asks students to research recent stories about databases which have been reported on in the news.

Students are asked to read at least three current news stories, answer a set of questions and then report their findings back to the class.

Useful to ensure that students get an idea of the use of the Internet in a real life context

Database exercise

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.

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.

Access Walkthrough - 3-4 lessons

This is a walkthrough that will take students right from the basics of creating a database

• creating fields
• choosing datatypes
• choosing field sizes
• creating drop down boxes
• using validation
• writing queries
• writing reports
• creating mail merged letters.

The theme is based on a fashion show. It could be adapted for another topic to suit your own class requirements.

This would take most students approximately three to four lessons to work through.

This is a large file - 2.8 kb.