restaurant table reservations

[Beari417]

I need a program for taking reservations at a restaurant, with 50 tables and
able to take bookings up to one month in advance. reservation info needed
includes name,number seats required, telephone # , time , special requests
(ie: wheel chair access , children ). I need to know how many are booked at
anytime or date. How many patrons in total.

 

[tina]

since you don't ask a specific question related to table/db design, i assume
you're not familiar with relational data modeling principles, and perhaps
not familiar with the Access software.

suggest you start by learning about data normalization/relationships. one
good book is Database Design for Mere Mortals by Michael Hernandez. you can
also use the following webpage (with bows to Jeff Conrad) which has tons of
links to db information

http://www.ltcomputerdesigns.com/JCReferences.html#Tutorial

once you've learned basic relational design principles, a good basic manual
such as Microsoft Access <version> Bible by Prague and Irwin can teach you
how to build a fully functional database with a moderate amount of bells and
whistles.

while you're learning, the above website and also www.mvps.org can provide
you with a lot of help. and these public newsgroups are always available for
you to post requests for assistance with specific problems and/or questions;
many skilled and experienced people volunteer their time here to help other
developers.

hth

 

[Jeff Conrad]

in message:

I need a program for taking reservations at a restaurant, with 50 tables and
able to take bookings up to one month in advance. reservation info needed
includes name,number seats required, telephone # , time , special requests
(ie: wheel chair access , children ). I need to know how many are booked at
anytime or date. How many patrons in total.

In addition to the information Tina provided, there is a sample data model
for this scenario here:

http://www.databaseanswers.org/data_models/restaurant_bookings/index.htm

Perhaps that will get you started.

One other thing to consider. Most higher end POS systems have booking
modules built in out of the box. You might consider doing some research
in that area as well.

I will most likely be doing something like this in the future and would have
enjoyed helping you on this, but I'm very busy with other projects at the moment
and will not get to it for quite some time.

Good luck,