Microsoft Office Applications

Not every business operation needs to be cloud based. Microsoft office provides the tools necessary to manage everyday tasks like keeping track of customers, issuing invoices, time-sheets, schedules or whatever else your business does. Although the ‘out of the box’ applications work well as stand alone programs, using the built in VBA programming language can greatly extend their potential especially when creating applications with Access and Excel.

Microsoft Access Application Development

MS Access is a database system for small businesses providing flexibility for any task that requires data management and storage. With Access you can create a multitude of applications from a contact list to a product invoicing system or an employee time-sheet to a CRM. Using the Access built in programming language VBA, applications can be customised specifically to meet your business needs.

We provide:

Database Consultancy and Development
Business Analysis
Enhancement and Maintenance
Data Migration
MS Access upgrades from previous versions
MS Access upgrades to SQL Server
VBA Programming
MS Access Training

Microsoft Excel Application Development

Most people are aware of the functionality of Excel in carrying out complex calculations for almost any business requirement. However not so many push Excel to its full potential. Using its built in programming language extends Excels capability exponentially. For instance you can easily automate those repetitive tasks, create user entry data forms that hides complexity and enhances security or export data automatically to a database system or a website for online publishing.

We provide:

Application Development
Enhancement and Maintenance
Data Migration
VBA Programming
MS Excel Training

Microsoft Office Application Intergration

MS Office is a powerful tool for any business, however each of the applications do not have to work as individual programs. They all share the same VBA programming language which enables them to easily ‘talk to each other’. For example, you could create a database application that automatically updates an Excel spreadsheet whenever a new record is added or deleted, that exports data to Excel with the click of a button or when a certain condition is met. Similarly data can be passed to Excel from a database, a new Word document can be created, a PowerPoint presentation updated or an email sent with an attached pdf created from a MS Access report. The combinations of inter-operations are limitless.

We provide:

Consultancy and development in MS Office Integration
Training on all MS Office products