Results 1 to 2 of 2
  1. #1
    Sawyer05 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2012
    Posts
    9

    Student Class Options

    i'm developing a student database for a college to hold student, course and class information.

    Students have a choice of 4 different classes per block, and there are 3 blocks a year, so they will get 3 choices of 4 classes per year.

    I need a form that will hold this information that i can view all the classes being taken that block, and to be able to store information of the classes taken in a previous block.

    In my ClassAssignment table, I have these fields

    {AssignmentID,Option_ID,Student_ID,Block,Period}



    To do what im planning would i be better to have {Period1,Period2,Period3,Period4}?

    I really can't figure out how to store this information so any advice you guys can give me would be great!

  2. #2
    recyan's Avatar
    recyan is offline Expert
    Windows 2K Access 2000
    Join Date
    Dec 2011
    Posts
    662
    A few questions, perhaps, the answers might come in helpful to others to help :
    Student
    Course
    Class
    Block

    One STUDENT can take multiple CLASSES per BLOCK.
    What is CLASS? Can you elaborate ?
    Can a STUDENT repeat or enrol for the same CLASS in another BLOCK ?

    There are 3 BLOCKS per YEAR.
    Does this mean,
    Jan 1, 2012 to Apr 30,2012 is the 1st block,
    May 1, 2012 to Aug 31,2012 is the 2nd block,
    Sep 1, 2012 to Dec 31,2012 is the 3rd block


    Is there a possibility of the BLOCK range definition changing in the long run?

    What is COURSE and what is it's relationship with STUDENT or COURSE if any?

    Along with the answers to above, if possible, attach your present table relationships.

    Thanks

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

Similar Threads

  1. Managing a CPR class
    By DiPietro14 in forum General Chat
    Replies: 1
    Last Post: 02-06-2012, 06:02 PM
  2. student question
    By scarlettera in forum Access
    Replies: 7
    Last Post: 03-27-2011, 12:03 PM
  3. Class Method
    By AndreT in forum Programming
    Replies: 3
    Last Post: 01-20-2011, 02:18 AM
  4. Class in Access
    By Huddle in forum Access
    Replies: 2
    Last Post: 07-15-2010, 04:08 PM
  5. Student warning system
    By spqr in forum Database Design
    Replies: 1
    Last Post: 03-17-2010, 10:45 AM

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