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

(subscription only)

Setting up a basic Access Database (walkthrough 2)

Skills covered:

• Creating a new database
• Creating and using tables
• using data fields, records, data types, field sizes and primary keys

(subscription only)

Plants Database Task

This task assumes that students are familiar with an Access database.

Students are provided with a ready created database and are asked to make various adaptations.

(subscription only)

Validation Task 1

This task assumes that students are familiar with Access and are able to set up a single table database.

They should also have some basic understanding of validation.

A good task to use for consolidating skills.

(subscription only)

Validation task 2

This task assumes basic familiarity with Access.

Students are given a pre-prepared database and asked to set up different types of validation on the fields.

A set of answers is supplied.

(subscription only)

Walkthrough for creating forms

(subscription only)