About groups of database objects

Microsoft Office Access 2003

Show All Show All

About groups of database objects

You can organize different types of database objects into a group. For example, you can manage a form with multiple subforms more easily if you create a group that contains the main form, the subforms, and the tables or queries that they are based on. You can also create a group for the forms and reports that you use most often; when you click the icon for that group, both the forms and the reports appear in the Object list in the Database window.

A group consists of shortcuts to the database objects that belong to it; adding an object to a group does not change that object's original location. When you click Objects and then click the icon for a particular object type, any database object of that type appears in the Object list— even if that object also belongs to a group. When you click the Groups bar in the Database window and then click the icon for your group, all of the database objects that you have added to the group appear in the Object list.

Deleting a database object shortcut from a group does not delete the object itself. For example, if you delete a form shortcut from your group, and then click Forms Button image under Objects in the Database window, that form still appears in the list of all forms.