Windows 10 
Access 2002
Creating genealogy db in Access
Warning: newbie question! Probably lots of "For Morgoth's sake, how could one does not know this?" things.
I need advice [2 questions] on one matter that is complicated to me.
Situation: I am making a research on my Catholic parish. Nothing too hard, 18th century peasants and rarely - nobles.
Situation 2: So far I am entering data in Excel. Data is entered like:
[year] [month_day] [sex] [social position] [given name] [baptized according to what?] [Illegitimate?]
So, typical entry:
1755 12_01 male peasant Andrew G I -->Male peasant, named Andrew, was bor 1st December 1755, baptized according to godfather, is illegitimate child.
Problem: making field "baptized accoridng to what?" bit more automatized.
My imagination: crreate a script/something in Access that would:
1. Check field "Given name"
2. Check field 'sex"
3. Compare "Given name"+"sex" withL:
a) parent's name (male to male, female to female); if positive, mark "Baptized..." field with P [for "Parent"], if no - go to b
b) godfathers' name (male to male, female to female); if positive, mark "Baptized..." field with G (for "Godfather"), if no - go to c
c) a list, created by me, with feasts of all Catholic saints of 18th century. In such case:
c1) compare birth date. If there is any feast, go to c2, else mark "Baptized,..." field with "X"
c2) compare "Given name" to name, with appropriate date. Example: if at December 1 there are ANY feasts of saints, script looks if there is "Andrew". If yes, mark "BAptized..." field with "S" (for "Saint")
c3) if not, mark "Baptized..." field with X
So, in my perfect situation, I create 4 additional fields (name of father, name of mother, name of godfather, name of godmother) and 1 addtiional list.
Then, in perfect situation, scripts looks if our Andrew's father was Andrew; if not, scripts looks if Andrew's godfather was Andrew; if not, looks if at December 1 is a feast of Saint Andrew. if all fails, then "Baptized..." is marked by X.
My guess is - Excel is not suitable, so Access is preferrred. I have Access (2 different versions) in my work and at home. I also have absolute zero experience with Access.
This was the first question.
Second one is much more prosaic and noobish: if this is possible - where to look for freelancer to make it? Sorry, Google offers too many freelance sites.
Reply With Quote
