Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
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. 

Outline

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
Ancestors

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

Lesson 5 (36:48)
Attachments
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
Enhancements

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

Questions

Post your questions or comments below

Buy Now

 

Comments for Access Genealogy Seminar
 
Age Subject From
16 daysGenealogyIna van Rooyen
2 monthsNot received Genealogy SeminarGary Irvine
11 monthsFamily book reportGary Becker
19 monthsEmbed Google Earth genealogyAnthony Mitchell
19 monthsAutomatic RelationshipHendra Gunawan
21 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
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.
 

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

LinkedIn
Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 10/15/2024 10:52:13 AM. PLT: 1s
Keywords: access genealogy seminar ancestry family tree  Page Tag: whatsnew  PermaLink  Microsoft Access Genealogy Seminar