Having never used Access before it took me 3 months to build my Genealogy Database, I've learned a lot on the way, both about Access and Genealogy. I started by trying every commercial family tree program I could and then took out the features I liked out of each one. It boils down to 6 basic Tables. Addresses - Repositories - Sources - Documents - People - Families. Although I do have many more than 6 tables to enforce integrity within the data. so the primary data is only ever stored once and cannot be duplicated. I'm currently holding 10,000 documents and 6,000 people in it. I wish you had started this tutorial a couple of years ago :) I'll be watching with great interest to see if you have any little add on's I can add to my own Db
Genealogy was never one of my interests until a few years ago. I guess the older you get the more interested you are in history - including your own. :)
@Andy Bawn Sir Can You Please Share Your Genealogy Database Logical Structure. I'm Trying To Design Genealogies of 1000 Families More or Less. And Going To Take It Upto Great-Great-Great-GrandFather. Adding Their Current Addresses, Contacts, Jobs, Skills, Temporary Addresses, Temporary/2nd Contacts. You Can See It'll Be Containing More Than 100k People.
Thank you for your work and contribution to all who were in search of assistance. I've been working with Access and knew it would be better than excel for a family tree. Blessings to you and your family. In a future video you may want to show how it can be linked to a calendar, helping families who have begun this kind of project take advantage of the data that was collected, and stay on top of important dates, anniversaries, etc.
Excellent video. I'm curious why you used combo boxes for the parents on the base form. I could understand a lookup as a navigation tool for the firstname and lastname fields, but why for the parents? How would selecting another parent affect the base form display? Thank you for the best Access video I ever saw.
You're selecting a value from a list. Perfect use for a combo box. 599cd.com/Combo. Thanks for the compliments. The full seminar is MUCH better: 599cd.com/Genealogy
Access may not be the best app for this since once the connections and known members are accounted they hardly changed except for new child births. Anyway it is easily implementable for biological links but may not be that straightforward for extended and legal relationships since now we have to account for marriages, foster parents, 2nd 3rd marriages, separations, adoptions and possibly multi-partnerships. It could be done surely but I'm expecting it to be so tricky.
Just a note to get out of the binary vs multi-gender situation, refer to the WHO definition of sex and gender. Sex is biological chromosomal, hormonal, male or female, as recorded at birth. Gender is the social construct that can vary from society to society and change over time. Therefore I choose to refer to a person's sex rather than gender and sidestep the whole interpretation issue ;)
Can you add the same document to several person files? examples are marriage licenses, birth certificates, death certificates where surviving spouse may be listed, land titles etc
The way this database is set up, no. You could make it a many-to-many relationship, however, so you could relate multiple documents to multiple people. 599cd.com/M2M
Dear Mr. Rost, I made Genealogy form as you made, but I have added to it search field. so search form in it subform of the person, and in that subform another subform of the sons. it is work great. but when I close it, appear to me pop up window told me to "enter parameter value". how can delete this window. best regards
So I am trying to make a “family tree” database for an organization I an in. We have a big/little system and thus have long “family lines”. I think I know how to alter the forms to fit my need (I don’t need Father and Mother, just 1 Big. And replace Child with littles). Is there a way pull the names of everyone in a direct line? So if I select a person, can I make it show there Big, Grand Big, Great Grand Big ect… until there is no more data?
I am having an issue when i drag the Child form to the person form, the child form doesn't return any results. The child form does work when opened manually and returns the currect results. I have checked the properties and it is pointed to the child Query. I am using Office accee 365.
Glad I could help. LOL. As you can see, I only check CZcams comments once a week or so. If you need help post in my Forums since you're a member. 599cd.com/Forums
Great job. I like this video very useful. I have a question: so, how to take a child out from its position as a child on the day it grows up and has its own family? How to put this child on its position of Father or Mother? Is it possible to move position from each individual up or down? Is it possible to create a check box and move person from position to position? Thx.
The beauty in this self join design is that "parental position" is independent of the relationship, it can traverse the full range between. Child through great great grandparent and more.
Yes, that's certainly possible. If you're more interested in tracking the marital history of families, that's perfectly fine. I was more interested in tracking the family biologically, but I realize that's not always possible (adoptions, etc.). But that's the beauty of Access, you can build your database however you like. I'm just here to show you how all the pieces work. You can put the Legos together as you see fit. :)
Very good tutorial and lesson. I am having some issues with the script you are writing at 27:53. When I type in what you say to type, I do not get all of the characters that appear as you are typing in your video. And, my eye sight is not good enough to read what is in the video. Is Access automatically typing the other characters? If so, what are they? I typed in what you said which is =Forms PersonF PersonID. What I get looks nothing like what you have. When I try to put in what I think you have =[Forms]:[PersonF]:[PersonID] I get an error of The Expression you entered contains invlalid syntax. You may have entered an operand without an operator. Yes, I do have the PersonF Form open while doing this. If anyone can help, I would be grateful. Thank you in advance.
I'm sorry Richard but this isn't going to work, you have to have 3 options for gender, Male, Female and Unknown. what happens if you get "J. Smith" is that male or female? you cant assume anything as it could take you down the wrong branch of the tree which could take years of research before you find out (if you ever do!). since learning Access while building my tree Db I've built a Db for a friends business, which tracks his warehouse stock, all his accounts, his international ordering and links to his web site. compared to the tree Db it was a piece of cake!
@@599CD yep, I found that out later on :) love your videos !!! you've inspired me to rewrite my own tree DB, there are SO many more things I can added to it now. my scripting isn't anywhere near as good as yours, but it gets the job done LOL
The reality is that there are people who want to be identified by a different gender than they were born with, and that's OK. The reality is also that, scientifically, it is possible to have BOTH or NEITHER sex organs and/or genetic markers. It's a very real possibility. So I leave it up to the individual database designer to make that call, and show them how to build a database to handle all situations. This isn't a political statement. It's science.
Having never used Access before it took me 3 months to build my Genealogy Database, I've learned a lot on the way, both about Access and Genealogy. I started by trying every commercial family tree program I could and then took out the features I liked out of each one. It boils down to 6 basic Tables. Addresses - Repositories - Sources - Documents - People - Families. Although I do have many more than 6 tables to enforce integrity within the data. so the primary data is only ever stored once and cannot be duplicated. I'm currently holding 10,000 documents and 6,000 people in it. I wish you had started this tutorial a couple of years ago :) I'll be watching with great interest to see if you have any little add on's I can add to my own Db
Genealogy was never one of my interests until a few years ago. I guess the older you get the more interested you are in history - including your own. :)
@Andy Bawn
Sir Can You Please Share Your Genealogy Database Logical Structure.
I'm Trying To Design Genealogies of 1000 Families More or Less.
And Going To Take It Upto Great-Great-Great-GrandFather. Adding Their Current Addresses, Contacts, Jobs, Skills, Temporary Addresses, Temporary/2nd Contacts.
You Can See It'll Be Containing More Than 100k People.
Thank you for your work and contribution to all who were in search of assistance. I've been working with Access and knew it would be better than excel for a family tree. Blessings to you and your family. In a future video you may want to show how it can be linked to a calendar, helping families who have begun this kind of project take advantage of the data that was collected, and stay on top of important dates, anniversaries, etc.
Or just build your own calendar in Access: 599cd.com/Calendar
Excellent video. Thank you. Keep up the good work.
Thanks, will do!
So glad I found this!
Sweet! :)
Great tutorial! Much appreciated!
Glad you liked it
@@599CDI managed to follow your work but I wished to actually see the tree.
in the first part I learned alot and developed as debase successfully but how to print out TREE ?
Thanks for doing this. I have been trying something similar with MRCAs in genealogy but kinda wish I had done this from the start
Welcome
i want to laearn full 8 hours seminal on genealogy but where ti find
tried to find members cut but can’t find on your site😢
Excellent video. I'm curious why you used combo boxes for the parents on the base form. I could understand a lookup as a navigation tool for the firstname and lastname fields, but why for the parents? How would selecting another parent affect the base form display? Thank you for the best Access video I ever saw.
You're selecting a value from a list. Perfect use for a combo box. 599cd.com/Combo. Thanks for the compliments. The full seminar is MUCH better: 599cd.com/Genealogy
Access may not be the best app for this since once the connections and known members are accounted they hardly changed except for new child births. Anyway it is easily implementable for biological links but may not be that straightforward for extended and legal relationships since now we have to account for marriages, foster parents, 2nd 3rd marriages, separations, adoptions and possibly multi-partnerships. It could be done surely but I'm expecting it to be so tricky.
It may not be the best app... but it works well.
Just a note to get out of the binary vs multi-gender situation, refer to the WHO definition of sex and gender. Sex is biological chromosomal, hormonal, male or female, as recorded at birth. Gender is the social construct that can vary from society to society and change over time. Therefore I choose to refer to a person's sex rather than gender and sidestep the whole interpretation issue ;)
Well put.
Can you add the same document to several person files? examples are marriage licenses, birth certificates, death certificates where surviving spouse may be listed, land titles etc
The way this database is set up, no. You could make it a many-to-many relationship, however, so you could relate multiple documents to multiple people. 599cd.com/M2M
Dear Mr. Rost,
I made Genealogy form as you made, but I have added to it search field. so search form in it subform of the person, and in that subform another subform of the sons. it is work great. but when I close it, appear to me pop up window told me to "enter parameter value". how can delete this window.
best regards
599cd.com/EPV
So I am trying to make a “family tree” database for an organization I an in. We have a big/little system and thus have long “family lines”. I think I know how to alter the forms to fit my need (I don’t need Father and Mother, just 1 Big. And replace Child with littles). Is there a way pull the names of everyone in a direct line? So if I select a person, can I make it show there Big, Grand Big, Great Grand Big ect… until there is no more data?
Maybe add a field to track family lines? LineID?
I am having an issue when i drag the Child form to the person form, the child form doesn't return any results. The child form does work when opened manually and returns the currect results. I have checked the properties and it is pointed to the child Query. I am using Office accee 365.
Please disregard, i figured it out.
Glad I could help. LOL. As you can see, I only check CZcams comments once a week or so. If you need help post in my Forums since you're a member. 599cd.com/Forums
Great job. I like this video very useful. I have a question: so, how to take a child out from its position as a child on the day it grows up and has its own family? How to put this child on its position of Father or Mother? Is it possible to move position from each individual up or down? Is it possible to create a check box and move person from position to position? Thx.
No need to move them. Every person can be either a parent or a child.
The beauty in this self join design is that "parental position" is independent of the relationship, it can traverse the full range between. Child through great great grandparent and more.
The ChildCurrentQuery didnot work for me at all. I tried several times. Did anyone had the same problem?
Not that I'm aware
Would you be willing to share a template that you have developed to use in genealogy research?
Access Genealogy Template: 599cd.com/GenealogyTemplate
How much if the full program? I am very interesting and have most of my date for 6 generations.
You can find pricing on my web site. There are two versions: the template by itself and the full seminar with videos: 599cd.com/genealogy
Would it be better/acceptable to use Parent1/Parent2 in place of MotherID and FatherID? I have the potential of two mother and two father families...
Yes, that's certainly possible. If you're more interested in tracking the marital history of families, that's perfectly fine. I was more interested in tracking the family biologically, but I realize that's not always possible (adoptions, etc.). But that's the beauty of Access, you can build your database however you like. I'm just here to show you how all the pieces work. You can put the Legos together as you see fit. :)
@@599CD How should I do to limit the combo box options for only female mothers and male fathers respectively? Thank you
Add a query criteria to each combo box (Gender = 1, for example). 599cd.com/Criteria
Very good tutorial and lesson. I am having some issues with the script you are writing at 27:53. When I type in what you say to type, I do not get all of the characters that appear as you are typing in your video. And, my eye sight is not good enough to read what is in the video. Is Access automatically typing the other characters? If so, what are they? I typed in what you said which is =Forms PersonF PersonID. What I get looks nothing like what you have. When I try to put in what I think you have =[Forms]:[PersonF]:[PersonID] I get an error of The Expression you entered contains invlalid syntax. You may have entered an operand without an operator. Yes, I do have the PersonF Form open while doing this. If anyone can help, I would be grateful. Thank you in advance.
Not sure if this matters, I am using Office 365 Version of Access. Did they maybe make a change preventing this?
It's an exclamation point: Forms!PersonF!PersonID. See 599cd.com/FormName
How can I buy all your tutorials till now?
You can buy my tutorials at 599cd.com - if you become a member of my CZcams channel, you also get access to all of my Extended Cut TechHelp videos.
I'm sorry Richard but this isn't going to work, you have to have 3 options for gender, Male, Female and Unknown. what happens if you get "J. Smith" is that male or female? you cant assume anything as it could take you down the wrong branch of the tree which could take years of research before you find out (if you ever do!). since learning Access while building my tree Db I've built a Db for a friends business, which tracks his warehouse stock, all his accounts, his international ordering and links to his web site. compared to the tree Db it was a piece of cake!
Andy you are absolutely right. While recording the rest of my Genealogy Seminar, I decided to add this option in Lesson 6: 599cd.com/XK1PV
@@599CD yep, I found that out later on :) love your videos !!! you've inspired me to rewrite my own tree DB, there are SO many more things I can added to it now. my scripting isn't anywhere near as good as yours, but it gets the job done LOL
haha. "I do know there are a bunch of different genders these days and that's fine but...." but it's time to adhere to reality.
The reality is that there are people who want to be identified by a different gender than they were born with, and that's OK. The reality is also that, scientifically, it is possible to have BOTH or NEITHER sex organs and/or genetic markers. It's a very real possibility. So I leave it up to the individual database designer to make that call, and show them how to build a database to handle all situations. This isn't a political statement. It's science.