Before I start -- Searching for Keywords

[KK]

Hello,

I am about to start a new project, and would appreciate some general advice
or guidance before I start setting up the database. I have used Access for
simple personal applications, but never for other users. The project will be
used by people who are not particularly 'PC-literate'.

There will probably be about 10 fields and perhaps 100 records. I know that
it is important to split the data into small tables and to link them
together, and I can do this OK.

The users will need to search the database by entering 'Keywords' . The
keywords could (in principle) be located anywhere in any of the fields.

Do I need to set up specific fields for the keywords, or will Access be able
to locate them within longer text strings?

I assume that I will need to present the user with a form in which to enter
the keyword. Will the user need to choose in which field to search?

Are there any other issues that I should beware of, or general tips that you
can give me?

I apologise if this is all a bit vague, but this could be (for me) a major
step in my use of Access.

With thanks for all advice

KK

 

[Ed Robichaud]

You don't say what your data is, so it's near impossible to advise on any
data structure. Access provides a "Find" dialog (that you can use from the
Edit menu, or call from a command button) that will search current/all
fields for any entered value. This may be good enough for you.
-Ed