Good day mates,

I'm trying to build a database to keep track of information that will
be stored when my client kicks off his brand new Taxi Cab business.
Initially it will be a one person operation.

The fellow is starting on a shoe string. He has no clients at the
moment.

He will be carrying people within a 50 mile radius at most. 99% of the
time he will be moving passengers within a ten mile radius.

These are the fields I have decided to use for the database so far:

ID

First name of caller

Middle Initial of Caller

Last Name of Caller

ID
Time of Call
Date of Call
Telephone number of Caller
First Name of Caller
Last Name of Caller
Address
City
State
Destination
Charged
mileage to pickup point
mileage to destination
Mapquest URL to their home location
Comments
Mapquest URL to Destination
------------------------------------------------------------------------------------------------------
I have three different programs I can use for the database.

Which one do you think will do the best job for a one person
operation? The person who will be doing the data entry, driving,
bookkkeeping, mopping, cleaning is very proficient with most aspects
of computers.

I could use:

Microsoft Access 2007

ACT! by Sage 2006

Goldmine 6.0


Which program do you reccommend and why?


Thanks for taking the time to help me out with this?


www.telebay.com/7777

On Jun 27, 1:34 pm, Knowledge <knowled... (AT) charter (DOT) net> wrote:
Entity names??

Address information will be redundant (repeated) is caller has mmore
than one phone number!
Learn to normalize you database


It looks like you haven't decided what entities you are dealing with.
Instead as is typical with beginners, you are just throwing fields at
the problem. The choice of program is less important at this point.

Do a google search and read up on normalization
search for
relational database normalization

HTH.
Ed

On 27 Jun, 18:34, Knowledge <knowled... (AT) charter (DOT) net> wrote:
Check out the database model at http://www.databaseanswers.org/data_...vice/index.htm

On Fri, 29 Jun 2007 10:08:42 -0700, Dulwich <loyal2uk (AT) yahoo (DOT) co.uk>
wrote:

Thank you and Ed both for your aiuto? :-)

On Fri, 29 Jun 2007 10:08:42 -0700, Dulwich <loyal2uk (AT) yahoo (DOT) co.uk>
wrote:


I spent hundreds of thousands of seconds looking for something like
this, and I never even came close. I found some canned stuff that
costs more than he wants to pay.

I think I can copy this one though and have it ready to be debugged my
Lunedi Mattina for sure.

Mille Grazie mon frere! :-)

I'll save this link. I suspect just about everything I will need to
know about developing massive databases that will serve several
hundred people can be found right here.

Much obliged hombre!