Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers,microsoft.public.word.newusers,microsoft.public.word.tables
|
|||
|
|||
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? |
#2
Posted to microsoft.public.word.newusers,microsoft.public.word.tables,microsoft.public.excel.newusers
|
|||
|
|||
rudimentary database form maybe?
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? |
#3
Posted to microsoft.public.word.newusers,microsoft.public.word.tables,microsoft.public.excel.newusers
|
|||
|
|||
rudimentary database form maybe?
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? |
#4
Posted to microsoft.public.excel.newusers,microsoft.public.word.newusers,microsoft.public.word.tables
|
|||
|
|||
rudimentary database form maybe?
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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
word form letters from access database over the network | Mailmerge | |||
Keep Database Merged to Form Letter | Mailmerge | |||
Create Form For Access Database | Microsoft Word Help | |||
Linking Access database to Microsoft Word form | Microsoft Word Help | |||
Form Letter Mail Merge using field code: {Database} | Mailmerge |