Instructor Course Reports

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

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.

Steve




"Billiam" wrote in message
...
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

"Steve" wrote:

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


Steve




"Billiam" wrote in message
...
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

I would suggest either of two possibilities ......
1.

Create a mini Access database that contains normalized tables for the
instructor, class and student data and forms for the instructor to enter the
data. The database needs to be designed so that all 500 instructors can use
the same database. Each instructor would then get a copy of the database.
When an instructor needed to send you data, he would make a copy of the
blank database then enter his data into the copy and send it to you. You
then need a routine in your master database that executes appropriate append
queries that appends the data in the instructor's database into your master
database tables.

2.

You could do the same as described in 1 by giving the instructors an Excel
file. When they needed to send you data, they would fill in a copy of the
blank Excel file and send it to you. You then need a routine in your master
database that could read the Excel file and import the data into your master
database tables.

Neither 1 or 2 are that difficult to implement.

Steve






"Billiam" wrote in message
...


"Steve" wrote:

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


Steve




"Billiam" wrote in message
...
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

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

"Steve" wrote:

I would suggest either of two possibilities ......
1.

Create a mini Access database that contains normalized tables for the
instructor, class and student data and forms for the instructor to enter the
data. The database needs to be designed so that all 500 instructors can use
the same database. Each instructor would then get a copy of the database.
When an instructor needed to send you data, he would make a copy of the
blank database then enter his data into the copy and send it to you. You
then need a routine in your master database that executes appropriate append
queries that appends the data in the instructor's database into your master
database tables.

2.

You could do the same as described in 1 by giving the instructors an Excel
file. When they needed to send you data, they would fill in a copy of the
blank Excel file and send it to you. You then need a routine in your master
database that could read the Excel file and import the data into your master
database tables.

Neither 1 or 2 are that difficult to implement.

Steve






"Billiam" wrote in message
...


"Steve" wrote:

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


Steve




"Billiam" wrote in message
...
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,

I'm sorry but I have no experience in doing this sort of thing over the
internet! However, here are some comments .......
1. Regarding the issue if familiarity, filling in a well designed form in
Excel or Access should not be any harder than filling in an on-line form.
Being that they are instructors, they should be intelligent enough to easily
learn to do it.

2. I recently did a project for a customer where orders were submitted by
email and my program adjusted their inventory kept in Excel when they
received an enail order. I wrote an Excel app where the email order was
copied into Excel and the app automatically adjusted the inventory for each
item in the app. You would need to to write the website part and then wite
something similar to read the email from the instructor and write the data
to you master database.

3. The problem with 2 is that you need a way to distinguish your
instructor data emails from all your other emails.

Steve



"Billiam" wrote in message
...
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

"Steve" wrote:

I would suggest either of two possibilities ......
1.

Create a mini Access database that contains normalized tables for the
instructor, class and student data and forms for the instructor to enter
the
data. The database needs to be designed so that all 500 instructors can
use
the same database. Each instructor would then get a copy of the database.
When an instructor needed to send you data, he would make a copy of the
blank database then enter his data into the copy and send it to you. You
then need a routine in your master database that executes appropriate
append
queries that appends the data in the instructor's database into your
master
database tables.

2.

You could do the same as described in 1 by giving the instructors an
Excel
file. When they needed to send you data, they would fill in a copy of the
blank Excel file and send it to you. You then need a routine in your
master
database that could read the Excel file and import the data into your
master
database tables.

Neither 1 or 2 are that difficult to implement.

Steve






"Billiam" wrote in message
...


"Steve" wrote:

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


Steve




"Billiam" wrote in message
...
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

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
"Steve" wrote:

Billiam,

I'm sorry but I have no experience in doing this sort of thing over the
internet! However, here are some comments .......
1. Regarding the issue if familiarity, filling in a well designed form in
Excel or Access should not be any harder than filling in an on-line form.
Being that they are instructors, they should be intelligent enough to easily
learn to do it.

2. I recently did a project for a customer where orders were submitted by
email and my program adjusted their inventory kept in Excel when they
received an enail order. I wrote an Excel app where the email order was
copied into Excel and the app automatically adjusted the inventory for each
item in the app. You would need to to write the website part and then wite
something similar to read the email from the instructor and write the data
to you master database.

3. The problem with 2 is that you need a way to distinguish your
instructor data emails from all your other emails.

Steve



"Billiam" wrote in message
...
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

"Steve" wrote:

I would suggest either of two possibilities ......
1.

Create a mini Access database that contains normalized tables for the
instructor, class and student data and forms for the instructor to enter
the
data. The database needs to be designed so that all 500 instructors can
use
the same database. Each instructor would then get a copy of the database.
When an instructor needed to send you data, he would make a copy of the
blank database then enter his data into the copy and send it to you. You
then need a routine in your master database that executes appropriate
append
queries that appends the data in the instructor's database into your
master
database tables.

2.

You could do the same as described in 1 by giving the instructors an
Excel
file. When they needed to send you data, they would fill in a copy of the
blank Excel file and send it to you. You then need a routine in your
master
database that could read the Excel file and import the data into your
master
database tables.

Neither 1 or 2 are that difficult to implement.

Steve






"Billiam" wrote in message
...


"Steve" wrote:

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


Steve




"Billiam" wrote in message
...
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" wrote in message
...
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

Another suggestion ......

When you create your web form, set it up to put Only the data in the email
body. When you receive the email, you can then use Control - A to highlight
the body of the email and then Control - C to copy the body of the email.
Then you can paste the data into whatever you have set up in the master
database for getting the data into your tables.

Steve




"Billiam" wrote in message
...
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
"Steve" wrote:

Billiam,

I'm sorry but I have no experience in doing this sort of thing over the
internet! However, here are some comments .......
1. Regarding the issue if familiarity, filling in a well designed form
in
Excel or Access should not be any harder than filling in an on-line form.
Being that they are instructors, they should be intelligent enough to
easily
learn to do it.

2. I recently did a project for a customer where orders were submitted
by
email and my program adjusted their inventory kept in Excel when they
received an enail order. I wrote an Excel app where the email order was
copied into Excel and the app automatically adjusted the inventory for
each
item in the app. You would need to to write the website part and then
wite
something similar to read the email from the instructor and write the
data
to you master database.

3. The problem with 2 is that you need a way to distinguish your
instructor data emails from all your other emails.

Steve



"Billiam" wrote in message
...
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

"Steve" wrote:

I would suggest either of two possibilities ......
1.

Create a mini Access database that contains normalized tables for the
instructor, class and student data and forms for the instructor to
enter
the
data. The database needs to be designed so that all 500 instructors
can
use
the same database. Each instructor would then get a copy of the
database.
When an instructor needed to send you data, he would make a copy of
the
blank database then enter his data into the copy and send it to you.
You
then need a routine in your master database that executes appropriate
append
queries that appends the data in the instructor's database into your
master
database tables.

2.

You could do the same as described in 1 by giving the instructors an
Excel
file. When they needed to send you data, they would fill in a copy of
the
blank Excel file and send it to you. You then need a routine in your
master
database that could read the Excel file and import the data into your
master
database tables.

Neither 1 or 2 are that difficult to implement.

Steve






"Billiam" wrote in message
...


"Steve" wrote:

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


Steve




"Billiam" wrote in message
...
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