calulation with acess

[Guest]

I'm making a reservation list with access. I need to be able to calulate the
price of there stay. Taxes etc. Will access let me do this? If it won't
what should I use and if it will can someone help me with this? Thanks for
all the help.

 

[Rick B]

Yes, it will let you do this. As far as how you do it, we would have to
know a great deal more about your data structure.

The "Northwind" sample database that ships with Access has an invoice form
and report. You could take a look at how they do it there and make your
system similar.

 

[Rick B]

Please note, you say you are making a reservations "list". Access is a
database application. If this is a one-time list, then Excel would be much
better. If you are creating a reservations "system" where you will retain
the data and add new reservations as they come in, then Access it the right
tool.

 

[Guest]

Yes, I what to retain the information and add to it. I also what to be able
to pull up a old reservation by the persons name and to be able to add the
new reservation for them. Can the old reservation be saved or will it delete
it with the new reservation?
The reservations are charged per person and if there is a group of people I
want to be able to calulate it without having to put up a calculator and do
it that way. I would also like it to be able to figure the tax amount and
give a grand total. Is this possible?

 

[Rick B]

Yes, that is all possible and is what a database is for. Access is just a
tool though. You have to build the database.

You might take a look at the various templates available in Access and on
the microsoft website. You might find some that you could use as a starting
point for your file. You will have to heavily modify them, but they might
get you started.

As you start building it and run into specific questions, feel free to post
here.

I'd highly recommend that you do a lot of reading first. If you are not
familiar with relational database design, then you will need to obtain that
knowledge before you start. If you dive in and get your table structure
wrong, you will end up spending countless hours trying to fix it. You need
to map out your plan very carefully before you start doing any work in
Access. Again, once you have your plan laid out, feel free to post here and
ask for advice to make sure you have followed all the normalization rules.

 

[Guest]

Thank you very much. I'm sure you will be hearing for me soon. Thanks again
for your help.