Using MS Access/Expert Profile

Expertise

I specialise in database analysis and design, SQL and database queries using QBE and VBA. In my work, I use MS Access together with MS SQL Server as ETL (Extraction - Transformation - Loading) tools for migrating data between business ERP systems and data stores. My forte is building bespoke functions and applications.

Experience in the area

I am a chartered engineer with 30 years of engineering and business experience, member of the BCS and have been working specifically in database applications, including SQL Server (v7/8/2000) for the last 9 or so years. I previously taught a course in Database Analysis and Design, but am now a freelance consultant and systems analyst.

Commercial database design and development work undertaken.

What do you like about this subject?

Designing and building business processes, databases and user applications is a cornerstone of my existence. They have such a powerful impact on people's lives, that success is sublimely rewarding.

What do you still hope to achieve/learn in this field?

One is never to old to learn - this environment is a never ending arena of learning, no matter how long you've been around. Serving the Access Experts group feeds the quest to learn. . . . .

Something interesting about this subject that others may not know:

Access is an excellent tool - it is very user friendly to learn - beginners in database work can achieve incredible productivity very quickly - it forms an excellent utility for developing Client applications in a Client Server environment - it is a great prototyping tool - it enables applications to grow in complexity with developer skill and experience.

Something controversial or provocative about this subject

A knowledge based economy depends on data.