Template for DataBase for Church Baptisms, Weddings, Deaths etc.

[homerallen]

I am volunteering for our Church. They want a database with all the records
of each person from Birth to Death. Including Baptism info, Wedding info,
etc. This Church dates back to the 1800's so it will be a large database.
There have already been 3 volunteers who want to enter data so it needs to be
an easy data entry screen that they can't accidentally get messed up or erase
the whole file. Any help or suggestions would be greatly appreciated. I have
all the fields in Excel but I worry about having a fool proof data entry
screen. This will probably be used mostly for Geneaology so I also want it to
be easy to look up a last name and get all the files with that last name to
show up. I am a little familiar with Access but was hoping to find a
Template. I couldn't find one. Maybe I am not searching the correct words.
Thanks Bunches for any help

 

[Tom Wickerath]

Hi Homerallen,

There is a Genealogy database template, available on Microsoft's UK
templates site. Strangely enough, this sample is not available on Microsoft's
US templates site:

http://office.microsoft.com/en-gb/templates/TC010765241033.aspx?CategoryID=CT063459251033

You didn't mention which version of Access you are using. This template
should work in Access 2002 and later. If you have an earlier version of
Access (97, 2000), then the sample, as written, will not work.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Tom Wickerath]

PS. You might also want to contact Access MVP John Vinson. Please refer to
this post as a reference:

http://groups.google.com/group/micr..._frm/thread/a3acd15132b7be46/9131bdf9d85941a4

I took another look at the Genealogy database template. If you end up using
that one, I strongly recommend having someone skilled in Access go through it
and fix lots of problems that are present in this sample. Lets just say it is
not a shining example of a sample database that Microsoft personel are
capable of producing.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html

 

[Mike Gramelspacher]

Here is an overview of a database I made for my own use. Since I am the
only person who uses it for entering data, it has never been user tested. I
started it when I knew nothing about Access or databases, and so it has
design flaws. It also uses a lot of code by others that I gathered off the
Access newsgroups. Some is acknowledged and some not.
http://www.psci.net/gramelsp/temp/ChurchTemplate.html

I have used the database to transcribe about 15 churches, mostly Catholic,
but some Lutheran and Evangelical.

Mike Gramelspacher
Ferdinand, Indiana

 

[Jeff Conrad]

Hi Mike,

Do you mind if I include a link to your Treeview Sample database
on my Treeview page here?:

http://home.bendbroadband.com/conradsystems/accessjunkie/treeview.html

Thanks,
--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:

 

[homerallen]

Thanks Tom for all of your info. I am using Access 2000. I tried to move
around in it and I already couldn't get it to do what I wanted. Of course,
it could be me not the database. I am not that familiar with Access. I do
have a book.
If you don't mind, I will keep a copy of this so that I may ask you future
Access questions.

Take Care and May God Bless,
Mrs. Marian Brooks

 

[Tom Wickerath]

Hello Marian,

I am using Access 2000. I tried to move around in it and I already
couldn't get it to do what I wanted.

Sadly, that's not surprising. The Genealogy database will not work with
Access 2000, as currently written.

You are welcome to send me future questions. Alternatively, just post them
to this newsgroup. If I don't happen to be available at the moment, there are
plenty of other regulars who volunteer their time to answer questions.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Michael Gramelspacher]

Hi Mike,

Do you mind if I include a link to your Treeview Sample database
on my Treeview page here?:

http://home.bendbroadband.com/conradsystems/accessjunkie/treeview.html

Thanks,

Jeff,

That is fine. The link should be relatively stable.

Tom Wickerath was kind enough to run Total Access Analyzer on the
database. Wow! It identified lots of things that could be better. That
is a real valuable tool, but really should be used throughout the
building stage. Still, the program seems to work OK.

Mike Gramelspacher
Ferdinand, Indiana

 

[Jeff Conrad]

in message:

Hi Mike,

That is fine. The link should be relatively stable.

Cool.
Your TreeView Sample database link is now listed on my page here:

http://home.bendbroadband.com/conradsystems/accessjunkie/treeview.html

Thanks for the inclusion.