Making an Outbound Call Tracker for my Job

[wutangclams]

Hey everyone!

I've been asked to come up with a method of tracking outbound calls for my company. This is a new job for me and I'm aiming to impress.. but I'm a touch out of my element so I'm not trying to reinvent the wheel here.

I've found this starting point:

http://office.microsoft.com/en-us/te...010206879.aspx

but I'm having difficulty conforming it to function the way I need it to.

Basically, I want the applet to
-store the employees name
-store customer names that were called


-a checkbox for whether or not an appointment was set
-a textfield storing an appointment date/time [if applicable]
-four radiobuttons to select which area of the business the call pertains to

..the employees would submit new values everyday, and ideally I would like the data to be accessible in a real time line graph.. am i getting greedy here?

I totally assumed this would have been done and redone before and that there would be a plethora of templates to choose from online, but for the most part my search has been fruitless and the only solid lead is the one posted above.

I have some q-basic experience.. and i took a turbo pascal class in hs.. other than that im adrift here, and could use a helping hand. Im defiantly not expecting anyone to do it for me,, but if you can point me in the direction of a better launching point i would be eternally grateful.

[June7]

Other than the fact the template was designed for incoming calls, how is it not accommodating your needs? Be specific. What modification have you attempted? What is the exact issue you have encountered?

Have you modified tables, queries, forms, reports?

What data is a real time line graph supposed to represent? Updating the graph would have to be triggered by an event.