NigelLloyd
Technical User
I am an intelligent layman, and a beginner at Access (2000). I would like to design an Access form as a questionnaire, so that:
1. I send it as an email attachment to respondents,
2. they can fill it in and email it back,
3. I add it as a new record to my database.
I haven't a clue how/where to begin. Problems I foresee:
- what if the respondent doesn't have Access 2000 (maybe has '97 or nothing at all)?
- will it be possible to make the questionnaire 'idiot proof' - I hate filling in people's application forms that go wrong?
- how do I keep a separation between the blank form which I send out, the single completed forms which are returned and the database of all the forms/records returned so far?
- how do I enter the returned form into the database?
- how do I give a unique reference (key?) to each record?
I'm sorry that I need help on what must be the most standard of Access applications. If you could point me towards a textbook or give me monosyllabic advice, I would be most grateful
1. I send it as an email attachment to respondents,
2. they can fill it in and email it back,
3. I add it as a new record to my database.
I haven't a clue how/where to begin. Problems I foresee:
- what if the respondent doesn't have Access 2000 (maybe has '97 or nothing at all)?
- will it be possible to make the questionnaire 'idiot proof' - I hate filling in people's application forms that go wrong?
- how do I keep a separation between the blank form which I send out, the single completed forms which are returned and the database of all the forms/records returned so far?
- how do I enter the returned form into the database?
- how do I give a unique reference (key?) to each record?
I'm sorry that I need help on what must be the most standard of Access applications. If you could point me towards a textbook or give me monosyllabic advice, I would be most grateful