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.
Hi, thank you very much for the tutorial! I would to ask you if, in a similar way to this, can a company organization chart be built. With each employee inside his office and clicking on the employee to go to his personal profile or clicking on the office to see the employees inside? However, also keeping in mind that each office also has its own hierarchy.. Thank you very much in advance
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
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.
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?
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
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.
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 RU-vid comments once a week or so. If you need help post in my Forums since you're a member. 599cd.com/Forums
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.
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 ;)
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. :)
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.