Our latest blogs
Insights and how-tos on modernizing Access/Excel, databases, BI & reporting, and custom software.
Browse by topic
- All topics
- Access & Excel
- BI & Reporting
- SEO
- Social Media
- Digital Marketing
- Web & WordPress
- Content
- Tech Insights
Showing Access & Excel Modernization posts. Visit the Access & Excel hub →
July 15, 2023
Customising Access Forms: Layout, Controls and Conditional Formatting
This covers making an Access form faster and clearer to work in — layout, control properties and conditional formatting. If you are still building the for…
Read More
July 13, 2023
Creating Forms in Microsoft Access: A Practical Guide
A form is the difference between staff entering data into a database and staff typing into a grid. Get forms right and most data-quality problems never happen,…
Read More.png&w=1920&q=75)
July 13, 2023
Advanced Query Techniques in Microsoft Access: Harnessing the Power of Joins and Subqueries
Introduction: Advanced Query Techniques in Microsoft Access Microsoft Access offers a wide array of advanced query techniques that allow you to extract complex…
Read More
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 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 →