Instructor booking System

[DennisJones]

I have been tasked with creating a system for booking instructors with clients. Customers will book in for a lesson which can be anything from 30 mins to three hours long in half hour chunks. There are up to seven instructors available and I need to be able book up to six months in advance and hopefully display a daily screen with a grid showing who is booked out with who at various time of the day.
Can anyone suggest some piece of freeware or example database to get me started?

Many Thanks

 

[durexlw]

I'm unsure about what your question is.

A good example is the Northwind database that comes with Access. It has all you'll need to know for pretty much anything you'd like to make.

If you question is a more specific example that relates to your problem, I have never came across something like that.
In the end, all databases are the same, only the form differs.

For your problem:
The 7 instructors that are available... how many is not relevant. Always plan ahead. They'll want to be able to handle more instructors later on. Same with the how much in front you want to plan...

In it's more basic form: You'll need an instructor-table, a client-table and an appointment-table.
Let's say you book per half hour, and you'll work 8 hours a day, this makes 16 segments per day you can book... base your primary key on the appointment table based on this:

You'd get for example: AppointmentId = Date + instructorId + a number from one to 16 (date + one of 16 segments someone can book on a day). Like this you can plan years in front, never have a duplicate and have as many instructors as you want

Just throwing some idea's at you... see if there useful to you. Good luck

 

[The_Doc_Man]

Search this forum (it has a usable if not perfect SEARCH option).

Look for keywords:

Booking

Reservation

Schedule (In the latter case, there are multiple types of entry you will find, some irrelevant to your question.)

 

[DCrake]

Simple Software Solutions

Hi

I know you mentioned freeware, but all good things have a price. Now if you are looking for a smooth user freindly approach and are familiar with VBA then I suggest you visit this link and view the demos.

I have been unsing these controls for 3 years and find that they are great for all types of things. A bit Expensive at first, but they have certainly paid for themselves since.

http://http://www.dbi-tech.com/product_page_Studio_Controls.asp

CodeMaster:http://www.icraftlimited.co.uk