rudimentary database form maybe?

  • Thread starter Thread starter =?iso-8859-1?Q?JethroUK=A9?=
  • Start date Start date
?

=?iso-8859-1?Q?JethroUK=A9?=

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
 
Back
Top