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

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Examine database object relationships

Examine database object relationships

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

Start my 1-month free trial

Examine database object relationships

“

- When you're working with a large database, or you need to explore the inner workings of a database that somebody 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 relationships between multiple tables, but that doesn't tell you what queries rely on specific tables, or which forms send data to certain reports. To get a deep dive onto the interconnectedness of all of your objects, we're gonna turn to the database tools tab and the tool called Object Dependencies. Let's go ahead and click on that. The first time you run it you might be prompted to rebuild the dependency information. Just go ahead and press Okay to that, and Access will analyze all of your objects to see where they connect. Once that's done, you'll see a Dependencies pane open up here on the right side of your screen. We can resize it by just dragging on it's edge. Now I always get a laugh out of the fact that the two options…

Contents