The Navigation pane on the left hand side has a few tricks up its sleeve so that you can use it effectively for your workflow. Let's take a look at its features. First you can click this little double arrow to collapse and open it to give yourself some more real estate. If you hold your cursor over the right edge, you'll get a double-headed arrow and you can make it wider or narrower as needed. You can click the Section headers to open and close them. You can use the search box at the top to quickly find what you're looking for.
For example, if I click in the box and type the word Customers, you can find all your database objects that contain the word customers. An added tip is that if you're clicked on any object in the Navigation pane, pressing Ctrl+F on your keyboard will jump your cursor up to the search box window. But that only works if you're already clicked there and not somewhere else on the screen. I'll click this little button to clear my search and see all my objects again. You can also Sort and Resort the Navigation pane so it's useful for you.
Right now it's sorted by object type. So all my Tables, my Queries, my Forms, and my Reports are grouped together. If I go to this little dropdown, this arrow inside the circle, I have more options. I like to use Tables and Related Views. If I get a message, I will go ahead and click OK and now it resorts itself. Here's my Customers: Table and then here are all the Queries, Forms, and Reports based on it. Below that is my Orders: Table and all of its Queries, Forms, and Reports.
Now if you have forms and reports that are based on more than one table, you may see them in more than one place. For example, my Orders by Customer Report has elements of both my Orders table and my Customers table. So I see it in both places. You can also reorganize by the date that objects were created or by when they were modified. Things I did today, things I did last week. The bottom half of the dropdown also allows you to filter. For example, let me change this back to Object Type, so that I am back to seeing my tables together and my queries together et cetera.
I'll drop this down and now I can filter it so that I am just looking at my queries. There are all my queries and everything else is hidden. When I'm done, I'll go back to the dropdown and choose All Access Objects, and everything is back again. Because the Navigation pane is so flexible, you can organize it and re-organize it any which way you need depending on your task at hand.
Author
Released
2/8/2011- Creating new field with field templates
- Understanding errors
- Filtering data
- Aligning and distributing controls
- Customizing the interface
- Navigating quickly between records
- Speeding up data entry
- Analyzing a table for redundant data
- Creating a multi-field primary key
- Moving records with append and delete queries
- Transforming a query into a PivotTable or PivotChart
- Working with images, charts, and Smart Tags in forms
- Hiding duplicates in reports
- Formatting shortcuts
- Using macros
Skill Level Intermediate
Duration
Views
Related Courses
-
Access 2007: Queries
with Adam Wilbert2h 8m Intermediate -
Access 2010: Shortcuts
with Alicia Katz Pollock3h 43m Intermediate
-
Introduction
-
Welcome43s
-
-
1. Top Tips
-
Using input masks2m 30s
-
Four ways to filter data2m 57s
-
2. File Management
-
Opening recent files1m 49s
-
-
3. Ribbon and Quick Access Toolbar Tips
-
4. Interface Shortcuts
-
Right-clicking2m 32s
-
Using keyboard shortcuts2m 50s
-
5. Navigation Shortcuts
-
Navigating between records1m 54s
-
-
6. Data Entry and Editing Shortcuts
-
Undo and Redo tips2m 26s
-
Inserting today's date1m 14s
-
Using AutoCorrect1m 45s
-
Using concatenated fields8m 56s
-
Linking Outlook contacts2m 38s
-
-
7. Table Techniques
-
Setting data types2m 15s
-
Setting default field types2m 30s
-
Using validation rules2m 1s
-
Using flag fields2m 6s
-
Using an index1m 58s
-
Using a datasheet Totals row1m 47s
-
Filtering by selection1m 22s
-
Resizing columns and rows1m 50s
-
8. Relationship Techniques
-
Using subdatasheets1m 31s
-
Using relationship reports1m 52s
-
9. Query Techniques
-
Using wildcards5m 33s
-
Using IN instead of OR1m 34s
-
Changing captions1m 42s
-
Finding duplicate records2m 17s
-
Using make-table queries2m 23s
-
Creating an update query2m 49s
-
Using SQL statements2m 27s
-
-
10. Form Techniques
-
Creating option groups2m 35s
-
Creating tabbed form layouts4m 41s
-
Inserting charts3m 39s
-
Creating your own smart tags1m 25s
-
Hiding fields in printouts1m 32s
-
Setting tab stops4m 46s
-
11. Report Techniques
-
Creating headers and footers4m 50s
-
12. Formatting Shortcuts
-
Using the Format Painter2m 17s
-
-
13. Macro and Event Techniques
-
Using AutoExec macros1m 46s
-
14. Database Management Techniques
-
Exporting to PDF1m 50s
-
Locking files38s
-
-
Conclusion
-
Goodbye42s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Customizing the Navigation pane