Appointment Scheduling

All,

I have been tasked with designing an appointments database for work.

Am sitting with a lot of scribbled on pages in front of me trying to design
the tables, but i just can't get my head around how staff will input their
avaialability into the database.
What form should those tables take?

At the moment they use outlook calendars and each week input the hours of
each day they will be available to see clients for the next two weeks, and i
just can't work out how to translate that into access?

Help would be much appreciated!

TIA,

K

A simple way would be to have a table called Availability, with columns
DateAvailable, StaffMember, TimeIn, and TimeOut. Then make a form and put 4
unbound textboxes named AddDateAvailable, AddStaffMember, AddTimeIn, and
AddTimeOut. Then put a button called AddTime with this event

Private Sub AddTime_Click()
DoCmd.SetWarnings False
DoCmd.RunSQL "INSERT INTO Availability _
(DateAvailable,StaffMember,TimeIn,TimeOut) VALUES _
(""" & Me!AddDateAvailable & """,""" & Me!AddStaffMember & """,""" & _
Me!AddTimeIn & """,""" & AddTimeOut & """);"
DoCmd.SetWarnings True
End If
End Sub

Then you could make tables for your staff, dates, and times to provide your
users dropdowns on your form. There are many ways to do this, this is just a
quick and easy solution.

--
Please remember to mark this post as answered if this solves your problem.


"KAquestions" wrote:

All,

I have been tasked with designing an appointments database for work.

Am sitting with a lot of scribbled on pages in front of me trying to design
the tables, but i just can't get my head around how staff will input their
avaialability into the database.
What form should those tables take?

At the moment they use outlook calendars and each week input the hours of
each day they will be available to see clients for the next two weeks, and i
just can't work out how to translate that into access?

Help would be much appreciated!

TIA,

K

On Fri, 7 Nov 2008 15:18:55 -0000, "KAquestions" (no_spam) wrote:

All,

I have been tasked with designing an appointments database for work.

Am sitting with a lot of scribbled on pages in front of me trying to design
the tables, but i just can't get my head around how staff will input their
avaialability into the database.
What form should those tables take?

At the moment they use outlook calendars and each week input the hours of
each day they will be available to see clients for the next two weeks, and i
just can't work out how to translate that into access?

Help would be much appreciated!

TIA,

K


Here is something I did as practice.
http://www.psci.net/gramelsp/temp/Pa...pointments.zip

It uses a calendar table and creates 20 half hour time slots for every doctor for each work day. A
time slot can be avaiable or not available. Scheduling an appointment is just a matter of matching
a patient with an available time slot.

One form is just for managing availability. Default is available, but it could just as easily by
not available. The second form is for managing appointments.

This is just something to look at as you seem to be searching for ideas.

Thanks Ryan & Michael,

Both useful responses, am going to spend the day working on the dbase and
this is a great help.

K

"Michael Gramelspacher" wrote in message
...
On Fri, 7 Nov 2008 15:18:55 -0000, "KAquestions"
(no_spam) wrote:

All,

I have been tasked with designing an appointments database for work.

Am sitting with a lot of scribbled on pages in front of me trying to
design
the tables, but i just can't get my head around how staff will input their
avaialability into the database.
What form should those tables take?

At the moment they use outlook calendars and each week input the hours of
each day they will be available to see clients for the next two weeks, and
i
just can't work out how to translate that into access?

Help would be much appreciated!

TIA,

K


Here is something I did as practice.
http://www.psci.net/gramelsp/temp/Pa...pointments.zip

It uses a calendar table and creates 20 half hour time slots for every
doctor for each work day. A
time slot can be avaiable or not available. Scheduling an appointment is
just a matter of matching
a patient with an available time slot.

One form is just for managing availability. Default is available, but it
could just as easily by
not available. The second form is for managing appointments.

This is just something to look at as you seem to be searching for ideas.