Documents with multiple choice fields

[woodpam]

I work for a not for profit organisation and we are trying to devise a means of creating a CV for a school leaver looking for a job by the user selecting choices from drop down menus, ie we would have all the local schools and colleges available to choose from in the Education section and the means of choosing subjects and grades to list. It's especially for students with disabilities. Can anyone tell me how to make this happen with Microsoft Office products or point me in the right direction please?

[rinkytink]

You could do something simple in Excel.
Here's how to create drop-down lists.
Open a new Work book.
In the first cell of a column type in a heading such as 'School Name'.
Click the cell directly below this and then go to the toolbar at the top and select data....validation.
From the box that appears select the settings tab and for the validation criteria select list.
In the source box type in School A, School B, School C etc.
Click O.K.
Now when you click on that cell you will be given a drop down list of the schools you have entered. You can click on the corner of the cell and drag it down across all of the cells below and it will auto fill the with the list.
Alternatively you could do something similar like this.

Open a new Work book.
Ensure that you have the formula toolbar showing - view....toolbars....formula.
On the second worksheet create your list of schools like this: School A in Cell A1, School B in Cell A2, School C in Cell A3 etc.
Select all of the cells. At the left end of the formula tool bar is a box called the name box. Type a name for you range of cells in here.
On the first worksheet, in the first cell of a column type in a heading such as 'School Name'.
Click the cell directly below this and then go to the toolbar at the top and select data....validation.
From the box that appears select the settings tab and for the validation criteria select list.
In the source box type = 'the name of your range'
Click O.K.
Now when you click on that cell you will be given a drop down list of the schools you have entered on the second worksheet.
You can click on the corner of the cell and drag it down across all of the cells below and it will auto fill the with the list.
You can created all of you other drop down lists in the same way.

[rinkytink]

Sorry forgot to add. You can then protect the sheet with all of your named ranges on by going to tools....protection....protect sheet and then define the level of protection and password. You can also hide the sheet by going to format....sheet....hide.

[darth vader]

alternative B write a webpage which asks for the questions with drop down lists, the page would generate a report, file, printout (whatever) on hitting OK (or alternatively you could have all options as buttons!), with the choices implemented. Could be written in Javascript or VBScript - neither of these are rocket science and can be picked up using a "dummies guide to..." or get a 14 year old computer-holic to write one for you. honestly they take 5 minutes to write and my son could do it. In fact if you send a spec. i'm sure he'd do it for something to do other than play comp. games for a change, he's always writing websites for a laugh

[woodpam]

I really appreciate the time and expertise you have put into answering this - we are now considering our options and hope to get something up and running in a couple of weeks, fingers crossed!