by Jonathan Tuppeny | Nov 11, 2015 | Non-technical
I’ve been developing database solutions using Azure SQL as a cloud-based database for a few years now. The combination of the local functionality afforded by Access coupled with the ability to share data across the internet has proved very powerful. Recently I have...
by Jonathan Tuppeny | Sep 10, 2015 | Technical
One of the great strengths of Access is its ability to act as a front end to other data sources aside from standard Access database files. This gives you the ability to use the user interface resources built in to Access with the database engine strengths of a network...
by Jonathan Tuppeny | Aug 17, 2015 | Non-technical
If I had to come up with a single phrase to describe the myriad of spreadsheets and databases that I’ve encountered over the years it would be – ‘If it looks terrible, chances are that it is.’ I’ve been working with spreadsheets, databases and Visual Basic code...
by Jonathan Tuppeny | Jun 15, 2015 | Technical
When you use VBA as part of an Access database, or if you add in a custom component, you might end up adding a reference to the application. References are links to components or applications installed on your system that are used by the database. For instance, if...
by Jonathan Tuppeny | Jun 15, 2015 | Non-technical
Over the years I’ve been involved in loads of projects and I’ve noticed that there are two key factors that every successful project shares. They seem obvious but it’s surprising how often they’re lacking. At the outset of a project, especially a long and/or complex...
