Questionannaires

[COMP]

Hi, i am trying to create forms and graphs based on some questionnaires i have. Now normally i would use excel, however i have been told to use Access. Now i have tried to enter in the questions into the field name however it only allows a certain number of characters. Is there a way of increasing this or is there a standard of how to create questionanires in access??

thanks

 

[DCrake]

Because Excel is far more proficient at creating graphs, and as instructed you have been told to use Access. Why don't you create the graphs in Excel using data generated by Access. Get Access to populate the Excel Data and switch to Excel for viewing purposes only. You could take it one step further and send your graphs to Powerpoint and create a presentation out of it.

David.

 

[COMP]

Hi DCrake,

that sounds like a good idea. i am having trouble putting the data in access as the way i am thinking of structuring the data is by putting the questions in the field name then have a dropdown list with the optional answers. However i cant get the whole question in the field name as it is restricted. Is there a way of oversoming this?? if not is there an alternative?

thanks

 

[dbDamo]

Can't you just name the question fields 'Q1', 'Q2' etc and then add a text box in design view to add the question?

Access only allows a 64 character field name.

 

[DCrake]

As suggested each question should have a question number, and each question should have an answer, even if this answer is N/A or unanswered. Then you need to set up a questions table, In this table will be a primary key, a brief description, and an optional extended description. You should then use this table to populate your output.

David