Looking For More Efficient Data Entry

[Maria]

One of my duties is to record student grades each report period(6). The
tables in the database basically look like:
TblStudent
StudentID
Name
etc

TblStudentGrade
StudentGradeID
GradePeriod
StudentID
Grade

The way the tables are, I need to enter the student each grade period. The
students are essentially the same students each period so my thinking is I
should only need to add new students and drop students who have left the
class. If the form was in a grid or matrix, I could have the name in the
first column and successive grade periods in the next six columns. Is there
a way to do this?

Thanks!

Maria

 

[Larry Linson]

One of my duties is to record student grades each report period(6). The
tables in the database basically look like:
TblStudent
StudentID
Name
etc

TblStudentGrade
StudentGradeID
GradePeriod
StudentID
Grade

The way the tables are, I need to enter the student each grade period. The
students are essentially the same students each period so my thinking is I
should only need to add new students and drop students who have left the
class. If the form was in a grid or matrix, I could have the name in the
first column and successive grade periods in the next six columns. Is there
a way to do this?

Sounds as if you might like a spreadsheet better.

There are "grid controls" for other programming languages, but none that can
be bound to Access data in an Access application, AFAIK.

Do you need to see all the students and all the grade periods on the same
form to enter a grade for the current period? Pivot tables or cross-tab
queries would let you, without much trouble, structure a report that way.
But seems to me you only need to step through all the students one by one to
enter the grade(s) for the current period.

A main form by student will allow you to add/delete students and navigate
from student to student, and a subform would let you enter the grade for
this period... if you want to see all the grades for that student, use a
continuous forms view in the subform.

Larry Linson
Microsoft Access MVP

 

[Larry Linson]

"Maria" wrote

One of my duties is to record student grades each report period(6). The
tables in the database basically look like:
TblStudent
StudentID
Name
etc

TblStudentGrade
StudentGradeID
GradePeriod
StudentID
Grade

The way the tables are, I need to enter the
student each grade period. The students are
essentially the same students each period so
my thinking is I should only need to add new
students and drop students who have left the
class. If the form was in a grid or matrix, I could
have the name in the first column and successive
grade periods in the next six columns. Is there
a way to do this?

First, there's nothing about your table design that forces you to "enter the
student each grade period" -- you didn't describe whether you are entering
data in datasheet view, or in a form, but see below.

Sounds as if you might like a spreadsheet better.

There are "grid controls" for other programming languages, but none that can
be bound to Access data in an Access application, AFAIK.

Do you need to see all the students and all the grade periods on the same
form to enter a grade for the current period? Pivot tables or cross-tab
queries would let you, without much trouble, structure a report that way.
But seems to me you only need to step through all the students one by one to
enter the grade(s) for the current period.

A main form by student will allow you to add/delete students and navigate
from student to student, and a subform would let you enter the grade for
this period... if you want to see all the grades for that student, use a
continuous forms view in the subform.

Larry Linson
Microsoft Access MVP

 

[Mike Painter]

One of my duties is to record student grades each report period(6).
The tables in the database basically look like:
TblStudent
StudentID
Name
etc

TblStudentGrade
StudentGradeID
GradePeriod
StudentID
Grade

The way the tables are, I need to enter the student each grade
period. The students are essentially the same students each period so
my thinking is I should only need to add new students and drop
students who have left the class. If the form was in a grid or
matrix, I could have the name in the first column and successive
grade periods in the next six columns. Is there a way to do this?

I've done this in code.
I create a "flat file" table where the data is entered and use an update
event to add/edit/delete the relational tables that were used for reporting.

The client demanded it because their atterndance record "always" looked like
that. Mostly a lot of busy work but there was some fun in it and I got paid
a lot more.

You would be better off with a form/subform showing the students in a
listbox on the main form and linking the subform to that student.