Complex Database

[rushilc]

I only have a little experience with Access and am developing a new database for a summer project for a hospital There are 5000 patients in the database. They all get a questionnaire every year. So I made one table with some key pieces of information about the patients, and then I made separate tables for each year they receive their questionnaire. The years only have subject id as the information connecting the the main table. I attached a screenshot of the relationships window.

 

[rzw0wr]

Start by Googling Access Table Normalization.

I see a lot of problems with your tables the way they are.

Dale

 

[rbh1090]

Merging all these tables into one will make things easier when querying but it will also make your queries slower because all the data is in one place. Some times is better not to normalize ...