creating a gradebook in access

M

matthew nance

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
 
D

Douglas J. Steele

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.
 
M

Mike Painter

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.
 
Top