Sophia Kelly

Databases are a way of filing information so that it is easy to find and use. Databases make it easier to find and compile specific information, particularly when you need to store and process a lot of it.

If you want to print out summaries of information or find specific bits of information simply and easily, you will most likely want to use a database.

A database is like a filing cabinet for information. The drawers are called ‘tables’ and the file folders are ‘fields’. Fields can be thought of as containers that hold one piece of information each, like first name, last name, city etc… Related fields are grouped together in tables. Fields also hold links to other tables whose fields hold related information (amount purchased, membership join date, last invoiced etc…).

A good database will organize information in a way that makes data convenient to put in, view and compile for reports and other printouts. A well designed database will also prevent data from being entered incorrectly.

Industry-Specific Databases

If a person’s needs for a database are fairly common to others in the same industry, there is usually a database software already created for that purpose. MLS systems for Realtors and iMIS for non-profit organizations are examples of such industry specific databases.

Tailored Databases

However, if an organizations needs aren’t met by prepackaged software, they will commission a custom database. This is similar to having a suit made by a tailor or dressmaker—it may cost more, but should fit much better. Common software/programming languages used in ‘custom’ databases are Access, Filemaker Pro and Visual Basic.

Customized Databases

An intermediate solution is to have an existing package database customized—sophisticated and flexible databases can be created, for example, by customizing Microsoft Outlook.

More about databases | Sophia Kelly Technology Tailoring has been providing custom, customized and configuration and training services for a variety of database platforms including Access, custom Outlook applications and iMIS support for the past 8 years. She is based in Vancouver, Canada. www.sophiakelly.ca