Marianne Martinez
The Navigation Pane is the primary way to view and access all your database objects in Microsoft Access. It is located on the left side of the Access interface and acts as a table of contents for the database. By default, the Navigation Pane displays Tables, Queries, Forms, and Reports. However, you can customize the Navigation Pane to display only queries by using the Filter by Group menu. This allows you to focus on a specific subset of database objects. To display the results of a query in the Navigation Pane, you can right-click on the query and select 'Run' or 'Design View' from the shortcut menu.
| Characteristics | Values |
|---|---|
| Displaying queries | Right-click the query and select 'Run' to execute it. Alternatively, open the query in 'Design View' to make modifications before running it. |
| Navigation Pane location | Appears on the left side of the Access interface by default |
| Navigation Pane function | Acts as a table of contents of the database, displaying all the objects that make up the database |
| Navigation Pane customization | Can be customized by creating custom categories, groups within those categories, and then adding database objects to each group |
| Hiding Navigation Pane | Can be hidden by pressing F11 or by using the shutter bar open/close button |
| Navigation Pane display options | Can be displayed as a list or as icons with varying levels of detail |
Explore related products
What You'll Learn
Right-click the query to run or edit it
To display only queries in the Navigation Pane, you can customise the Navigation Pane by creating custom categories and groups. You can then add, hide, or show groups and objects to fit your needs.
Now, to run or edit a query, simply right-click on the query in the Navigation Pane and select 'Run' to execute it. Alternatively, you can open the query in 'Design View' to make modifications before running it. This process allows you to view and refine query outcomes effectively.
When you right-click on a query, a shortcut menu will appear. From this menu, you can select 'Run' to execute the query and display the results in Datasheet View. If you select 'Design View', you can edit or review the query design before running it. You can also add fields to the query design by double-clicking on a field from a table in the upper pane and moving it to the Field row of the design grid.
It is important to note that you can only run queries if a database is not operating in Disabled mode. Additionally, by default, Access disables all action queries in a database unless you indicate that you trust the database.
Right-clicking on a query in the Navigation Pane gives you the option to either run the query directly or modify it in Design View before execution. This flexibility allows users to efficiently manage and refine their queries within the same interface.
Concave Pans: Stainless Steel's Flaw?
You may want to see also
Explore related products
Create custom categories and groups
The Navigation Pane in Microsoft Access is the primary means of viewing and accessing all your database objects. It is customisable and can be used to create custom categories and groups. Here is a step-by-step guide on how to create custom categories and groups:
Creating Custom Categories
- Open the Navigation Options dialog box: Right-click on the top of the Navigation Pane and select "Navigation Options".
- Create a new category: In the dialog box, you will see a list of all the existing categories. To create a new custom category, click on the "New" button and enter a name for your category.
- Assign a type: Decide whether your custom category will be for Income, Expenses, or Transfers.
- Choose the group: Confirm the group that this custom category will be under.
- Optional settings: Decide if you want to toggle on the "Make this category a monthly rollover" and "Exclude this category from the budget" options.
- Add an icon: You can also give your custom category a unique icon to help identify it.
Creating Custom Groups
- Start with a category: First, decide which category you want to create a custom group for.
- Create a new group: In the Navigation Pane, right-click on the category and select "New Group".
- Name the group: Give your custom group a name that reflects the type of objects it will contain.
- Assign objects: You can now drag and drop existing objects from the Unassigned Objects group or create new objects specifically for this group.
- Hide or show groups: You can choose to hide or show specific groups within a category to focus on certain objects.
By creating custom categories and groups, you can organise your database objects in a way that suits your specific needs and helps you find information more efficiently.
Chip Pan Fire: What to Do and What Not to Do
You may want to see also
Explore related products
Add, hide, or show groups and objects
The Navigation Pane in Microsoft Access is the primary means of viewing and accessing all your database objects. It can be customized in a variety of ways, including adding, hiding, or showing groups and objects.
To add objects to custom groups, you can drag or copy and paste the objects from the Unassigned Objects group to a custom group. This adds a shortcut to a database object without moving or copying the object itself. Shortcuts can be identified by a small arrow in the lower-left corner of the object icon. Each group should have only one shortcut to a given database object.
You can hide some or all of the groups in a custom category and some or all of the objects in a group. You can use right-click commands provided by the Navigation Pane or choose a property for each object to hide it from all groups and categories in the open database. You can make hidden objects and groups completely invisible, or display them as dimmed, unavailable icons by selecting or clearing the Show Hidden Objects check box in the Navigation Options dialog box.
To unhide a group or object, use the same Show Hidden Objects check box. If you hid a shortcut in a group, right-click the shortcut and then click "Unhide in this Group". If you hid the object from its parent group and category, right-click the object and then click "Unhide". If you hid the object from all categories and groups, right-click the object, click "View Properties", and then clear the Hidden check box.
To display the results of a query in the Navigation Pane, right-click the query and select "Run" to execute it, or select "Design View" to make modifications before running it.
Wok: Pan, Pot, or Both?
You may want to see also
Explore related products
Change the way icons display
The Navigation Pane in Access is the primary means of viewing and accessing all your database objects. It can be customised in a variety of ways, including changing the way icons are displayed. Here are some ways to do this:
Create Custom Categories and Groups
You can create your own categories and groups within those categories, and then add the relevant database objects to each group. When you create a new custom category, groups named 'Unassigned Objects' and 'Custom Group 1' are automatically generated. You can then add, hide, or show groups and objects to suit your needs.
Adjust the Appearance of Icons
You can adjust the appearance of icons by changing their size or hiding them. To resize icons, select 'View' and then choose from 'Large icons', 'Medium icons', or 'Small icons'. To hide icons, select 'View' and uncheck 'Show desktop icons'. This will hide all icons, but you can easily show them again by rechecking the same option.
Change App Icons
If you're using an Android device, you can change your app icons by installing a third-party app launcher or using your device's native support. For Samsung Galaxy devices, open 'Settings', scroll down and select 'Themes', tap the 'Icons' tab, and then tap the app icon pack you want before tapping 'Download'.
Change Essential Icons
On Windows, you can customise essential icons such as 'This PC', 'Recycle Bin', and 'Network'. In the Settings app, select 'Personalization' > 'Themes' or use the shortcut by selecting 'View' and then choosing icon size.
Skimming Oil from Pan: Easy, Quick, and Efficient Methods
You may want to see also
Explore related products
![Warrky USB C to DisplayPort Cable for Office and Gaming (8K 60Hz, 4K 240/144Hz) Aluminum Type-C to Display Port Cord [Thunderbolt 3/4 Compatible] for MacBook Pro/Air, iPhone 15 Series, iPad -10ft](https://m.media-amazon.com/images/I/71JWQDCOVXL._AC_UL320_.jpg)
Show or hide the Navigation Pane
The Navigation Pane in Microsoft Access displays database objects and is the primary way to view and access all your database objects. It is located on the left side of the Access window by default. The Navigation Pane can be customized in a variety of ways, including the ability to hide or show the pane.
To show or hide the Navigation Pane in Access desktop databases, you can press F11. Alternatively, you can follow these steps:
- Click the File tab.
- Click Options.
- Click the Current Database category.
- Under Navigation, clear or select the Display Navigation Pane check box.
- Click OK.
- Close and reopen the database to see the changes.
To show or hide the Navigation Pane in Access web apps:
On the Home tab, in the Show group, click the Navigation Pane toggle button.
Note that when you open a Blank Access web app for the first time, the Navigation Pane is not displayed by default.
You can also adjust the appearance of the Navigation Pane by hiding or showing specific groups and objects within the pane. This can be done through right-click commands or by changing the properties of each object. You can also choose whether to display hidden objects by selecting or clearing the Show Hidden Objects check box in the Navigation Options dialog box.
Additionally, you can display the results of a query in the Navigation Pane by right-clicking on the query and selecting 'Run' or 'Design View' from the shortcut menu.
Removing Burnt Cookies: Tips for an Easy Clean
You may want to see also
Frequently asked questions
Right-click the query and select 'Run' to execute it. Alternatively, you can open the query in 'Design View' to make modifications before running it.
Right-click the query in the Navigation Pane and then click 'Run' on the shortcut menu.
By default, Access displays Tables, Queries, Forms, and Reports. To display only queries, you can create custom categories and groups.
Use the Navigation Options dialog box to create and manage custom categories and groups.
To switch between queries, select the query you want to go to.
