![]() ![]() This view helps you to find out what objects will be affected if you make a change to a table.Įxample: In the Language Arts Classes database, the Bonus Points table is used by five queries and two reports, as shown in the illustration. Since some objects use more than one table, an object can appear in more than one category in this view. Tables and Related Views: Puts together all of the objects that use the same table.as the illustration at the top of the page shows. Object Type: (default) Puts the tables together and the queries together, etc.You really cannot see all of these at once! Category Schemes: The Language Arts Classes example database has 17 tables, 48 queries, 21 forms and subforms, 31 reports, and 2 macros. But it is easy to build up a large number of objects, especially queries and reports. (Yes, it's still called a 'filter' even though nothing is left out.)Ī database with only a few objects is easy to work with when all objects are shown in the pane. This combination shows all of the objects in the list and puts all tables together, all queries together, etc., like the illustrations above. The illustration shows the default choices: show a category for each Object Type and filter by showing All Access Objects. You must make a choice in each section, which will then show a check mark. The menu (shown at the right) has two sections: Navigate to Category and Filter by Group. You can also right click on the pane's title bar or a group's title and choose Category to open a list of the same choices for Category. The down arrow opens a menu of category schemes and filters. The text on the shutter bar at the top of the Navigation Pane shows the current filter. The Navigation Pane can show or hide category lists in any combination. You can open or close them in any combination that you wish. Just click the chevron button at the right end of the bar to open or close that category list. The category bars in the pane are also shutter bars, with chevrons that point up or down. To resize the pane just drag the right border out or in. Click on it again to open the full pane back up. Just click on the left-pointing chevron >. Access 2013, 2016: File > New > search for Northwind 2007 Open/Close or Resize Pane:Īt the top of the Navigation Pane is a shutter bar, which has a chevron button to close up the pane when you want more space to work.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |