473,320 Members | 1,939 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Looking For More Efficient Data Entry

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
Nov 13 '05 #1
4 2009

"Maria" <ml*******@csonline.net> wrote in message
news:2C*****************@newsread3.news.atl.earthl ink.net...
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
Nov 13 '05 #2
"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

Nov 13 '05 #3
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?

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.
Nov 13 '05 #4
Your table structure is correct -- it may be tempting to make a table
with six fields for the six periods per student, but your method
offers the best flexibility over the long term. However (as you have
discovered), data entry is made more difficult using this "normalized"
structure.

I think that you have two alternatives:
- use a temporary table for data input with six columns for the six
periods, and write some VBA code to transfer from the temporary table
to the permanent (existing) table at some point in time.
Alternatively, you could enter the six grades into unbound textboxes
on the main form, and transfer them to the table using VBA code.

- modify your data-entry procedure. Instead of trying to enter all
periods for a single student, try entering all the students for a
single period. You could build a form/subform in which the period was
selected in the main form, and the subform would show all the
students' grades for that period. You could populate the table with
blank records for each student for the selected period so that you
would not have to manually create each student's record for that
period. This could be done with VBA on a command button, or when you
select the period (say, from a combo box), or when the subform gets
focus.
On Sun, 05 Sep 2004 02:12:14 GMT, "Maria" <ml*******@csonline.net>
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?

Thanks!

Maria

**********************
ja**************@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
Nov 13 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

22
by: Martin MOKREJ© | last post by:
Hi, I'm looking for some easy way to do something like include in c or PHP. Imagine I would like to have: cat somefile.py a = 222 b = 111 c = 9
2
by: scadav | last post by:
I am new to Perl and I am trying for figure out how to solve this problem. If anyone can give me some suggestions, I would greatly appreciate it. I am trying to read a log file and generate...
1
by: Simeon Nevel | last post by:
As a personal exercise, I'm trying to create a call tracking DB for my own use at work. Here's an abbreviated version of the database layout: Company: CompanyID - Primary Key (Text Length...
116
by: Mike MacSween | last post by:
S**t for brains strikes again! Why did I do that? When I met the clients and at some point they vaguely asked whether eventually would it be possible to have some people who could read the data...
10
by: Teis Draiby | last post by:
In an application manipulating streaming video and 3D stuff I want to implement mutithreading to ensure a decent UI response time. Since my application is very speed critical I want to use the...
10
by: Bonj | last post by:
I almost understand TSTs, to the point where I just need to know the answer to this: When making a TST (in C++) that will have as its leaf nodes words that make up SQL language and an categorising...
23
by: walterbyrd | last post by:
Way back when, I got a lot of training and experience in highly structued software development. These days, I dabble with web-development, but I may become more serious. I consider php to be an...
1
by: joshai | last post by:
Hi, I'm pretty new to the php/mysql world and am building an article database for a website with multiple content types. I have an entry screen built that allows the site owner to enter articles,...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.