Results 1 to 3 of 3
  1. #1
    Brightspark98 is offline Advanced Beginner
    Windows 7 64bit Access 2013 64bit
    Join Date
    Dec 2016
    Posts
    57

    Another Student/Subject/Class Question

    Hi,

    Can anyone point me in the right direction.

    I currently use excel to plan classes for a year in advance.

    Row Headings = Student name, Column Headings = Date, Cross Ref = Subject

    There is only 1 subject per week so that would be 52 entries per student - easy in excel just a cross in a box.

    How would I do this using Access.

    I have database with separate tables for studentInfo, SubjectInfo but with the table I have created,

    StudentID---WeekNo---Subject

    For 100 students would mean 5200 entries if I wanted to plan a year ahead.

    I'm sure I must be going about this the wrong way!

    Any help would be greatly appreciated.

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    'StudentID---WeekNo---Subject' is the probably the right way to go. For 100 students there's 5200 entries regardless of whether you use Excel or Access, what matters more is how you enter the data to populate the records. If there are null weeks where students do not have a subject (or a subject does not have students), then access will have fewer records.

    With access you can choose a subject, then select the week numbers it will be 'in session' and then select the students for that subject

    or choose a student, then select the subjects they will be doing.

    There are other ways, but your description is incomplete - do students do the subject for the full year, or every other lesson or only for three months? or just attend one session?
    Are subjects limited by class size?
    Do subjects run for a full year or only certain times?
    etc

  3. #3
    Brightspark98 is offline Advanced Beginner
    Windows 7 64bit Access 2013 64bit
    Join Date
    Dec 2016
    Posts
    57
    Hi thanks for the prompt reply.

    There are 12 subjects each is three or four weeks in duration, approximately 12 students per class, students do not repeat the subject they attend for 1 month and that module is complete.

    Thanks

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

Similar Threads

  1. Replies: 25
    Last Post: 11-23-2014, 02:43 PM
  2. Replies: 2
    Last Post: 07-21-2014, 08:47 AM
  3. mailto with Subject
    By umarus in forum Programming
    Replies: 4
    Last Post: 12-20-2012, 12:58 PM
  4. Student Class Options
    By Sawyer05 in forum Access
    Replies: 1
    Last Post: 08-09-2012, 06:08 AM
  5. student question
    By scarlettera in forum Access
    Replies: 7
    Last Post: 03-27-2011, 12:03 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