If you think about it, the only differences between then and now are in the details: people (well, normal people) don't converse with their computers, "reasonable time" is measured in seconds not days, and fedoras are no longer considered proper business attire. Aside from the lack of fedoras, businesses run much more efficiently than they did back then. At least, that's what Brandon believed.
When Brandon started at a new company, he was surprised to see how their reporting system worked. While most companies use some sort of reporting application to allow for the easy creation and retrieval of reports, Brandon's company used the receptionist.
The process was fairly simple. For one particular report, the receptionist would pull up the Instruction Sheet (a Word document) which contained the forty or so steps required to generate the report. Some of the steps involved copy-pasting, others involved creating several Access databases to import data from the data warehouse, and one involved double-clicking on 87 different queries (named Run001, Run 002, Run087). The instructions were developed jointly by a (highly paid) business consultant and an access programmer.
From looking at the output, it was apparent that the entire report could be generated with a script and a few long queries. Not wanting to overstep his bounds, he offered the poor receptionist girl a little relief in the form of a Macro:
Code: Select all
Public Sub RunAllQueries() Dim i As Integer Dim Query As QueryDef For i = 0 To CurrentDb().QueryDefs.Count - 1 Set Query = CurrentDb().QueryDefs(i) If Left$(Query.Name, 3) = "Run" Then Query.Execute Next End Sub
The Daily WTF - The Last of the Computers