Year 8 – Creating a Database

Lesson Aim

  • Identify suitable data types and field lengths for Fields
  • Understand the need for a primary key
  • Create a Database in MS Access

Main Task

Create a database table for recording details of world athletics records.

Then add the details you collected in to the database

Use the sheet below to help you create you database

How to create a database