Showing posts with label Genetic Genealogy. Show all posts
Showing posts with label Genetic Genealogy. Show all posts

Thursday, October 4, 2018

Genetic Genealogy Simplified: Intro to AncestryDNA



AncestryDNA is the Goliath of genetic genealogy. They broke 7 million testers in their database at the end of 2017, and will likely only continue to grow as we enter the 2018 holiday season. To give you an idea of how many people that is, it's roughly the population of the entire state of Arizona.

So what does this mean?

It means that more people than ever are taking AncestryDNA tests to learn something about themselves... and more people than ever are going to look at their ethnicity results and think, "That's it? That's what I paid all that money to find out?"




But it doesn't have to be that way!

The AncestryDNA test, like all genetic genealogy tests, does more than cheap scientific parlor tricks in estimating your ethnicity. It can tell you volumes about your genealogy, your personal history, and your connections to all the best highlights of history.

The trick is, it takes work. And time. And research.

All those commercials that told you finding out about yourself was as simple as spitting in a tube? Gimmick. Pure and simple.

 


But don't let that stop you! AncestryDNA has some amazing features, which I talk about in my newest video. There has never been a tool like it to document and discover the story of your family. And because DNA tells the stories that have been lost from memory and written records, it's likely the only way to find the secrets your ancestors took to their graves... or never knew about.

So if you're looking for a guide to AncestryDNA for beginners, look no further. Get ready to dig into all the best tips and tricks right here. And if you want to get even more bang for your buck, subscribe to my YouTube channel for even more tutorials on all things genetic genealogy.

Friday, September 7, 2018

Facebook Groups and Crowdsourcing for DNA

The way some commercials and advertisements talk about genetic genealogy, it's easy to believe all you have to do is spit in a cup and learn the secrets of your family history. Not so! There is A LOT of work that goes into learning anything truly substantial about your family from genetic testing. And along the way, it becomes necessary to ask for help from people who have also put in the work to learn.

One of the places I recommend people to start is with Facebook groups dedicated to genetic genealogy. The people, knowledge, and resources available to you in those spaces is truly without price. Imagine an entire community of people who personally invest themselves in what you want to know about your family, and engage with you to find answers with you. You may be new, but you don't have to be completely lost and alone while trying to make the most of your DNA test.




All you have to do is search for "DNA testing" into the Facebook search box, sort by Groups, and you'll see so many of these groups appear. Why are there so many? What's the difference between them? How do you know which ones to join? And what should you post once you join them?

No Two Groups are Exactly Alike

Each group has different rules about what kinds of posts they accept. Some welcome people to post their GEDmatch kit numbers. Others don't. Some are targeted at new users. Some are targeted at adoptees and the donor conceived. Some allow sharing personal success stories. Others want to focus solely on inquiries and solving specific research problems. Some don't mind if you post relevant or topical stories from the news as it relates to genetic genealogy. Others view those posts to be a distraction from the core purpose they are trying to fulfill. To find the groups that best match your needs and interests, you'll want to familiarize yourself with the conversational culture of the group.

Most admins will try to communicate those rules and the group's purpose in their About section, as well as their group entrance questions, and possibly even a welcome post to all new members. Be sure to familiarize yourself with these before you post in a group. This truly is not something you should skip, and attempt to learn "on the fly" if you truly want people to help you.

Inquiries

When you're writing a message to a cousin match from a testing site, it's very important not to throw too much information at the person all at once. You go into the interaction assuming they may not know anything about genetic genealogy, segment data, or their family tree. You break your research questions into basic, digestible chunks. You try to engage someone in a prolonged conversation, in which you explore many questions over an extended period of time--months, or sometimes even years. At the same time you're trying to solve research problems, you're also trying to build a personal connection with another relative or family member.

Posting in these groups is completely different. You go into these interactions with completely different assumptions and behavior because your audience is different. You're talking to people who DO understand segment data, and who will assume that to you do too (unless you clarify otherwise.) You take into account the volume of inquiries the group has. Your post is one of many that is entering what essentially amounts to an assembly line. The more already-complete pieces you can bring to that line, the more complete your final product will be. And the results you get will vary depending on who is on the line that day.

What the users in these groups need to know to help you is who you're trying to find, what cousin matches you think might be related to your question, the segment data for those matches, and what you've already done to solve your own problem. All these details center around the same one question: "Do your numbers and segment data line up with the relationships you think you share with these people? And if not, why not?" You won't need to include loads of private information or back story. The segment data is its own language for family relationships, and will help people to tell you where to look for the answers you're trying to find.


Questions

Sometimes the questions you need to ask won't always be related to a research problem. Sometimes they'll be conceptual problems, and trying to grasp how DNA works and how to use it. Don't be afraid to ask these questions when you need to. Even if people have taught about something like X DNA a thousand times, and you read all the background material in the world, there's no guarantee that someone would explain it in a way you understand it completely. Sometimes the only way to achieve understanding in your own mind is to ask questions. 

A good example of this for me was when I was seeing my cousin matches line up on my chromosomes in the same places, but the people weren't related to each other in any way I could see. It was a basic question that I knew must have a very simple answer, and I didn't want to ask it for that reason. But I asked it anyway in one of these groups because I knew it was the only way I would learn.

The answer I got from one woman was perfect, and even came with a visual that I still think about to this day. We don't just have one copy of each chromosome. We have two of each: one from our birth mother and one from our birth father. And we can think of these as being overhead projector transparencies sitting on top of each other. The only way to tell them apart is to see who does and doesn't match each other in these positions together, and then determine which matches come from our maternal side, and which from the paternal side.

Had I not asked that question where and when I did, I don't know when or how I would've had the "A-Ha!" moment when everything finally made sense. But it would've been much later on in my journey than if I'd tried to do everything myself.

Thread Etiquette and Tips

Discussions in these groups are organized into "threads." You have two options in how to interact with these threads: to post a new thread, or to respond to someone else's thread. Knowing when to do each one can be really helpful in being the most efficient and respectful group member you can be.

Before you ask any question or make a post, it's helpful to search the back catalog of the group to see if someone else has asked the question before. In Facebook groups, the search box is on the left side of the page. Think about how you might Google the question you're asking, breaking down your question into search terms. Use those in the search box and see what you find. You may find not only the answer to the question you were looking for, but answers to questions you haven't even thought to ask yet!

It may be helpful to tack your question onto a previous thread, if the issue or question you're trying to explore isn't substantially different from what someone else has already posted about. It can save you and others the work of having to get and reframe the same context that went into that discussion. What you should avoid, however, is posting a completely irrelevant response or question on someone else's thread. It distracts people's attention away from the original poster's question, making it less likely they will get the help they asked for. And for posts that may be very old and involve a lot of respondents, it's helpful to consider how many people will have to sit through a slew of notification and responses in a conversation they not longer want to be a part of.

The temptation to post your same question, word for word, into various other groups isn't the best course of action. I recently saw a woman do this, and someone pointed out that he'd seen her same post for the 4th time that day. It's better to err on the side of assuming that most people will be in more than one group. If you're going to post the same question to multiple groups, consider spacing them out a week or more apart, and posting them at different times of day to get the greatest variety of responses.

What makes Facebook groups great for traditional genealogy and connecting with local communities where our ancestors lived also makes them great for DNA analysis. Who you know or can access in person is no longer a limitation with the social media machine on your side. And with just a little bit of prep work, the returns on that time are sometimes exponential.

A Group List

Here are some Facebook groups you could consider joining for your genetic genealogy journey. Note, there are other regional, national, and ethnicity specific DNA analysis groups that are more specialized than these. Try combining different search terms together with DNA to see what you find!

Thursday, August 16, 2018

Uploading Your Raw Data to MyHeritage DNA



If you've tested your DNA with one company and want to connect with others from other companies, we can all meet together on MyHeritage DNA. The upload is free, and includes access to segment data. Why wait? Take advantage of those features today for your DNA analysis!

Thursday, August 3, 2017

Uploading Your Tree to GEDmatch

GEDmatch has become an essential tool to everyone who is serious about genetic genealogy. I'm not sure how many matches you have there. But the last time I saved my match list as a PDF, it was 23 pages long. And the last time I checked, the last page of matches stopped at about 10 cM. As more people take these tests and upload their raw data to GEDmatch, making traceable connections to our distant cousins becomes easier every day.




But are you taking full advantage of everything GEDmatch has to offer you? If you don't have a tree uploaded, the answer is "No!"

Why You Should Have a Tree on GEDmatch


In order to take full advantage of what genetic genealogy has to offer, you need three types of information:

  1. Segment data
  2. A tree
  3. Shared matches
I like to compare this to a car. In order for a car to function, at the bare minimum it needs wheels, an engine, and a fuel source. Without any one of those elements, the car simply couldn't move. In genetic genealogy, these same three elements are THAT fundamental. Some testing companies create this data scarcity by not providing tools to convey this essential information to their users. And given that some of the newest testing companies are gravitating away from this bare minimum, it leaves some newcomers in our community at a disadvantage.

Whenever a testing company has refused to offer one of these necessities to its customers, GEDmatch has been the equalizer. AncestryDNA won't provide segment data? GEDmatch will do that. MyHeritage DNA won't provide segment data or shared matches? GEDmatch will do that. That same capacity for tree sharing is also available. The ability to cross reference people on all of the sites on which they've tested is there. But how many of us are taking advantage of it?

I've used trees on GEDmatch to match users there to their original testing companies. Once I know I have the right person on AncestryDNA, their shared matches become a powerful finding tool. I compare those shared matches to what I know about the segment data. A much clearer image of the relationships at work in my DNA begins to emerge. It makes my job on GEDmatch AND AncestryDNA easier. And when I invite these shared matches to upload to GEDmatch, and they accept that invitation, documenting and preserving this record becomes possible.

How to Upload a Tree to GEDmatch


Now that I've been focused on linking GEDmatch users to their original testing companies, I'm noticing a trend. Many who provide trees at their original testing companies haven't done so on GEDmatch. Some of these users may not realize the capability to add a tree exists, or how to do it. So I've made a video for our YouTube channel to explain the process.




The trees they produce are not fancy, by any stretch of the imagination. But they provide needed information to the discoveries we're all trying to make. If you haven't uploaded a gedcom to your GEDmatch kits, be sure to add one today!

Wednesday, June 14, 2017

Family Tree DNA: My Review

Over the past couple of years, you've gotten ample insight from yours truly on AncestryDNA and GEDmatch. Clearly, this conversation is incomplete without giving Family Tree DNA some long-overdue attention. So today, I'm going to be sharing my thoughts on their Family Finder/autosomal DNA test. Specifically, I'll be sharing my experience with their autosomal transfer service.

As I did in my AncestryDNA review and the follow-up, I'll be breaking down this review into a couple of different categories. I'll grade them individually, and average them together for a final score. Here are the categories:
  • Cousin Matching
  • Admixture
  • Projects
I'm also giving them extra credit right out of the gate for offering the autosomal transfer at all. Their biggest weakness, at this stage of the game, is the size of their database of matches. It's difficult to compete with AncestryDNA's 4,000,000+ tests analyzed, especially with their last million being added between January and April of this year. Having such a common sense incentive for the customer is one of the industry's best bargains. If 23&Me would follow suit, I'd have a full house.


Cousin Matching: C+


There are so many different fronts to approach this from, so let's dive in! Family Tree DNA has an overall great interface. In my opinion, their interface has always been better than AncestryDNA. While the capability of Family Tree DNA's interface isn't as robust as GEDmatch, they have many more analysis tools to offer someone out of the gate than AncestryDNA does. And by using all of the features available on Family Tree DNA, I can see how it would help someone transition much more smoothly over to GEDmatch.




Family Tree DNA's match list is like GEDmatch's One-to-Many match list, on training wheels. It's a sortable table that allows you isolate matches in a variety of ways. You can click the column headers, which allow you to sort X-DNA matches to the top of the list. You can also use the "In Common With" button, to see which matches you share with a given relative. What AncestryDNA customers usually have to find on two different websites, Family Tree DNA has consolidated into one.

Their match list also has an additional field for surnames, which is unique to this site. Those surnames are searchable, as are your cousin matches. This feature is only available with users who fill out their profile, but many of the most active users fit that description. While I do like being able to sort by location on AncestryDNA and feel it is missing here, Family Tree DNA still has a running head start. They could easily add that functionality without a significant disruption to their interface. Which is still more than AncestryDNA can say when it comes to revisiting a cousin match. (Does anyone else realize you can use the Membership Directory to do this? Yeah, no one else does either.)

Family Tree DNA has a chromosome browser, which is also more than AncestryDNA can say. As nice as that is to have, it's actually my least favorite part of working with Family Tree DNA. However, the chromosome browser isn't the problem. It's how inefficiently it operates to do a very simple job.




I greatly dislike that this is the only way to access the full segment data for each match. To do this, I have to systematically input all 2700+ matches into the chromosome browser in batches of 5. And of course, there's literally no way to pull up 5 matches on the same chromosome in the chromosome browser. So they're just 5 random matches from an alphabetical list.

I click on each segment that appears, and copy the data from a pop-up box that has a nasty habit of disappearing if I click anywhere else. This is particularly annoying to do when the segments are small, and there are multiple segments to analyze for the same person. Since I also use Microsoft Access for my data entry, this means I have to move my Access window around my screen based on where the box appears. Many times, I lose the box while trying to situate my windows, and have to start all over again.

First World Rage!
This interface has so much potential, and has so many great features on it. I don't understand why they have it programmed to function only one way, which is the least efficient way possible. They have TWO other options through which they could present the segment data, and THIS is the one they chose. They have the match list and the Excel/CSV download feature they could be using instead.

As an Access user, I can't tell you how valuable it would be to me to export segment data on an Excel spreadsheet. I would be able to do a bulk import of segment data into Access. This would save me hundreds of hours of work, and allow me to spend more time on analysis instead of data entry. And really, what exactly is the purpose of exporting matches into an Excel spreadsheet without the segment data? Like so many things going on with Family Tree DNA, it's a fantastic idea that falls short in the execution.

[NOTE: When I used the Excel/CSV feature in preparation for this post, I used the link available from the Match List page. The matches exported from that page are as I described them: just about useless in every way. It provides the user's name, contact information, relationship estimates, and no full segment data. I didn't know that using the Excel/CSV link from the chromosome browser page would produce a different match list, which DOES include exact segment lengths and locations. The mistake here is mine, and I apologize for the confusion.

However, upon receiving this second match list, I find it equally dissatisfying for the following reasons: it does not include any of the pertinent identifying information from the previous list. It has an entire column dedicated solely to my name, and no contact information or relationship estimates. Having the relevant information I need broken up across two Excel workbooks does not, in fact, allow me to import that information into Access. And given that the segment data match list has matches smaller than 6 cM, I would have to manually remove each of them myself. According to my personal user needs, I'd like to see these two lists combined. And with the knowledge I have of DNA comparison, segments smaller than 5 cM are best removed from that match list.]

I'm also not a fan of Family Tree DNA's matching criteria. They give too much emphasis to smaller segments, with no way to set your own match criteria. With 2700+ matches to process on their website alone, I don't have time to waste with 5 and 6 cM matches. And yes, considering some of my research challenges, those matches are a waste of my time. The closest thing that Family Tree DNA has to custom match criteria is a drop down list of options on the chromosome browser. And since I haven't had anyone else closely related to me tested, most of the options are useless to me.

Family Tree DNA has room for improvement when it comes to cousin matching. But they're in a much better position to address those issues than AncestryDNA is, and I hope they recognize it. They have the potential to be a much more comprehensive service than AncestryDNA probably ever will be. What AncestryDNA has done by being the lowest of all possible fruit, Family Tree DNA can accomplish by superior performance.


Admixture: B-


It's no secret that I'm not the biggest fangirl of admixtures. We've all heard the wacky stories about how ethnicity estimates revealed that babies born a hundred years ago were switched at birth. But really, for most of us, ethnicity estimates don't have that kind of potential unless you're biologically diverse. Nevertheless, I was still curious to get a second opinion on my AncestryDNA ethnicity estimates.


European Ethnicity Estimates from AncestryDNA

myOrigins from Family Tree DNA

You'll note that there are some pretty large discrepancies here, including between ethnic groups that both companies test for. The largest disparity is the 26% Scandinavian from AncestryDNA, versus 0% from Family Tree DNA. With a difference that large, someone here is wrong. I don't have much of sense of who it could be. The more detailed view of the AncestryDNA test seems consistent with what I suspect about the unknown branches of my family. But without more traditional research and confirmation of details to back it up, it's not a question I can resolve myself right now.

I will say that unlike AncestryDNA, Family Tree DNA has a separate, distinct testing region for South America. This was news to me, and has been added since I originally did the autosomal transfer. AncestryDNA treats the Caribbean, North, Central, and South America as one homogeneous region. As someone with Caribbean heritage, with rumors of Native American ancestry I was trying to squash, being able to distinguish the two is useful. Anyone with interests in these regions will receive more detailed results from Family Tree DNA than from AncestryDNA.


Projects: C


AncestryDNA has 4,000,000+ samples in their database. There's no escaping that fact. If Family Tree DNA is going to compete with the statistical probability of making a match, they need to deliver superior service. They can accomplish this by updating features they already have, and maximizing on AncestryDNA's weaknesses.

You can't make money if you don't exist.
#Duh
From what I can see, a significant portion of Family Tree DNA's attention is still focused on Y DNA and mitochondrial DNA testing. And before anyone challenges me about it, I recognize that these tests have their place. But those tests are niche at best, and stubbornly nostalgic at their worst. There is no sense in encouraging the average person, let alone a new customer, to spend hundreds of dollars on one line in their genome anymore. Commitments to niche tests take resources away from developing autosomal testing offerings. And anyone who isn't committing the lion share of their resources to autosomal testing is making a big mistake. They are going to seem crazy when they try to explain their reasoning in ten years, if they're still around to talk about it.

One example of where I see this happening is with their projects. They are most analogous feature they have to AncestryDNA's newest Genetic Communities. With Genetic Communities, AncestryDNA approximates the geographic regions your ancestors belonged to, based on DNA and family trees. Family Tree DNA has had this feature for years, with user-operated location, lineage, and surname projects. But it's still set up specifically from back in the day when Y and mT DNA tests were all the rage.

Why haven't these been upgraded to function with autosomal testing? They're literally sleeping on one of the biggest advantages they have over AncestryDNA. The might as well stand on a street corner and give away free money, for the amount of good it's doing them.





To those who have taken DNA tests, imagine being able to pull up a map to find collaborative discussions about the communities you care about most. Everyone there is specifically talking about DNA. As you scroll in deeper on the map, more specific projects appear, on state, county, or even the city level. Each one would have surname and lineage projects associated with it, with the ability to add more projects. As much as I enjoy Ancestry's Historic Insight tree hints, these don't create or engage people in conversation. Having projects based on historical events and common experiences would spark those conversations for DNA. And unlike Facebook, where a lot of these community-based conversations are happening right now, Family Tree DNA can integrate their features into these projects and conversations.

One of AncestryDNA's critical weaknesses is not fostering effective communication between it's users. They ignore this in favor of automating as much of their user's experience as possible. Family Tree DNA already has, as part of its offerings, the solution to this problem. But those features are only available for the most expensive, niche components of their offerings. (And that's if you don't want to go as far as I will, and say that Y and mT DNA are already dead.)

As a user experience and a business strategy, it simply makes zero sense. You can't be everything to everyone. It's the same trap that restaurants fall into when they have too many choices on their menu. Instead of trying to provide value through eleven different offerings and options, why not focus on the one thing that matters, and doing it the best way you know how?


Final Grade: B-


Out of the box, is Family Tree DNA a better service than AncestryDNA? In terms of the product they offer and the features that come with it, yes. But when you factor in the size the of their respective user bases and the company's ongoing leverage, the story changes. If you're going to compete with a much larger company, and a growing playing field with increasing amounts of competition, you have to focus on innovation. You can't rely solely on carrying obsolete products your competitors don't have, and charging more for them. That is not a strategy for growth. That's a memoir for Radio Shack.


The Eighties called.
They want their DNA test back.

But from where I'm sitting, there's no reason for Family Tree DNA to be in the position they're in. They have everything they need to give AncestryDNA a serious run for their money. They just aren't using any of it to their advantage. And as a customer who is approaching the decision about purchasing secondary kits for family members, I'm finding it difficult to decide who deserves my money more. The company that doesn't listen, or the company that is moving precariously close to the wrong meaning of "throwback"?

Some might say that "only time will tell," but I disagree. It isn't time that will tell. It will be innovation and common sense that determine the future of Family Tree DNA and their Family Finder test. And the silver lining here is that innovation and common sense are 100% within their control.

Friday, May 5, 2017

Roots Magic Websites for Genetic Genealogy

I've been trying to find a way to embed my family tree onto my personal blog for a while now. It just seems like a logical thing to include on a blog about my family history. But I've never found any options I liked that would allow me to do that. You'd think that because I host my main tree on Ancestry.com, linking to my public tree would be sufficient. But since the only ones who can view Ancestry member trees are people with active paid subscriptions, this isn't a perfect solution.

This came to my attention again as I was interacting with one of my cousin matches on AncestryDNA. AncestryDNA was able to match us together, and we have a shared ancestor hint linking our trees together. But because he doesn't have an active subscription, he can't see my tree. And since his tree is private, I'm not able to see his. He even asked me how to change his tree to public because he doesn't actually care about keeping it private.




We're trying to work that out right now. I'm pretty eager to know who he is because he isn't connected to anyone else that I recognize. The entire exchange has gotten me thinking about the continued struggle of being an AncestryDNA customer. How did I make it this far into this exchange, and I'm still no closer to an answer about this connection?

And on that same note, how can I make this process easier and more familiar to that generation of users that will never, ever be comfortable using computers?

I've come across a lot of people who have websites that allow them to post interactive versions of their GEDCOM files online. I decided that could be a good option for addressing this problem. If I could optimize it enough for a genetic genealogy application, I thought it could be a very useful tool. I set out to explore some of the options that exist. Since I have full access to the latest version of Roots Magic and it has free site hosting, I decided to try them out first. And I have to admit, I'm pleasantly surprised by the results.


MY DNA FAMILY TREE


Not only is the site simple to navigate, it's one of the few GEDCOM-to-web options I've ever seen that bothers to include sources. And as I thought about how I could make the most of it as a tool in making contact with DNA matches, there were a couple of other features I decided to include:

  • All of my confirmed biological ancestors from the last 12 generations
  • All of their descendants I can find who share a biological connection with me
  • Social media links
  • Links to my profiles and trees from the DNA testing companies I've tested with
  • My GEDmatch kit number
  • A link to my blog

This site, which took me less than 10 minutes to set up, is an awesome little hub for my genetic genealogy efforts. I can imagine sending it to anyone who might be related to me, and everything they need to compare notes with me is all in one place. Regardless of what testing site they use, I make it easy for them to connect with me, and find the resources they're looking for.

Looking at the sample site on the Roots Magic website, I also see that they've color coded different lines. It's nice to see that feature carried over into the site, because there's an awesome bit of untapped potential for that for genetic genealogy. I can activate color coding when DNA matches for different lines have been confirmed. I can even color code them based on the testing site they come from. I don't know how well the pedigree view on the live site would allow me to do this, or whether the color coding displays on any other view within the website. But I know working with the data within Roots Magic, that potential is there.

What tips and tricks do you have for reaching out to your DNA cousin matches? What tools are making it easier for you to collaborate and discover your common ancestors?

Saturday, April 29, 2017

10 Tips for Making the Most of GEDmatch.com

I'm not really shy when it comes to how much I love GEDmatch.com, the open-source tool for anyone who has taken a DNA test for genetic genealogy. And really, what's not to love? I get matched up with relatives from all of the major testing companies, for free, without having to take or pay for multiple tests. It presents me with all of the segment information for my matches, and gives me the tools to analyze and work with my own results. I can decide for myself what matching criteria I want to use. Without GEDmatch, my experience as a genetic genealogist would be controlled and limited by corporate interests and objectives.




A downside to GEDmatch is that it has a steep learning curve. I've been using the website for several years now, and I'm still discovering new ways to use it all the time. To say nothing of all the ways I could be using it better. So in the spirit of helping us all to make the most of what GEDmatch has to offer, here are some of the tips that are making life a little easier for me.

1. Use Internet Explorer


I know. Let's party like it's 1999, right?
I'm not an expert on the technology behind web browsers, what makes them work, and why it matters which ones you use for which site. All I can tell you is what I've seen on my computer, in the hundreds of times I've used GEDmatch over the past several years. The sum of all that experience has shown that Google Chrome is the browser most likely to time out, crash, or just not load at all. Firefox is hit or miss, depending on the number of users on the site.

The only browser that consistently loads GEDmatch for me, regardless of the time of day or function I'm using, is Internet Explorer.

2. You Can Identify the Testing Company from the Kit Number


Am I the only person who didn't know the letter in the kit numbers corresponds to testing company? A is for AncestryDNA, T (and previously F) for Family Tree DNA, and M for 23&Me. (I recently saw an H, which I'm assuming is for MyHeritage.)

3. Printing your One-to-Many Match List as a PDF


In order to view all of the cousins and relatives that match with you, you have to load them all onto a single page. Called the One-to-Many list, this page takes the longest to load, and is the first thing to stop working when the site gets busy.

Rather than loading this page over and over again, print your results as a PDF document. That way, you can reference all of the information on it without creating extra strain on the site.

4. Sorting the Match List


Another feature I discovered by accident, you can actually sort by different columns on the One-to-Many match list. By default, it sorts by Total Autosomal DNA. Because of the way I sort and organize my data, however, I prefer to view it by Largest Segment. Every time I load the page, it's the first thing I change. But depending on what you want to view, you can reorganize the page and save a PDF of that version

This is especially useful when you want to create a match list of your X-DNA matches. By sorting with that column, your match list will load with a completely different set of matches. Based on the experience I had processing these matches for the first time, GEDmatch doesn't include all of the X-DNA matches on the default match list. The only way to see all of these matches is to use the sort arrow in that column. Keeping a separate list of these matches as a PDF is also helpful.

5. Use the X-DNA One-to-One Analysis


Speaking of X-DNA, which I also discovered in the past week, let me eliminate some confusion. X-DNA is Chromosome 23, and determines gender. It is not the same thing as mitochondrial DNA, which is inherited from your direct maternal line only. X-DNA is inherited by both men and women, and follows different inheritance paths according to gender. Being female, I inherited an X chromosome from my father, and my mother. My father got his X chromosome from his mother, and back through several different men and women along her lines. My mother, however, got her X chromosomes from a much larger collection of male and female relatives from both her paternal and maternal lines.





GEDmatch provides X DNA matches and analysis. If the only tools you ever use are the default match list and the general One-to-One analysis, you might not know that. There is a separate One-to-One utility for X DNA matches, which is the only one that will display those results. For relatives that share both autosomal and X DNA with you, you'll have to run their kits through both One-to-One match utilities to see all of the segments they share with you.

6. There's a Facebook Group!


Do yourself a favor and join this Facebook group. When I was first starting out, I had to ask a lot of questions that, looking back, I realize were really basic. The people there didn't have to take the time to explain such fundamental stuff to me. But they did, and it has made all of the difference in the choice I made to stick it out until I could understand. And they helped me without making me feel stupid, which is always an awesome thing.

7. STOP UPLOADING MULTIPLE KITS FOR YOURSELF!


To do DNA analysis, you have to process and compare literally hundreds of pieces of unique data. It's time-consuming and slow. From GEDmatch alone, I've processed over 1,500 samples. And I still haven't made it through half of the 23 pages of matches GEDmatch has to offer me. Let alone all of the matches on other websites I haven't gotten to yet. I may actually die before I process them all. And I know I'm not unique in that respect.

The number of people who upload duplicate kits for themselves, especially when they don't make it obvious, does a disservice to everyone. They take up precious space on the site servers with duplicated information. They waste everyone else's time in processing extra samples for the same person. And as much as I hate this behavior, I can at least understand it if you upload results from different testing companies. I seriously wish you wouldn't. But I get it.

But y'all who are uploading duplicate kits from the same testing company. Why? WHY?! What did you think it was going to tell you the second, third, fourth, or fifth time that it didn't say the first time? And before you think I'm blowing my stack about nothing, I'm not making this up. I have seen multiple people in my match list upload as many as five kits for themselves, and they're all from the same testing company.


I'VE HAD IT WITH YOUR CRAP SANDRA!

Just stop it already!

(Note: You can tell if it's a duplicate if you do a One-to-One comparison with the Graphics turned on. The bars that show up will be solid blue and green)

8. Link Your Kit Number and Tree Together


DNA segment data isn't useless without a tree. Certainly adoptees have had to make do with less. But everything about genetic genealogy is so much easier with a tree. So the more you do to connect your GEDmatch kit number and your online tree together, the better.

I post my kit number all over the place. It's on my blog, in my Ancestry.com profile, and on my Find a Grave profile. On Twitter, I put my kit number in the location field of my profile. I made a graphic of my kit number with a template on Canva.com. Then I set it to be a Featured Photo in the sidebar of my Facebook profile. You can also share it on Instagram, Pinterest, and other forms of social media. Put your kit number anywhere a relative might see it, and who knows? Maybe one day, it'll pay off.




I only wish it were that simple to link to our various online trees on GEDmatch. While the site allows people to upload gedcom files, the interface is dated and limited. It doesn't display any source information, and does nothing to connect users to their profiles or trees from their original testing companies. Links to online trees, usernames, and testing company user profiles would be much more useful, in terms of building bridges between trees and segment data. I'd love to see that in future builds for the site.

9. Tell Your Cousin Matches About GEDmatch


Whenever I contact cousin matches on AncestryDNA, I tell them about GEDmatch. I always send along my kit number, in case they're already users. If it's someone I'm particularly interested in connecting with, I tell them they can access more free matches from other testing companies at GEDmatch. Quite a few people have taken me up on that invitation, and some of my best matches are with people I've introduced to the site.

GEDmatch exists entirely from word of mouth. Everyone who uses it heard about it from someone else once upon a time. If we want the site to keep growing, we have to keep telling people about it.

10. Do Descendancy Research!


When I took my DNA test, I thought it was going to tell me who my ancestors were. Now I see that isn't how it works, at least not directly. The thing DNA tests are best at is connecting me to other living descendants of my ancestors. It's up to us to figure out where the connection is through collaboration and traditional research.

Since cousins and distant relatives are primarily what my test gives to me, it makes sense to spend time researching who they are. The more you know about the descendants of your ancestors, the more easily your will recognize them when they take a DNA test. Since most of us start a new tree with only biological ancestral connections anyway (or at least you should!), it makes sense to include descendants on that same tree.

When your biological tree becomes a more complete record of every person who is biologically related to you, the more DNA testing will reward you for those efforts.

Learning to use segment data can seem like a daunting task. It requires an investment of time that some of us may question. Is the value of what I've going to get back in the end worth the time I'm taking away from traditional research? I know that was a question I once had. I know it's a question that many people ask themselves before and after taking a DNA test. Is it worth the time and money I'm about to spend on it?

Even as many are asking themselves those questions, they still underestimate the investment that goes into doing genetic genealogy well. There truly is no royal road to geometry, no easy way to learn to use DNA, and no credible way to make it easier. We all have to pay what it costs to achieve understanding.

Monday, August 8, 2016

Your DNA Cousin Match Database: Getting Started with my Excel Template

A reader from a recent post requested a template for setting up a DNA matching database. Because it's quick and easy to set one up in Excel, I threw one together quickly. Please feel free to reuse for non-commercial purposes, but not to repost.






When you open this file, it's going to be a View Only file in my Google Drive. In order to use it yourself, you need to download it. The link to do so is on the top right corner, next to the Print option. You'll then be free to use it in Excel, or with whatever other spreadsheet software you want to use that is compatible with Microsoft Excel.

I've got the Filters already set up and enabled, which means you'll be able to sort and filter information when you analyze the data. In order to see those matches with the greatest similarity/longest segments, sort your Segment Length column from largest to smallest. If you want to see the other matches that might also connect to a given cousin on the same chromosome, sort the Starting or Ending Point from largest to smallest. Reading the ranges between these two numbers, determine where there may be overlap. Use the matching utilities from your testing company or analysis website of choice to determine whether a match exists. Record your findings in your Notes section. If you're able to determine who the common ancestor(s) are that you share with a match, record that information in the Most Recent Common Ancestors (MRCA) column.

If you decide you want to move different columns around, or add more columns, I recommend turning off the Filters (highlight headers, Data > Filter button toggled off), changing things around, then turning the filters back on.

If you use the table in Excel, I've frozen the column headers, so they continue to show up as you scroll down through the data. To enable or disable this option, highlight the headers, go to View > Freeze Panes > Unfreeze Columns, Freeze Top Row, or Freeze First Column, according to what your preferences are. I don't know if this option works in Google Sheets or not, or in any other spreadsheet software. So bear that in mind.

However, now that I'm seeing this open in Google Sheets, I think anyone who decides to use this may want to consider using it there. Not only will this allow you to access your spreadsheet from multiple devices at once, the layout of the file itself is much nice in Sheets than in Excel. Because of the way Excel scrolls the tabs across the bottom of the screen, you have to click through a series of tabs over and over again to get from Chromosome 1 to Chromosome 22. In Google Sheets, however, all of the tabs display across the bottom without any of them being hidden. This may not be an issue, depending on the size of your monitor or display resolution. But definitely check around to see what you like/makes your life easier!

Let me know how it works out for you in the comments, and be sure to like and subscribe to our Genetic Genealogy series on YouTube!

Saturday, April 23, 2016

Setting Up a DNA Cousin Match Database: A Success Story



DNA testing for genealogy is one of the best investments I've ever made into my research. The more I invest into my understanding of the subject, the greater returns I receive from it. And at no point was that ever more apparent than when I connected with a distant cousin several months ago.

Photo of Charles Miller Doyle and Birdie Price
from the collection of Irene Doyle Ashley,
 ca. 1920-1950; Scanned by Dwight Edwards,
Alameda California, 2016.
I initially reached out to this cousin more than a year ago, at a point when I was just beginning to figure out what I was doing with DNA analysis. I'd written dozens of such emails, and finally clued into something important. Reaching out to a DNA cousin match is good. Offering to help them determine the connection you share is better. But being able to share a real theory about where you think that connection is--this is the best approach, the essential component to every email we write to DNA cousin matches.

Had I not mentioned to this cousin that I was a Doyle descendant, and through looking around at shared matches I suspected he was too, he might never have written me back. He might have never taken the time to answer the vague form email I'd gotten into the habit of sending. And that would be truly tragic, because without this connection I never would have seen the pictures he shared with me of my 2x great grandparents.

Even though I made this connection on AncestryDNA, the real potential of this connection is untapped at GEDmatch.com, where I can analyze the DNA segments in greater detail. But inviting him to use GEDmatch and performing the analysis of our DNA segments were only the beginning. Having a way to compare our match to hundreds of other matches, in detail, across various other testing websites is the necessary next step.

By setting up a DNA database, harnessing the powerhouse of DNA testing for genetic genealogy becomes a reality. And in my newest tutorial, I explain how to set up such a database in spreadsheet software you already use. Whether you use Microsoft Excel or Access, Google Sheets, or any other type of spreadsheet software, many of these tips I share will help you to get started with your DNA cousin match analysis.

In many respects, setting up a centralized database of DNA matches isn't a question of starting over. It's learning how to be more organized int he efforts you're already making, in order to obtain the results you want, and solve the mysteries you're trying to unravel through DNA.

[UPDATE: Be sure to check out our free Excel template for setting up your own DNA database, based on this presentation!]

Thursday, October 8, 2015

AncestryDNA: A Year Later

As some of you may recall, I did a post about my initial experience with the AncestryDNA test. That post is more than a year old now, and AncestryDNA has undergone two major changes since then. There are new features to consider, and how they have fundamentally changed my experience with their DNA test.

Like last time, I wanted to give myself ample opportunity to use these new tools before doing a follow-up review. And unlike last time, I have something else to which I can compare my experience. Not only have I been using GEDmatch.com, I’ve also uploaded and unlocked my free trial matches at Family Tree DNA. While my experience with these sites have informed my perspective, I will try to save my comments on each of these sites for their own respective posts.

I won’t be reviewing the Ethnicity Estimates again, because my opinion of them has not changed.

Cousin Matching: C-


My experience with cousin matching has improved significantly. The first impact my DNA test has had on my tree came from using the tools at AncestryDNA. I began the process using the surname search, which is one of the best tools on AncestryDNA. It allows me to search through my cousin matches’ trees for a surname, a location, or both at the same time.


An example of the surname search, using the surname Halsey


I reached out to one of my cousins, then decided to compensate for her lack of response by researching her family tree for her. Thanks to what little information she provided on her parents, I was able to use obituaries and newspapers to trace her family until I arrived at our common ancestors. I never knew where they went after the 1920 census, and the answer was with her line of the family. They moved to Somerset County, Maryland. Her ancestor was the youngest sibling in a family I’d never realized had more children—the only ones still living with them ten years later at the time the 1930 census was taken.

The names and new census records were added to my tree—and my cousin is none the wiser. Which is probably for the best, because I don’t know how to explain to her what I did without using the words, “Don’t freak out, but I stalked you a little bit.”

A general lack of communication is still one of the predominate issues with DNA testing. This was my chief complaint in my previous review, and over time I've come to understand that this isn't a problem unique to AncestryDNA. With every DNA testing service to which I've been exposed, responses to inquiries are rare and wait times are long. It's the human element of the equation that no DNA testing company can control.

The surname search, plus some extra elbow grease, was enough to find the match between us. AncestryDNA deserves credit for that--and the maps, surname lists, the search functionality, and all of the other tools they've come up with to analyze your cousin match. But the set of tools AncestryDNA provides is still incomplete. The single greatest thing they can do to improve the cousin matching experience would be to have a chromosome browser. I still believe it's unadulterated stubbornness that perpetuates their refusal to build one. A chromosome browser, together with the other tools they provide, would make their DNA test a tour de force of unstoppable discovery.

I understand that people take DNA tests for different reasons. Based on my experience with reaching out, I'd say that more than half of the people with any genetic connection to me have no interest in collaboration. That means that more than half of the messages I send will never amount to anything. This makes me think that some people come into this relationship already knowing they don't wish to contribute. But rather than wasting my time lamenting about it, I'd rather we simply created a way to be upfront with each other.

What reaching out to DNA cousin matches feels like
In my mind, this situation could be handled with a single check box--either as part of the registration process, or a prompt to every person who is part of the AncestryDNA system. “I am currently interested in collaborating with other researchers for the purpose of finding our common ancestors.” Check yes or no. I envision this as a status update type of feature, where we all can act like grown ups and communicate our intentions from the outset. I'm even envisioning that after a person hasn't been active on AncestryDNA for more than 3 months, that status is automatically changed to "No."

Imagine being able to filter your cousin matches by the people who are actively using their DNA tests. No more wasting time sending messages to people who never had any intentions of responding to them. If we can't change other people's behavior, we can at least communicate the behavior we all intend to exhibit.

DNA Circles: C

This was the first of the two newest features to the AncestryDNA test since my last review. A DNA Circle is where AncestryDNA points out the people who share DNA with you, as well as a common person in your trees.





I questioned this feature when it first launched, because all it takes to throw it off is for several cousins to have the same wrong information in their trees. While the DNA Circle links people together with shared DNA, the DNA Circle does no good if the ancestor it claims to represent is wrong.

However, this is not entirely AncestryDNA’s fault. Relying on member trees as part of this process is necessary. Research will always be a part of genealogy, including genetic genealogy. It’s on us to do a better job with our research, so the matching algorithms can do a better job of connecting us together. Being more exact is a necessary part of that process.

Moving forward after my DNA test, I made a lot of changes to the way I used my Ancestry member tree. I created a second tree in which I placed biological relationships only. I removed all extraneous information, including photos, to streamline my work with this DNAonly tree. I expanded the scope of my research for this tree to include all descendants, all siblings and half siblings, second marriages--anyone with a biological link to my direct line ancestors. At the same time, I cleaned up the dates and places in the Facts section, since these drastically improve the Map tool for the cousin match tree comparison. If we want better quality DNA Circles, we each need to participate in some aggressive housecleaning.

What I dislike is how the DNA Circles come with a page for the common ancestor, and that page is a random assortment of stuff from the trees of everyone in the Circle. Photos, Stories, Facts, dates, and names become an unattractive, oftentimes inaccurate jumble of ugliness.




There are no source citations, no criteria for anything that is placed automatically on that page. Being able to clean up and correct these DNA Circle pages is a much needed feature. Unless we're trying to create the world's largest (and worst) Ancestry member tree.

Rather than seeing an assemblage of what everyone has collected on the DNA Circle, I’d rather start with a blank slate, to which my cousins and I may add information. Provide us with the ability to collaborate, allowing us to choose what to add to this ancestor's page. Make valid source citations a requirement for submitting anything to an Ancestor's DNA Circle page. Otherwise, it becomes a compounded source of ignorance instead of providing genuine insight.

In fact, increasing the quality of the DNA Circle ancestor pages and Ancestry member trees could go hand-in-hand. Ancestry.com currently provides shaky leaf hints to member trees, which have a certain reputation for being garbage. These hints and copying data from other member trees is how errors spread and become entrenched in the family consciousness. Instead, why not hint everyone to the DNA Circle page? Let it become the single, authoritative source for researchers as they assemble their trees together--whether they've taken a DNA test or not. I'd much rather be introduced to cousins who haven't tested yet this way. If/when they do take an AncestryDNA test, I'll already know who they are!

I'd also like to see some better communication tools for the purposes of DNA collaboration. With each DNA Circle page, I envision a Google Hangouts-style interface which would foster online meet-ups/family reunions, group research discussions, and individual conversations between descendants. These meetings could be private, or publicly stored as part of the DNA Circle page.

A DNA Circle as it stands now seeks to reconstruct the identity of the dead. In order to do the greatest good, it should foster communication and a sense of kinship among the living.

Ancestor Discoveries: C+


Of all the new features on AncestryDNA, this one has me the most excited. This feature has done great things for me already, despite the accuracy shortcomings of the DNA Circles. Over time, I imagine this being one of AncestryDNA’s biggest assets—the thing that sets them apart from other testing services and websites.





So imagine a DNA Circle has been formed for an ancestor. It’s well established, and there are plenty of cousins all matched together. The only thing missing is you, because you share the same DNA as everyone else in the Circle. But the matching algorithm hasn’t matched you to the Circle, because you don’t have the ancestor in your tree yet.

Bummer, right?




Not anymore!

Ancestor Discoveries is intended to do exactly that. It has already done this for me. My Greene family is a hot mess. That’s what happens when the courthouse that services your ancestors burns down… Twice. I was stuck on Henry Greene for ages, until the Ancestor Discovery for his grandparents came along. I did the research to back up the information, because I know better than to believe people on the Internet. I had to go into some unusual places to find the evidence I needed, but finding it was a direct consequence of my Ancestor Discoveries. In terms of results, it really has delivered.

Part of why I like the direction AncestryDNA is going with Ancestor Discoveries is because the lovely so-and-so's with private trees are included. If they fit into a DNA Circle, they become a part of my potential Ancestor Discoveries. Everyone else with a private tree that isn't connected to a DNA Circle can be triangulated via the Shared Matches tab on their cousin match page. I now expend less effort on figuring out where these people fit into the puzzle, and move on to other research problems. AncestryDNA is figuring out ways to avoid giving me an inferior product because of someone else's privacy settings. As one of my chief complaints from my first review, the privacy settings of other users is one of AncestryDNA's areas of greatest improvement.

My only complaint regarding the Ancestor Discoveries is one specific place I've seen it fall apart. To put it delicately, I come from Southern communities in which endogamy was a common practice. I'm one of the lucky ones whose ancestors moved away before the family tree got too tangled, and our current generation is far removed from it. But some of my cousins who are still living in these communities haven't been so fortunate. I connect to them in a multitude of places. We have multiple sets of common ancestors. How well do the Ancestor Discoveries reflect situations like these? Because I know just enough about the science of how the relationship estimates are calculated to know this effectively hoses the entire thing. And some of the Ancestor Discoveries I'm getting suggest the matching algorithms are struggling.




And don't y'all go making fun my endogamy. There are two types of people in this world: people who are inbred, and people who don't know it yet.

In situations like these, having segment data matters. I need to see the exact length of the DNA segment. Comparing it to standard genetic inheritance estimates is crucial to properly calculating my relationships to my cousins. I can't judge how skewed my inheritance is without the numbers--data that AncestryDNA does not display as part of its test. While I'm able to use GEDmatch.com to get this information, I would love so much more to have it as part of my Ancestor Discoveries. Localizing these connections, as well as analyzing them for accuracy, would be so much simpler with the segment data than it is without it.

Final Grade: C

AncestryDNA has made promising progress. I no longer consider it the worst $99 I ever spent. I still encourage anyone who is planning to take a DNA test to consider all of their options before purchasing one from AncestryDNA. Understand that you are making sacrifices of functionality no matter which testing company you choose, so be sure you choose the one that aligns with your reasons for testing.

Regardless of which testing service you use, your plans should also include uploading your results to GEDmatch.com. As a more open source option, it provides many of the analysis tools and data AncestryDNA is currently lacking. While there's a bit of a learning curve to using GEDmatch, it's time and effort well spent. If you need a beginner's guide, be sure to also check out our Genetic Genealogy for Beginners video series.

Good luck, and happy testing!

Monday, August 3, 2015

Free DNA Discoveries from GEDmatch.com



DNA testing is among the many technological revolutions taking place in the genealogical community. With a little help from AncestryDNA, 23&Me, and Family Tree DNA, you can connect with other descendants of your ancestors to increasingly remote corners of the globe. By collaborating with them, many genealogists are tearing down long standing brick walls and making incredible discoveries.

However, there are limitations to genetic genealogical testing--and not just the 8 generation window the technology gives us at this present time. These limitations instead come from expense, and the boundaries between testing companies. If the descendants to whom you need to connect have tested with a different company than you have, you may not see that match until one or the other of you takes a second test with the right company.

But does it have to be that way? In our day and age of open source software and good digital citizenship, there are no necessary boundaries between testing companies anymore.

Introducing GEDmatch.com

GEDmatch.com is a website which allows users from each of these testing companies to upload their DNA test results. No matter where you live or which of the testing companies has performed your test, GEDmatch.com is free for you to use. You are then placed into a database, which includes users from each of the major testing companies.

Learning to use GEDmatch requires a little more than the average sit-down to learn how to use it. Because of that, we've provided a beginners guide with our Genetic Genealogy video series. This final video in that series provides a beginners introduction to GEDmatch, and the three most essential tools on that site: the One-to-Many match list, the One-to-One analysis, and the Admixture utilities.

Have you taken a DNA test and are still waiting to make the right cousin match? Check out GEDmatch.com and see what you can discover today!



AUTHORS NOTE: This is not a compensated endorsement. I receive nothing from GEDmatch for writing this post.

Wednesday, May 27, 2015

Using Microsoft Access for Genealogy




Let's be real for a minute. As genealogists, one of the worst mistakes we can make is being our own worst enemy. Many moons ago, I did this through being disorganized. But as I wrangled my digital files into submission and limited all of my papers to a single binder, organization became one of my greatest strengths.

Now that I'm organized, my new enemy is inefficiency.

Inefficiency: The Genealogy Edition

Let me set a scene for you. You find a family group sheet or a report you really like to track certain information about a family. Maybe it's your research log, or tracking vital records for a family, or any type of family group sheet--anything you use to analyze your research. Naturally, you have copies of those reports for different ancestors. So the number of them begins to grow exponentially.

But then what happens when it's time to update them? Do you hunt down each one of them, and update them individually? When it's time to delete the outdated ones or backups, there's no easy way to do that. And what happens if you find a new report you like more, or want to make changes to the one you've been using? Do you copy and paste all of that information from your old form onto your new form? That takes forever!




The moment I have a blank document where I'm typing information I already know, about people I've already discovered, that to me is inefficiency. For a long time, it seemed like a necessary evil because I didn't know of any programs that could avoid that needless repetition.

Then I discovered Microsoft Access.

Introducing: Microsoft Access

Microsoft Access is a great source of untapped potential for genealogy. In terms of a learning curve, the transition is minimal--it uses the same menu and command structure as the Microsoft Office ribbon. Learning the unique functions of Access was simple. Everything I needed to know, I learned from YouTube. Creating a fully customized database is no more difficult than creating a PowerPoint presentation.

Looking at you, Evernote!
No coding, no tinkering with new platforms or websites. No more apps bricking up my phone. No more wondering if some website is going to get hacked and all of my data is going to disappear. And no more sacrificing functionality because a website like Evernote seems to think that fully functional rich-text editing is some kind of luxury.

For me, Microsoft Access's single greatest strength was how it unified my research tasks. I don't have research logs, document tracking, DNA matching lists, repository contact information, and other such documents and information scattered all over my computer and different platforms anymore. All of that information is organized and working together in the same stand-alone program.

How else does it help my productivity? In Microsoft Access, the data entry mode and creating reports from that data are two different steps, not one. If I create a family group sheet in Microsoft Word, the only way for the information to end up on that family group sheet is if I type it on there. The same is true of Excel, OneNote, and Evernote. To create a new document or page means I have to copy and paste, or type, for every additional report I create. The creation of the form and the data entry and pretty much the same step.


In Microsoft Access, the form on the left creates the report on the right

 In Access, this is not the case. It allows me to create forms for data entry. I enter the data, and it saves that information into a spreadsheet. Once that information is on the spreadsheet, it's there until I delete it. So I enter the data ONCE--for any person, from any family line--on the same data entry form. It will store it all that data together on the same sortable spreadsheet, which I can export in a variety of formats. But I'm not just limited to displaying that information on a spreadsheet.

When I want the information on a specific individual or family, I can easily create a report from Microsoft Access. It takes the information from my spreadsheet, and will create any combination or number of reports that I want it to create. It will sort, organize, or reorganize the data on that report in whatever way I wish. I can change the report content or design without having to retype any information I've already entered. It simply pulls all of the same data from the spreadsheet, and enters it for me on the report.

No more hunting down a specific document to update, which is already outdated the second I finish it. I don't even create reports until I need them anymore. Every document I create is up to date, existing in real time with the rest of my research. All I have to do is backup my database, and it backs up literally hundreds of forms--all at the same time.

If the definition of efficiency is only having to do something one, Microsoft Access is the only program I've found that allows me to be efficient in everything I do.


NERDGASM!

If you're spending more time tinkering with documents and websites than getting your research done, maybe it's time for a change.

And maybe that change should be Microsoft Access.

Popular Posts