problems

[Guest]

I'm trying to make a invoice using access. I am making a invoice for a
fishing lodge. What my invoices include is name, address, phone number what
lodge they will stay in, date of arrival, date of departure, price per
person, and total price per group. I would like to be able to look up a
person by there name for furture bookings. Can this be done? I'm not sure
how to do this and is access the best program to use. Do I need to use
anyother program with it? Thanks for the help.

 

[Rick B]

You'd have to share your table structure with us.

You should have a table that contains guests. A table for groups. A table
for stays. A table for lodges. Etc.

When a guest returns in a year or two, they should still be in your "guest
table". You will just be adding a new "stay" for that person.

This is a many-to-many relationship.

 

[jahoobob via AccessMonster.com]

Do you want to use this as an invoicing system or do you want to use it as a
bookings/reservation system also. Either way, Access is all you need and is,
IMHO the best program to use
However, you should learn Access first, either in a formal class or by self
teaching using one of the many good books you can find at your local
bookstore or online. The Access Bible was what I used. Most of the books
have excellent examples of how to do this and that and you may even find one
that uses a system similar to what you want. Some of the MVPs that
participate in this group also have examples and helps on their web sites. I
have used them more than once. Allen Browne (www.alenbrowne.com has some
excellent tips for what he calls casual users and I would call beginners that
will help. Read especially his tip on calculated fields and relationships
for your purpose. Other MVP sites can be found at www.mvps.org
You should see the Access Ten Commandments at
http://www.accessmvp.com/djsteele/AccessTenCommandments.html