How can I enter Scripture references in Access 2003?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sister Susan Word of God - 29 Sep 2004 20:23 GMT

Bible Database in form of Book chapter:verse (Often a span of verses or
across chapters)
Can I use a mask or template to enter data in Access 2003?
Thank you so very much & God will bless you for your help,
Sister Susan

Reply to this Message

Allen Browne - 30 Sep 2004 05:04 GMT

Although it is possible to do this in Access, there are better ways.

Access is not great at searching large volumes of free-form text, and there
are many products such as QuickVerse that are very cost effective ways to
search the Bible instantly. There are also free copies of the entire text of
the Bible you can download from the 'net.

If you want to go ahead in Access anyway, your first task is to teach Access
the order of the Books of the Bible. You need a table named (say) "tblBook"
with fields:
BookID Number 1 = Genesis, 2 = Exodus, ...
BookName Text

The next table then has fields:
BookID Number
Chapter Number
Verse Number
VerseText Memo
and you can enter your text there.

That approach can never be as efficient as the software that actually
maintains a dictionary of the words in the Bible, and cross-references them
with the chapter/book/verse where they are used, so it can instantly list
the verses where a particular word occurs.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Bible Database in form of Book chapter:verse (Often a span of verses or
> across chapters)
> Can I use a mask or template to enter data in Access 2003?
> Thank you so very much & God will bless you for your help,
> Sister Susan

Reply to this Message

LeAnne - 30 Sep 2004 15:52 GMT

Hi Allen, Sister Susan -

<snip>

> If you want to go ahead in Access anyway, your first task is to teach Access
> the order of the Books of the Bible. You need a table named (say) "tblBook"
[quoted text clipped - 8 lines]
> VerseText Memo
> and you can enter your text there.

Personally, I would argue that the relationally "proper" approach would
to be to have separate tables for
Testaments --> Books --> Chapters --> Verses.

Having said that, I agree with Allen that an eBook would be better, and
much easier.

hth,

LeAnne

Reply to this Message