![]() To display the Filter by Group menu, click the title bar of the Navigation Pane.īy default, Access displays Tables, Queries, Forms, and Reports. You may want to show only a subset of database objects to help focus your attention. For example, if you select the Tables and Related Views category, the global group is called All Tables. You can easily locate the global group for a category by looking for the word All in front of the group name. You can also filter by Today or All Dates.Įach predefined category also includes a global group that contains all the objects in the database. Locate objects that are modified on a specific date in descending order or in a date range. You can also filter by Today or All Dates. Locate objects that are created on a specific date in descending order or in a date range. If an object uses more than one table, it appears in all relevant groups. View all the objects in the database, arranged by their type: tables, queries, forms, reports, macros, and modules.Īrranges items one group per table, with each group containing shortcuts to all the objects that use the table - queries, forms, reports, and so on. To display the Navigate To Category menu, click the title bar of the Navigation Pane. In addition, Access provides two more predefined categories based on when the objects were created or modified For example, when you select Object Type, you see all the database objects grouped by the type of object. When you select a category, the items are arranged into the groups that the category contains. When you create a new database, the category displayed by default is Tables and Related Views, and the group is All Tables. Although you can use the Navigation Pane in an Access web app opened in Access, you can only display, hide, sort, and search for database objects. Note The Navigation Pane is not available in an Access web app or web database when viewed in a browser. For more information, see Set user options for the current database. If the right-click menu of the Navigation Pane doesn't work, it may be disabled in your Access database. For more information, see Navigation Options dialog box.ĭo other commands, such as open an object in Design view You can change this to single click in the Navigation Options dialog box. If you can't change the width, see The Access Navigation pane is too narrow, and I can’t widen it. Position the pointer over the right edge of the Navigation Pane and then, when it changes to a double-sided arrow, drag the edge to increase or decrease the width. If the Navigation Pane is not visible, it may be turned off in your Access database. Also, the F11 key is a Special Key and it may be disabled in your Access database. If F11 doesn’t work, make sure function keys (Fn) are enabled on your laptop device. You can adjust the appearance of the Navigation Pane and work with database objects in the following ways:Ĭlick the Shutter Bar Open/Close Button or press F11. For more information, see Customize the Navigation Pane. Note The Navigation Pane can be customized in a variety of ways. Looking for a way to track and manage your database objects? The Navigation Pane is the main way you view and access all your database objects and it displays on the left side of the Access window by default.
0 Comments
Leave a Reply. |