Hi, I need some help/advice on what is best to do.

I have to create a database to hold information from questionnaires, should I use access? If so, how do I go about creating the table? The questions have several different answers, is the best way to enter the data just be entering the information chosen? I'm new at this not entirely sure what it is I need to be doing, any advice, help, links etc will be greatly appreciated

Thanks I think the best thing for you would be to use excel.
I had do create a similar document.

Use the top row for the questions, and the first column (A) for the people's names if needed. Then beneath the corresponding question you can type in the answers.

Maybe after you have all your information you could transfer it to Access.

Hope this helpsWell the other thing is that I think I need to use the report facilities of access to be able to make the graphs and pie charts, I've had a play around with it but I cant seem to get them to work very well. Thank you fro the advice. If you are wanting to do graphs and charts then your only BET is Excel. I have done courses on these applications and as FAR as I know Access does not offer these functions.

Give excel a try, I'm sure you'll find it a lot easier!The choice of Excel or Access is going to depend on your preference, knowledge, and whether you're willing to SPEND time learning whichever application you choose.

From a technical viewpoint, Access is probably the better choice. Collecting data from questionnaires is more of a database application than a spreadsheet application. But, from a practical viewpoint, Excel can be adapted to such a task, as lau said, and the learning curve may be steeper with Access. Therefore, you may want to choose Excel.

And, regarding graphs and pie charts, if I used Access to capture the data, I'd most likely export it to Excel, which is very easy to do, and use Excel for the graphs and pie charts.

Is this project you're working on a one-time task or might you be doing more of this in the near future. You might weigh this factor in deciding whether to use Excel or Access.

Hi there, If I was working to your requirements Access would be my choice. HOWEVER, you sound relatively new to both Excel and Access and so out of the two you should use Excel. It can be used in a very basic way if you wish and will be easy when you come to the bit where graphs or charts are needed. Microsoft office does have a fairly good help facility so if you are prepared to sit and read for a while you should be able to have a good go at it

Cheers,

Graham.use excel, its ALOT easier to use and in a way it saves time.no way use access for sure.

maybe this video will show you how easy it is.

http://beyourownit.com/videos/howtouseaccess.html


I would be glad to help further.

if you ever want to be able to do anything with your data use access.Well, I see uberpirate is getting conflicting OPINIONS here, and he/she may be getting a bit FRUSTRATED with this thread. I think my and Graham's replies were the best ones.
Quote from: beyourownit on March 18, 2008, 09:45:12 PM

no way use access for sure.

maybe this video will show you how easy it is.

http://beyourownit.com/videos/howtouseaccess.html


I would be glad to help further.

if you ever want to be able to do anything with your data use access.