dbTalk Databases Forums  

Need some domande answered while setting up this new Taxi database

comp.database.ms-access comp.database.ms-access


Discuss Need some domande answered while setting up this new Taxi database in the comp.database.ms-access forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
Knowledge
 
Posts: n/a

Default Need some domande answered while setting up this new Taxi database - 06-27-2007 , 01:41 PM







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

Reply With Quote
  #2  
Old   
BAM
 
Posts: n/a

Default Re: Need some domande answered while setting up this new Taxi database - 06-28-2007 , 07:28 AM







"Knowledge" <knowledg_e (AT) charter (DOT) net> wrote

Quote:
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
I think you're ready to roll - don't change a thing. You might want to add
though, a passenger satisfaction/comments/recommendation form that can be
entered on one of those touch screens that you can bolt onto the back of the
front seat. (with a big shortcut on the screen to Windows Solitaire)

BAM




Reply With Quote
  #3  
Old   
Knowledge
 
Posts: n/a

Default Re: Need some domande answered while setting up this new Taxi database - 06-28-2007 , 02:34 PM



On Thu, 28 Jun 2007 07:28:07 -0400, "BAM"
<mcca5761 (AT) blahblahbellsouth (DOT) net> wrote:

Quote:
"Knowledge" <knowledg_e (AT) charter (DOT) net> wrote in message
news:e98583dl46qobbot1phps7gkitgbsfav48 (AT) 4ax (DOT) com...

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

I think you're ready to roll - don't change a thing. You might want to add
though, a passenger satisfaction/comments/recommendation form that can be
entered on one of those touch screens that you can bolt onto the back of the
front seat. (with a big shortcut on the screen to Windows Solitaire)

BAM

Which of the software programs would you sue for this simple database
Bam?

I also have Filemaker Pro 8.5 if I need it.

Will this require a relational database? Or will a flat file database
suffice very nice?


Reply With Quote
  #4  
Old   
Paul Danaher
 
Posts: n/a

Default Re: Need some domande answered while setting up this new Taxi database - 06-28-2007 , 04:21 PM



Knowledge wrote:
....
Quote:
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 don't know Goldmine at all, so interpret the following in the light
of that gap.
I'd say much depends on what use he wants to make of the data. If he's
using it for contact management (who are his regular customers, do
they have regular orders, how much do they use him, what are their
addresses for special offers, holidays, seasonal publicity), then ACT
would make sense. If he wants to analyse the market, looking at
origins and destinations, business by category (passenger, courier,
business, personal), then I'd think in terms of a relational db.


Reply With Quote
  #5  
Old   
Paul Danaher
 
Posts: n/a

Default Re: Need some domande answered while setting up this new Taxi database - 06-28-2007 , 04:24 PM



....
Quote:
Will this require a relational database? Or will a flat file database
suffice very nice?
You know, after I replied, I realised that you could be reinventing
the wheel. Look at all the taxi management software that's out there -
it might be cheaper to buy something off the shelf.


Reply With Quote
  #6  
Old   
BAM
 
Posts: n/a

Default Re: Need some domande answered while setting up this new Taxi database - 06-28-2007 , 10:23 PM




"Knowledge" <knowledg_e (AT) charter (DOT) net> wrote

Quote:
On Thu, 28 Jun 2007 07:28:07 -0400, "BAM"
mcca5761 (AT) blahblahbellsouth (DOT) net> wrote:


"Knowledge" <knowledg_e (AT) charter (DOT) net> wrote in message
news:e98583dl46qobbot1phps7gkitgbsfav48 (AT) 4ax (DOT) com...

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

I think you're ready to roll - don't change a thing. You might want to add
though, a passenger satisfaction/comments/recommendation form that can be
entered on one of those touch screens that you can bolt onto the back of
the
front seat. (with a big shortcut on the screen to Windows Solitaire)

BAM

Which of the software programs would you sue for this simple database
Bam?

I also have Filemaker Pro 8.5 if I need it.

Will this require a relational database? Or will a flat file database
suffice very nice?
I'd be more concerned about whether you were going to equip your driver with
a Bowie knife or a Billy club.

BAM




Reply With Quote
  #7  
Old   
Knowledge
 
Posts: n/a

Default Re: Need some domande answered while setting up this new Taxi database - 06-30-2007 , 09:40 PM



On Thu, 28 Jun 2007 22:23:04 -0400, "BAM"
<mcca5761 (AT) blahblahbellsouth (DOT) net> wrote:

Quote:
"Knowledge" <knowledg_e (AT) charter (DOT) net> wrote in message
news:hnv7835sb19llii4ldq0sg4l07305quth9 (AT) 4ax (DOT) com...
On Thu, 28 Jun 2007 07:28:07 -0400, "BAM"
mcca5761 (AT) blahblahbellsouth (DOT) net> wrote:


"Knowledge" <knowledg_e (AT) charter (DOT) net> wrote in message
news:e98583dl46qobbot1phps7gkitgbsfav48 (AT) 4ax (DOT) com...

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

I think you're ready to roll - don't change a thing. You might want to add
though, a passenger satisfaction/comments/recommendation form that can be
entered on one of those touch screens that you can bolt onto the back of
the
front seat. (with a big shortcut on the screen to Windows Solitaire)

BAM

Which of the software programs would you sue for this simple database
Bam?

I also have Filemaker Pro 8.5 if I need it.

Will this require a relational database? Or will a flat file database
suffice very nice?

I'd be more concerned about whether you were going to equip your driver with
a Bowie knife or a Billy club.

BAM

They are going to have all that plus a 9 MM, several cans of Mace, and
high powered tasers. He's going to be working in one of the most
dangerous areas of the United State in Montana.


Reply With Quote
  #8  
Old   
Knowledge
 
Posts: n/a

Default Re: Need some domande answered while setting up this new Taxi database - 06-30-2007 , 09:45 PM



On Thu, 28 Jun 2007 16:21:17 -0400, Paul Danaher
<paul.danaher (AT) watwinc (DOT) com> wrote:

Quote:
Knowledge wrote:
...
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 don't know Goldmine at all, so interpret the following in the light
of that gap.
I'd say much depends on what use he wants to make of the data. If he's
using it for contact management (who are his regular customers, do
they have regular orders, how much do they use him, what are their
addresses for special offers, holidays, seasonal publicity), then ACT
would make sense. If he wants to analyse the market, looking at
origins and destinations, business by category (passenger, courier,
business, personal), then I'd think in terms of a relational db.
Ok,

He can use both ACT! 2006, and Filemaker Pro 8.5 for the first hundred
or so calls. By that time he will know which one fits his needs best
and we will go with that one.


Reply With Quote
  #9  
Old   
BAM
 
Posts: n/a

Default Re: Need some domande answered while setting up this new Taxi database - 07-02-2007 , 09:38 PM




"Knowledge" <knowledg_e (AT) charter (DOT) net> wrote

Quote:
On Thu, 28 Jun 2007 22:23:04 -0400, "BAM"
mcca5761 (AT) blahblahbellsouth (DOT) net> wrote:


"Knowledge" <knowledg_e (AT) charter (DOT) net> wrote in message
news:hnv7835sb19llii4ldq0sg4l07305quth9 (AT) 4ax (DOT) com...
On Thu, 28 Jun 2007 07:28:07 -0400, "BAM"
mcca5761 (AT) blahblahbellsouth (DOT) net> wrote:


"Knowledge" <knowledg_e (AT) charter (DOT) net> wrote in message
news:e98583dl46qobbot1phps7gkitgbsfav48 (AT) 4ax (DOT) com...

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

I think you're ready to roll - don't change a thing. You might want to
add
though, a passenger satisfaction/comments/recommendation form that can
be
entered on one of those touch screens that you can bolt onto the back of
the
front seat. (with a big shortcut on the screen to Windows Solitaire)

BAM

Which of the software programs would you sue for this simple database
Bam?

I also have Filemaker Pro 8.5 if I need it.

Will this require a relational database? Or will a flat file database
suffice very nice?

I'd be more concerned about whether you were going to equip your driver
with
a Bowie knife or a Billy club.

BAM

They are going to have all that plus a 9 MM, several cans of Mace, and
high powered tasers. He's going to be working in one of the most
dangerous areas of the United State in Montana.
Now yer talkin'

And maybe some night vision goggles for Elk crossings.

BAM




Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.