Now that you understand the table relationships, you can expand your scope of knowledge and find out how all the objects—such as forms, queries, and tables—depend on each other.
For example, before you make changes to any queries, you will want to know if there are any forms dependent on the returned results of that query. Also, if a form is dependent on the structure of a table, you may need to change the design of both to keep them in sync.
The Object Dependencies task pane, a new feature of Microsoft Office Access 2003, is very helpful in determining how your database is structured. The Object Dependencies task pane gives you both a top-level and detailed view of objects in your database and shows which objects depend on each other.
The Object Dependencies task pane lists different types of dependencies, such as relationships between tables and forms that have subforms.
If you run into any issues with using the Object Dependencies task pane, refer to the Quick Reference Card at the end of this course for more details.
Note The task pane doesn't show macros and modules. If you'd like to learn more about automating your database by using macros and modules, please visit the Office Developer Center.