Using Groups to Manage Database Objects in Access 2000 

In Microsoft Access 2000, you can organize different types of database objects into a group. For example, you can create a Customers group and add to it all database objects that relate to Customers - the Customers table, the queries based on the Customers table, and the forms and reports based on those queries. When you click the Groups bar in the Database window and then click the icon for the Customers group, you see all of the objects related to customers in the Object list.

To create a group, right-click anywhere under the Groups bar, click New Group on the shortcut menu, and then type a name for your group in the New Group Name box. To add an object to the group, drag it from the Object list to the icon for the group.

Adding a database object to a group doesn't actually change the object's location in the database; it creates a shortcut to the object in the group.