How can I enter Scripture references in Access 2003?

[Sister Susan Word of God]

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

 

[Allen Browne]

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

"Sister Susan Word of God" <Sister Susan Word of
(e-mail address removed)> wrote in message
news:[email protected]...

 

[LeAnne]

Hi Allen, Sister Susan -

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.

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