There is much to share and just not enough time! :-)
I have been working on four lessons for one of the classes I teach on how to use Excel and FileMaker Pro. I wrote out the content because there is not a book that addresses how to use Excel and FileMaker Pro from a nursing perspective.
The good news, is that I believe I have FileMaker Pro figured out. I developed a Metabolic Syndrome Registry database and have incorporated calculations that:
- Calculate height in total inches height in feet and inches
- Calculate the BMI from height in inches and weight in pounds
- Analyze the BMI for World Health Organization Obesity classifications
- Analyze the weight goal based upon BMI classifications
The similarities between Excel formulas and FileMake Pro are remarkable. Where you use a comma in an Excel formula, you use a semicolon in FileMaker Pro. The creation of concatenation is identical. Concatenation is where you link two fields. For example if you have systolic blood pressure in one field and systolic blood pressure in another you can create a new field showing 120/80.
I really like the fact that FileMaker Pro does not use words that are so "techie." For example, the term layouts is used (the default is single form, running forms, and table view) for any table or queries. The term "queries" is not used - just a different layout. The term "script" is used instead of "macro."
