Susan Harkins

After creating a presentation, you can ensure everything looks the same on other computers by embedding the fonts in the presentation by selecting the right options when saving.

Don’t manually re-enter data you find on the Web. Open Excel and transfer the data directly into a worksheet.

Referencing a control on an Access form is easy. Referencing a subform and its controls is a little more complex. To Access, a subform isn’t a form at all, but a control, so you must reference it as such.

A quick keyboard shortcut puts you right into the Formula bar. You don’t need the mouse at all!

Microsoft Access may not be right for all situations, but it does have its place — at least according to database expert Susan Harkins. Here’s her take on some of the more common complaints she’s encountered from IT pros who like to kick Access around.

Bullets are easy to insert in all Office applications, but the default bullet might not make the right impression in a PowerPoint presentation. Change bullets quickly and easily.

Outlook is flexible enough to send e-mail to cell phones. You just need the cell phone’s 10-digit number, the carrier’s domain, and a cell phone that supports SMS.

By holding down the Ctrl key, you can copy a Word table’s row or column to create a new row or column.

The Recordset object is an essential component in Access development, but it often trips up even experienced developers. Susan Harkins explains 12 common Recordset pitfalls you can anticipate and avoid.

Word’s default number alignment is Left, which presents an awkward list if the numbers reach double digits. Fortunately, you can force proper alignment — if you know where to find the correct option.

When adding endnotes to a Word document, you can position them at the end of a section instead of at the end of the document.

Number Word table rows and columns