Databasics IV: Streamlining data entry

In the previous tutorial I discussed some guidelines for creating data entry screens that are easy to use. In this tutorial, we’ll put those guidelines into action by refining the membership database we introduced in part two of this series. I’ll step...

Spreadsheeting I: Basic concepts

While word processing programs are the most commonly used office application and browsers are probably the most commonly used application of all, much of the success of personal computers is due to spreadsheets. In 1979, two blokes – Dan Bricklin and Bob Frankston –...

Shading every other row in Excel

I sometimes wonder whether Microsoft spends so much on its programming budget it has little left over to spend on designers. This thought often crosses my mind when working with Office sample files, templates and styles. Take, for example, the auto-formats supplied...