Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2021
    Posts
    1

    Create grade card report


    Want to create grade card report in ms access for school. Each student has to take 9 subject, each subject has 6 exams say fa1, fa2, sa1, fa3, fa4 and sa2. Each of these exams are having marks 15,15 and 20

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    You need some of these tables:
    fields with * are keyed.


    tStudents table
    StudentID*
    FirstN
    LastN
    Addr
    City
    etc...


    tTeachers table
    TeacherID*
    FirstN
    LastN
    etc


    tClasses table. (algebra rm101)
    ClassID*
    ClassName
    Subject
    TeacherID
    etc...


    tClassRoster table (all students in 1 class)
    ClassID*
    StudentID*
    Status (dropped, removed,active)
    Memo




    tAssignments table (all work given to students in 1 class)
    AssignID (autonum)
    ClassID*
    AssignName*
    AssignDate
    DueDate
    TotalPoints
    Memo




    tStudentWork table. (the assigment that a student worked on, graded)
    StudenWorkID (autonum)
    StudentID*
    AssignID*
    Points
    Grade
    Memo




    tClassDates table (all dates a class meets. used for attendance)
    ClassDateID (autonum)
    ClassID*
    ClassDate*
    Status (meet, cancelled, holiday)
    Memo


    tAttend table. (student attend that class date)
    ClassDateID*
    StudentID*
    Status (present, absend, excused,sick)
    Memo

  3. #3
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi

    Can you upload a zipped copy of your database?
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

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

Similar Threads

  1. Time Card Report
    By graisbeck in forum Reports
    Replies: 20
    Last Post: 02-04-2021, 03:00 PM
  2. Replies: 6
    Last Post: 01-16-2014, 12:41 PM
  3. Programming a Report Card Application
    By mrovet in forum Programming
    Replies: 1
    Last Post: 06-16-2012, 02:11 AM
  4. Calculate Grade
    By DCV0204 in forum Forms
    Replies: 4
    Last Post: 12-13-2011, 02:59 PM
  5. Student report card design software
    By mado in forum Access
    Replies: 1
    Last Post: 11-27-2011, 04:24 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