Posted by computertrainer in Access Tips, Excel Tips, Outlook Tips, PowerPoint Tips, Publisher Tips, Visio Tips, Word Tips.
Tags: customize toolbar, icon, toolbar
Today during an Office 2007 class with employees at KaZak Composites in Woburn, MA, we discussed using the Filter feature in an Outlook calendar. This is a multi-step process if you start from the menu.
Adding the Filter icon to a toolbar makes the process simpler. Since that feature was not included in their book, I thought I would share the steps here so everyone can benefit from this shortcut.
NOTE: You can add icons to other office applications using the same technique, however, Outlook 2007 is the only Office 2007 application that uses the toolbar. So try this in Office 2000, XP, or 2003 for Excel, Word, etc.
- [RIGHT] click on any toolbar and select Customize.

- Make sure you can see the toolbar you want add an icon to.
- Click the Commands tab.
- In the Categories box, click the View category. (The Category will be the Menu that you would use to find the command.)

- Scroll on the Commands: until you find Filter … (or the command you want to add).
- Click on the Filter… command and drag it to the toolbar.
- Release the mouse button when it is placed in the location of your choice.
NOTE: You will see an “I beam” where it will be dropped.
- Click Close.
- Now when you want to filter simply click the icon, then go to the More Choices tab and click Categories to filter based on a category.
- When you want to remove the filter, click on the Filter icon and select Clear All.
Posted by computertrainer in Access Tips.
Tags: Access
(Access 2000, 2003, and 2003)
If you are working in Datasheet view with a table or query that has many fields, moving between columns can be frustrating. There is an easy way to move to a particular column.
First, display the Formatting (Datasheet) toolbar. To do so, right-click on the Table Datasheet toolbar and choose Formatting (Datasheet) from the shortcut menu. (You can also choose View | Toolbars | Formatting (Datasheet) from the menu bar.)
Then, choose the name of the field that you want to go to from the Go To Field dropdown list. Access selects the cell in the appropriate field within the current record.