DAAUG Board Member Ken Mulvihill will show us how easy it is to work with external data as it’s imported into Microsoft Access. Look for examples using the built-in Import/Export capabilities, the FileDialog method to find and save your external files, and finally, how to manipulate your external data with VBA prior to a final import into your data tables. Don’t miss this presentation if you work with data!
After leaving the industrial distribution industry at age 59, Ken began to re-invent himself as a data analyst. He received an AAS in Database Administration from Red Rocks Community College in 2011. New Data Design LLC was the culmination of 30 plus years of business experience with a new set of tools and technologies. The goals are still the same – save the client time, money, or make their job easier. After 2-1/2 years with Red Rocks Community College writing automation applications utilizing Access, Excel and SQL Server for data collection, analysis, and compliance reporting, Ken is now the Access Database Developer for Void Form Products in Englewood, CO.