Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.
You can work more efficiently with data when you know how to take advantage of the ActiveX data objects (ADO) library. Susan Harkins offers some pointers that will help you use ADO objects effectively and avoid potential code snafus.
You can save paper by printing multiple PowerPoint slides to a single sheet of paper. The trick is to rely on a printer option rather than on PowerPoint itself.
A sluggish database can cost your money and waste users’ time. Here are some maintenance tasks and general best practices to ensure your database is healthy and operating at peak efficiency.
Plenty of solid products are available to help you protect your system — and some of them don’t cost a dime. Here’s a list of some of the most popular and effective free tools for defending yourself against a variety of threats.
The right add-in can provide helpful features and make existing Office capabilities easier to use. Susan Harkins has rounded up a selection of handy add-ins for various Office applications.
A few best practices can go a long way toward protecting your Access data from careless or overly curious users. Here are some simple ways to add a few layers of security to a database.
Entering data into a worksheet can be time-consuming, and mistakes often find their way in — but with the right tools, both speed and accuracy can be improved. Here’s a look at several Excel features that facilitate data entry.
Don’t let selection woes get in the way of formatting just the numbers and bullets in a list. Here are two simple (but non-intuitive) ways to handle the task.
A missing value can lead to confusion by returning error values. But a properly used Nz() function can turn an error message into an understandable and expected value.
