Last week, Matthew Moran, gave a workshop as part of The Russell Fisher Business Collection at the Camarillo Library. The RF Business Collection is a grant that provides the library funds for hosting business workshops and informational seminars. Georg Winkler administers and books speakers for the event. He has also started getting them on video […]
We just published the initial version (beta: ver. 0.5) of an MPAA Content Security Audit Review Tool built in Microsoft Excel. The Motion Picture Association of America (MPAA) has a Content Security Best Practices Common Guidelines document that our client needed us to follow to help them pass a digital security audit review. The audit […]
This came up for a client recently, so we decided it was worth covering here on the blog. Also, it was supposed to be our first Tech Tuesday content but we had to get to a client early to ensure they passed a network security audit that was tied to a substantial amount of new business. […]
AKA: How to build better technology solutions for your organization. Part 1 | Part 2 | Part 3 RECAP & INTRODUCTION In part 1 I covered origins and impact. In part 2, I wrote about objectives, what to expect, and described the dangers of process-driven thinking. In part 3, we’re going to explain how to move […]
AKA: How to build better technology solutions for your organization. Part 1 | Part 2 | Part 3 RECAP & INTRODUCTION In my last article I discussed the origins, impact, and initial premise for Concept Over Process. Today, I want to cover what to expect as you learn more about COP, the objectives of COP, and […]
AKA: How to build better technology solutions for your organization. Part 1 | Part 2 | Part 3 HISTORICAL BACKGROUND Back in 1994, I worked for a large insurance company. I was building a document assembly system (contract assembly) – one that would receive some notice in the tech world, eventually being written up in PC […]
Summary: This demonstrates a methodology and some of the associated technologies I’ve used to create complex and flexible contract generators, proposal generators, and other document assembly systems. Technologies: Microsoft Access (SQL Server*) Microsoft Word – Word Templates – Word Global Template w/AutoText Entries * SQL Server: For simplicity, this demonstration uses Microsoft Access as the […]
Summary In our own work with data analytics, in coaching financial & business analysts, and with data conversions, we often coach clients to learn and use Microsoft Access or SQL Server, rather than (or perhaps more accurately, in conjunction with) Microsoft Excel. In this article, we explore some of the reasons why. “I suppose it […]
Summary Some visual-basic for applications code to extract all the formulas from every sheet in an Excel Workbook and save them in a text file. Background Avoiding a long explanation, we’ve been writing a reporting tool that combines a Microsoft Access front-end to a SQL Server database. It generates and updates some Excel reports/data visualizations […]