Module 5: Databases

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)

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 - Queries Practice - cars

This task gives students the opportunity to have a really good practice at setting up and running queries

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