Thank you very much, SOS. That fixed it. I'm a newbie in Access so it's quite likely that I make fundamental mistakes in my database. Can you tell me why it's probably not a normalized database?
I've attached my database (with student names removed).