From the course: Access Essential Training (Office 365/Microsoft)

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Examine database object dependencies

Examine database object dependencies - Microsoft Access Tutorial

From the course: Access Essential Training (Office 365/Microsoft)

Start my 1-month free trial Buy for my team

Examine database object dependencies

“

- [Instructor] When you're working with a large database, or you need to explore the inner workings of a database that someone else created, it's important to understand how all of the objects interrelate. We've seen how you can use the relationship screen to explore the connections between multiple tables, but that doesn't tell you what queries are relying on those tables or which forms send data to a specific report. To get a deep dive into the interconnectedness of all of your objects, we're going to turn to a tool on the Database Tools tab called Object Dependencies. When you activate that option, it opens up this panel over here on the right. Now, I always get a laugh out of the fact that the first two options on the top are written in the first person, "Objects that depend on me and objects that I depend on." Me and I here refer to the currently selected object over in the navigation pane. Choosing "objects that depend on me" displays the objects that use the selected object as…

Contents