Need ideas on collecting info and building a tracker for work

[Byte 2.0]

I opened my mouth with what I thought was a good idea at work and I was told to do it.

As many of you know I work in a call center and we have several different call centers. They are always rolling out some new tracking program and databases we have to use.

Just to do my job I have 15 to 20 windows open on my work station at all times.

Here lately we have been seeing allot of stupid stuff being done at various levels of support causing big issues.

So My Idea was to create a tracking program to collect some of this information and to be able to display it in a useful fashion

I said this in the present of one of the High managers who replied to me "Do it".

When I suggested it I really meant for it to be considered and someone else that has more knowledge in programming to do it.

Anyways I basically have the tools on my workstation to work with, can't install anything else.

So assume I have all MS Office 2k to work with.

I am guess Access is the program I need to set this up in and I am not an access user.

I am still in the planning stage of my project and I don't have a set deadline. I pretty much could drop this whole idea and it would not come up again. But if I do this It might go aways to help me out in the long run.

So in short here are some field of data I know I will want to collect.
On the collection side

customer phone number
Call center that took the call
Level of support, tier1, tier2, tier3, etc...
Notes from the call
extra comments field.

Display I would like to be able to have a suitable layout as well here I am also still in the dark.

Also this is just a broad picture of my over all project and I am looking for Ideas, is Access the type of program I should use? Will it do the job?

[bailey]

well I am stepping out of bounds here, suggesting something I know knothing about.

but from what I have seen that can be done with microsoft excel, I am thinking that that would do what you want, but you would need to find someone who knows how ti apply it the way you need.

[Jaggannath]

Is it supposed to be something that sources the information from another program, or is it something you want the user to input into the program??

If the latter, I recommend Excel... it's similar to something we do at a LMU in the RAAF

[Byte 2.0]

Yea, i could manually enter the data directly to a spread sheet but I would rather have it like some we aready have in place. I might need to check around and see which program they used, but I am certain the other trackers we have are in access.

I would like to have a user interface side of the program that just gives blanks to be filled out to collect the data.

Then on the display side, I have figured I would like to have the program display it and be able to go from record to record. Right now I am imaging having each record goto a new page and just change pages to see the next record.

The more I think about it the more bloated it is starting to look. Because I would also like to pull some raw numbers out of it in the form of a report. Total records, total by call center, total by agent, etc.

Heck this is sounding to me like a major program now. Probably going to go beyond what I can do, but I might be able to find a few people around where I work to help out.