I need some direction here please

[Guest]

I am looking for some direction here and hoping you can help.
First let me outline a couple of things. The non-profit organization I work
for is a homeowners association, and part of the associations common grounds
is three cabins to rent, a campground which includes three shelters, a
pavilion, boats for rent, a recreation hall and a pool.

Property owners, their families, and their guests are the only ones who can
use these facilities. The application that I want to create should be able
to book reservations for all of the above, keep track of payments,
confirmations, cancellations, and deposits, as well as check in and out
dates. I also need to be able to have it tell me that something is already
booked for a particular time/date if I am trying to book it again for someone
else. I need to be able to type in a guest or property owners name and find
out if that particular guest or property has had problems in the past and
have been banned from the facilities for abuse.

I would also like to be able to have a report to give to maintenance and
security each week, that tells them who is renting what and when. A report
that can tell me what our rental sales have been for each entity (cabins,
campground, shelters, pavilion, etc.)

So far, I have created the following tables and entered some of the data

Guests (those who will be using the facilities)
Property Owners (those who sponsor the guests)
Location (cabins, shelters, campground)
Unit (the different cabins, shelters, and camp sites)
Facility (pavilion, boats, pool, rec hall, that can be rented as well)
Reservation (to enter the reservation information in to)
Reservation Status (to see or update a reservation)

First can you tell me knowing the information as I outlined it above, what
forms would I need to create, and what queries I will need to create and how
I should proceed from there?

One last question, what are the uses for macros and modules, and how does
one go about creating them. So far, I will admit to be heavily dependent on
the wizards, but there don't seem to be any for these items.

Thanks for your help

Charli

 

[Keith Wilby]

I am looking for some direction here and hoping you can help.
First let me outline a couple of things. The non-profit organization I
work
for is a homeowners association, and part of the associations common
grounds
is three cabins to rent, a campground which includes three shelters, a
pavilion, boats for rent, a recreation hall and a pool.

Property owners, their families, and their guests are the only ones who
can
use these facilities. The application that I want to create should be able
to book reservations for all of the above, keep track of payments,
confirmations, cancellations, and deposits, as well as check in and out
dates. I also need to be able to have it tell me that something is already
booked for a particular time/date if I am trying to book it again for
someone
else. I need to be able to type in a guest or property owners name and
find
out if that particular guest or property has had problems in the past and
have been banned from the facilities for abuse.

I would also like to be able to have a report to give to maintenance and
security each week, that tells them who is renting what and when. A report
that can tell me what our rental sales have been for each entity (cabins,
campground, shelters, pavilion, etc.)

So far, I have created the following tables and entered some of the data

Guests (those who will be using the facilities)
Property Owners (those who sponsor the guests)
Location (cabins, shelters, campground)
Unit (the different cabins, shelters, and camp sites)
Facility (pavilion, boats, pool, rec hall, that can be rented as well)
Reservation (to enter the reservation information in to)
Reservation Status (to see or update a reservation)

First can you tell me knowing the information as I outlined it above, what
forms would I need to create, and what queries I will need to create and
how
I should proceed from there?

One last question, what are the uses for macros and modules, and how does
one go about creating them. So far, I will admit to be heavily dependent
on
the wizards, but there don't seem to be any for these items.

Thanks for your help

Charli

This is a very tall order to tackle in one go but basically your forms
should be laid out in a logical manner to reflect the relationships between
the entities. So perhaps you could have a main form for properties
detailing the owner, location, type ... anything pertaining directly to the
property. You might have a subform in a one-to-many relationship with the
main form to detail reservations - date, time, tenant etc (you'd have the
tenants details in another table as a lookup).

Pretty high level stuff but I hope it gets you pointed in the right
direction.

As for macros and modules, they are a way of automating tasks from simple
stuff like opening another form to more complex things like interfacing with
other Office apps. You can get an idea of how code works by creating a
simple macro and having Access convert it to code.

HTH - Keith.
www.keithwilby.com

 

[Craig Hornish]

Tall order - I think is an understatement since you said you haven't
used the modules. (I am assuming no coding experience) You will see some
of the coding when you design the lookups (combo Boxes) for your forms but
this will be limited. With something this big you will most likely need
something that the standard wizards will not be able to handle.
Also right now your tables need future work you mentioned deposits and
payments, they will need tables. And you have a table for "Property
Owners" - but they can be guests also - These probably should be in one
table - with a way to identify them as property owners also (more info would
be needed to determine the best solution for your situation)
I'd be happy to critique your table design if you send me a copy.
--
Craig Hornish
chornish at cap-associates dot com

Visit weekly Access conferences
Tuesday, 11:00am-12:30pm (Eastern US)
Thursday, 3:30pm- 5:00pm (Eastern US)

http://community.compuserve.com/n/pfx/forum.aspx?webtag=ws-msdevapps

"Think outside the box, because anything is possible."
"How long it will take or whether it requires divine intervention is another
issue"

 

[Guest]

Hi Craig

I tried to send you a copy of what I had so far, did you get it? Let me
know if you didn't and I will try to send it again...thanks for offering to
look it over for me

Thanks
Charli