Complex Database (1 Viewer)

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.

Start by Googling Access Table Normalization.

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

Dale

Start by making 3mo - 17 year tables all ONE. Add a column to identify the time period. The way you have it organized, is going to cause a huge duplication of effort. When you get down to a single table, your queries with take a parameter to select just data for year 1 or year 17 or some group of years, whatever.

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 ...