Work Tracker

[Neil Greenough]

I am looking into helping a friend design a basic Access package to help him
with his business. Basically, he is a plumber and has 3 other employees.

What he would ideally be able to do is have a drop down menu on his
switchboard, from which he chooses the employee. Then from there, it will
take him into another menu, example review days jobs, add a job etc..... Is
this possible? I am assuming it will need a calendar of some sort.

Does anybody know of any templates which could be adapated? (if only!)

 

[Mike Painter]

I am looking into helping a friend design a basic Access package to
help him with his business. Basically, he is a plumber and has 3
other employees.

What he would ideally be able to do is have a drop down menu on his
switchboard, from which he chooses the employee. Then from there, it
will take him into another menu, example review days jobs, add a job
etc..... Is this possible? I am assuming it will need a calendar of
some sort.

Does anybody know of any templates which could be adapated? (if only!)

I hope that you have a solid friendship, that no money is changing hands and
that you have told him that your knowledge of Access is limited to very
limited.

I'm basing this on your comment about the switchboard and the fact that you
have not examined the templates that come with Access.

My advise would be for him to pick up MYOB for his accounting needs and I
would write any custom routines in Access needed in his line of work.

Unlike Peachtree and Quickbooks, MYOB has seamless ODBC connectivity. It
also handles a product matrix better than the others.