Access 2007 object window

[kidrobot]

Sorry if this has been discussed! I have Access 2007 and I hate how the object window (view tables, queries, forms, reports, etc) is one single column. I have databases that have 20 tables and 20 queries and it's pretty hard to find what I'm looking for sometimes. I'm sure some of you have this problem, what should I do?

 

[boblarson]

Sorry if this has been discussed! I have Access 2007 and I hate how the object window (view tables, queries, forms, reports, etc) is one single column. I have databases that have 20 tables and 20 queries and it's pretty hard to find what I'm looking for sometimes. I'm sure some of you have this problem, what should I do?

Use the feature of the navigation pane which allows you to limit the view by certain objects.

 

[kidrobot]

bob, so there is no way to expand this in any way? I have some databases with 40 tables.

 

[boblarson]

I use it all of the time. You can select just tables, just queries, just forms, etc. or you can create your own custom lists with whatever frequently used items you want in there.