Taxi Driver Online
http://www.taxi-driver.co.uk/phpBB2/

Databases or spreadsheets?
http://www.taxi-driver.co.uk/phpBB2/viewtopic.php?f=1&t=17905
Page 1 of 2

Author:  thelodger [ Mon Nov 21, 2011 8:31 pm ]
Post subject:  Databases or spreadsheets?

Hi, I have took on a role, that involves me looking after 30 cars and drivers (PH) At the mo, everything is just on bits of paper all over the place.

I want to put in place a proper record of all drivers (Some waged, some renters and some on a commission) what hours/rent and/or gross income. Also I need to keep a database of expenses, other than derv, thats spent on car repairs, so I can see what needs servicing and when

Anyone recommend a database or spreadsheet that can do some or all of the above?

Author:  toots [ Mon Nov 21, 2011 9:41 pm ]
Post subject:  Re: Databases or spreadsheets?

Microsoft Excel will do the trick :D

Author:  thelodger [ Mon Nov 21, 2011 10:22 pm ]
Post subject:  Re: Databases or spreadsheets?

toots wrote:
Microsoft Excel will do the trick :D


Well for spreadsheets, your correct, but for databases you will need Access, I have the full office suite of course.

I know how to use it and arn't bad with excel functions, I can even edit and change some minor databases, but feck me, building one is a no no.

Author:  toots [ Mon Nov 21, 2011 10:46 pm ]
Post subject:  Re: Databases or spreadsheets?

I hate repeating myself. Microsoft Excel will do the trick.

Author:  captain cab [ Mon Nov 21, 2011 10:47 pm ]
Post subject:  Re: Databases or spreadsheets?

toots wrote:
I hate repeating myself. Microsoft Excel will do the trick.



why change the habit of a lifetime 8)

CC

Author:  toots [ Mon Nov 21, 2011 10:50 pm ]
Post subject:  Re: Databases or spreadsheets?

captain cab wrote:
toots wrote:
I hate repeating myself. Microsoft Excel will do the trick.



why change the habit of a lifetime 8)

CC


I never said I didn't do it I said I hate doing it :roll:

Author:  captain cab [ Mon Nov 21, 2011 10:52 pm ]
Post subject:  Re: Databases or spreadsheets?

toots wrote:
I never said I didn't do it I said I hate doing it :roll:



Image

Author:  toots [ Mon Nov 21, 2011 10:53 pm ]
Post subject:  Re: Databases or spreadsheets?

captain cab wrote:
toots wrote:
I never said I didn't do it I said I hate doing it :roll:



Image


You can be such a drama queen sometimes :lol:

Author:  grandad [ Tue Nov 22, 2011 6:24 am ]
Post subject:  Re: Databases or spreadsheets?

Most, if not all of what you are trying to acheive can be done quite easily with the Cab Vista software. Is is reasonably cheap and if used properly it is very good. If you contact them they will provide a demo version that you can try before you buy.

Author:  edders23 [ Tue Nov 22, 2011 7:43 am ]
Post subject:  Re: Databases or spreadsheets?

personally I just use excel but i have a smaller fleet to keep track of but it is very easy to set up seperate sheets for each car just put the reg in the sheet name bar and have a summary sheet

Author:  toots [ Tue Nov 22, 2011 11:01 am ]
Post subject:  Re: Databases or spreadsheets?

grandad wrote:
Most, if not all of what you are trying to acheive can be done quite easily with the Cab Vista software. Is is reasonably cheap and if used properly it is very good. If you contact them they will provide a demo version that you can try before you buy.


Why go to the expense of buying something when it's already there :?

Author:  wee eddie [ Tue Nov 22, 2011 11:05 am ]
Post subject:  Re: Databases or spreadsheets?

Open Office is Free. It includes a Word-processor, Spreadsheet, Database.

M$ Office Pro, which you will need to get Access, is about £340, which is Tax deductible of course, as is all your Computer Equipment and there may be a suitable, ready-made, Database among the Templates.

Designing a database, to do what you want, is not a doddle, but neither is it that complex, if you are familiar with the software that you are going to use.

Author:  grandad [ Tue Nov 22, 2011 1:41 pm ]
Post subject:  Re: Databases or spreadsheets?

toots wrote:
grandad wrote:
Most, if not all of what you are trying to acheive can be done quite easily with the Cab Vista software. Is is reasonably cheap and if used properly it is very good. If you contact them they will provide a demo version that you can try before you buy.


Why go to the expense of buying something when it's already there :?

Cab Vista is also a booking and dispach system.

Author:  toots [ Tue Nov 22, 2011 2:57 pm ]
Post subject:  Re: Databases or spreadsheets?

I see your point grandad but he never asked about a booking system :D

Author:  thelodger [ Tue Nov 22, 2011 9:17 pm ]
Post subject:  Re: Databases or spreadsheets?

grandad wrote:
Most, if not all of what you are trying to acheive can be done quite easily with the Cab Vista software. Is is reasonably cheap and if used properly it is very good. If you contact them they will provide a demo version that you can try before you buy.


Thank you I have googled cabvista and will get a demo copy.

Page 1 of 2 All times are UTC [ DST ]
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/