Keeping track

We’re going to start out by looking at two databases that can be posted to the Web: one aimed at business, the other at social clubs.

The first thing you might ponder is why anyone would want to post a database to the Web. We’re glad you asked that question. It’s like this:

If you have

a business and the customer database was posted to the Web, then the customers could enter changes in their address and phone information themselves, and you wouldn’t go nuts trying to figure out where and when they had moved. The customers could also view their own invoices, so they don’t have the excuse of telling you they lost the invoice, or it never arrived.

If it was a database designed for your own employees, they could log onto the Web and find out how much ready inventory you have in any of your products; they could also find out the current status of any project underway. These are just a couple of examples that spring to mind; there could be hundreds of others.

Now we know what you’re thinking, that anyone could go in there and type in any changes they want and mess up the whole database. Well, they would have to have the proper password, you see. And some people would have passwords that provided access to just some parts of the database, and a few people would be able to access all parts. And the next thing you’re thinking is what a lot of work it would be to set up all these database categories and forms and access codes. Well it wouldn’t be, because Alpha Five has ready-made templates for doing those things.

Ah, Alpha Five. Over the years, this has been our favorite database program. Not the biggest, not the smallest, but just right. Version 6 just came out, and it can now be posted to the Web and lets you do all the things we mentioned above. This thing is a hummer: Type in a Zip code, and it automatically fills out the town and state. Type a company or personal name, and it automatically capitalizes the first letters. It can calculate sums and percentages, etc. It has several dozen other features as well, but we don’t have room for everything.

This is the easiest large database we have ever used. Unlike nearly all others, no programming is required. The user selects a number of choices from menus, and the program then creates a database that contains those elements. You can go right down to selecting the color of the data fields. Security features let you keep credit card, medical and other sensitive information unavailable except to those with the proper passwords. Then it creates your Web site and you can post the whole thing.

A single-user version of Alpha Five, version 6, lists for $349; the server version is $699. You need both if you’re going to post your database on the Web. It is compact enough to run on an older Windows computer that doesn’t have the latest operating system or lots of memory. In fact, that can act as a server and still be used to run other programs. There’s lots more information and a free trial at www.alphafive.com.

If you have a club, church or special-interest group, you might want to leave the driving to someone else. A guy in Chicago who belongs to a Morgan car club (by golly, we used to have a Morgan, too) has designed a Web database for groups. Members can change their personal information to keep it up-to-date and view upcoming events, meetings, etc., for a fairly nominal fee.

There is an initial cost of US$150 to set up the database on a Web site and then 40 cents per member per month. That works out to US$4.80 a year, which is OK for a small group, but the women’s club that Joy belongs to has more than 400 members and that would come to $160 a month, almost US$2,000 a year; the club wouldn’t stand for that. So you and your own group have to decide whether this is worth it or not. A free 60-day trial is available at the database Web site (www.clubexpress.com).

INTERNUTS

Triple threat at www.bootdisk.com. This Web site allows you make a bootable CD for Windows, DOS or Linux computers. This is a nice thing to have since many new computers no longer have a drive for floppy disks.

Take it from Harvard. At www.yourdiseaserisk.harvard.edu you can click on a risk: heart disease, cancer, diabetes, stroke, etc. The site will then provide a series of questions designed to estimate your risk and makes suggestions to lower that risk. Hypochondriacs are welcome here.

Surreal Web site here. At www.obits.com there are around 300 obituaries here, covering an eclectic collection of people of note. Some are fairly recent, like Forrest Mars, owner of America’s largest candy company. Others are a ways back, like Jane Austen. You can add obits for a fee. We’re a fan of obituaries, and if you are too, there’s a great collection from The New York Times in “”The Obituary Book.”” Check out the one for Philadelphia’s “”Father Divine.””

At www.site59.com, last-minute travel packages offered at deep discounts. If you’re willing to go with the flow, on short notice, they’ve got a deal for you. Unlike other travel sites, you don’t have to select where, or when, you want to go before looking at the deals.

BOOKS

“”eBay Global, the Smart Way,”” by Joesph T. Sinclair and Ron Ubels; US$20, Amacon Books (www.amacombooks.com).

How to increase your sales and profits when selling to an international market through eBay. Approximately one-third of eBay transactions occur outside North America, so this is worth considering.

Would you recommend this article?

Share

Thanks for taking the time to let us know what you think of this article!
We'd love to hear your opinion about this or any other story you read in our publication.


Jim Love, Chief Content Officer, IT World Canada

Featured Download

Featured Story

How the CTO can Maintain Cloud Momentum Across the Enterprise

Embracing cloud is easy for some individuals. But embedding widespread cloud adoption at the enterprise level is...

Related Tech News

Get ITBusiness Delivered

Our experienced team of journalists brings you engaging content targeted to IT professionals and line-of-business executives delivered directly to your inbox.

Featured Tech Jobs