Note: The Navigation Pane is not available when you use an Access web app or a web database in a browser. Although you can use the Navigation Pane in an Access web app opened in Access, it has a limited feature set: display, sort, and search for database objects. In this article Overview The Navigation Pane is the primary means by which you view and access all your database objects. When you open a database in Access, by default the Navigation Pane appears along the left side of the workspace. This wikiHow teaches you how to set up and use Microsoft Excel on your Windows or Mac computer. Install Microsoft Office if you don't have it. Microsoft Excel isn't available as a standalone program, but it is included in a Microsoft. You can filter tables to show only the data that meets the criteria that you specify, or you can filter by color. For more information on how to filter or sort data, see Filter data or Sort data. Formatting table data You can quickly format table data by applying a predefined or custom table style. Adjusting the Navigation Pane You can adjust the appearance of the Navigation Pane in the following ways: To Do this Change the width of the Navigation Pane 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. Open and close the Navigation Pane Click the Shutter Bar Open/Close Button or press F11 to open and close the Navigation Pane. Using database objects in the Navigation Pane You can use any object in the Navigation Pane by double-clicking it. Rpg computer games for mac free online. If you right-click an object, you see a shortcut menu that lets you do a variety of things, such as opening an object in Design view. Categories and groups in the Navigation Pane You can organize the objects in a database into groups and categories. Groups let you arrange and associate the objects in the Navigation Pane and categories let you arrange and associate the groups. ![]() For example, in the preceding figure, Tasks Navigation is the category, and Tasks, Contacts, and Supporting Objects are the groups. When you select a category, the items are arranged into the groups that the category contains. For example, if you choose the Tables and Related Views category, the items are arranged into one group per table, with each group containing shortcuts to all the objects that use the table — queries, forms, reports, and so on. If an object uses more than one table, it appears in all relevant groups. Select a category in the Navigation Pane When you create a new database, the category displayed by default is Tables and Related Views, and the group is All Tables. Every database also has a category named Custom that you can use to create a custom view of your objects. In addition, Access provides two more predefined categories that you can select, according to the way in which you want the objects to be displayed: Category Description Object Type View all the objects in the database, sorted by their type. Created Date and Modified Date Locate objects that are created or modified on a specific date or in a date range. You can filter by Today or All Dates. These categories display objects in descending order from when they were created or last modified. Each predefined category includes a global group that contains all the objects in the database. You can easily locate the global group for a category by looking for the word All in front of the group name. For example, if you select the Tables and Related Views category, the global group is called All Tables. Display and sort objects in the Navigation Pane You can select the way in which the objects in the database are displayed in the Navigation Pane. For example, you can include the creation or modified dates, or display objects as icons or lists. By default, Access sorts the objects in the Navigation Pane by object type in ascending alphabetical order, but you can also change the sorting to suit your needs.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |