[AccessD] Two stupid questions from newbie

I'm a newbie not only to this list, but to Access.  I've worked with FileMaker and Summation, but not with SQL.


This is a small Access 2002 database with basically one data entry form, mostly text, no calculations, no relationships.  Not even lookup tables.  It's basically for searching for and reporting on info.


 I would like to do two things which I don't seem able to and which I'm sure are painfully obvious.


1.  I have a text field which describes issues.  Let's call them wealth, fame, power.  Some of the data relates to more than one of these, e.g., wealth and fame.  (Actually there are about twenty of them.)


What I'd like to do is put "wealth fame" or "wealth, fame" into the issues field, so I can search for either weaIth or fame and come up with the appropriate record. don't seem to be able to search on part of that field, which is a text field.  So what I've been doing is creating one record under "wealth," then another which is identical except that the issues field reads "fame."  This seems to be a waste of bytes, and also allows the likelihood of a search on another field bringing up duplicate records.  I tried "like" but that didn't do it.  If I put both wealth and fame into the issues field, I can't pull up either, either by filtering or by querying.


2.  If you thought that was dumb, this one is dumber but I'm tearing my hair out.  I would like to create forms and reports based on a saved filter result.  The instructions say it's easy:  Run the filter, select "autoform" or "autoreport" from the "new object" icon, and there you are.  Trouble is that "autoform" and "autoreport" are grayed out.  If I put them up as individual icons they're grayed out too.  Any ideas of what settings I've screwed up or how to ungray them?


Thanks, everyone!
Barbara