creating a gradebook in access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i'm trying to create a gradebook in access. this is a pretty easy task IF
you know ahead of time how many assignments you will have. is there a way to
enter information into a form that will cause access to add a new column with
predefined properties to an existing table or will cause access to create a
new table?

i'm sure there's an easy solution that i'm just overlooking.

i'm mostly using access 97 with windows 95
 
Actually, you're designing it incorrectly if you've got a separate field for
each assignment. Each assignment should be a separate row in a "child" table
of the "parent" table.
 
Students have assignments.
You need one table for the students. Id, Name, etc.
One table for the asignments. ID, description, date due?, etc.
One table for assignments to students
ID, Assignment ID, Student ID etc.

One form and one subform based on queries will do all that you want to do.

Reports generated from this are straightforward.

There are examples of similar sturctures in the Northwind database and a
massive amount of help in Access itself.

This is Access 101.

I'm blowing steam here but if you expect your students to be able to gain an
education rather than learn by rote memory you should be able to demonstrate
to them that you can RYFM.
 
Access 101?

I've tried to RTFM but I'm still stumped by the following problem. I'm looking to create a grading database for a course which is made up of 23, of which any student will only do 2, 4 or 6. Each unit has a different number of tasks and subtasks - each subtask is a simple boolean to register completion and the task then receives one of three grades - this leads to a grade for the whole unit. So far so easy, I create a table for Students and a table for each of the 23 units including all the assessment criteria. Where I am struggling is in linking the tables together via an Entry table. There is a level of indirection suggested that I just don't understand how to accomplish in Access. In coding terms, I want to create a record entry in the appropriate unit table depending on the unit enrolled in to by the student, and then somehow record the location of that record in the Entry table. Does Access allow this sort of thing?

TIA

Tony Martin
 
Back
Top