> 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