Check out my new book, Microsoft Access 2016 for Dummies published by Wiley:
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 (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, (more…)
I did an Internet search for “is Microsoft Access dead?” and found lots of conflicting information on this topic. This seems to be a hot topic in the database world with all kinds of people chiming in, some of whom by the comments they’ve made, don’t know much about Access or relational databases. I read in my search that Access is useless, a “toy”, Excel can do anything Access can do, stuff like that.
Since I’m an Access database developer, I guess you could say I have a bias. However, let’s look at the facts. (more…)