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.