Need help creating a database for school project

[SJSUSTUDENT]

Hi, guys! I'm new to this forum, and I am looking for help. To get straight to the point. For class, I have been assigned a project from a company to fix their current database system. At the moment the company is using Microsoft Excel to store data for a program that they run.

This program initially starts with a Google Form for initial interest to the program. The data is then extracted and put onto an Excel file where a worker can contact them about how serious they are interested in the program. After the Google Form, there is a paper form that they must fill out, and data is also stored within another Excel file. And after that, there is ANOTHER form with an assessment test where that data is filled out. After they are accepted into the program, their status code is then changed, and placement within the program is tracked. I am finding a rather hard time deciding on how the outline of an Access database would look. My team and I want to make it a relational database.

Some entities within the data are Contact Info, Survey short answers, and more data bout their demographics.

How would you suggest I go about this?



I am currently thinking of using one table to store contact information and then 3 more tables to represent the three forums.

[ranman256]

You'd need tPersons table of course,
tPersons
----------
PersonID (autoNum)
FirstN
LastN
addr
etc.

TPrograms
------------
ProgID
ProgramName
etc

A table to hold a person's programs the are in:

tPersonProgs
----------
PersonID
ProgID
ProgDate
etc

A table to hold their tests
tTests
---------
PersonID
TestName
TestDate
Score