Is this possible - Not an issue with Access

[Adsso]

Hi Guys,
I'm fairly new to Access and have done abit with it but not alot to say I'm the best or I know everything but I was wondering if you can help me out and point me in the right direction..

Scenario - I work in a contact center and well I have been asked to help create an access database to keep track of all our call volumes and employees and also the employee stats for monthly, quarterly and yearly setup.. the Call data would come through from another program and I can export that into an excel sheet and I think I might be able to have access import it and pick up that data and I can make a table for all the employees but I was wondering if this is at all possible ???? Access will get rid of all our spreadsheets that we use as there is about 60 in total and with data going and being fed straight into access it's one central point..

Sorry if I have confused you I'm just trying to find out if this is at all possible before I try and figure this out




Thanks

[pbaldy]

It sounds like no problem. I'd import some data into Access and play with the queries to summarize it the way you want. Even better would be if you could link to the other program and eliminate having to export/import.

[Adsso]

Thaanks Pbaldy the other program is Avaya so I can export the tables across into it but I guess the other question is because it's a daily and then monthly thing would access treat it as a new table or can I put all the data into the same table ?? I don't like the idea of having over 1000 tables if that makes sense..

Sorry if I'm asking stupid questions I just want to make sure it is possible before I try and start making it...

[pbaldy]

Not familiar with Avaya, but shouldn't matter if you can export/import (failing the link). I would certainly append the data into a single table in Access, rather than separate daily/monthly tables. As long as the data has a date field, you can cut/slice/dice the data any way you want from that single table. What kind of volume are we talking about?

[Adsso]

We get data from 32 skills splits and that has avg handle time and about 10 other fields in it... so I know that data would get big and would make the data file big but I will have it so after 3 months that is will archive or something like that to try and keep it down and compacted.