From the course: Access 2019 Essential Training

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 2019 Essential Training

Start my 1-month free trial

Examine database object relationships

“

- [Instructor] 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 tools button available here in the Database Tools tab to get a good look at how all the different tables relate to each other in the database. But this doesn't give us any information about the queries, forms, or report objects. For those, let's go ahead and close that. We're gonna turn to a tool called Object Dependencies that's also in the Database Tools tab. When I click on that, that'll open up a new pane over here on the right called Object Dependencies. Now, sometimes when you run this tool you'll be prompted to rebuild the dependency information. Press OK and Access will analyze all of your objects to see where they connect. And when that's done, you'll get this dependencies pane on the right. You can go ahead and grab it by the…

Contents