Tag: Databses

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

YOU MAY WANT TO USE VIDEO TUTORIALS

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

 

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

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.