Green Dot Consulting offers a wide range of programming and application
development using Microsoft Office products and Visual Basic for Applications
(VBA).
VBA can completely automate mundane or repetitive tasks and offers
connectivity between Microsoft Office applications. For example, VBA in
Microsoft Access can send emails with attachments automatically or reconcile
itself with external applications such as SAP or MYOB, and so much more!
Here are some examples of recent projects:
Microsoft PowerPoint
We recently
designed a PowerPoint presentation that ran as a quiz engine. The presentation
asked a series of questions on occupational health and safety, to ensure
employees were properly trained. If the employee got the answer correct they
could move into the next slide, if not, they would need to watch a video on
workplace safety. All the quiz results across the organization were tracked so
managerial reports could be developed, showing statistics on OH & S knowledge
across the entire organization.
Microsoft Access
Access is a powerful database
application that can store mass amounts of information, automate common tasks
and produce detailed reports on data. Green Dot has designed and implemented
many Access databases, from Laundromat management systems to CCTV. For more
information on the projects, Click Here
Microsoft Excel
Many organizations use Excel extensively in every day business tasks, but
don’t realize how easily you can automate Excel! Our most recent project in
Excel took data from a corporate payment system and reconciled the data against
the corporate accounting package to ensure the payments leaving the organization
matched the invoices in the accounting system. This system has saved thousands
of dollars in only a few weeks, and continues to pay for itself daily!
MS Office Integration
From over 10 years experience in office automation and Microsoft
products we have in-depth knowledge of how to increase your business efficiency.
Project Management
Green Dot Consulting can provide expert advice and
management of your IT application development process. We primarily use the
PRINCE2 methodology of project management to ensure all projects are controlled
and reported efficiently.
For more information on any of these services, or
simply to discuss what is possible, please email us or call on 1300 80 11 88.