ExecuTrain Houston

Monthly Tip | Customizing the Ribbon

Customizing the Office^® 2010 Ribbon

In Windows^® Office^® 2010 you can create a custom ribbon tab with custom groups for your frequently used commands.

1. 1. Click the File tab and choose Options.
2. 2. In the Options dialog gox, click Customize Ribbon.
   
3. 3. Click the New Tab button.
   
4. 4. In the Customize Ribbon area, click on New Tab (Custom) and click the Rename button. Type the name for the tab. Click OK.
   

5. 5. Click on New Group (Custom) and click the Rename button. Key in the name for the group. Click OK.
6. 6. Populate the new ribbon: click the appropriate command from the Commands list and click the Add button. Continue until finished.
7. 7. Rearrange the buttons on the tab, if needed. Rearrange the placement of the tab on the Ribbon, if needed.
8. 8. Click the OK button.

NOTE: Return to the Customize Ribbon window and add and delete buttons to your Custom tab.

Tags: Office 2010, weekly tip
Posted in Company Blog, Featured Products, Tip of the Week | Comments Off

Monthly Tip: Windows 7 | Customizing a Library

Customizing a Library in Windows^® 7

Setting a Library Type

1. 1. Open the Library window
2. 2. Right-click the appropriate library icon.
3. 3. On the shortcut menu, click the Properties command.
4. 4. In the Properties dialog box, click the Optimize this library for drop-down list, and select the appropriate option.



5. 5. Click the OK button.

Remove a Folder for a Library

1. 1. In the Properties dialog box, click the appropriate folder, and then click the Remove button.



2. 2. Click the OK button.

Tags: training, weekly tip, Windows 7, Working Smart
Posted in Company Blog, Tip of the Week | Comments Off

Weekly Tip: Windows 7 | Search for Files

Searching from the Windows^® 7 Start Menu

Windows 7 includes several different tools for locating files stored on your computer or your company network.

1. 1. Click the Start button
2. 2. On the Start menu, enter the known criteria.



3. Note: Windows will show the matching results as you enter the criteria. In most cases you only have to enter the first part of the search information.
4. 3. In the results list, click the desired item.
5. Note: If necessary click the See more results hyperlink.

Windows^® Explorer Search

1. 1. Access the Windows Explorer window.
2. 2. In the Search text box, located in the upper, right-hand corner of the window, enter the search criteria.



3. Note: A list of matching results will display in the Windows Explorer as you enter the information for the search.
5. - OR
6. Click the drop-down arrow in the Search text box, to select a previously used search option.
7. 3. Click the Show Preview button to view the contents before opening the file.
   

   Tags: weekly tip, Windows 7
   Posted in Company Blog, Tip of the Week | Comments Off

Weekly Tip: Windows 7 | Taskbar Pinning

Pinning an Application in Windows^® 7

Programs that are used frequently can be pinned to the taskbar for easy access. There are a few ways to accomplish this task.

Open Applications

For applications that are already open, complete the following steps to pin them to the Taskbar.

1. 1. On the Taskbar, right-click the appropriate program icon.
2. 2. In the Jump List, click the Pin this program to taskbar command.

Closed Applications

For application that are not currently open, complete the following steps to pin them to the Taskbar.

1. 1. Click the Start button.
2. 2. On the Start menu, locate and right-click the appropriate application.
3. 3. On the shortcut menu, click the Pin to Taskbar command.

Tags: weekly tip, Windows 7
Posted in Company Blog, General, Tip of the Week | Comments Off

Weekly Tip: Windows 7 | Taskbar Preview

Forget what documents you have open or which compotators’ Web Site you were looking at? Using the Taskbar Preview feature in Windows 7, you can quickly see what files you have open.

Previewing Files from the Taskbar in Windows^® 7

1. 1. Move the mouse over the appropriate Taskbar icon.
   A mini thumbnail preview displays at the bottom of the screen.
2. 2. In the Preview pane, move the mouse over the appropriate mini thumbnail to display a larger preview.
   – OR –
   Click the appropriate mini thumbnail to launch the appropriate file.

Tags: weekly tip, Windows 7
Posted in Company Blog, Tip of the Week | Comments Off

Weekly Tip: Windows 7 | Taskbar

The Windows 7 Taskbar includes larger buttons that make it easier to see available files and applications. The Taskbar can include pinned programs, in addition to showing programs currently open on the computer. For pinned programs the look of the icon changes depending on the current status of the corresponding application.

Using the Taskbar in Windows^® 7

1. A. Icons with a raised look, indicates the icon’s application or file is opened.
2. B. Icons with stacked look, indicates the icon’s application is opened to more than one file.
3. C. Icons with a flat look, indicates the application is currently closed, but pinned to the Taskbar.

Tags: weekly tip, Windows 7
Posted in Company Blog, Tip of the Week | Comments Off

Weekly Tip: Windows 7 | Aero Peek

The Aero^® Peek feature allows you to quickly switch between the open
windows and the computer Desktop. To see past all the open windows, hover over the Show Desktop button. When you are done viewing the desktop, move your mouse away from the button and the windows redisplay.

Using Windows^® 7 Aero Peek to View Desktop

The Show Desktop button is located on the right-hand side of the taskbar.

1. 1. On the Toolbar, click the Show Desktop button to minimize all of the open windows.
2. 2. Click the Show Desktop button again to maximize the previously open windows

Tags: weekly tip, Windows 7
Posted in Company Blog, Tip of the Week | Comments Off

Weekly Tip: Windows 7 | Aero Shake

The Aero^® Shake feature allows you to minimize all open windows except the one you are working on.

Using Windows^® 7 Aero Shake

1. 1. Click the title bar of the window you want to leave open.
2. 2. Shake the mouse left to right. All other windows are minimized.

Desktop View before Aero Shake

Desktop View after Aero Shake

Note: Repeat the process to restore all windows to the desktop.

Tags: weekly tip, Windows 7
Posted in Company Blog, Tip of the Week | Comments Off

Weekly Tip: Office 2007 | Ribbons

One of the biggest changes in Microsoft^® Office 2007 is the addition of the Office Ribbon which includes the Office Button, Quick Access Toolbar, and Tabs. The Tabs replace the Menus and Toolbars with a graphical representation of the available options within the application.  The options are grouped based on common actions and page elements, allowing you to apply the options to your document, spreadsheet or presentation rapidly.

The Tabs available change depending on the application in which you are working and the type of element you are working with. For example, if you select a photo or graphic within your document, the Picture tab displays. When you click off of the object, the Picture tab is then hidden.

To minimize the tabs, complete the following action:
· Click the Customize Quick Access Toolbar button, and then click the Minimize the Ribbon link. – OR – Double-click any tab name.

Tags: Office 2007, weekly tip
Posted in Company Blog | Comments Off

Weekly Tip: Access^® 2007 | Displaying a Calendar

Displaying a Calendar

1. Open the form in Design view.
2. On the Design tab, in the Controls gallery,
click the Insert ActiveX Control button.

3. In the Insert ActiveX
Control dialog box, click the Calendar Control 12.0 option,
and click the OK button.
4. Click in the form at the location for the
calendar.

5. Size and arrange the calendar on the form.
Use the calendar’s Properties dialog box to
customize its looks.

This Tip of the Week was brought to you
by the learning professionals at ExecuTrain Houston.

To learn more, sign up for one of our Microsoft Office Access 2007 public classes
or ask about our Private Consults or Client-Site learning events.

To get the complete Quick Reference Card for Microsoft Office,
contact a learning specialist for pricing and delivery.

Tags: Access 2007, weekly tip
Posted in Company Blog, Tip of the Week | Comments Off