I need for more information about "Time and Billing"

[Hany Freedom]

in Access 2003 , there is example called "Time and Billing" ...... I don't understand what exactly mean or what it aim to !!!

I need any help to understand it well.

go to :-
http://office.microsoft.com/en-us/templates/TC010184611033.aspx?CategoryID=CT101426031033
to download the "Time and Billing" example.
OR
go to that link :-
http://www.zshare.net/download/1252846375e7fb37
in case the first link don't work.

and this is the ERD of the "Time and Billing" example :-

that's all ...... I'm waiting for any explanation ......

 

[Hany Freedom]

I'm still waiting for any answer ........

 

[georgedwilkinson]

It's an un-normalized business system that someone thought would make a good example. I feel sorry for anyone who actually uses it for a real business. I wouldn't use this **** in any system I was working on.

It's supposed to track employee time billed against projects.

 

[Pat Hartman]

George, this actually looks better than most of the samples. I don't like the spaces in the names but otherwise it looks like it should work.

Hany, your question is a little too broad to answer. As you can tell by the name, the database tracks a person's time against a project. I am not sure what you want us to tell you about it.

 

[Hany Freedom]

the database tracks a person's time against a project.

I'm not understanding what suppose that's mean
if there anyone want to make project and he the only owner for that project , so why he need to use this template (Time and Billing)
I think he can control on the time by himself , and he can also hire the employees he thinks they better for their jobs in his project so ...... what's the purpose here for this template (Time and Billing) ???

 

[georgedwilkinson]

Tracking all the team member's time on a project so you'll know how much a project costs. This will help to estimate your time/costs on future projects.

While it's true there are worse data models out there, I would never implement this model. True, they did some things right. But they did enough things wrong to not meet my standards.

 

[Hany Freedom]

Tracking all the team member's time on a project so you'll know how much a project costs. This will help to estimate your time/costs on future projects.

you mean like (Feasibility Study) ?!

 

[georgedwilkinson]

Well, I would expect that an estimate would be part of a feasibility study. And you could certainly get a better estimate if you know how you've performed in the past.

However, that is only one small aspect of why you would track this type of information. You may pay (and/or bonus) your employees/contractors based off this data. You would definitely want to know how you performed on a project. You might want to tie bonuses to performance. You might use the data for budgeting purposes. And you might want to outsource all or part of future projects based on this data. You might be able to look at the data over time to find waste.

The possibilities are only limited by the imagination of the person analyzing the data. It's a management tool.