Resource

KS3

KS4

KS5

Click Here

Setting up a basic Access Database (walkthrough 1)

Skills covered:

• Creating a new database
• Setting up fields
• Changing the field size
• Selecting appropriate data types
• Setting up formatting e.g. date
• Primary key
• Required field
• Validation rule
• Lookup table
• Creating a form
• Entering records

Task

Database walkthrough 2

A different database walkthrough.

Again it will take students through setting up a simple one table database step-by-step.

Database terms explained as they are used e..g primary key

Task