Results 1 to 2 of 2
  1. #1
    ajh19742000 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2014
    Posts
    5

    Creating a database for student tracking


    Views: 7 Size: 30.5 KB">TRACKING ANDY.doc


    Hello,

    I am trying to create a simple database for a tutor so that she can track the progress of her students on her course. I am trying to create a dadatabse which will help her by having tick boxes for each of the criteria that is met. However each criteria has its own criteria to it, for example 054 has 3.1 and 3.2 attached to it, and 055 has 3.1, 3.2 and 3.3 attached to it. How can I create these fields in the table? It would be benefical if we could have tick boxes to tick when the criteria is met. When creating field can that field have a field within it? (If that makes sense)!

    I attach what the tutor has as her criteria so it can sort of make sense.

    Any help appreciated
    Thanks
    Andy

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    I avoid 'tick' boxes for data entry.

    I think will need a dependent table for the criteria. Maybe like:

    Student Criteria Element DateComp
    1 054 3.1 1/20/2014
    1 054 3.2 2/10/2014
    2 054 3.1 1/15/2014
    1 055 3.1 2/17/2014
    2 055 3.1 3/8/2014
    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.

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

Similar Threads

  1. student account database
    By jlmyree24 in forum Access
    Replies: 1
    Last Post: 10-24-2013, 12:39 AM
  2. Student Database
    By jlc668 in forum Database Design
    Replies: 2
    Last Post: 10-09-2013, 03:26 PM
  3. Student Enrolment database
    By Sawyer05 in forum Access
    Replies: 6
    Last Post: 07-31-2012, 04:33 AM
  4. Student database....kinda
    By jice89 in forum Access
    Replies: 7
    Last Post: 03-30-2011, 03:33 PM
  5. Student Access user, need help creating a table
    By racheliza79 in forum Database Design
    Replies: 3
    Last Post: 08-07-2010, 01:08 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