Before I start -- Searching for Keywords

  • Thread starter Thread starter KK
  • Start date Start date
K

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
 
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
 
Back
Top