Results 1 to 12 of 12
  1. #1
    JimBell's Avatar
    JimBell is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Location
    Bailey, NC 27807 USA
    Posts
    5

    Post New Bible Project help needed

    I am hoping to develop a new Holy Scripture DB in Access.
    I currently have the entire 66 books in one table. I think where I need to begin is assigning a Primary Key to each verse.
    I am looking for a partner to be a sounding board. Any suggestions will be most helpful.


  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    What exactly are you trying to accomplish with this database?

  3. #3
    JimBell's Avatar
    JimBell is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Location
    Bailey, NC 27807 USA
    Posts
    5

    Bible Project

    Well I guess the end result would be to create a application that someone trying to look a topic for a sermon, could get a report with all relevant subject matter.
    With references to versus in the Old Testament. That would be a good start.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Bible already has 'keys' - chapter and verse.

    What is db structure - only 1 table?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    You could create a system of "tags", so when someone does a search on a topic all the relevant verses will come up. If you go down to the verse level I hope you don't have to type it all in! A tag would be a topic, such as the Christmas story, and when they enter that they will be shown all the chapters/verses where that is mentioned.

  6. #6
    JimBell's Avatar
    JimBell is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Location
    Bailey, NC 27807 USA
    Posts
    5
    This is the basic structure 66 books in one table.
    Do I subdivide the Testament by OLD and New. With Primary keys for each?
    The Primary key taken from the Verse?

    Testament | Book | Chapter | Verse | VerseText

  7. #7
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    This functionality is widely available for free on the internet. Google "Search Scripture" for a list of sites.
    Unless your project is just an exercise in learning Access, you can save yourself a lot of time and frustration by using the above.

  8. #8
    JimBell's Avatar
    JimBell is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Location
    Bailey, NC 27807 USA
    Posts
    5
    "just an exercise in learning Access"

  9. #9
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Only need primary key if you will have related dependent table where the PK will be saved as a FK. In which case you can use an autonumber field for the PK.

    Do not have separate tables for Old and New. Can have another field to identify this category.

    So you could have a master table of Books with fields like:

    BookID (autonumber PK)
    BookName
    AuthorName (if known - is Genesis ascribed to a single author - Moses?)
    DateWritten (Year?, Century?)
    Old_New
    Comments

    Then a related table of the verses:

    BookID_FK
    Chapter
    Verse
    VerseText

    Correction to earlier post. The combination of book/chapter/verse would be a unique identifier. But compound identifers are seldom required. Use autonumber as PK if you need a PK in the Verses table. So unless you can come up with a need for a tertiary table, see no requirement for PK in Verses. You can add the autonumber field if you want. You just don't have any immediate use for it.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  10. #10
    JimBell's Avatar
    JimBell is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Location
    Bailey, NC 27807 USA
    Posts
    5
    It is all in one table at the moment. But that is what I was thinking I needed to do was separate the one table into two, by old and new. This is helpful, thank you.

  11. #11
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    No, not an OLD and NEW tables. The recommendation is to have a master table for the Books info and a related table for the Verses. Otherwise, just ONE table.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  12. #12
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    This is really a chosen project to learn Access?

    I found this via Google. I realize it is a different text and language, but if you read parts of the article you may get some ideas of what others (with similar project) have found re volumes and findings.

    I don't mean to dissuade you, but it seems a very big project (or could be) for learning Access.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Help with a project that i have!
    By Haoming0 in forum Access
    Replies: 1
    Last Post: 10-07-2017, 02:37 PM
  2. Replies: 8
    Last Post: 07-16-2014, 12:51 PM
  3. Help needed : Library catalogue in access format is needed
    By dealers in forum Sample Databases
    Replies: 3
    Last Post: 01-16-2014, 02:03 PM
  4. Help with a project, please!
    By newtothis in forum Access
    Replies: 1
    Last Post: 06-28-2011, 03:22 PM
  5. sorting Bible verses
    By SitarSteven in forum Access
    Replies: 2
    Last Post: 09-08-2009, 07:48 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums