Functional Skills – Database II

You will learn to:

  • Sort a database in Access
  • Search a database in Access (create queries)

Download the database below and save it to your user area:

Newsome Fitness


Create queries to carry out the following tasks

  1. Sort your database in Surname order
  2. Sort your database by Gender and then Firstname
  3. Find all members with surname Mcdonald
  4. Find all members who are under 21
  5. Find all members between 25 and 35
  6. Find all members who live on Claycliffe Hill Avenue or Street

Now create a report for your Queries


Functional skills – Intro to Databases

Lesson Aim:

Define Field, Record and File

Design a database structure in MS Access and add records to your database

Click on the link below to view presentation on databases


Now create a database structure to hold information about members of Newsome fitness Centre.

Use the design details below to design the table.

Database design details

Now add 10 records to your database.

Please ensure they are not for real people.