![]() ![]()
Once you figure out how to use a database, you'll never go back to a spreadsheet unless its the right use for one. I use databases (Filemaker, and Panorama from ProVue Software) for address books, photo catalogs, etc. I use a spreadsheet (Excel, with all it's warts and bugs) to forcast cash flow and tax liability. But you should, because it's FAR more logical and friendly to organize info like grocery lists, address books, etc. Very few people know how to use a database because we don't normally use them in every day life. It's like using a screwdriver to drive nails- do-able, but not a pleasant experience. It's just not designed to organize and report data that way. Excel can SORT OF do that, but you have to be VERY adept at using it, and it's still not very elegant. The possibilities are endless- because a database can find all records that meet a given criterion, and THEN sort them, and you can do that all day long very easily. Jeroen, If you need to do this regularly ODBC might be a bit slow. Voila! Instant match results that show scores for all competitors ranked by score, and then a whole other set of results reported by age class first, then score. Then find all female competitors, sort them by age and aggregate score, and print. But the magic comes at the end, when you tell the program to sort first by age class (these were junior matches), then by aggregate score, and print it. ![]() Again, think of those little boxes as being on each person's index card. Tremendous freedom here.Īs targets were scored, we just entered the scores for each target into their appropriate fields. Then you simply arrange them on your "report" layout to show all that info in any way that's visually pleasing. Then I added a calculation field for prone total, another for standing total, then match total, etc. Then I added other fields, like score for prone stage 1, stage, standing 1, etc. Here's what I could do with it: Enter a shooter's name, address, etc. CAN YOU LEARN FILEMAKER PRO FROM MS ACCESS SOFTWAREAnd it's now cross-platform and highly regarded in the software world. ![]() But Filemaker Pro is an extremely easy app to learn easier than MS Access in my experience. (Caveat- it was on a Mac, and it's old enough now that it wouldn't run on most computers even if I posted it here for all to use. I built just such a program using Claris Filemaker Pro some years ago. like an entry in a match and then sort that data with multiple criteria. though many people do use it for match results, it's very much inferior to using a database for that use.Ī database will be FAR easier to use if you wish to tie bits of data (like scores in each target or stage) to one entry in the database. Excel is for making calculations on large sets of variables based on one change in one variable. A database is designed to organize information completely differently than Excel does. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |