I have a question regarding a database that I am trying to build for my PhD-research in the field of history. It is the aim of my research to follow people throughout a number of years. Throughout each of those years important variables (e.g. death of a parent, apprenticeship, address, ..) may and will change. But how can I include these chronological changes in my database? Do I 1) add multiple records per person for each year and change the variables per year or 2) use a specific element of Access that allows me to do this?
Help is much appreciated as my pile of books on Access can’t seem to provide an answer!