create schedule

S

slofotomama

Are there templates for creating a appointment schedule database? Or can
anyone recommend a website or book where I can learn to create one?
 
A

Arvin Meyer [MVP]

slofotomama said:
Are there templates for creating a appointment schedule database? Or can
anyone recommend a website or book where I can learn to create one?
Click to expand...

I use Outlook to manage the appointments but I create them in Access. I
wrote an article in Access Advisor magazine last year explaing how to do it.
The sample database for that article is at:

http://www.datastrat.com/Download/OutlookAppointment.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
S

slofotomama

I looked at the appointment.zip. Thank you! If you could tell me the month
your article was written, I will look that up online. What I am trying to
create may be more complicated, tho'. I should elaborate. I created a mdb and
data access page called 'photoassignments.mdb' which anyone in our office
can go to our intranet and create/print an appointment report for a
photographer. (The database being generated isn't used for anything, yet).
The person creating the report still has to check an appointment book to see
who is working or is on vacation. My goal is to replace the appointment book
with a scheduling database (eventually a data access page) and tie it
together with the photo assignment database. My goal is when someone creates
an 'appointment', any conflicts and/or availability of the photographer from
the scheduling database would display. I was hoping to find some type of
scheduling template to eliminate a lot of work. Of course I am willing to dig
in and do the work if a template is unavailable. Any tips or good books on
how to accomplish this is appreciated. Thanks again! This site has been a
great resource so far!
 
A

Arvin Meyer

The article was published in September 2004.

You can do what you want directly in Outlook. Look for books by, Byrne,
Slovak, Poremsky, and Moser for good Outlook references. Also ask some
questions in one of the Outlook newsgroups. There are plenty of great MVPs
there that can help you in your quest.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
S

slofotomama

Thanks so much! I will look for those books.

Arvin Meyer said:
The article was published in September 2004.

You can do what you want directly in Outlook. Look for books by, Byrne,
Slovak, Poremsky, and Moser for good Outlook references. Also ask some
questions in one of the Outlook newsgroups. There are plenty of great MVPs
there that can help you in your quest.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
Click to expand...
 
R

Ronbo

Dear Mr. Meyer,

I am a Det/Sgt for a municipal police department, in a city of 110K, in
Pennsylvania. I am tasked with scheduling our detectives for 2006. (Newest,
most junior Sgt)

We have always done handwritten schedules, and it's very time
consuming....time that would best be spent doing police work...but it's
"always been done this way."

My problem is this....two teams, five men each. Mon-Saturday shifts of
0700-1500 and 1500-2300....with one detective from the latter pulled to work
1900-0300.

No Sundays (a rotating "on-call" assignment will cover Sundays, and will
back-up the 1900-0300 person on major cases)

No major holidays (again, an on-call assignment) and reduced staffing on
lesser holidays.

By contract, we need to achieve 260 days of work per year. Anything in
excess will be compensated for by awarding "schedule adjustment" days (SA
days), or days guys can schedule off with permission to result in the
contractual number of days being scheduled.

Those SA days must be used by year's end. Vacation days will be scheduled
as operations permit, or
'carried over" to the next year.

Can you recommend a template I can try to "plug in" those parameters and
generate a schdule more quickly and efficiently than has been done in the
past?

Thanks for whatever advice you can offer.

Ron Flowers
flowers @allentowncity.org
[email protected]
 
Top