Visual Basic Programmer

VISUAL BASIC Programmer SKILLS

Microsoft Access and Visual Basic for Applications

The Microsoft Office Professional suite of software includes the popular Microsoft Access database system. Programming for Microsoft Access uses a subset of Visual Basic called Microsoft Visual Basic for Applications (or VBA).

Microsoft Access Database and VBA programming

Here are some examples of VBA programming for Access Databases:

• Created a Component Object Module (COM) interface to allow third party access, using VBA, Microsoft Word and Microsoft Excel, to the records on the Microsoft Access database on the Server.
• Supported a Microsoft Access database which contained the rules for a data driven Client/Server system.
• Converted a DAO Jet Engine to an ADO database module using Visual Basic for Applications. Converted the relinking of a Back-End Access database from DAO to ADO.
• Using Visual Basic for Applications, supported an Asset Valuation database written in Microsoft Access which included substantial work both in developing automation applications for both Microsoft Word and Microsoft Excel.
• Porting and redevelopment of a Sales Analysis application to a Microsoft Access Database, using Visual Basic for Applications.
• Amended and enhanced the Microsoft Access database Rostering system for the Sydney Opera House using Visual Basic for Applications.
• Amended and enhanced the Corporate Express Cataloguing Microsoft Access database.
• Using Visual Basic for Applications, created correlation functions for City Rail's accident analysis (SPAD) Microsoft Access database.
• Designed and created a Microsoft Access database for the University of New South Wales, using Visual Basic for Applications to handle the automation of Prospectus mailing from their Web site.
• Using Visual Basic for Applications, created a Microsoft Access database for Singles, featuring a compatibility algorithm for matching couples. It includes data entry from a Web Site and automated Access database updating from Microsoft Outlook emails.
• Created an automated payment system for Independent Practitioner Network (IPN), which handled the submission of doctors' fees to Westpac. An ADO Recordset was created from an Access Query, and payment details extracted for each doctor. There was provision for manual adjustments and balancing before submission to the bank.
• Extended the life of an Access database and avoided the necessity of migrating Access to SQL Server. By moving embedded images from the database to the Windows file system on the Server, the size of the data in the Back-End database was reduced by 98.5%. Backup now takes a fraction of the time.
• Converted Access 95 databases to Access 2007.
• Created a procedure to read records and headings from a .dbf Table for any Dbase version.