- Are based on using
our experience and knowledge to provide practical solutions to our clients.
- We build effective and practical Excel and Access applications using
the Visual Basic for Applications (VBA) programming language.
- VBA is a powerful object oriented programming language that comes with
every copy of Microsoft Office for Windows.
- We like developing in VBA, because our clients can
take over the programming of their applications when they are ready.
- We start by talking to people about what they want, reviewing present
systems, gathering information and documenting our findings.
- We involve our client's managers and staff as appropriate, to establish
the facts, their real needs and expectations.
- When clients don't have
time to describe the full technical detail of what they want, we help
them fill in the gaps.
- We optimise data collection, modeling and calculation methods
and data structures for better
solutions.
- We build
smart new Excel and Access applications to meet our client's actual
needs.
- Spreadsheets can get complicated - starting with logical data
structures and good organisation, helps keep them under control.
- A good understanding of Excel objects and their events is important
for interactive applications and data input error avoidance.
- Spreadsheet formulas are a good start, but many calculation tasks and
operations can't be done without real programming.
- Reliable databases require well thought out, formalised data structures,
referential integrity and good data protection.
- Getting applications to interact effectively requires experience and
a good understanding of application object models.
- Some
of our software jobs start from an existing application that works, but
needs a little help.
- Starting from an existing spreadsheet or database is useful, because
it provides an insight into where the client started.
- It is often easier for people to see where they want to go, when they
have the experience of some existing
software.
- It is often useful to quickly improve existing applications with simple
not so obvious changes, before full redevelopment.
- Because part of the work has already been done, sometimes software
redevelopment can give a quicker result.
- Errors in spreadsheet
formulas and code operation, or database structure and queries, are very
frustrating when you know something is wrong, but you can't see any obvious
way of finding or fixing the error.
- Sometimes they are due to one of those mysterious built-in bugs that
just happen to come with complex software.
- We have considerable experience in the art of finding work-arounds for
built-in bugs in spreadsheet applications,
- Usually they are caused by simple mistakes in formulas, logic, protection,
linking, data structures and macro coding.
- We use our own Ex-Ray tools to find and fix the ordinary
spreadsheet errors and logic mistakes that we all make.
- We use our experience and the advantage of seeing from a different perspective,
to find and fix the harder ones.
We believe
advanced training is better when focused on your actual software needs, because
high end Excel and Access capabilities are so extensive, you have to be quite
selective to get the most helpful training done in a reasonable time.
- We train experienced computer users at levels from intermediate to advanced.
- We recommend beginners attend the readily available classes, or work
through do-it-yourself courses.
- Training is customised to each client and normally focused on development
a real project they need.
We also do general
process, software, mathematical, statistical, engineering, automation and
technical analysis.
- The object of technical analysis is sometimes associated with a software
development project we undertake.
- We also do technical analysis from an engineering perspective of systems
or proposals not related to software.
Click HERE to see our Terms & Conditions of
Engagement.