+ Reply to Thread
Results 1 to 3 of 3

Access or Excel

Hybrid 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.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Access or Excel

    As per my understanding of your data, excel will work for you. You can create pivot tables to get the desired results like percentages, data by dates / time, etc.

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2406 Win 11 Home 64 Bit
    Posts
    24,029

    Re: Access or Excel

    Here is a White Paper on the subject.

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

    Alan
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

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