By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,392 Members | 1,556 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,392 IT Pros & Developers. It's quick & easy.

Student Coursework - Grading System

P: n/a
Hi, I am a first time poster here. I have been given an assignment to do
from college and it is ot create a student gradebook. I have planned all the
tables etc. to what I believe to be correct. I have also set the
relationships etc.

I have three tables here that are causing the most problems. These are:

Students - contains information on students
Assignments - this is the actual work the students should be doing
Results - These are the results of the assignments (there are three fields:
result id, student and assignment)

The biggest problem I am having is trying to create a form that actually
looks like a teachers' gradebook. For example assignments aligned
horizontally across the top and the students names vertically aligned on
the left with the results matching in a gridlike section between. I hope
that make sense to you... I was thinking that the assignments FORM could
have a sub form on it which lists the students and one text box where I can
input the grade for that assignment. Is this possible?

Louis
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
> input the grade for that assignment. Is this possible?

Yes, it is possible.

Access is not inherently 2-dimensional, like a spreadsheet,
so making forms with 2 data dimensions is more work.

Instead, Access is inherently list-oriented and multi-dimensional,
so it is easier to build systems with 3+ data dimensions. The
harder stuff is easier, but the easy stuff is harder, when compared
to a spreadsheet.

There is NO GOOD EASY WAY to do a general student gradebook in Access.

Three of the choices you have are: (1) Pretend it's a spreadsheet.
Create a table with Assignment ID as field names. (2) Use extensive
VBA to reformat a form to get the assignment and student ID's onto
a form that looks like a spreadsheet, and allows data entry, or
(3) Use a separate data entry form and data display form.

Since this is a student project, let's assume that you want method
(3), with minimum work. So: For data display, use a CROSSTAB QUERY.

For data entry, use an separate form, with no connection to the
display. Force the user to select student and assignment from a
drop down list, or some other method. Just write the data into
the results table.

(david)
"Louis" <lo***@NOSPAMplatt1985.fsnet.co.uk> wrote in message
news:c9**********@newsg1.svr.pol.co.uk...
Hi, I am a first time poster here. I have been given an assignment to do
from college and it is ot create a student gradebook. I have planned all the tables etc. to what I believe to be correct. I have also set the
relationships etc.

I have three tables here that are causing the most problems. These are:

Students - contains information on students
Assignments - this is the actual work the students should be doing
Results - These are the results of the assignments (there are three fields: result id, student and assignment)

The biggest problem I am having is trying to create a form that actually
looks like a teachers' gradebook. For example assignments aligned
horizontally across the top and the students names vertically aligned on
the left with the results matching in a gridlike section between. I hope
that make sense to you... I was thinking that the assignments FORM could
have a sub form on it which lists the students and one text box where I can input the grade for that assignment. Is this possible?

Louis

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.