hort.net Seasonal photo, (c) 2006 Christopher P. Lindsey, All Rights Reserved: do not copy
articles | gallery of plants | blog | tech blog | plant profiles | patents | mailing lists | top stories | links | shorturl service | tom clothier's archive0
Gallery of Plants
Tech Blog
Plant Profiles
Mailing Lists
    Search ALL lists
    Search help
    Subscription info
Top Stories
sHORTurl service
Tom Clothier's Archive
 Top Stories
New Trillium species discovered

Disease could hit Britain's trees hard

Ten of the best snowdrop cultivars

Plant protein database helps identify plant gene functions

Dendroclimatologists record history through trees

Potato beetle could be thwarted through gene manipulation

Hawaii expands coffee farm quarantine

Study explains flower petal loss

RSS story archive

Excel or other databases

>John I Jones <jijones@ix.netcom.com> says: 
>For that reason I have also imported the complete file into Helix 
>Express, a database program that allows me to much more easily format 
>reports, and makes it difficult for me to accidently screw up the entire 
>data base. Adding fields is very easy, and I can search for
>words within a field. For instance I could easily print a list of every 
>variety that has a tangerine orange in its color scheme. Once I better 
>format the descriptions I could further restrict the search to just 
>those with tangerine beards.
>I am going to keep parallel data bases in both programs for a while to 
>see which I end up feeling more comfortable with.

In my experience with using SW, I have found out that Excel is a 
wonderful tool for certain things such as keeping track of things that 
require computations. Also for formating nice tables for reports. 
However, if you want to do searches, sort by fields, find out 
information, and even store comments, a database (instead of a 
spreadsheet) is much more robust and versatile.

I started using the MS Access Database a couple of years ago for keeping 
track of my artwork, my mailing lists, and the overall handling of my 
home documents. It has very nice facilities for creating reports, and the 
beauty of the reports created by a database tool is that you only have to 
fret about the formatting once and for all. For example, in Excel when 
you move a cell, all the formatting information goes with it, and your 
beautiful report is messed up. However, I still use Excel to keep track 
of costs, prices (e.g. prices of stock), dates, etc. because it is more 
convenient that Access for that purpose.

I am not familiar with Helix Express. I started with Access because its 
model of working is closest to the other MicroSoft tools I was familiar 

I could not live without both tools.

Anastasia Czerniakiewicz

 © 1995-2017 Mallorn Computing, Inc.All Rights Reserved.
Our Privacy Statement
Other Mailing lists | Author Index | Date Index | Subject Index | Thread Index