Access Database Solutions
Repairs, optimisation, upgrades and multi-user client-server applications for Microsoft Access.
Access services
Canberra · Microsoft Access, Excel & SQL Server
Database and spreadsheet solutions that just work.
For over 20 years we have built custom Microsoft Access databases and Excel VBA applications. We fix what is broken, modernise what is outgrown, and build what is missing.
Our services
Our core expertise is advanced Microsoft Access, SQL Server and Excel development with VBA, backed by database assessments, data conversions, documentation and training.
Excel Solutions
Turn-key Excel applications with custom menus, forms and VBA, including front-ends to SQL Server.
Excel servicesKnowledge Bases
HTML-based intranets that bring team knowledge together, easy to navigate and cross-reference.
Knowledge basesTraining
Courses in Bitcoin and cryptocurrencies, personal cyber security, and HTML.
View coursesCommon problems we solve
If any of these sound familiar, we can help.
“Our database won't open any more.”
Older .mdb databases can be incompatible with current versions of Microsoft Office. We repair and convert them.
“Only one person can use it at a time.”
Splitting into front-end and back-end files turns a single-user database into a multi-user system.
“It has outgrown Access.”
We move your data to SQL Server or PostgreSQL so the server does the heavy lifting, and keep the forms your staff know.
“The data is a mess.”
Missing lookup tables and non-normalised structures cause data quality problems. We fix the structure and cleanse the data.
“We need our data somewhere else.”
We extract data from Access into SQL Server, PostgreSQL or Excel, in a format your IT team can manage.
“Our team can never find anything.”
A cross-linked HTML knowledge base puts critical information a few clicks away.
Featured project
Marine logistics application
The client needed a system built on the tools already available across the enterprise: an Excel front-end with all data held in SQL Server.
We delivered a truly multi-user, client-server application covering vessel resupply audits, warehouse management, supplier lists and automatic purchase orders, with a custom ribbon, role-based logon and custom forms for every record. No third-party tools meant no licensing issues on deployment.
Outcome
- A simple user interface for each user group
- Low maintenance costs thanks to consistent standards in every object and line of code
- Quick response times and data availability from a central SQL Server database
- All security requirements met
Why choose us?
Expertise
Decades of experience across IT and software development, with deep specialisation in Access, Excel and SQL Server.
Customisation
Every solution is tailored to the unique needs of your organisation.
Quality
High standards in every object and line of code, so your solution is reliable and easy to maintain.
Support
Reliable, timely help with any questions or issues, long after delivery.