Search PalmPower Enterprise Edition's 188 Palm-related article archive 
Home
EasyPrint
News details Click here for the RSS feed's XML code. This is not a browser URL.
Articles-only Click here for the RSS feed's XML code. This is not a browser URL.
Harness the power of databases on your Palm handheld (continued)

You may have to add other fields for your particular type of business. It's easy to add a new field as required at a later time. At the end of every month you'll upload this file to your PC and import the data into a Microsoft Access database that performs all of the billing calculations such as subtracting the END from the START time and multiplying by the RATE. Some Palm OS database programs will let you perform these calculations in the Palm handheld itself.

Shared travel expenses
Here's that shared expense trip I mentioned at the beginning of this article. Every time someone lays out some cash, enter the amount in his named field. In this case BOB bought you all lunch for $45.00, Albert spent nothing, and Jake left the tip. Leave ALBERT's field blank. Most database programs will total the amounts in each numeric field, so you'll know at any time whose turn it is to buy. At the end of the trip you'll know how much each of you spent, and you can settle the account quite easily. Make the DATE and TIME fields default to the current date and time when you create a new record. The TYPE field is a pull-down list that has such items as breakfast, car rental, dinner, entertainment, car, hotel, lunch, parking, snack, taxi, tips, and tolls. PMT can be a pull-down list with AmEx, Cash, MC, prepaid, and Visa.

DATE: 5/21/2000
TIME: 13:15
VENDOR: Mirage Hotel Deli
ALBERT:
BOB: 45.00
JAKE: 7.00
TYPE: Lunch
PMT: Visa

Conclusion
Hopefully these sample databases have given you ideas of what you can do with a general-purpose database program. Consider keeping anything you would normally put in lists or on index cards on your Palm handheld instead. These things will be backed up on your PC, and you can convert them on your PC to other formats for printing or merging. The possibilities are endless.

Product availability and resources
For more information on HanDBase, visit http://www.ddhsoftware.com/solutions.html.

For more information on JFile, visit http://www.land-j.com/jfile.html.

For more information on MobileDB, visit http://www.mobilegeneration.com/products/mobiledb/.

For more information on thinkDB, visit http://www.thinkingbytes.com.

For more information about Palm computers, visit http://www.palm.com.

Bulk reprints
Bulk reprints of this article (in quantities of 100 or more) are available for a fee from Reprint Services, a ZATZ business partner. Contact them at reprints@zatz.com or by calling 1-800-217-7874.

Jake Jacobs is a retired electrical engineer and part-time flight instructor who has used a Palm handheld since 1997 and enjoys writing in his spare time.


« Previous  ·  1  ·  2  ·  3  ·  4  ·  5
Other articles you might like
Home > Phones and PDAs > Palm and Treo > Software (211 articles)
   TealOS: great Palm software you are prohibited from buying
   CallRec gives your Treo better call recording
   Edit Office files on the go with Documents To Go
Get Weekly Email Updates
Subscribe to our regular weekly email newsletter. It's packed with tips, reviews, deep analysis, and the latest news.
 
More from the ZATZ journals
Computing Unplugged: Make Mafia Wars an offer it can't refuse
David Gewirtz Online: CNN commentary and analysis
DominoPower: Application development, William Shatner, and the origin of the universe
OutlookPower: Removing an Office installation that doesn't want to go away
-- Advertisement --

Write for Computing Unplugged!
Share your experience and expertise with other handheld device users. There are new opportunities at ZATZ for contributing authors and editors.

Write about something you're an expert on and get your name in lights.

For Writers' Guidelines and to discuss topics, contact Staff Editor Steve Niles. This is your opportunity to shine in front of your peers, your clients, and friends.

Click for more info!

ZATZ Home  ·  News  ·  Back Issues  ·  Credits/Trademarks ·  Link To Us
Copyright © 2000-2010, ZATZ Publishing. All rights reserved worldwide.
Editor's Login