Access tracking database ideas
Posted on 2005-04-19
Need to steal some brain power, since I am lacking.
Problem: I need an Access 2000 database that allows me to track "Problems", "Changes made", and "Resolution" if any. Most importantly I need the text to be searchable.
Example: On Tuesday 4-19-2005, one of the technicians "JOHN" (technician) had a user come to him about an error (Problem) in the database.......so he change two settings in the fee matrix (changes made) and found out later that DID fix the problem (resolution). This could also be an issue with a certain asset (computer or printer).
Your job: I want ideas ON DESIGN. This will hopefully turn out to be a good project for me to do some learning. I'm basically trying to partially duplicate a package I used before called "TrackIt!", but not interested in something that robust. MOST IMPORTANTLY I WANT A DATABASE THAT IS SEARCHABLE REGARDING ALL TEXT. In other words, using the example above with John........: ---3 weeks later an issue occurs with fee matrix code XXXXX. John remembers he made some type of change but isn't sure, so he does a text search and finds all instances (entries) related to "xxxxx" and immediately knows what happened.--
Ideas must center around Access 2000. Give me design ideas. Are there issues with being able to search all text in fields? Points for deep thought and detail.