Microsoft Excel Addition Bug Workaround
Here is part 2 in my series about the Microsoft Excel Addition Bug. I demonstrate 2 ways of working around the problem.
The Pros and Cons of Email vs Paper Newsletters
I was interviewed by Matthew Rodella from the Computer Business Marketing Show on the topic of newsletters.
How to Speed up an Access Database on a Network
Speed up your Access Database on a network connection with these tried and tested techniques from a database professional with over three decades of experience. A slow Microsoft Access database on a network is painful for the staff who have to use the system. It makes using it, a tiresome, burdensome chore. Unnecessary slowness causes…
Marketing tips on the YFNCG podcast
I was interviewed by Matthew Rodella from Your Friendly Neighbourhood Computer Guy about marketing techniques for small business owners. CBP 008: Tips from a Veteran Computer Business Owner Thanks to Matthew Rodella for the opportunity to be on his show. I shared my experiences at different and unique ways of marketing an I.T. business. The Your…
Software Installation Guide for I.T. Professionals
This guide explains the software installation for all software in our catalog at I.T. Guaranteed, including Open Fleet®, NEPTA (Non-Emergency Patient Transport), Open Fleet®-CT, (Community Transport software), PETS (Photocopier Electronic Transaction System) and Easy Health Stats.
21 Tips for Writing Amazing Tech Newsletters
Regardless of the medium of newsletter you opt for, here are 20 amazing tips to ensure your tech newsletter gets read, and remembered.
Are paper newsletters better than mailing lists?
Paper-based newsletters have many advantages over their electronic cousins. They can be read more, last longer and have higher perceived value.
Are email newsletters and mailing lists overrated?
Keeping in touch with existing clients is, to put it simply, absolutely vital. Whether they are regularly putting in requests for work, or on retainer, or even if you have only worked for them once, it is essential to stay connected. For most businesses this means sending out regular email newsletters. There are two ways…
Microsoft Excel Addition Error
It might surprise some to learn that Microsoft Excel is not infallible. Rather it has an annoying bug that has been in every version since inception. In some circumstances, it is incapable of adding 3 numbers together. Don’t believe me?
Re-link MS-Access Databases Automatically
Now that your database is split into a back-end and a front-end, (if you haven’t then read this article) you should be getting frustrated having to delete all linked tables and re-link them. This will need to be done each time you need to connect to test data, or live data, or the back-end is…
Splitting a Microsoft Access Database
Splitting a databse is the third step in improving the speed of a Microsoft Access database. If you haven’t yet read or heard about splitting a Microsoft Access Database then either you are very new to databases or work in an I.T. department. Splitting a database is the process of separating the working bits from…