FileMaker Pro vs Access Update

I am working on a second tutorial for the eBook I am writing about using spreadsheets and databases for data analysis.  The FileMaker Pro database I have created has only two tables and four layouts, but it is over 500 MB in file size.  The comparisons I have thus far are:

• Access allows you to easily format text as zip codes and phone numbers, but FileMaker Pro does not
• Access allows you to do a Compact and Repair, but FileMaker does not have that feature in the menu
• Creating a button to open a URL was very easy with FileMaker
• Creating list features with Value Lists in FileMaker is child's play - so easy!
• FileMaker Pro works on the Mac and Windows computers and provides a 30-day free preview, but Access works only on Windows computers
• After you create a database with FileMaker Pro, you can sync it to your iPad or iPhone FileMake Go app.  Once it is synced, you can edit the database and enter data (a real plus!).  FileMaker Pro has settings for themes that work best on the iPad and iPhone.
• Calculating an age is more complex calculation in FileMaker (although may be more accurate) than using Access.
• If/then and other mathematical calculations are basically the same in both database software packages.

FileMaker Pro 12 vs Access Update

The past few weeks I have been learning how to use FileMaker Pro 12 so that I can teach it to students in a few weeks - there you go - the life of a teacher (learn one, do one, teach one).  The bottom line is that I really am liking FileMaker Pro!!  My son told me (sons are always smarter than mothers) that FileMaker Pro is more intuitive than Access and I have to agree.

FileMaker Pro makes fantastic use of "layouts."  Layouts are views of table and query data.  FileMaker Pro does not use the techie terms of queries.  The calculation formulas are identical to Access with the exception that FileMaker Pro uses semicolons ; instead of commas, in the calculations.

Okay - Microsoft - Access was the only app that kept me in the Microsoft system.  Since 1/3 of the students in the class I am teaching this summer are Mac users and I need to introduce them to database software - I am sucked into the Apple ecosystem.

I am also learning ScreenFlow software in order to show the students certain database functions.  Will have additional blogs on that software.  Learned an important lesson today on how the videos show up in YouTube in HD!  OMG!  Amazing!!  Thanks FL!!!!

Now if I could only do without any sleep I could be twice as productive :-)

Microsoft Access 2010 or Apple Filemaker Pro 12?

I have used and taught others to use Microsoft Access for the past 15 years but must consider changing to Apple Filemaker Pro.  Why? -- because Filemaker Pro is available for both the Mac and the PC.  Furthermore, Filemaker Go is a free app for the iPad.  Finally, Filemaker Pro is must easier to use than Access!

The only plus for Microsoft Access is the cost.  Microsoft Access is one of seven apps available from Office University 2010 for $99.99.  The academic version of Filemaker Pro costs $179.

I am teaching an informatics course this summer and discovered that 1/3 of the students are Mac users.  What it means is that I cannot use the lessons I developed on relational databases using Access 2010.  As a result, I spent time over the last couple of weekends working through the Filemaker Pro tutorial to learn how to use the software.

Although Microsoft Access 2010 is a great improvement over earlier versions, it is still clunky and not intuitive for learners.  There are essentially four different views - tables, queries, forms, and reports.  In contrast, Filemaker Pro allows the user to do the same functions using different "Layouts."

Filemaker Pro is available as a 30 day preview, so I can incorporate it into the course without additional fees for the students.

My next step is to import the tables for the Metabolic Syndrome database I created from Access into Filemaker Pro.  That process should help shed new insight on the differences between the two applications.