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.