Results 1 to 3 of 3
  1. #1
    khughes46 is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Grapevine, TX
    Posts
    231

    Teacher/Student Schedule

    I am trying to build a Teacher/Student Schedule where the teacher may have more than 1 student, the student may have more than 1 teacher, and both may have more than 1 subject to schedule. The schedule must have date and time entries built in certain blocks of 1 hour each before noon and 40 minute blocks after noon. Any suggestions or tips would be helpful. The tables I have so far are for teachers, students and subjects. Thanks, Ken

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    each course has many classes
    each Class has a list of students.
    the class then has assignments (tWork) ,tests, etc.
    the student is graded on the assign and graded (tStudentWork)


    tCourses
    -----------
    CourseID (auto)
    subject
    CourseType



    tStudents
    --------------
    StudentID (autonumber)
    FirstN
    LastN
    Addr
    City
    St
    Zip
    phoneH


    tClasses (classes offered, Sci101, Tri202)
    ----------
    classID (auto)
    courseID
    semester
    Subject
    Room#
    TeacherID
    ClassTime



    tClassRoster (students in 1 classroom)
    --------------
    RosterID (auto)
    ClassID (long)
    StudentID (long)
    FinalGrade



    tWork (all tests,quizes given to class)
    ----------
    WorkID (auto)
    RosterID
    WorkType (test,lab,quiz)
    GradePts



    tStudentWork (grade student got on test)
    -------------
    StudentWorkID
    StudentID (long)
    WorkID
    Grade



    tAttend (attendance per class)
    ---------
    AttendID
    StudentID
    ClassDate
    Present (T/F)

  3. #3
    Bulzie is online now VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    Seems like you are close, tables for the individual recordsets (Teacher(TeacherID), Student(StudentID), Subject(SubjectID)) and your main Schedule table would have:
    ScheduleID(autonumber), SubjectID, TeacherID, StudendID, ClassDate, ClassTime(from combo box below), {any ofther fields related to this specific event datetime that could vary such as max class size, location of class, etc.}

    For the specific times ("blocks of 1 hour each before noon and 40 minute blocks after noon."), create tblClassTime and list out only the times you want them to use.

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

Similar Threads

  1. Seeking Mentor/Teacher
    By Meat4grinder in forum Access
    Replies: 1
    Last Post: 03-14-2015, 02:14 PM
  2. Teacher Subject Allotment Database
    By grieve_physics in forum Access
    Replies: 2
    Last Post: 11-05-2014, 08:12 AM
  3. Replies: 2
    Last Post: 07-21-2014, 08:47 AM
  4. Databse design for a teacher application
    By James89 in forum Database Design
    Replies: 6
    Last Post: 04-18-2012, 08:54 AM
  5. Substitute Teacher in need of answer key!
    By misssunshine1973 in forum Access
    Replies: 4
    Last Post: 05-14-2009, 02:25 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