storing data from checkboxes

[MelB]

I am creating an access database and am not sure how to handle the following
data.

I am entering data from an intake form. The Field Name would be
ModeOfTherapy the possible "modes of therapy" are:

Child Therapy
Family Therapy
Adult Therapy
Couples Therapy

The instructions on the form will be to "Check all that apply".

I have not yet had to create a check box, but from what I surmise this is
something that is created on the Form that will be used for data entry and
not in the table formatting the actual field if that makes sense. Are check
boxes appropriate in this case? Should I have four fields corresponding to
the four modes of therapy and then store a "yes" or "no" in each of the
fields. Is there a way to have one field "ModeOfTherapy" and then to store
the actual modes, ie "Child Therapy", "Adult Therapy" etc in that field as
they are checked off. Is this advisable?

In terms of using the data I imagine I would want to be able to easily pull
stats such was what number of clients are in child therapy only. What number
of clients are in Adult Therapy and Couples Therapy, etc.

Thanks for the help.

 

[Allen Browne]

It sounds like one person can have several modes of therapy. This should be
stored as data in a related table, not check boxes in one table.

For more information, see this example:
Don't use Yes/No fields to store preferences
at:
http://allenbrowne.com/casu-23.html