I have been developing MS Access / VBA based applications for the past 20 years in Australia. I am a fan of Access development work. Some of the organisations for which I developed major MS Access applications in the past 20 years include JP Morgan, NSW Police, Channel-9, Department of Health (NSW), Registry of Births Deaths and Marriages, AMP (Super & Insurance), ANZ, Westpac, Mann Industries, Honeywell Australia and APC.
Access applications I developed include the following features:
* User friendly forms, reports, menus and switch boards
* Data retrieved from Access and other ODBC supported databases like SQL, Oracle etc
* Complex reports based on both homogeneous and non-homogeneous type of data, in some cases data coming from more than 32 separate queries & temp tables
* Pivot table based queries and reports
* Context sensitive online help system
* Comprehensive multi-user security system
* Application types include Knowledge-base, Health, Industry, Finance, Stock tracking etc
* Easy to maintain features such as: Automated backend database link update, backup, user maintenance etc
Shown below is the summary of my skills.
Skill Years Proficiency
============================
MS ACCESS / VBA 20 9
SQL SERVER 14 8
Visual Basic 15 8
ASP 4 7
.NET C#/VB/ADO 6 7