I have a little programming experience mainly using Borland C++ in the past. I am nowadays trying to create a software which mainly will do the following :
- The user will select a list of variables (e.g. symptoms of a disease)
- The software will list the possible disease according to the symptoms selected
- The software will suggest a proper therapy.
And this should go vice versa . (e.g. selecting a therapy , then the software will automatically list the diseases which can be treated with this therapy, or selecting a disease and then the software will automatically list the symptoms etc.)
I've been told that the best way to do it is to use Microsoft Access (Database). Since i don't have really any serious experience with Microsoft Access or Database programming in general, I would appreciate if i could get some general guidelines regarding the design of your database tables and relationships. (most important thing is to know where to start, what should i study in order to accomplish my goal).
Thanks a lot.