The Genealogy & Family History Social Network
Getting started--any tips?
I am just getting ready to set up a database for research purposes. It has the potential of becoming very large. I have Access and Excel. Should I be using a different program? Any ideas for those with more experience in this field? Thanks in advance!
Views: 54
Replies to This Discussion
-
Permalink Reply by Iain Kennedy on
-
Access is more powerful but it depends how far into it technically you want to go. Also it doesn't have to be an either/or decision, you can for example store your data in spreadsheets and link to them from Access to run queries against them. Both (in their latest versions) can handle as much genealogical data as you are are likely to generate - I have run a 1Gb Access database at work!
Excel has nice features like comment fields for cells, colouring etc but you should think carefully before using these too much - always ask yourself what will happen if you export this data to something else.
There are converters on the internet for converting to and from GEDCOM, I have used ged2csv and use the basic table structure that generated - individual, family, relation, fact and note - as the core layout for my database, with some extra stuff I added. -
© 2024 Created by IIGSExecDirector.
Powered by
