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