I have been developing MS Access / VBA based applications for the past 20 years. 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 screens, 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/ASP/ADO
6
7
WINDOWS
16
8
VISUAL SOURCE SAFE
10
7
PVCS
8
7
BORLAND C / C++
3
6
MQ SERIES
2
4
WORD/EXCEL
18
8