susan harkins

Blog Post

Store sent mail efficiently in Outlook

June 10, 2008 9:54am PDT

If your Sent folder has gotten unruly, you might want to try this organizational trick: Have Outlook store your replies in a separate folder with the original messages.

50 Latest comment by MC68000

Blog Post

Align just the numbers in Word's automated numbered lists

June 9, 2008 9:17am PDT

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.

2 Latest comment by lbindustries1@...

Blog Post

How do I... Identify and delete duplicates from SQL Server tables?

June 3, 2008 8:21am PDT

Duplicate records in a database are bad. You can't tolerate them. The good news is that finding and deleting duplicate records in Microsoft's SQL Server isn't a difficult task. However,...

3 Latest comment by Tony Hopkinson

Downloads

How do I... Identify and delete duplicates from SQL Server tables?

June 3, 2008 12:00am PDT

Duplicate records in a database are bad. You can't tolerate them. At the very least, they'll produce misleading analysis. At the worst, they'll totally wreck everything. The good news is that...

Provided by: Susan Harkins

Blog Post

Toggle Word's Print Preview

June 2, 2008 12:00am PDT

Use the keyboard shortcut [Ctrl]+[Alt]+I to toggle back and forth between your document and Print Preview.

10 Latest comment by deantaia@...

Blog Post

Force a page break before a specific paragraph

May 30, 2008 12:00am PDT

Don't let manual page breaks muck up your Word document. When you really need content to begin on a new page, attach the page break to the first paragraph on that page.

9 Latest comment by Ruby007

Blog Post

Use an array to add time components in Excel

May 26, 2008 12:00am PDT

Use an Excel array to return a single cumulative time value. This works equally as well when the time components are single integer values instead of literal time values.

Blog Post

Outlook shorthand for dates

May 23, 2008 12:00am PDT

Use shorthand to enter dates when printing Outlook calendars. For instance, if you want to print 5 months from the current date, you can enter the string 5mo, instead of a literal date.

4 Latest comment by ssharkins@...

Blog Post

How do I... Replace a complex connection string with a DSN?

May 20, 2008 8:09am PDT

Anybody who’s interacted with foreign data programmatically knows that getting the connection code right can be frustrating. If you support yourself, you might find a Data Source Name (DSN)...

Downloads

How do I... Replace a complex connection string with a DSN?

May 20, 2008 12:00am PDT

Technically speaking, a Data Source Name (DSN) is an identifier to a data source for an Open Data Base Connectivity (ODBC) driver (library). ODBC is a function library that interfaces between the...

Provided by: Susan Harkins

Blog Post

How to add descriptive text to a PowerPoint slide

May 19, 2008 12:00am PDT

Take advantage of PowerPoint notes. During the development stage, jot down reminder notes and suggestions. During a presentation, use notes as handouts for the audience or use them to script the...

2 Latest comment by kevinsmith880

Blog Post

How to get around Outlook 2007's printing bugs

May 16, 2008 12:00am PDT

Outlook 2007 has a number of print bugs. You can download the Calendar Printing Assistant or Office 2007 SP1 for help.

3 Latest comment by StevePrem

Blog Post

10+ common questions about SQL Server data types

May 15, 2008 2:07pm PDT

SQL Server has a variety of data types, and as with most things, the more options you have, the more confusing a choice can be. Susan Harkins offers answers to the questions she hears most often...

3 Latest comment by sqllion

Downloads

10+ common questions about SQL Server data types

May 15, 2008 12:00am PDT

SQL Server has a variety of data types, and as with most things, the more options you have, the more confusing a choice can be. Susan Harkins offers answers to the questions she hears most often...

Provided by: Susan Harkins

Blog Post

How do I... Spice up a list in a Microsoft PowerPoint presentation?

May 13, 2008 11:10am PDT

Most of us use bullets or numbers to introduce specific ideas or points. There's nothing wrong with them, but they are rather ordinary. In a Microsoft PowerPoint presentation, you might want to...

39 Latest comment by ssharkins@...

Downloads

How do I... Spice up a list in a Microsoft PowerPoint presentation?

May 13, 2008 12:00am PDT

Most of us use bullets or numbers to introduce specific ideas or points. There's nothing wrong with them, but they are rather ordinary. In a Microsoft PowerPoint presentation, you might want to...

Provided by: Susan Harkins

Blog Post

How do I... Use the Office Clipboard instead of the Windows Clipboard?

May 8, 2008 11:18am PDT

Most of us get by most of the time just using the basic Microsoft Windows Clipboard. Copying multiple items at the same time will take a bit more work. However, the Office Clipboard makes quick...

Downloads

How do I... Use the Office Clipboard instead of the Windows Clipboard?

May 8, 2008 12:00am PDT

Most of us get by most of the time just using the basic Microsoft Windows Clipboard. Copying multiple items at the same time takes a bit more work. You can spend a lot of time switching between...

Provided by: Susan Harkins

Blog Post

Shortcuts for accessing the Windows Desktop

May 2, 2008 12:00am PDT

Use Windows keyboard shortcuts to give focus to the Desktop and then return quickly to the window in which you were last working.

12 Latest comment by lal@...

Blog Post

10+ tips for using Word's Track Changes feature for collaborative editing

April 30, 2008 9:55am PDT

Word's Track Changes feature simplifies the process of editing and reviewing documents -- if you know how to use it effectively. Susan Harkins shares some of the tricks she's discovered from using...