Monthly Archives: March 2012

Create a watermark in a Word 2007 or Word 2010 document

You may have created a document which you want to send out to colleagues but want a watermark in the document to remind them that this is a first draft. With the document open, on the Page Layout tab, in … Continue reading

Posted in Microsoft Word, Microsoft Word 2007, Microsoft Word 2010 | Tagged , | Leave a comment

Keyboard shortcuts for entering records into a Microsoft Access table or form

Shortcut What will be inserted Ctrl + ; Inserts the current date Ctrl + : Inserts the current time Alt + Ctrl + Spacebar Inserts that field’s default value Ctrl + ‘ Inserts the value from the same field in … Continue reading

Posted in Microsoft Access, Microsoft Access 2003, Microsoft Access 2007, Microsoft Access 2010 | Tagged , | Leave a comment

Compacting and repairing a Microsoft Access database

When you delete data and objects, such as tables and queries from an Access database, the database may become fragmented and take up more space than it should. If your database suddenly seems very large, this may well be the … Continue reading

Posted in Microsoft Access, Microsoft Access 2003, Microsoft Access 2007, Microsoft Access 2010, Uncategorized | Tagged , | 1 Comment

Transposing Microsoft Excel rows to columns and columns to rows

Excel data can be easier to interpret as rows or as columns depending on the context. Sometimes it is necessary to switch the orientation to make it easier to understand, more efficient to work with, or more presentable. An example … Continue reading

Posted in Microsoft Excel, Microsoft Office 2007 and 2010 | Tagged , | Leave a comment

Shortcut keys in Microsoft PowerPoint

Some of the shortcut keys shown below are used in other packages in the Microsoft Office suite. All are common to Microsoft PowerPoint 2003, Microsoft PowerPoint 2007 and Microsoft PowerPoint 2010. Keystrokes Use Ctrl + A On Slide tab, selects all … Continue reading

Posted in Microsoft PowerPoint | Tagged , | Leave a comment

Creating an Microsoft Outlook e-mail message from Microsoft Access that includes a form asking for specific database items

If you are using Outlook 2007 or Outlook 2010 and Microsoft Access 2007 or Access 2010 you can create an e-mail message from Access that incorporates a form asking the recipient for specific items required for the database. When the … Continue reading

Posted in Microsoft Access 2007, Microsoft Access 2010, Microsoft Outlook | Tagged , | 1 Comment

Total Several Rows and Columns Quickly in Microsoft Excel

You may need to create totals for several rows and columns in a worksheet, such as for each year, or for each store, as in our example. First select the table containing the data and the empty cells to the … Continue reading

Posted in Microsoft Excel, Microsoft Office 2007 and 2010 | Tagged | Leave a comment

GROWing Others in Coaching Sessions

Sometimes we are asked to coach others who are new to the job just because we are older and wiser. It doesn’t necessarily mean we have the necessary skills to coach them. The GROW model gives us a ground plan … Continue reading

Posted in Coaching skills, Mentoring training | Tagged , , | Leave a comment

Viewing Styles in Microsoft Word 2007 and Microsoft Word 2010

Sometimes you use a style but cannot see it in the Styles group. On the Home tab, in the Styles group, click the Styles dialog box launcher. The Styles task pane opens at the right of the window. Click the … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment