Author Archives: Tom Chandler

Starting Outlook in Safe Mode

This gallery contains 6 photos.

Every so often, for no apparent reason, Microsoft Outlook doesn’t quite start the way it should. Or worse maybe it doesn’t start at all. This may be caused by an Outlook add-in that for some reason isn’t working. Thankfully there … Continue reading

More Galleries | Leave a comment

How to plan your Access or FileMaker Pro database – Part 3

This gallery contains 26 photos.

Before creating a database you should have some blueprints that will guide its creation. In part one of this series we talked about having sketches of input forms and reports. Part two was about creating a list of fields in … Continue reading

More Galleries | Leave a comment

How to plan your Access or FileMaker Pro database – Part 2

This gallery contains 1 photo.

In part one of this series we said you should start planning your Access or FileMaker Pro database by using paper and pencils to draw the input forms and reports that your users will need.  Now we are going to … Continue reading

More Galleries | Leave a comment

How to plan your Access or FileMaker Pro database – Part 1

This gallery contains 1 photo.

One of the biggest mistakes new database developers make is they don’t plan.  Instead, they just open up Microsoft Access or FileMaker Pro and start creating their tables.  But, as with just about everything else in life, a little bit … Continue reading

More Galleries | 1 Comment

Access Data Types

This gallery contains 2 photos.

As discussed in a previous blog post about Database Terms, a field in a database table is like a column in a spreadsheet. But one of the main differences between a spreadsheet and a database is that fields must have … Continue reading

More Galleries | Leave a comment

The Wrong Way to Create Microsoft Word Forms

This gallery contains 17 photos.

Sometimes you need to create a form with Microsoft Word that you want someone else to fill out. So you create a beautiful form like Figure 1 below, only to have the it come back looking like Figure 2 or … Continue reading

More Galleries | Leave a comment

Database Terms

This gallery contains 9 photos.

Many sites on the World Wide Web, as well as many applications on PCs, Macs, smart phones, and tablets use databases. The purpose of this blog post is to define some basic database terms which need to be understood by … Continue reading

More Galleries | 1 Comment

Splitting an Access Database

This gallery contains 2 photos.

One of the most useful features of a Microsoft Access database is the ability to split the database into two files. The first file, which is commonly called the back-end or data file, holds the data (the tables). The second … Continue reading

More Galleries | Leave a comment

Microsoft Access – How to update linked tables

This gallery contains 5 photos.

Open your Access database.   Start the Linked Table Manager feature. In Access 2003, from the menu choose Tools, Database Utilities, Linked Table Manager. In Access 2007 from the ribbon choose Database Tools, Linked Table Manager. In Access 2010 from … Continue reading

More Galleries | Leave a comment

Excel PivotTable 101

This gallery contains 20 photos.

What is a PivotTable? A PivotTable is a useful tool for creating summary reports from Excel data. And the cool thing is you can “Pivot” or move the fields of the report. For example all of the following screen shots … Continue reading

More Galleries | Leave a comment