Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2004
    Posts
    214

    Unanswered: quality monitoring form

    Hello all,
    I designed a quality monitoring program for a call center I work for. I need to design the form for the coaches to us in an access database. I need an idea how to do this and have the results reported in a scorecard. For example; a form by technician and score for each key point similar to a survey. Any ideas on how I need to proceed or any samples out there. The end result must be a scorecard.
    Thanks

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Need more info. Perhaps uploading a sample of the mdb or explain your table structure and form design.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    Jul 2004
    Posts
    214
    I apologize for being vague. I am still brainstorming. I was thinking a table structure as follows:
    tblTech-techID,techname
    tblQuestions-questionID, question

    My problem is that I have to assign a weight to each question. Ex. question1
    tech could receive a rating of 1-5 question2 tech could receive a rating of 1-5 and so on. I want to have coaches rate the tech and assign a value through a data entry form and have the numbers added and something like a weighted avg for their call which can be either inbound or outbound. I would then need to develop a report with a scorecard. I am not sure this is the best way to do this. Is this possible? Are there any sample databases out there maybe I can use?
    Thanks

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I have to assign a weight to each question.
    tblQuestions-questionID, question, weight.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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