So within Access, the column on the far left is organized by Tables
, Queries
, Forms
and Reports
. Within those groups, are obviously all the tables, queries, etc that you've created.
Is there any way to add custom groups within each? So for example, you have a table for Carrots, Onions, Strawberries and Grapes. Is it possible to create groups/categories called "Fruit" and "Vegetables", keeping all the "Fruit" tables together and vice versa?
Best Answer
Choose custom from the drop down list:
Once you have chosen Custom, you can choose to add objects to groups using right-click:
Groups can be renamed.
I found this link helpful as well, along with Remou's response. Shows a different way of creating custom groups.
Manage database objects in the Navigation Pane