Thread: Access or Excel

I am pretty efficent with Excel, but I am wondering if what I want to do would be better served with Access.

I work in a restaurant and my customers call a 800 number and take a survey.

They rate 6 categories and can choose a score of 1 thru 7 for each category. 1 bad, 7 great. With that info it generates a percentage of score.

Each week I recieve my scores. It showes dates and times customers visited and breakes down each score in each category along with the overall percentage.

I take my schedule and match the results with who was working.

I want to be able to enter category scores and percentages according to person, then be able to generaate overall reports as a group.

I would also like to be able to filter scores according to date or time. So for instance, I will be able to find out if monday's generate bad scores or by time of day.

I will attach a pdf of a results sheet I receive each week. I also attached an excel file I have been using to keep track.

I want to be more efficent and track more results. Is Access my answer, or should I keep working with Excel?

Thanks in advance

Here is a White Paper on the subject.

http://forums.aspfree.com/microsoft-...el-349267.html

Alan