A while ago I asked this question about using Access 2007 to implement a family tree model. I had all the tables and relationships mapped out in a UML diagram but realised it was getting out of hand (for a "fun" project), so I carried on with what I was doing (storing all my data in Excel).
I've realised now that I still want to find a way to do this in Access 2010, simply to be able to query the data in a number of ways using SQL. The forms will also be a much better way for me to capture the data and represent it visually. Before I start drawing up the UML diagram again (want to start it with a fresh approach), I would like to know if anyone has any advice about the feasibility of doing such a project in Access?
I have been using Family Tree Maker (genealogical software) to store the family data as well, but I do not like some of its features, and there are features I feel it is lacking. I'm also not too concerned about actually having a physical family tree drawn and populated in front of me, but merely a way to store all the data in perfectly normalised tables and relating them correctly so I can query the data in a variety of ways.
edit I should clarify that it is not strictly a family database, but also a "membership" type database as well, where people are divided into various groupings not necessarily dependent on family relations. The
SIM relations are quite simple, but adding in the
CLASS cuts across family lines.