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...
Friday, October 17, 2008
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:
- Open the form in Design view.
- In the Forms Design Tools, Design ribbon, in the Controls group, click the Insert Chart tool.
- Click and drag in a blank area of the form to create the chart.
- Select Queries under the View section and then select the November Hours Worked query and then click Next >.
- Double-click the Last Name and Hours Worked fields.
- Click Next > four times.
- Enter Total Hours Worked In November for the chart title.
- Select No, Don’t Display Legend and then click Finish.
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.
Well, after a bit of research, I found the answer. I've included both the Windows XP and Vista versions for reference.
- 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
- Copy the QAT file from your source computer to a USB drive or CD.
- Take the file to the destination computer and copy the QAT file into the same location on the destination computer.
- 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
Saving a Cover Page to the Cover Page Gallery
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.
Inserting a Cover Page
- On the Insert ribbon, in the Pages group, click Cover Page.
- 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.
Saving a Cover Page to the Cover Page Gallery
- Select your entire cover page in the Word window
- On the Insert ribbon, in the Pages group, click Cover Page
- Click Save Selection to Cover Page Gallery…
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.
- On the Insert ribbon, in the Pages group, click Cover Page
- 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..."
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..."
Subscribe to:
Posts (Atom)