My new book, Microsoft Access 2019 for Dummies published by Wiley was recently released:
As a database developer for small businesses in the service industries, I’ve found that Microsoft Access is still their database tool of choice. It’s the logical first step for small business databases. If you’re storing your business data in spreadsheets, here are some questions to consider:
If you already have a Microsoft Access database for your small business or even have your business data in a spreadsheet, Access makes it easy to take data from your desktop database or spreadsheet and put it out on the web. All it takes is a $12.50 per month subscription to Office 365 for business. With that you get the latest desktop versions of all the Microsoft applications plus Office apps that run on any device including mobile devices. In addition, you get SharePoint 365, Microsoft’s web tool to secure, store, share, and view information on the web.
With this subscription, you’ll have everything you’ll need to build an Access web app that runs in a browser. The app is built Read More
Today I want to share a case study from a client of mine.
Side Note: Because I sign non-disclosure agreements with my clients and I respect their privacy and trade secrets, I can’t name names or get into details.
A few years back, a client in the manufacturing business contacted me about automating their order, production, and shipping data processes. This was a relatively small (under 50 employees at the time) and growing company. They were doing all of their data management either on paper or in spreadsheets. Surprisingly, Read More