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.

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