Access 2002: Data Entry Survey Program.

I have a VB program that I wrote to help me gather data. This program is very basic. You put data into the box it compute it adds it to a text file.

I then take this information after all my data is together and put it in an excel spreadsheet.

I am posting a zip file that has the VB prog and the excel file in it. Can someone please help me build this into an access file.

I have confused my self so I basicly discarded all previous tries and will start anew from your suggestions.

Thanks for any help.

build into an access file??

you mean create a database? or use a database to store the data instead of
an excel sheet?

Do you want to move just the data storage into the database, or do you also want to have the data entry from converted to an Access Form?

Also, can you add an attachment with the Excel File?

I want everything to be in database. The ability to do the chart. The data entry everything.

Can you add an attachment with the Excel File?

And also a screenshot of the entry form. I don't have VB, only VBA, so can't open it.

Here is the excel program. It is in the.txt format. Change it to .xls to get it back to excel.

The screen shots are in word.

Put the Excel file into a zip file and tehn upload the zip.

Changed

OK, the first thing you're going to have to do is decide on your database design.

Here's some ideas/questions to get you started.

Is the list of questions fix, or might there be a need in the future to add/remove/change the questions?

Same as above but for question categories rather than just questions.

Do you need to record which cabin/room/whatever the customer/survey participant was staying in?

Do you need to record any info about the customer/survey participant?

Starting to think through these types of questions will help you decide on the table structures that you will need.

These are fixed questions.

I do not need a record of where the guest stayed

No information other than the numerical response.

Quote:

---

No information other than the numerical response.

---

I'm sorry but that incorrect. From the spreadsheet I can see that you at least need to capture the date that the survey was taken. :bigyello:

If the questions are locked then you really only need a single table, which will hold the survey results.
Are you set on using Access?
I ask this because a single table solution would be a lot easier to achieve in Excel.

No I'm not set having to use Access. I just thought it would be easier to do with inputing the data and showing format instead of using 2 different programs for that.

I was using excel only to start off with but I was having to go int and input the data like = 5+5+4+6+7...... Which was a pain.


Just let me know how you think it is best served.