Help with multi-user database design

[macca]

I want to have a database that stores the records of a number of people who
are going to complete a survey.

I will be using a network of 10 PC's and want these users to come in and
simultaneously access the database via some data entry type form and
complete their own survey form i.e. fill in items such as their names,
address and their responses to various questions.

I want the users to have their responses added as a record to the main
database. Later I want to be able to analyse these answers.

So I guess there will be the issue of allowing multiple access to the
database. I am presuming that MS Access would be appropriate.

Can you advise me of a gereral strategy for me to get going with this
project?

 

[Roxie Aho]

Access should work well.

1. Create your database application.
2. Split the database. Tools>Database Utilities>Database
Splitter.
3. Put the back end on your server.
4. Make a .mde file (forms, etc, can't be modified).
Tools>Database Utilities>Make MDE file.
5. Put the .mde on each of the 10 PCs. (The PC has to
have Access installed. Otherwise YOU have to work in
Developer Edition and make a run-time executable for each
PC.)

I assume you will have many people filling out the survey
at each PC, not just one user at 10 PCs. If the latter, I
recommend paper and pencil.

Roxie Aho