rudimentary database form maybe?

Several times a week i have a group of students penning out forms - i then
spend the afternoon typing them all into a spreadsheet or a word table which
i can use as a rudimentary database

I'm looking for a method of using an electronic form for the students to
complete directly

My problem is that several students will be completing their own
form/record/row simultaneously on several different (networked) computers
and need these to appear as seperate records/rows

I can't use Access since the company don't have it installed - but i don't
mind using Word table or Excel spreadsheet

Any ideas?

Hi Jethro,

I assume that you would like to keep this relatively simple. My thoughts are
as follows:-

Create an Excel worksheet with only one worksheet.
Unlock only those cells where the students enter data.
Password protect the worksheet allowing only 'Select unlocked cells'
Save the worksheet in a folder that the students can access and then set
security on the file to read only and also that the students cannot delete
it. (Your Computer Systems Administrator should be able to help you with
this.)
Students could then load the workbook and enter their details and would have
to save it to a new filename (say Student Id.)
You could then have a macro that picks up all workbooks in a specific folder
and copy the required data to a master worksheet.

Now you need to consider how to address any privacy issues. Talk to your
Computer Systems Administrator on this issue to find the best option to suit
you. My preferred method is one whereby the saved files can only be viewed
and accessed by the owner (the person who saved them) but other people like
youself can have full access to all the files in the folder.

Regards,

OssieMac



"JethroUK©" wrote:

Several times a week i have a group of students penning out forms - i then
spend the afternoon typing them all into a spreadsheet or a word table which
i can use as a rudimentary database

I'm looking for a method of using an electronic form for the students to
complete directly

My problem is that several students will be completing their own
form/record/row simultaneously on several different (networked) computers
and need these to appear as seperate records/rows

I can't use Access since the company don't have it installed - but i don't
mind using Word table or Excel spreadsheet

Any ideas?

Hi

Just to add to the advice given here.
Ron de Bruin has some excellent code for merging data from several workbooks
into one.
http://www.rondebruin.nl/copy3.htm
--
Regards
Roger Govier



"OssieMac" wrote in message
...
Hi Jethro,

I assume that you would like to keep this relatively simple. My thoughts
are
as follows:-

Create an Excel worksheet with only one worksheet.
Unlock only those cells where the students enter data.
Password protect the worksheet allowing only 'Select unlocked cells'
Save the worksheet in a folder that the students can access and then set
security on the file to read only and also that the students cannot delete
it. (Your Computer Systems Administrator should be able to help you with
this.)
Students could then load the workbook and enter their details and would
have
to save it to a new filename (say Student Id.)
You could then have a macro that picks up all workbooks in a specific
folder
and copy the required data to a master worksheet.

Now you need to consider how to address any privacy issues. Talk to your
Computer Systems Administrator on this issue to find the best option to
suit
you. My preferred method is one whereby the saved files can only be viewed
and accessed by the owner (the person who saved them) but other people
like
youself can have full access to all the files in the folder.

Regards,

OssieMac



"JethroUK©" wrote:

Several times a week i have a group of students penning out forms - i
then
spend the afternoon typing them all into a spreadsheet or a word table
which
i can use as a rudimentary database

I'm looking for a method of using an electronic form for the students to
complete directly

My problem is that several students will be completing their own
form/record/row simultaneously on several different (networked) computers
and need these to appear as seperate records/rows

I can't use Access since the company don't have it installed - but i
don't
mind using Word table or Excel spreadsheet

Any ideas?

See also http://gregmaxey.mvps.org/Extract_Form_Data.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


JethroUK© wrote:
Several times a week i have a group of students penning out forms - i
then spend the afternoon typing them all into a spreadsheet or a word
table which i can use as a rudimentary database

I'm looking for a method of using an electronic form for the students
to complete directly

My problem is that several students will be completing their own
form/record/row simultaneously on several different (networked)
computers and need these to appear as seperate records/rows

I can't use Access since the company don't have it installed - but i
don't mind using Word table or Excel spreadsheet

Any ideas?