Garry Robinson
Mike Gunderloy, editor of developer central asks
Garry a number of questions that should be of interest to anyone trying to make
it as an independant IT consultant.
Developer Central Web Site
http://www.adtmag.com/newsletters.asp?nl=DEV
1) So OK, what IS your strategy for enjoying life on the beach as a
developer?
I confess, I live and work 5 minutes walk from a beach where a
snorkel will allow me to see lots of fish, the occasional blue groper (nearly a
yard long), the odd stingray and not get too cold even in the middle of winter.
This is not something that every developer in the world gets to do so my
business plan is to ensure that I remain my own boss so that I can have an
occasional swim (and don’t have to
iron a shirt too often).
The strategy sort of goes like this “you must work a lot
harder when you haven’t got paying work than when have” or another way of
putting it “there is no such thing as a successful part time consultant”.
If you read through the rest of my answers to Mikes questions,
you will gain an insight as to how l have survived 8 years is metropolitan
Sydney without pulling out the ironing board too often.
2) What payback do you see from publishing a newsletter?
Five years ago I was sitting around wondering how I could drum
up some new business when I decided to write a newsletter and send it to 200 or
so email addresses that I had in my database. As I really was a technology
person, I decided that what I did and discovered whilst working would be my
content. As this newsletter first went out in the days before spam, I was lucky
enough that 50 people opted into the list. More important than that, one of my
clients who had been quiet for a while asked me to come in and guess what the
email paid for itself, I had some work.
Since then, I have continued to prepare a newsletter every
month or so that now goes out to 4000 programmers and other hardy soles.
Surprisingly the emails are still a useful tool for generating custom programming
work even from my less technical savy clients. Given that I am the worlds worst
tele-phone-marketer, the newsletter has proved to be a marketing strategy that puts my
name back into the consciousness of people who pay for programming.
The second reason that I write my newsletter is that it
actually sells my software and it seems to improve the Amazon rankings of my
Access book. Unfortunately it doesn’t sell thousands of dollars worth but it
does generate a $100 or $200 dollars in sales and given that I try to write the
newsletter when I haven’t got any work on, this is $100 more than I would have
made if I hadn’t written the newsletter.
Reason three is probably one that you wouldn’t pick until you
had been writing a newsletter for a while. As soon as I send out a newsletter, I
setup a new one (its no more than a Word document) and I start adding content to
the newsletter about what I learn as I work. Included in this content is a list
of Good Reading web pages that are actually like a list of favourites. If I
stumble across a web page of greater value, then I might write more on the
topic. This list actually then becomes my knowledge base and I generally find
that I can remember that important web page by refer back to the newsletter
chronologically. As I also post this newsletter to my web site, I now can use
Google to search my web site to find those little gems that I wrote up in the
newsletter many issues ago. I also find that by using this approach that I
actually save time because I don’t spend the half hour reading that important
article that I discovered on the web. Instead I just save the
chronological/searchable “bookmark” in my newsletter for a later date.
3) Why do you keep working with Access?
The reason that I keep working with Access is that the clients
keep coming back for more and more clients keep turning up. Maybe it is the fact
that I am known as an Access guru but I hardly ever get asked to do other things
so why not stick to a good thing.
But what is special about the clients that make them want
Access development in the first place? In my experience, my skills are required
because prospective clients have either built a bit of the system in Access or
they have had a dabble in Access and think that it would be the logical
improvement for managing their hellishly complex Excel spreadsheet monster. My
most important clients are generally not IT department managers, just people in
reasonably big companies that need to have a system that will happily run 2-5
users and do a lot of really tricky things little calculations just like their
spreadsheets. Because I know the workings of Access, I generally seem to be able
to come up with a simple systems that actually meets a business need. Return
work and referals ensue.
4) What's the first computer you ever worked with?
I actually entered computing during a Masters Degree in
Land Surveying. I undertook this work with a Vax 730 using some early 3D visualizations
software called Movie BYU. When I landed my first job (with a mining company),
we owned a PDP 11 that ran Fortran. An interesting twist in this mix was this
massive Huston plotter that weighed a tonne and used to take 4 hours to draw a
fairly modest map. Looking back on those good old days, every piece of technical
software that we wrote seemed to read a text file, do a few things and then spit
out another text file. We would then write a new program to process the second
file and produce another text report or text plot file and maybe even another
text file. When we made the switch to Informix 4GL running on PC’s, our life
improved dramatically compared to the “good old days”.
5) Is there still room for a one-man shop to profitably develop and sell
products instead of services?
I believe that if you intend going out on your own as a
software developer that you must have a project. My project was developing
software and an associated web site but your project could well be to write good
computer articles or contribute heavily to a popular programmers web site.
When I started my company off 8 years ago, I had just just one
client. I was able to bill about $8,000 for work in the first 6 months and
luckily my wife had a real job because we weren’t going anywhere fast. In the
lull (after I spent a day ringing everyone I knew), I devoted an enormous amount
of time to writing a data mining application in Access. This then managed to get
some publicity in the Smart Access magazine, the software got a little bit of
boost and I made some sales. During the development process I was forced to
learn all sorts of things about the internals of Access and I emerged from that
with a good understanding of the product. If I had spent the 6 months just
experimenting and reading a book or two, I would never have had the skills to
adapt Access to a client requirements.
Fortunately for the bank balance, an Aussie IT manager in
a big trucking company found out about the data mining program and asked me to
come in and demonstrate it. After the demonstration, they asked me to come in
and customise the data mining software so that they could graph their data. I
went to the site and spent 6 weeks writing custom reports and graph in Access and the
data mining software sat “unused” on my laptop. What the software did for me in
this instance was to provide a good reason to have a good long chat with the
customer and subsequently my first meaningful job. From that job, other people
started to hear about my work and my business was finally of and racing
(slowly). I have since expanded my project approach to three other products and a
detailed web site. I find that development of those products is not only good for
sales but it makes me and my offsider(s) more productive. Oh I could go on but
the reality is that I now have work coming in from a good variety of clients and
I feel confident that I can head down to the beach without the burden of
worrying about the next mortgage payment.
Pages related to this article include my first newsletter
Access Unlimited - Edition 1
An FMS article on why Access continues to be successful
http://www.fmsinc.com/tpapers/genaccess/DBOD.asp
My data mining shareware product
http://www.vb123.com/graf/
Thanks for listening and I hope you can glean something useful
from my ramblings.
Garry Robinson Editor of vb123.com
Postscript: It’s a pity that my 4 year and the baby conspire
to ensure that I only manage to go swimming 2-3 times a week. Oh well, pushing a
pram along Sydney beaches overrun by scantily clad joggers who love a cute baby
isn’t a bad fallback strategy.
To find out about Garry’s book which is
called “Real World Microsoft Access Database Protection and Security”, point
your browser to http://www.vb123.com/map/
or use a search engine to look for the ISBN 1590591267.
Other Pages On This Site You Might Like To Read
Access Unlimited Newsletters - Table Of
Contents
Data Mining Using MS Access -
Garry's first article for Smart Access
Implementing a Successful
Multi-user Access/JET Application
Scott's Blogg
Scott McManus also wrote to Mike as a follow up:
"I work with Garry from the article "DC #61: Extra
briefings, Five
Questions, and more!" I sub contract to Garry on Access projects, as
well as have my own Access development clients, I also do Mining
specific IT tasks. I lead a little more cruisy life than gaz as my aim
is to work only 5 days a month. Some months I fail and have to do more
work. But that is not the real reason why I want to add some thoughts.
"Flying back from a client's Garry and I were talking about the 5
questions and some other issues. The main issues were about staff being
sent on access courses because management saw that as a way to get the
staff developing databases and as a 'thank you' to staff as the courses
are time of work, sometimes away from home so there is some travel,
dinners and hotel stays.
"Garry bought up the issue that it was an excuse not to hire good
developer help by some managers, be that at as it may, Garry and I have
always taken the view that having an Access educated (or what ever
system you develop in) staff member at a client's is a boost and we have
always made sure there was a transfer of skill to the client's staff.
Even if it means there is less work for you, the client knows where to
go for help, and more important - What is the question!!! SO much of my
time is spent helping clients find out what the question is. They know
they have a problem, They know a database system or solution may help
them, but they don't know how to articulate this. (This is sometimes
known as systems analysis, I wrap it in the guise of 'I can't quote on
your project as I don't know what you want, how about I sit down in your
office, talk to your management and your staff and develop a project
plan and costing to help you get project approval from senior
management. The resultant document will also be able to used to obtain
quotes from other developers. It will cost you three days work.' Garry
Calls this Phase 0.)
"Better educated staff mean that in the long run, they know when they
can't go further as they know what the question is and that they don't
know the answer, and then you end up being an advisor and help fix the
big problems, in the mean time the clients staff increase in skill and
knowledge and take on importance in their companies and eventually move
on, to either a senior position or another company, but not having the
time to develop they call you, as they know they can trust your product
and advise.
"Another issue Garry brought up was, does a course make you an access
developer and Garry asked me the question 'How long did it take you to
become good at developing access?' My Answers was 'Not long, but then I
had spent two years learning Visual Basic, I had 15 years IT experience
from punching cards on Sperry's to 3D databases to Remote Imagery to
Networks to Fortran to DBIII+.......... Access just seemed so sensible.'
"At the end of the day, why do I develop in Access?
"It is an excellent prototyping tool. Data models, software design and
flow developed in access can be quickly translated in to more 'heavy
duty systems' Development is fast and clients get immediate benefits.
Not every client has a 10 million budget or even $10,000 one.
"But most of all the main reason is that I see it as niche market. Many
IT people see it as of no consequence and would not even be seen with
access on their machine. These people happily chug away on Oracle,
SqlServer etc in the mean time, departments they are meant to be
supporting are crying out for quick small applications, that never seem
to come out of the IT department."
Phil from Sydney said
One comment that I thought I'd make is actually related
to a point that Scott made. Yes, a lot of my Access customers don't have
anywhere NEAR the $10,000 budget and this makes it hard for them to sometimes
part with only a few hundred dollars to spend on making things run smoother
for them. The challenge becomes one of honing your "marketing" skills to try
to convince them to hand over the money in return for better productivity!
Over the years we have also moved from one-off custom
development work towards trying to develop products that have some appeal.
Having specialized more in mobile solutions in recent years, Access is no
longer our only development tool but there is always a place for it somewhere
in the chain of apps that make up a solution. Ah, there's nothing like a
Sunday afternoon spent whipping up a few forms and reports to put in place
first thing on Monday morning! (Even when the Sydney sunshine is calling you
to hit the beach...)
Click on the following button
to jump to the next page in the document loop.