![]() Instead of learning about and growing into yet another “tool”, I found great success continuing my use of Access (for pretty forms and a dwindling number of reports/queries) connected to a database server (MySQL) then using the powerful professional tools available in the world of Python/Pandas/Django, etc. Far as I know there is no real replacement for Microsoft Access on the Mac, but keep looking if you must. ![]() All this Python stuff installed inside an Anaconda (free) environment–which again is a fantastic simplification that allows a quick install and setup and allows me to focus on the data/business and not fiddling with the computer. Terrific graphics from that via Matplotlib (free). Over the years I’ve built up some very-useful automation–but in instead of using Access VBA (which I don’t really like and never did!) I use Python (free) with a Django (free) connection to the database with Pandas as the main analysis tool. Sometimes I do quick management of the data and database via MySQL Workbench (free). I simply use Access some of the time to interface with it (using ODBC) from the local and networked machines for the pretty forms (nothing better than Access) and a very few reports/label printing. In actuality, my database (essential for my business) runs on MySQL (free) on the Mac. If you do this then you’ll have a quick/easy setup and you can focus on the database and not the new “system”. I’m quite happy with leveraging my Microsoft Access experience (Using Access since 1992) by running it inside Parallels on both my Macs.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |