Connect Microsoft Access to MYSQL backend – A fully illustrated instructions guide
This article is a set of complete instructions on how to link a Microsoft Access database front to an MYSQL database hosted on a webserver. We start you from ground zero and build it up to the top.
Why small businesses should use Access database – 6 Reasons that really matter.
Time and again I have found that the humble Microsoft Access database can serve the needs of resource-strapped SMEs perfectly. Let me explain the 6 reasons why.
Fully Automated Dashboard with Excel VBA
A local airport operator seek us out to create a fully automated dashboard using Excel VBA. The airport operator collects customer satisfaction surveys using iPads and the results are stored in an Oracle database.
Excel-based Expense tracking tool for Ship Management
A ship management company typically is engaged by ship owners to operate their tanker ships within a strict yearly budget. This company approached us to improve their Excel expense tracking tool for a fleet of 20 ships.
A Trading Database in Excel
A commodity trader approached us to create an Excel VBA database application to store and manage trading records.
Project Management: Why you always don’t have time.
In every project we undertake, we are always held hostage by two constraints: “time” and “quality”.
The strengths of Excel vs Access
As development consultants, we often get the question: “Should we do this project in Access or Excel?”.
What is an Independent Contractor?
Having worked as an independent contractor for Excel VBA development for a number of years, I would like to share some useful experiences for people who drop by my site and prospective clients.
