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?