Switching to the Mac: The Missing Manual, El Capitan Edition

Microsoft Access

Microsoft has never been interested in creating a Macintosh equivalent of its flagship database program (which comes with the higher-priced versions of Microsoft Office for Windows). FileMaker, a much easier-to-use database program, towers over the Macintosh database market like the Jolly Green Giant (and has a decent following on the Windows side, too). Resistance, Microsoft apparently assumes, is futile.

It’s easy enough to get your data out of Microsoft Access; just choose File→Export. In the resulting dialog box, you can choose from a number of common export formats that can serve as intermediaries between the Windows and Mac worlds (see Figure 7-1).

Figure 7-1. When you export your data from Access, you can choose from any of several formats. The idea is that you’ll transfer the resulting exported file onto your Mac and then import it into a proper database program there.

Among them is Microsoft Excel—that is, you can turn your database into a spreadsheet. The beauty here is that FileMaker on the Macintosh can turn Excel documents into FileMaker databases without even batting an eye. You just drag the exported Excel document onto the FileMaker icon, and FileMaker does the rest.

Unfortunately, there’s more to an Access database than just its data. Your database may well have fancy forms (layouts), complete with letterhead and other graphic elements, not to mention ...