Appointment Scheduling

[KAquestions]

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

 

[Ryan]

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.

 

[Michael Gramelspacher]

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/Patient Appointments.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.

 

[KAquestions]

Thanks Ryan & Michael,

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

K