Friday, October 17, 2008

ARTICLE: Add a popup window to a PowerPoint slide

Date: October 12th, 2008
Author: Susan Harkin, TechRepublic.com

"Sometimes you want to display additional information that’s not a permanent element on a slide — similar to a popup window. In other words, the information is hidden until you want to display it. For instance, you might want to display quarterly bonuses to build excitement. Or you might want to share a contact phone number or e-mail address if asked. There’s no built-in feature that does this, but you can still get PowerPoint to display a pseudo popup window by adding a trigger that displays a callout." Read the full article...

Wednesday, October 1, 2008

Microsoft Access 2007: Use charts to display data on Access 2007 forms

Access 2007 makes it easy to build a graph control for your form that will display calculated data — and often better than with a text form control. For example, say your employee database includes two tables: one with employee data and one with data about hours worked during 2007. The database also contains a November Hours Worked query that includes the Last Name, First Name, and Employee ID fields from the Employee Data table, and the Week Ending and Hours Worked fields for November from the 2007 Hours Worked table. You create a form based on the query that includes all of the fields. To add a chart to the form that graphs the total hours worked for each employee for the month of November, follow these steps:
  1. Open the form in Design view.
  2. In the Forms Design Tools, Design ribbon, in the Controls group, click the Insert Chart tool.
  3. Click and drag in a blank area of the form to create the chart.
  4. Select Queries under the View section and then select the November Hours Worked query and then click Next >.
  5. Double-click the Last Name and Hours Worked fields.
  6. Click Next > four times.
  7. Enter Total Hours Worked In November for the chart title.
  8. Select No, Don’t Display Legend and then click Finish.
As you click through each employee’s record, the Graph control will display a bar chart for the employee, showing the total hours they worked in November 2007.

Thursday, September 25, 2008

Copy the Quick Access Toolbar to Another Computer

One of the users on campus asked me a very good question that I'm sure other people would love to know. Her question was that after she spent a good amount of time customizing her Quick Access Toolbar in Word, is there a way to share it with her co-workers so they don't have to take the time to do so? I thought this was a great question. I was thinking the same thing earlier this week as I was working on a PowerPoint presentation at work, but didn't finish by 5:00, so I took it home with me. My home computer still had the default Quick Access Toolbar as I hadn't taken the time to customize it. I wished I could just copy it from work to take home.

Well, after a bit of research, I found the answer. I've included both the Windows XP and Vista versions for reference.
  1. Find the Quick Access Toolbar (QAT) file associated with the application you want from your source computer.
    • XP, C:\Documents and Settings\\Local Settings\Application Data\Microsoft\Office\*.qat
    • Vista, C:\Users\\AppData\Local\Microsoft\Office\*.qat
  2. Copy the QAT file from your source computer to a USB drive or CD.
  3. Take the file to the destination computer and copy the QAT file into the same location on the destination computer.
  4. DONE!


Tuesday, September 16, 2008

Monday, September 1, 2008

Word 2007: Inserting a Cover Page

Word 2007 makes it easy for you to customize the look of your documents. But one of the handiest features in Word 2007 is the Cover Page option. Word 2007 includes a number of preformatted cover pages that you can insert with a few clicks of your mouse.

Inserting a Cover Page
  1. On the Insert ribbon, in the Pages group, click Cover Page.
  2. In the Cover Page gallery, select a design that you like. The cover page will be inserted at the beginning of your document. The Drawing Tools ribbon will open to allow you to customize the look of the cover page.
Of course, you're not limited to the cover pages included with Word. You can customize the preinstalled designs. You can also save your own cover pages in the Cover Page gallery.

Saving a Cover Page to the Cover Page Gallery
  1. Select your entire cover page in the Word window
  2. On the Insert ribbon, in the Pages group, click Cover Page
  3. Click Save Selection to Cover Page Gallery…
Removing a Cover Page from Your Document

You can also remove a cover page if you want to insert a different one or if you decide you don't want a cover page at all.
  1. On the Insert ribbon, in the Pages group, click Cover Page
  2. Click Remove the Current Cover Page


Monday, August 18, 2008

ARTICLE: Why did the line spacing change in Word?

During most of the workshops I've done regarding the upgrade to Word 2007, I've taught attendees how to change the default font and paragraph settings back to the preferred Word 2003. I, personally, like the change in default, but have not had an answer as to "why" this change happened. Here is the answer...




Tuesday, August 12, 2008

ARTICLE: Word Has a Mind of It's Own

If you have attended one of my workshops, you may already know what a huge fan I am of the Crabby Office Lady. Here's a terrific article she wrote about many of the "troubles" people have with Word. I know I've answered my share of these questions myself. Even though this article is from September 2005 and deals with Word 95-2003, it's still worth reading. The topics are still relevant to 2007, but you will have to find them in the new places.

Word has a mind of it's own: So do you
"I get a lot of inquiries about how to institute a restraining order on Word to stop it from guessing what you want to do with your documents. I created a video about it, and now we'll delve a little deeper..."