Home Training  Web Design News Consulting Databases Contact Us
Log In
 
 
 
 


VBA programming and automation of Microsoft Access, Excel, Word and much more!

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!

 

General Consulting

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 contact us ONLINEor on 0420 713 868.