Better VBA: Access, Tools, Code Quality

Microsoft Access DevCon 2017, Vienna, Austria

FMS President Luke Chung was a presenter at the Microsoft Access DevCon 2017 in Vienna, Austria in early April.

Before giving two conference presentations, he sat down and spoke with Philipp Stiefel of codekabinett.com of Germany discussing VBA development.

They talked about:

  • VBA Best Practices
  • How end-users migrate from Excel to Access, then learn how to code
  • Why people are hesitant to purchase third party products and how FMS overcomes that by showcasing the value we offer
  • Using tools like Total Access Analyzer to catch errors before shipping and learning best practices
  • Using the module code in Total Visual SourceBook to address problems we've already solved so you can focus on the unique issues in your applications
  • The value of creating consistent, quality code, how to improve code for developers of all backgrounds
  • Being in constant "growth" mode to look for ways to become a better developer

MSDN Channel 9/ARCast.TV

Filmed at Microsoft Offices, Reston, Virginia

Microsoft Access to SQL ServerMicrosoft's Dr. Zhiming Xue interviews Luke Chung on dealing with Microsoft Access Database solutions and the challenges project teams face when migrating them to more scalable platforms.

Luke Chung, founder and president of FMS, shares his view on Microsoft Access database solutions. (22 minutes)

Microsoft Worldwide Partner Conference

Washington, DC Convention Center (August 2010)

creating growth in cloud computingHere's a video recorded by Voices for Innovation (VFI) at the Microsoft Worldwide Partner Conference regarding cloud computing with FMS President Luke Chung.

Watch the video to see how the Cloud and IT innovation have driven growth and improved the businesses of Microsoft Partners.


Tech EDMicrosoft Tech Ed Conference 2009

Los Angeles Convention Center (May 2009)

Video: Migrating Your Data Tier to Microsoft SQL Server: Strategies for SurvivalThis panel explores the different reasons and approaches for migrating applications to Microsoft SQL Server. In addition to moving the data to SQL Server, ideas are presented for transforming applications to offer additional features while watching budgets.

Examples are provided for migrating data from Oracle, Access, and Excel to SQL Server. That's the easy part. Discussions also cover the challenges of maintaining and monitoring the new database, whether a database administrator is needed, and the life cycle of a SQL Server application.

Speakers: Luke Chung, Richard Campbell, Stephen Forte, and Armen Stein, emceed by Mary Chipman. (43 minutes)

Video: The World Turned Upside Down: Development Strategies for Lean Times Are you a developer wondering what to do in these dire economic times? Or are you in charge of a development team facing tighter budgets and higher risk? Not sure what to do or consider to protect your job or career? Listen to this panel for their insight and experience.

During tough economic times, development teams tend to get smaller while business requirements get larger in an effort to do more with less. The panelists share their insights and experiences gleaned from years of surviving economic ups and downs.

Hear the panel discussion among Luke Chung, Stephen Forte, Kent Alstad, Armen Stein, Rockford Lhotka, and Paul Sheriff, emceed by Mary Chipman. (51 minutes).

Video: Let's Talk about Software Consulting as a BusinessThinking of creating your own consulting business? Trying to grow your existing consulting business?

Hear the panel discussion of the experiences of Luke Chung, Paul Sheriff, and Armen Stein in founding and running their consulting firms over the past two decades. (54 minutes)

Video: Let's Talk about Software Consulting as a BusinessFMS has survived many business and technology cycles since its founding in 1986. Microsoft's Mary Chipman interviews Luke Chung about the story of FMS, how its survived these 23 years, and how it has served its wide range of customers.

Luke discusses the three groups within FMS:

Learn more about FMS, our history, and our successes over the years. Hear about our challenges and philosophies, and how we've helped our customers maximize their IT investments and anticipate the evolution of their applications. (28 minutes)


Microsoft Tech*Ed Conference 2008

Orlando, Florida (June 3, 2008)

Are we there yet? Successfully navigating the bumpy road from Access to SQL Server

Hosted by Microsoft's Mary Chipman, the panel discusses the challenges and approaches of migrating Microsoft Access applications to SQL Server. Learn about situations where Access is appropriate, and when they need to upsize to SQL Server. (49 minutes)


Additional Resources

Additional Resources

 

 

Thank you! Thank you! I just finished reading this document, which was part of a link in the recent Buzz newsletter. I have printed it for others to read, especially those skeptical on the powers of Access and its capabilities.

Darren D.


View all FMS products for Microsoft Access All Our Microsoft Access Products

 

 

Free Product Catalog from FMS