HOW DO I CREATE A DATABASE FOR MINISTRY TEACHING AUDIO TAPES

M

Minnie

I WANT TO CREATE A DATABASE FOR MY MINISTRY TEACHING AUDIO TAPLE COLLECTION
USING ACCESS. THE FOLLOWING INFO WILL BE USED:
THE AUTHOR, YEAR, ID# AND SCRIPTURE REFERENCE.
THERE ARE SINGLE TAPES, AND SETS OF 2-12..
 
J

John Vinson

I WANT TO CREATE A DATABASE FOR MY MINISTRY TEACHING AUDIO TAPLE COLLECTION
USING ACCESS. THE FOLLOWING INFO WILL BE USED:
THE AUTHOR, YEAR, ID# AND SCRIPTURE REFERENCE.
THERE ARE SINGLE TAPES, AND SETS OF 2-12..
Click to expand...

Minnie, one thing to be aware of: typing in all caps is considered
impolite. It's hard to read and it looks like you are SHOUTING at us.
Please type in all lower case if the shift key is inconvenient for
you.

You might want to check out the references at
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html
particularly the Database Design 101 links.

In a nutshell (in a mustard seed maybe? <g>) you'll need to identify
the Entities of importance to your collection; an Entity is a
real-life thing, person, or event. Each Entity should correspond to a
table.

You'll probably need several tables here - a table of Authors and one
of Tapes at the very minimum:

Tapes
TapeID Primary Key (a unique tape identifier, your existing ID??)
Title
DateMade <don't use Date as a fieldname>
ScriptureReference <Memo; copy and paste from a digital Bible or see
below>
Comments <Memo, your notes about this tape>
AuthorID

Authors
AuthorID Primary Key Autonumber
LastName
FirstName
<other bio information as needed>

Probably a table of Sets as well, which will mean you'll need the
SetID as a field in the Tapes table.

Your post prompted me to do a quick Google search; it seems that the
entire text of the Bible is in fact available in at least three
translations, in the form of Access databases (free):

http://www.htmlbible.com/ and search the page for Microsoft Access.

This would be kind of neat as you could just store book, chapter, and
verse in three fields in your tapes table, and link directly to the
Bible passage itself in the Bible database.

John W. Vinson[MVP]
 
M

Minnie

Thank You very much Mr. Vinson for all the information you've given me about
creating my database. I sincerely apologize for using all caps. I didn't know
it was considered impolite. I'm new at using the computer and I'm grateful
for any positive help I can receive. I have no problem being corrected. Thank
you for not sending me off to some web site. I can tell that you actually
thought about this, because you showed me how to set up the different tables
that I will need and you did something that just made my heart soar! You did
a Google search and found out about the Access database of the Bible and gave
me an excellent idea of how to use this great resource that I would not have
known about if you didn't care about the people you help.

Keep up the good work Mr. Vinson, because Minnie will be back, and I sure
hope that John Vinson will be there to help. I've gotta go now because I am
so excited about creating my first database, thanks to John Vinson.

See Ya!

MINNIE
(smile)
 
Top