AnsweredAssumed Answered

MS Access to FM Pro - questions before making a purchase?

Question asked by NCDave on Oct 25, 2013
Latest reply on Oct 26, 2013 by NCDave

Title

MS Access to FM Pro - questions before making a purchase?

Post

     Hello All,

     I'm new to this forum - after recent retirement, I transitioned from PCs to Apple (iMac + MBPro w/ Mtn Lion - plan to go to Mavericks but not immediately); I had a half dozen databases on Access, 4 of the smaller ones transferred to other programs (Google Drive, Numbers, & iPad app) - BUT, I have 2 large musical databases for my CD collection, one w/ 2500 records & the other w/ 1500.  Before spending $300 on FM Pro (which is steep for someone in retirement especially for this purpose) and having tried Numbers which failed me in wanting a certain printout appearance, I have several questions that I hope can be answered - thanks in advance for any help:

       1.  Import the 2 large Access DBs into FM Pro - I assume that my best option is to use the 'unsorted' table, export to Numbers (as an Excel file extension), then import into FM?  I at that point manipulate the table relative to sorting, etc.?

       2. Reports & printing - certain columns in my DBs contain repetitive entries (attached are two pics from my wine recommended DB shown in Numbers) - in the altered table (right) I simply deleted repeat entries, but in Access in setting up a report I was able to easily achieve this goal - Numbers does not offer me that flexibility w/o using a bunch of complex formulas (just went through a long discussion in the Apple Community, so that is my understanding) - SO, does FM Pro provide that printing feature easily?

     Thanks for comments or any other suggestions - not sure that there is another 'powerful' DB for the Mac OS that would accomplish my goal (all of the 'free' Office suites appear deficient in their printing options).  Dave

WineRecComb.png

Outcomes