Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   News   Courses   Seminars   Templates   Help   TechHelp   Forums   Order   Contact   Logon  
 
Home > Seminars > Access > Genealogy 1 >
 
Access Genealogy Seminar Part 1

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  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.

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

Questions

Post your questions or comments below

Buy Now

 

Post a New Comment or Question
 
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.
 
Subscribe
 

You may want to read these articles from the 599CD News:

10/21/2020Consolidate Tables with Helper Data
10/20/2020Is Microsoft Access Going Away?
10/12/2020Store Multiple Phone Numbers
10/10/2020ABCD Part 1: Core Database
10/10/2020Create Your Own Custom Function
10/8/2020Update Query from Another Table
10/5/2020Access Business & Contact Database
10/5/2020How and Why to Split Your Database
10/2/2020Multiple Nested Continuous Subforms
9/28/2020Access Developer 18
 
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search The Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

YouTube Channel    LinkedIn

Blog RSS Feed   
Keywords: access genealogy seminar ancestry family tree  Page Tag: whatsnew  PermaLink