For the most part, you're probably accustomed to using Microsoft Excel for tasks such as preparing reports, forecasts, and budgets. However, Excel is much more powerful than that. It can be used to ...

Database normalization is the cornerstone of database theory. Once a database is normalized, relationships between the data in multiple tables must be established. A hefty part of designing a ...

Four queries and some in-app iteration on collections (joins). At my current job, we have a monolith of similar size/complexity that sits on top of a relational database. The DAOs are somewhat 1:1 ...

For over two decades, Oracle, IBM, and Microsoft relational databases were the only consistent leaders in the Gartner Magic Quadrant for Operational Database Management Systems--and there were few ...

While Excel is renowned for its versatility in calculations and data visualization, it can also do the job just fine as a database. Small businesses, non-profits, and even departments within larger ...

File-based databases have been around since the dawn of computing. We’ve always needed to have a way of storing records of the same kind of information. In the PC world, we ended up with very popular ...

The last piece of this three-part article is about merging your custom Word documents with your client list (exported from Outlook to Excel) for distribution. Part One explains how to selectively ...