Jed C' Morris Expert AccessExcelVBA Developer

1
Jed C. MorrisExpert Access/Excel/VBA Developer
2
Introduction Jed C. Morris

• The following slides review one Microsoft Access
  database project authored exclusively by Jed
  Morris.
• Technologies demonstrated are Microsoft Access,
  Microsoft Excel, VBA development.
• This database was developed during a six month
  sabbatical in Guyana South America for use in
  monitoring AIDS prevention programs.

3
Main Menu

• Program Areas Six primary program areas
• Reports 14 detail and summary reports
• Admin Security, backup, support, etc.

4
Community Outreach

• Community Outreach one of six program areas
• Complex system capable of supporting the work of
  many AIDS prevention agencies
• Widely endorsed by agencies and the national
  Ministry of Health

5
Multi-Session Training

• Multi-Session Training a second of the six
  program areas
• This system replaced cumbersome manual monitoring
• Quality monitoring is having a direct impact on
  national public health policy

6
User Interfaces

• Note the clean, professional user interfaces
• Simple, clear error messages
• Pleasing use of color and fonts

7
User Help Systems

• Three levels of real-time user help
• 1) Hyperlink to the full User Doc
• 2) Tool tips
• 3) Context sensitive Help

8
User Training

• User Training supported by Viewlets, a product of
  ViewletBuilder5 from Qarbon.
• Viewlets provide a simulation of actual
  software usage.
• A presentation provides a series of screens that
  animate mouse movements, menu selections, data
  entry, etc.
• Training is also enhanced with explanatory text
  boxes that provide comments.
• The movie presents a realistic presentation of
  actual software usage.

9
Tables

• System defined by 19 tables
• Full use of the relational database model keys,
  indexes, constraints, cascading deletes, and
  relationships

10
Reporting

• 14 Reports
• Categorized as Summary or Detail
• All reports seamlessly produced in Excel
• Previous reporting had been un-reliable,
  inconsistent, in-complete, and time consuming

11
Reporting

• Excel reporting advantages (over Access)
• 1) Flexible output
• 2) Powerful, user friendly report buttons
• provide additional functionality
• 3) Easy user customization
• 4) Support for saving reports to disk
• 5) Users feel comfortable in Excel

12
Visual Basic

• Extensive use of Visual Basic
• Greatly enhances the system functionality and
  user interface
• 10 years experience with VBA in both Excel and
  Access

13
Administration

• Administrative tools support sustainability
• Not sufficient to supply only the basic
  functionality
• Administrative tools that ease tasks such as
  backup, security, updates, etc. are required if
  the product is to have a long term impact

14
Documentation

• Always fully document my software
• Above manuals written for DB Admin, Users,
  Support personnel
• Not just an after thought or a bother but
  integral part of project

15
Documentation

• Documentation is extensive (this manual is 75
  pages)
• Is of the highest quality

16
Business Value

• A single person, with the right skill set, can
  have a significant impact
• Very satisfying to produce a national database
  that can impact public health policy and peoples
  lives

• Improved data quality
• Wide range of Automated Reports
• Meet auditing requirements
• Security features to protect confidential data
• Fully documented
• Administration tools for sustainability

17
Work History

• Driven to complete projects
• Consistent strong reviews for both quality and
  quantity of software
• Very client oriented
• 22 years with Pfizer Pharmaceuticals
• Strong presentation, teaching, and mentoring
  skills
• Excellent references
• In January 2008, awarded by Pfizer, with a 6
  month sabbatical in Guyana South America serving
  as a database administrator in a non-profit HIV
  program

18
Personal

• Excellent health.
• 30 years of exercising 23,000 miles jogging, 5
  years swimming.
• Adventurous, high-energy life style.
• 1,400 skydives and a 3,500 mile bicycle trip
  across US.
• Six months traveling at sea in Central America.
• Hobbies are home improvement and furniture
  making. Have installed my own indoor, in-ground
  exercise swimming pool.

19

• What Can I Do For You?

Jed C. Morris jed.c.morris_at_gmail.com 860.373.4036