If you need to know what your customers or your employees are thinking, a survey is a good way to solicit honest feedback and get a true picture of where you stand. You can use Microsoft Access to create that survey and get the information you want. The key to successfully creating a survey database in Access is to plan ahead by sketching out each question ahead of time. Once you have a full list of the questions you want to ask, you can build those questions into the database and make the answers you receive more valuable.
- Skill level:
Other People Are Reading
Write down a list of questions you want to ask. Try to make the survey as inclusive as possible, without making it too long or cumbersome for users to complete.
Create a list of possible responses for each question. For instance, a question about the quality of customer service in your company could include responses like, Excellent, Very Good, Good, Acceptable and Poor.
Open Microsoft Access and create a separate table for each set of responses you want to include in your database. If several questions share the same possible responses, you can use a single table for all those questions. For instance, your survey may include several questions whose responses range from Excellent to Poor. You can create a single table called Quality. Populate that Quality table with the responses, Excellent, Very Good, Good, Acceptable and Poor.
Create a table for your survey questions. Use short titles for your field names, avoiding spaces between the words whenever possible. For instance, a question about customer service quality could use CustServ for the field name. Use the description section within the table structure to type a lengthier explanation of the field and its contents.
Go to the "Forms" section of Access and create a data entry form for your survey database. You can use the form wizard to create the form quickly, or you can use design view to open a blank grid and drag each field you want to use into the data entry form. In either case you need to specify the table you want to base that data entry form on. Choose the table that contains your actual survey questions.