software

Hi all,

I'm hoping someone can give me some solid, practical advice or suggest
a solution to a work related problem.

I am employed in a contact centre and am looking at developing some
framework for a 'ticket of work' system. This would involve a
consultant logging a job and a senior staff member then actioning the
request.

Currently, we use a paper based system to record the job. It is then
logged on one of four spreadsheets by the senior staff member (one for
each team). There is a need to keep a paper record for audit reasons.

The workplace consists of around 80 people who will use the system,
with a potential maximum of around 45 using at one time. Realistically,
it is unlikely more than one person will need to 'log' a job at the same
moment in time - but I need to consider the possibility.

I have a couple of solutions.....

1. Develop an Access FE/BE database to perform the function of
capturing and editing the jobs through a form.
2. Develop an Access FE/BE database and set up the spreadsheets with
the DB linked as a datasource. However, I do not know how I can make
the spreadsheets write updated data 'back' to the database.
3. Continue using the spreadsheets and improve the functionality.

Has anyone here used either complaints management/ticket of work
systems before - and what approach was adopted? Can anyone suggest
strenths/weaknesses with excel V access to perform the function?

Thank you...any advice or thoughts would be well received!

Cheers

Systematic --
systematic
------------------------------------------------------------------------
systematic's Profile: www.excelforum.com/member.php...oamp;userid=25294
View this thread: www.excelforum.com/showthread...hreadid=530450Have you considered getting one of the many many off-the-shelf packages that
do this type of thing?

quot;systematicquot; wrote:

gt;
gt; Hi all,
gt;
gt; I'm hoping someone can give me some solid, practical advice or suggest
gt; a solution to a work related problem.
gt;
gt; I am employed in a contact centre and am looking at developing some
gt; framework for a 'ticket of work' system. This would involve a
gt; consultant logging a job and a senior staff member then actioning the
gt; request.
gt;
gt; Currently, we use a paper based system to record the job. It is then
gt; logged on one of four spreadsheets by the senior staff member (one for
gt; each team). There is a need to keep a paper record for audit reasons.
gt;
gt; The workplace consists of around 80 people who will use the system,
gt; with a potential maximum of around 45 using at one time. Realistically,
gt; it is unlikely more than one person will need to 'log' a job at the same
gt; moment in time - but I need to consider the possibility.
gt;
gt; I have a couple of solutions.....
gt;
gt; 1. Develop an Access FE/BE database to perform the function of
gt; capturing and editing the jobs through a form.
gt; 2. Develop an Access FE/BE database and set up the spreadsheets with
gt; the DB linked as a datasource. However, I do not know how I can make
gt; the spreadsheets write updated data 'back' to the database.
gt; 3. Continue using the spreadsheets and improve the functionality.
gt;
gt; Has anyone here used either complaints management/ticket of work
gt; systems before - and what approach was adopted? Can anyone suggest
gt; strenths/weaknesses with excel V access to perform the function?
gt;
gt; Thank you...any advice or thoughts would be well received!
gt;
gt; Cheers
gt;
gt; Systematic
gt;
gt;
gt; --
gt; systematic
gt; ------------------------------------------------------------------------
gt; systematic's Profile: www.excelforum.com/member.php...oamp;userid=25294
gt; View this thread: www.excelforum.com/showthread...hreadid=530450
gt;
gt;


Yes! The easy solution is always the obvious one....but with the absence
of funding in a Government department...any procurement is nigh on
impossible!--
systematic
------------------------------------------------------------------------
systematic's Profile: www.excelforum.com/member.php...oamp;userid=25294
View this thread: www.excelforum.com/showthread...hreadid=530450