Monthly Archives: March 2012

Create a watermark in a Microsoft Word document

Posted on March 29, 2012 by jdonbavand

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, Microsoft Word 2013, Microsoft Word 2016 | Tagged , | Leave a comment

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

Posted on March 28, 2012 by jdonbavand

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

Posted on March 28, 2012 by jdonbavand

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

Posted on March 15, 2012 by jdonbavand

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 Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016, Microsoft Office 2007 and 2010 | Tagged , | Leave a comment

Shortcut keys in Microsoft PowerPoint

Posted on March 15, 2012 by jdonbavand

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

Posted on March 12, 2012 by jdonbavand

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

Posted on March 8, 2012 by jdonbavand

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

Posted on March 8, 2012 by jdonbavand

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

Posted on March 4, 2012 by jdonbavand

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