How to Database Object Dependencies in Access
Databases can often be complicated and interconnected. For example, a form might be based on a query, which in turn is based on a table. So, how do you keep track of all these interconnected database objects? By viewing object dependencies.
The Object Dependencies pane appears. Here, Access displays the objects that are dependent on the database object you selected.
You may need to click OK to update dependency information or to turn on the Track name AutoCorrect info option before the pane will appear.
There are two ways to view dependencies:
Access displays the objects that are dependent on the selected database object.