“Can I do it myself?”
It’s a common question and one you really need the correct answer to before getting in too deep and realizing you’ve made a mistake.
In Microsoft Access, programming is the process of adding functionality to your database by using macros or Visual Basic for Applications (VBA) code. For example, you could add a command button to a form and have that command button open a corresponding report. For a simple operation like this, you can use the Command Button Wizard to do most of the work or you can turn off the wizard and probably do the programming yourself.
Your database can even get complex, but in many cases, you can still achieve the results that you want by using very little programming.
Automating simple tasks like switching forms or printing reports can often be done with a little VBA training.
However, when Macros or VBA are used to actually run the database itself, such as by making changes to your data, managing users or changing the appearance of the screen in real time, it is often best to consult with an expert. The more steps involved in a piece of code, the more likely it is to break as you make changes to it if you are not used to writing complex algorithms. And since writing Access databases is likely not your full-time job, it is difficult to gain the exposure necessary to all the ins and outs, the tips and tricks that will ensure your data is safe and secure as the complexity of your database grows.
A consultant or expert will have more experience and knowledge of these potential dangers.
“Can I do it myself?” is one question.
“Should I do it myself?” is another.
But avoid ever having to say, “I should never have tried doing that myself!”
We can help if you want the training to do it yourself.
We can also help if you feel the need to hire a consultant instead.
Learn more about some of the projects we have worked on.
Contact us today at 416-264-6247 or email us for a free consultation to discover the best solution for your organization.