Results 1 to 3 of 3

Access or Excel

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-24-2011
    Location
    Van Wert, Ohio
    MS-Off Ver
    Excel 2010, 2000
    Posts
    104

    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
    Attached Files Attached Files
    Last edited by gocolonel77; 09-24-2011 at 10:17 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1