Denver Area Access Users Group

General Meeting Presentation

Thursday, September 21, 2023

Armen Stein, Access MVP, J Street Technology

Advanced Database Design

Armen Stein, Access MVP, J Street Technology

Access MVP Armen Stein will lead you on an exploration beyond database design standards and best practices. He will cover useful techniques and patterns such as:

  • Designing for flexible and powerful user permissions far beyond hierarchical levels, that put your users fully in control
  • Storing variable, expandable data using attribute-value pairs (and when not to use them)
  • Recording application usage telemetry events, so that you always know which parts of your application are being used - and which ones are being neglected
  • Storing diagnostic data, to help you with debugging those long and complex calculations and processes
  • Designing tables and fields to avoid hardcoding special values

Armen is the founder and president of J Street Technology, a team of 15 developers, designers and support staff located near Seattle. J Street has designed and built hundreds of custom Access desktop and ASP.NET web applications since 1994, and also supports dozens of Access and web applications that were built by others.

Armen is an Access MVP since 2006, and has spoken at many user groups and conferences around the world. He also regularly guest lectures on requirements discovery and database design at a local college. His other interests include travel, photography, Kauai, backgammon, movies, supporting people with disabilities in Nepal, and driving his 1969 Ford Bronco in the sun.

Watch the recorded video of Advanced Database Design on our YouTube channel