Free Lessons
Fast Tips
Topic Index
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
Home > Courses > Access > Seminars > Genealogy >
Access Genealogy Seminar

Do you want to learn how to build a database for tracking Genealogy in Microsoft Access? If so, this seminar is for you.

 S  M  L  XL  FS  |  Slo  Reg  Fast  2x  |  Bookmark Buy Now

Learn More

What's Covered?

This seminar is over 8 hours long and will teach you everything you need to know to build a Genealogy Database from the ground up. We'll start by building the basic tables and forms needed, and learning about self-join relationships. You will learn how to create clickable fields so you can quickly jump to a person's parent or child records. We'll make quick-add buttons so you can add people to the database who aren't already in there without leaving the current record.

We will see how to store dates of birth and death, and have the database automatically calculate their age. If they're still alive, you'll get their current age. If they're deceased, you'll get their age at death. You'll also see how to colorize the gender combo boxes accordingly.

You will learn a quick way to store profile pictures in your database. Then you'll learn a better way to have access store them in an external folder customized for each person. We will build a graphical family tree that you can use to quickly move up through your ancestors and down through your descendants. Click on someone and the tree reorganizes around that person. A great way to navigate through your family.

We will track life events for people in our database. You can log their birth and death dates, marriages, divorces, jobs, education, name changes, and anything else you wish. You can specify which events, such as marriages, get linked to another person – for example a person’s spouse.

We’ll build a main menu, and a master list of people. You can search, filter, and sort by names, gender, birth and death dates. And we’ll throw in a ton of enhancements, such as customized delete warning messages, and showing or hiding fields and buttons based on the data shown.

Template Only

If you want to purchase the database template but don't need the video lessons that go with it, you may do so here. However, please note that the template by itself does not come with any support. If you have questions about the construction of the database, that's what the Seminar is for. 


Lesson 1 (32:53)
Create Person Table
Person Form
Self-Join Links
Parent Combo Boxes
Child Subform

Lesson 2 (1:02:30)
Double-Click Follow
Add Child in Subform
Quick Add Person Form
Can't Delete w Child

Lesson 3 (25:14)
Family Tree

Lesson 4 (24:53)
Date of Birth, Death
Calculate Age
Color Gender Combo

Lesson 5 (36:48)
Add Pictures & Documents
Navigate Family Tree
Lesson 6 (53:16)
Unknown Gender
Life Events

Lesson 7 (25:12)
Count of Events for Person
Children on Family Tree

Lesson 8 (54:21)
Replace Attachments
Use Linked Images
Create a File Folder
Select File Dialog Box
Copy Files to Person Folder

Lesson 9 (31:20)
Update Family Tree
Use Linked Images

Lesson 10 (47:51)
Master Person List
Filter, Search, Sort
Main Menu

Lesson 11 (1:18:11)
Bug Fixes

Possible Future Updates

These are topics that are on my list for potential future upgrades of this Seminar in Part 2:

  • A report showing the relationship between any two people. See this


Post your questions or comments below

Buy Now


Comments for Access Genealogy Seminar
Age Subject From
8 monthsFamily book reportGary Becker
16 monthsEmbed Google Earth genealogyAnthony Mitchell
16 monthsAutomatic RelationshipHendra Gunawan
18 monthsGeneol deathdate unknownRoxanne Drachenberg
2 yearsGenealogy dB customizableRoxanne Drachenberg
2 yearsCant open Sample Database FilRoxanne Drachenberg
2 yearsTemplateTimothy Schmidt


Start a NEW Conversation
Only students may post on this page. Click here for more information on how you can set up an account. If you are a student, please Log On first. Non-students may only post in the Visitor Forum.
Subscribe to Access Genealogy Seminar
Get notifications when this page is updated

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 7/15/2024 4:28:46 PM. PLT: 1s
Keywords: access genealogy seminar ancestry family tree  Page Tag: whatsnew  PermaLink  Microsoft Access Genealogy Seminar