Hello Guys,

I have never used Access before but now find myself in a situation that it seems only Access can get me out of. My primary goal is simply to express and understand some data; basically all the effects of a particular cause, and simultaneously all the causes of a particular effect (for maybe 40-100 causes and 50-200 effects). As far as I can tell Access will be the best way of displaying/manipulating this data without a massive amount of repetition. There are some additional nuances but at it's core this is really all I need.

I spent some time reading/watching Access database tutorials but my need is so specific that they weren't very helpful and my unfamiliarity with the program makes it very hard to know exactly how to express my question. My main job means I travel a lot and only get a few days here and there to devote to this project so my time is very limited, only a few days a month at the moment. Can anybody help me find where to start with this. Ideally a template that matches my database, or at least somebody explaining how to express this particular basic relationship so that I can begin to fill out the data. I looked at many-to-many relationships but it was usually giving examples of students enrolling on courses or shop stock databases, things that did not help me with the specific type of database I need.

Thanks

I didn't find the right solution from the internet.
References:
- http://www.accessforums.net/showthread.php?t=67434
- Copyright Management Video Examples.

http://www.sql.ru/forum/1268316/where-to-start