Hello,I've been searching for a while on the internet and these forums, but I can't quite wrap my head around how to achieve what I want to.Currently I have a number of spreadsheets tracking data for a secondary school. There are 5 year groups. Within each year group are two or more ability groups. Each ability group does a number of assessments through the year. Each assessment's data is inputted question by question under a new worksheet (Test 1, Test 2, etc). I have attached a sample attachment to illustrate this setup a little better.These spreadsheets have a lot of duplicate data, and I feel a move to Access would make the data management more straightforward. My issue is I can't quite understand how to set the database up.My initial thoughts were as so:One teacher can have many classesOne class can have many studentsOne student can have many testsOne test can have many students (that attempt it)One test can have many questionsOne question can have many answers (from different students)I'm at a loss as to how to set this up effectively to encompass all year groups' data. If anyone could please help me work out how to do this, I'd be extremely grateful.Thank you.