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

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.