Connecting Tech Pros Worldwide Help | Site Map

APPOINTMENT TRACKING PER CLIENT AND CALCULATIONS - HELP

hyde
Guest
 
Posts: n/a
#1: Nov 13 '05
Is it possible to have a daily calender that will

show all clients for the day(including time of appointment)

show whether the client was present, called off, no show
or etc.

calculate the total number of clients that showed up,
called off, no show etc - per day, week, month and year

and if possible to click on the clients name and pull up
his/her contact information

I have been racking my brain in access and excel and i am stumped
I am fairly new at access and have a current database of all my clients
and their information. but am unable to track anything without using
written information.

please help

Larry Linson
Guest
 
Posts: n/a
#2: Nov 13 '05

re: APPOINTMENT TRACKING PER CLIENT AND CALCULATIONS - HELP


Yes, what you describe can be implemented in Access. No, Access doesn't have
such an application "out of the box", but there are some "templates"
available, one of which might give you a "headstart" on the basic contact
management tables, etc..

On the other hand, unless you have a compelling reason to implement this
kind of thing yourself, I suspect you can find some free or very reasonably
priced applications to do what you want.

Larry Linson
Microsoft Access MVP


"hyde" <hyde129@comcast.net> wrote in message
news:1119500438.071512.255360@z14g2000cwz.googlegr oups.com...[color=blue]
> Is it possible to have a daily calender that will
>
> show all clients for the day(including time of appointment)
>
> show whether the client was present, called off, no show
> or etc.
>
> calculate the total number of clients that showed up,
> called off, no show etc - per day, week, month and year
>
> and if possible to click on the clients name and pull up
> his/her contact information
>
> I have been racking my brain in access and excel and i am stumped
> I am fairly new at access and have a current database of all my clients
> and their information. but am unable to track anything without using
> written information.
>
> please help
>[/color]


Closed Thread