View Single Post
  #3  
Old May 5th, 2010, 12:42 PM posted to microsoft.public.access.tablesdbdesign
Maarkr
external usenet poster
 
Posts: 240
Default System for Analyzing a database

you could try to enable Autocorrect, then in Dtabase Tools, select object
dependencies. Similarly, in the database window (A2007), under all access
objects you can select Tables and related Views.


"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?