[AccessD] Database Design

Barbara Ryan BarbaraRyan at cox.net
Wed Feb 28 12:30:16 CST 2007


I am designing a new Access database for a therapeutic equestrian riding facility.

The database holds names of all the "partners' (individuals, groups, and companies) who volunteer, donate, and/or ride horses.  This database will primarily be used for mailing thank you notes, information about upcoming events, etc.  Each "partner" will have a mailing address and (optionally) a billing address.  Many partners will share the same mailing address (e.g., handicapped individuals who live in a facility, or a family where mom and dad are volunteers and their child is a rider).

Selection of partners for mailings needs to be very flexible --- sometimes a mailing is "one per household" --- however, each rider in a facility should receive a separate letter.  Sometimes mailings will only go to donors and volunteers; sometimes just to riders, etc, etc.

Would you split addresses into a separate table or include mailing/billing address information in the Partners table (and provide a mechanism to "copy" an address from an existing in the same household)?  

Thanks,
Barb Ryan





More information about the AccessD mailing list