Hi All,
I'm a hobby genealogist with a lot of records on various Excel files. I want to pull these together into one Access file which I can then Query and add to. Basically I want help with designing the database so it does what I want it to do.
I have four types of records (which I assume will be my four Tables):
1. Directory. E.g. John Smith lived in England in 1890.
2. Births. E.g. Eliza Smith born to John Smith in England in 1885.
3. Marriages. E.g. John Smith married Sarah Jameson in England 1884.
4. Deaths. E.g. John Smith died in England in 1900.
None of these tables will be connected to each other, but they will have common fields (e.g. names, place names, dates). I want to be able to have a Query where I can search, for example, for "John Smith" which will return all of the above results. Alternatively I may want to search for anyone with the surname Jameson who lived in England - this would return only the 3rd record above. This is complicated by the fact that some records may have as many as 6 different people in them (e.g. a marriage with the fathers' names, and two witnesses).
Firstly - does this sound possible?
Secondly - how do I go about doing it?
Thirdly - I intend to build this database by essentially copy-and-pasting data from my excel files. Does that sound nuts or should it be fairly straightforward?
Thanks,
Povo