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)

Walkthrough for creating forms

(subscription only)