Our latest blogs
Insights and how-tos on modernizing Access/Excel, databases, BI & reporting, and custom software.
Browse by topic
July 8, 2023
Creating Queries in Microsoft Access: A Practical Guide
A query is how you ask an Access database a question. Which orders shipped late, which customers have not bought since March, what did we sell by region last qu…
Read More.png&w=1920&q=75)
July 7, 2023
Relationships Between Tables in Access: Junctions, Cascades and Joins
Relationships are what separate a database from a pile of spreadsheets. They are also where most home-built Access databases go wrong, and the damage is quiet:…
Read More
July 6, 2023
Access Data Types: Choosing the Right One, and What Goes Wrong
Choosing a field's data type takes two seconds and is close to permanent. Get it wrong and you find out months later, when leading zeros have vanished from ever…
Read More
July 5, 2023
Tables and Fields in Microsoft Access: A Comprehensive Guide
Introduction: Designing Tables and Fields in Microsoft Access Designing tables and fields is a crucial step in creating a robust and efficient database in Micro…
Read More.png&w=1920&q=75)
June 30, 2023
Create a Simple Database in Microsoft Access: A Worked Example
Most guides to building an Access database describe the process in the abstract: plan your entities, define your fields, establish your relationships. Then you…
Read More
June 28, 2023
Introduction to Microsoft Access: A Beginner's Guide
Introduction to Microsoft Access In today's digital age, data management plays a crucial role in the success of businesses and organizations. Microsoft Acce…
Read More
June 27, 2023
The use of biometrics across industries
Among the game changers in the tech industry, biometrics remains to be one of the most widely used in people’s daily life. From switching on your phone to…
Read More
June 19, 2023
How Does Instagram Influencer Marketing Work?
In today's digital era, Instagram has become more than just a platform for sharing photos and stories. It has transformed into a thriving marketplace where…
Read More.png&w=1920&q=75)
June 18, 2023
Mobile security: protecting your digital sidekick
In this digital era, smartphones are everybody’s best friends. They know everything–from the conversations you share with family and friends to your…
Read MoreRecognize any of this in your own systems?
Get a free assessment of your Access database, Excel spreadsheet, or process — no call required.
Request a free assessmentNot sure what to expect? See how it works →