Module 5: Databases

Video Tutorials

Use these video tutorials to aid independent learning and find out how to do something for yourself

Exercise 1 - Creating a database

This exercise shows students how to set up a table from scratch. They learn how to:

Choose the correct data types
Choose the correct format for date and currency
Alter field sizes
Index a field
Set up a required field
Set up a range of validation rules
Enter data into a table

online lesson

Exercise 2 - Creating forms

This exercise shows students how to create a data entry form from scratch and how to customise the design to make it attractive to use.

Online lesson

Fairy.jpg

Pirate.jpg

Exercise 3 - Access Practice - DVD rentals

This exercise shows students how to

Change the default text field sizes
create relationships between tables
set up referential integrity
set up a query
use the database to answer 20 different questions

Remember to print out a set of questions for each student

Exercise 4 - Access Practice - Concerts

This exercise provides students with an opportunity to

delete an existing relationship
set up a correct relationship
enforce referential integrity
update cascading records
add a missing field to a form
create a query
add and remove fields in a query
show and hide fields in a query
create a report, grouping data by category
include numeric calculations in a report

Exercise 5 - Access Practice - Skiing

This exercise provides students with an opportunity to

set up a range of validations
customise a form
sort tables
use filters
create queries
customise a report

Exercise 6 - Access -Final Task

A really comprehensive task which can be used as a final exercise to check students' knowledge and understanding prior to being ready to take their test.

Many thanks to Richard Stanyer from Kelly College