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?

2

Best Answer


Choose custom from the drop down list:

custom

Once you have chosen Custom, you can choose to add objects to groups using right-click:

custom 2

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