Results 1 to 5 of 5
  1. #1
    zoiets is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2018
    Posts
    2

    Question Database design for grading / profile tracking

    Hello everyone!



    I'm currently working on a database, but it's been a few years since I've made one, so I could really use some guidance to get me going in the right direction.

    Here's the situation. I monitor people who record audiobooks on a daily basis, and have to judge their voice/speech. A lot of them have several sessions a day, a few times a week. I'd like to be able to track their session scores in a database, along with some additional remarks I might have relating to the session. Ideally, I'd like to create a form I can open where I can select the specific reader, fill out their score for a session, and save it to the database. Eventually I may want to create reader profiles I can load up, to see their progression over time and retrieve any comments that were added to their sessions.

    Here's what I was thinking I'd need when it comes to tables:

    • Reader table
      • Name

    • Comment table
      • Comment
      • Comment author
      • Reader the comment pertains to

    • Reading Session
      • Date
      • Reader
      • Book
      • Voice
      • Articulation
      • Optional comment

    • User table (for me and whoever does the monitoring?)
      • Username


    Am I missing something rudimentary? Any hints/tips/guidance would be greatly appreciated!

    Thanks in Advance!

  2. #2
    Gina Maylone is offline Always learning
    Windows 10 Access 2016
    Join Date
    Jun 2013
    Location
    Afton, MN
    Posts
    526
    Each table should have an "ID" field that is set to autonumber.
    Your comment table needs to be related to the reader table, by the "ReaderID".
    Not knowing what your scores are, you may want some list tables for quick data entry. I.E. Articulation, data would be 1,2,3,4,5 etc.(or good, bad, indifferent) Then use that data in a combo box in your form for Articulation. NOTE: "Name" is a reserved word in access as is "date", don't use them as field names, use "readername" or "readdate" instead.

    Hope this helps!

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,047
    throw in some autonumber ID fields.
    I assume theres a tReader table ...

    tComments
    ComID (auto)
    comment
    etc..

    tReadingSession
    SessID (auto)
    Date
    ReaderID (long)
    BookID
    etc...


    tReaders
    ReaderID (auto)
    ReaderName
    etc

  4. #4
    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
    15,852
    Here's a rough draft model based on posts. Good luck with your project.

    Click image for larger version. 

Name:	EvaluatingReaders.PNG 
Views:	24 
Size:	14.3 KB 
ID:	36338

  5. #5
    zoiets is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2018
    Posts
    2
    Thanks very much, everyone. That's great stuff to get me going!

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

Similar Threads

  1. Employee Time Tracking Database Design
    By shell159 in forum Database Design
    Replies: 1
    Last Post: 01-12-2016, 02:58 PM
  2. Asset tracking database design question
    By ittechguy in forum Database Design
    Replies: 9
    Last Post: 11-09-2015, 04:41 PM
  3. Replies: 7
    Last Post: 05-27-2015, 07:11 AM
  4. Database Design Help: Lien Waiver Tracking
    By twarner3 in forum Database Design
    Replies: 1
    Last Post: 03-10-2014, 02:42 PM
  5. Help With Patient Tracking Database Design
    By wkenddad in forum Programming
    Replies: 2
    Last Post: 04-25-2012, 09:15 PM

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