If you're using Access 2007 there is an easy-to-use "Object
Dependencies" menu item. Look on the "Database Tools" tab, about three
columns from the left. When you click on it a window pops open on the
right hand side that shows "Objects that depend on me" and "Objects that
I depend on." Also notice the "Refresh button."

Two other things to check are 1) the "Relationships" window and, 2) the
"Record Source" of your forms and reports. Often they aren't based on
queries, but rather have their own SQL statements stored with the
form/report themselves.

Kathy R.



TGalin wrote:
I am working with an access database that I did not create and I am looking
for pointers that will help me analyze and understand what is happening with
the data as it is being transferred between tables. More specifically, I
need to figure out what the database queries are filtering and manipulating
as they transport the data to its final table output. I know exploring the
queries in design view will help, but choosing where to start seems confusing
and I am seeking, if possible, a more step by step/sequential approach to the
undertaking. Do you have any suggested approaches or strategies that might
help me accomplish this task more effectively?