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
Bookmarks