Database: Hello I am looking for software to keep a record of miles gas , any expense used to travel to take photo and a record of clients information.

Ugly Hedgehog - Photography Forum

Home Active Topics Newest Pictures Search Login Register ☰

Database

Page 1 of 2 next>

Jun 29, 2015 16:28:38 #

willdenise Loc: Tennessee

Hello I am looking for software to keep a record of miles gas , any expense used to travel to take photo and a record of clients information.

Jun 29, 2015 16:47:53 #

Flyerace Loc: Mt Pleasant, WI

I use Microsoft Excel. Has worked for over 5 years keeping track of mileage with running totals etc. You need to learn how to program the formulas into the cells, but that doesn't take long.

Jun 29, 2015 16:59:36 #

RLSeipleSr Loc: North of Boston

Flyerace wrote:

... I use Microsoft Excel ...

:thumbup: :thumbup: :thumbup:

Recommend that you do your own in Excel ... a little work to get started but you will never find anything off the shelf to fit your exact needs ... !

Bob S

Jun 29, 2015 17:08:18 #

rjaywallace Loc: Wisconsin

I agree with the suggestions re Microsoft Excel. However Intuit's QuickBooks is a more complete business-tracking package capable of automating tax payments, depreciation, assets, liabilities, net worth, etc. Intuit tech support phone reps (I was one for several years) will work with you to set everything up as you need it now and will point out tips to grow the database as your needs expand.

Jun 29, 2015 17:48:50 #

nicksr1125 Loc: Mesa, AZ

willdenise wrote:

Hello I am looking for software to keep a record of miles gas , any expense used to travel to take photo and a record of clients information.

I use Excel as well. If you like, PM me & I'll email you my template. It's taken me a couple years to work it out to where I like the way it works but, now all I have to do is put in the basic information & the rest is calculated for me.

Jun 30, 2015 06:39:18 #

RogueStorm Loc: East Sussex, England

I'd agree with everyone on the Excel way to go. Why use a database with front end programming and form design when a simple spreadsheet would suffice?

I've just returned from a campervan holiday, 91 days and 8510 miles and used a spreadsheet to keep check of miles, mpg and stops along the way and it worked brilliantly.

Jun 30, 2015 07:38:46 #

rmalarz Loc: Tempe, Arizona

willdenise wrote:

Hello I am looking for software to keep a record of miles gas , any expense used to travel to take photo and a record of clients information.

I'd not recommend a database for this application. I'd recommend a spreadsheet application. You can always incorporate the results of the calculations in the spreadsheet into the database, if you so desire.
--Bob

Jun 30, 2015 08:33:19 #

jerryc41 Loc: Catskill Mts of NY

willdenise wrote:

Hello I am looking for software to keep a record of miles gas , any expense used to travel to take photo and a record of clients information.

I've been using this auto program for years, and I love it. Although it's designed for cars, I'm sure you can enter info about clients.

http://www.lonewolf-software.com/automotivewolf.htm

Jun 30, 2015 08:40:24 #

BatManPete Loc: Way Up North!

Excell is "NOT ONLY" about numbers. . . .
U can attach a "word cloud" to any cell [DOES NOT REQUIRE ENTERING DATA INTO CELL HOLDING NUMBERS... USE TEXT IF U WISH] and add a note or other comment. It can be viewed/not viewed with just a [right MOUSE click] . . choice box appears . . (13 or 14 choices) click on insert comment ] . . .

I created a sheet '20 yr old Dodge Dakota'... 'ALL ABOUT MAINTENANCE... DATE,SOURCE,COST,ESTIMATES . . COMMENT ETC. . . . SEE ALL INFO ON ONE SHEET.... NO MORE THUMBING/LOCATING/READING QUOTES, INVOICES ETC.
NOTE: I create a new EXCELL file [with new name i.e. 'TRUCK 6-1-15' ... next save file name will be 'TRUCK 6-23-15' ... WHY? . . I save 2 copies. One to the hard drive on computer and the second to a "STICK DRIVE"... $10 or $12 dollars...NEVER TRUST UR' COMPUTER... THEY HAVE MINDS OF THEIR OWN1

'HAVE FUN'

Jun 30, 2015 09:43:18 #

dcampbell52 Loc: Clearwater Fl

willdenise wrote:

Hello I am looking for software to keep a record of miles gas , any expense used to travel to take photo and a record of clients information.

I use Microsoft Access and Excel. Access is a very good DB and Excell is a good spreadsheet that interfaces with it. My Access is also connected to my Quick Books which does all of my book keeping including generating invoices, processing credit cards etc.

Jun 30, 2015 09:43:28 #

OldEarl Loc: Northeast Kansas

If you happen to use Open Office or Libre Office, their spread sheet is slightly better than Excel--it works like the old Lotus 1,2,3. Even at work I used Lotus up until Excel 97 which operated on a Lotus license. The open source has as much computing power as Microsoft and the files do not take up as much space as the proprietary garbage in Excel.

Jun 30, 2015 09:48:47 #

jeep_daddy Loc: Prescott AZ

If you want something simple and free, just create an account with google and use their Google Sheets. It's a simple spreadsheet that you can add formulas to for calculating mileage etc. I use it for mileage to and from my Workers Compensations doctors and the pharmacy. I can calculate how much they owe me so I know what I should receive from them. The great thing about it is that you can access it from your smart device any time and update it. You can also save it and open it from any MS Excel program too.

willdenise wrote:

Hello I am looking for software to keep a record of miles gas , any expense used to travel to take photo and a record of clients information.

Jun 30, 2015 09:49:11 #

dcampbell52 Loc: Clearwater Fl

[quote=BatManPete]Excell is "NOT ONLY" about numbers. . . .
U can attach a "word cloud" to any cell [DOES NOT REQUIRE ENTERING DATA INTO CELL HOLDING NUMBERS... USE TEXT IF U WISH] and add a note or other comment. It can be viewed/not viewed with just a [right MOUSE click] . . choice box appears . . (13 or 14 choices) click on insert comment ] . . .

I created a sheet '20 yr old Dodge Dakota'... 'ALL ABOUT MAINTENANCE... DATE,SOURCE,COST,ESTIMATES . . COMMENT ETC. . . . SEE ALL INFO ON ONE SHEET.... NO MORE THUMBING/LOCATING/READING QUOTES, INVOICES ETC.
NOTE: I create a new EXCELL file [with new name i.e. 'TRUCK 6-1-15' ... next save file name will be 'TRUCK 6-23-15' ... WHY? . . I save 2 copies. One to the hard drive on computer and the second to a "STICK DRIVE"... $10 or $12 dollars...NEVER TRUST UR' COMPUTER... THEY HAVE MINDS OF THEIR OWN1

'HAVE FUN'[/quote]

Remember that Steve Wozniak once said, "Never trust a computer that you can't throw out a window".

Jun 30, 2015 11:30:09 #

twillsol Loc: St. Louis, MO

Flyerace wrote:

I use Microsoft Excel. Has worked for over 5 years keeping track of mileage with running totals etc. You need to learn how to program the formulas into the cells, but that doesn't take long.

I agree, easy to learn and use.

Jun 30, 2015 11:55:29 #

brucewells Loc: Central Kentucky

willdenise wrote:

Hello I am looking for software to keep a record of miles gas , any expense used to travel to take photo and a record of clients information.

Does it have to be 'mobile'? Do you use a smart phone or tablet?

Page 1 of 2 next>

If you want to reply, then register here. Registration is free and your account is created instantly, so you can post right away.

Main Photography Discussion

Home | Latest Digest | Back to Top | All Sections

UglyHedgehog.com - Forum