MS Access – Investigating / Understanding Relationships

[danharman]

Forum Users:
Any advise on the best approach to investigate a large Access database, with the ultimate goal to gain an understanding of the data stored, the tables created and the relationships that they hold, and ultimately where (ie. the tables etc.) certain reported figures are sourced?

I realise that the above query is very broad, but any suggestions on the best way to investigate an already established database would be much appreciated!

Daniel.

 

[wabtrainer]

If you have got Microsoft Visio 2002 (Evaluation copies available from Microsoft.com), it has a function where you can reverse engineer a database and put it into an Entity-Relation diagram which is sometimes easier to understand.
It also gives information about the relationships. Hope this will help. If you want to be a bear:
Be a Grizzly!