Instructor Course Reports

[Billiam]

I have 500 instructors that are using a form to track up to 40 students marks
per course taught. They can teach up to three different courses in one
session. I would like to be able to have a chart style form which can be
filled in by the instructor and sent to me where Access will automatically
extract the data and place it in my tables. In access 2007, they do offer a
feature like this, but there is not enough control over the form design that
I know of. Does anyone have any suggestions as to the best way to accomplish
this?

Just to clarify, I would have student name 1, a possible mark in any to all
of the three classes, possible check mark yes/no would work. The top of the
sheet would only have to be filled out once wih detatils such as Instructor
name, class size, class location etc.

Thanks for any help!
Billiam

 

[Billiam]

The first question for you is are you on a network with the 500 instructors?
If you are, everyone can share a common set of tables.

No, we are not on a network. They are spread over a very large distance, and
many are not computer savy...that is why we hoped all they would have to do
is send an e-mail form back which I/Access could open and incorporate the
data. It does not look like I can modify the e-mail form to accomplish what I
need, which is a page with all the Instructor and course details at the top
of the page, and 40 individual student records which include the type of
course(s) taken, and their respective marks.
Thanks,
Billiam

 

[Billiam]

Thank you Steve for the great suggestions. I think the access route might be
easier, unless the 500 instructors do not need to have a copy of Access
2007...

Steve, if we had a website which the instructors could login to, could we
put the form for submission there. Would that require major knowledge of
ASP/HTML???

As not all instructors have Excel or Access, I am looking for the
easiest-cheapest way to do this...also, 99.8% are unfamiliar with Access, and
probably 60% are unfamiliar with Excel. If I could give them something they
could fill in online, which could then be sent to me, or become part of an
online database for the instructors, i think that might be easier for them?

Thanks again for your great help!
Billiam

 

[Billiam]

Great points...as for #2, a specific I am thinking of a specific e-mail
address which is only used for the purpose of receiving those e-mails...

Thanks again for your advice and help, I really appreciate it!
Billiam

 

[John... Visio MVP]

Great points...as for #2, a specific I am thinking of a specific e-mail
address which is only used for the purpose of receiving those e-mails...

Thanks again for your advice and help, I really appreciate it!
Billiam

Careful, Stevie is a known troll who provides psuedo help in an attempt to
con unsuspecting posters into paying him for work of questionable quality.

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who glady will help for free.
Stevie is not one of them. He is a long term troll with dillusions of
competency in Access, Word and Excel who likes to prey on unsuspecting
posters. If he was any good, the supposed thousands he has helped would be
swamping him with repeat business. The fact that he needs to grovel for work
indicates that few ( if any ) of his customers considered the quality of his
work worth a second chance.


As to your real problem, you mentioned you use a form. Can you give more
details on the form you use or are you just speculating on how you want
things to work.
Things to consider:
1. It is possible to create a form in Outlook that can be easily read by
Access
2. A "form" can be created in Word or Excel and sent as an attachment
3. The "form" can create an XML file that can be easily sent as an
attachment or embedded in an email.
4. Try and avoid sending free form information that requires disection.

There are several other ways of doing this. There are also many individiuals
who gladly will help for free. If you decide to hire someone, make sure you
check them out first.

John... Visio MVP