If you show or explain the structure of your database (tables, fields, relationships and match fields) I'm sure people here will be glad to offer advice. More info is needed. As well, you may find something in the templates/starter solutions that could get you started.
You say you are new to database use. How familiar are you with other programs? Are you good with excel? Also, Do you currently have any of this data in electronic form? Contact management program perhaps? And have you thought out what specific information you will be tracking?
all information is currently stored by name as word documents. I can search the hard drive and come up with patients.
in a sidebar (excel table) I have a list of medical problems, surgeries, allergies, medications and test results.
this information is copied and pasted with each patient contact to keep current.
the problem is I cannot do any type of data collection or document outcomes with this data and I cannot figure out how to get 5000 patients into a simple database that would have this information easily accessable
thanks for any help you can provide