I am going to create a database for a local computer club that I attend.

3. The data I need to collect

For my database I will need the following information:

First and last names of members

Address including postcode

Home and mobile numbers

Emergency contact and their number

Their class details

Their doctor’s name

4. The tables I will create

I will create three tables: a member’s details table, a doctor’s details table and a Class details table. The member’s table will contains all personal information about the member. The Doctors table contains all the details about the member’s doctors and the class table contains what classes are and who teaches them as well as the time of the lesson.

1. Member’s details

2. Doctors details

3. Class detail’s

5. The relationships I will use

I will connect all three of my tables together, I will do this by creating a relationship between them. I will link the doctor’s name field from the doctor’s table to the doctor’s name field in the member’s table. Then I will connect the class field from the class table to the class field in the member’s table.

6. How I created my database

This section shows how I created my database.

6.1 Creating the tables

After loading up access you will get this screen.

6.2 Setting up the table structure

To get the below screen you will need to click on this button

6.3 Creating the primary key