Course Description Course covering the mechanics involved with interfacing with databases from both Access and Excel. Topics covered include the following: Creating database applications with Microsoft Access Using data forms with Access data tables Performing queries VBA overview Data access and controlling Microsoft Access with VBA ActiveX/Userform overview Interfacing with other databases (Excel, Oracle, etc. - SQL language overview) All of the similar things in Tom's brochure for this course Prerequisite: a working knowledge of Access and Excel (5-days)
Instructor Tom R. Mincer, Ph.D., CEO, SpreadsheetWorld Inc. and Professor of Mechanical Engineering, California State University, Northridge (CSUN). Dr. Mincer initiated the use of EXCEL spreadsheets in the under-graduate and graduate curriculum at CSUN by integrating it into the courses on systems design, computational methods and computer-aided-engineering. For the past 10 years he has worked extensively in the areas of systems design, simulation and optimization using the Excel structured spreadsheet environment. He has taught the SpreadsheetWorld 5-day seminar on Spreadsheet Aided Engineering over 80 times to 1,200 engineers including on-sites at Goodyear Tire, NASA Goddard Space Flight Center, NASA Glenn Research Center, NASA Johnson Space Center, Jet Propulsion Lab, TRW, General Motors, Delco, Delphi, Naval Weapons Center, Naval Warfare Center, L3 Ocean Systems, Edwards Air Force Base Rocket Research Lab, Hamilton Sundstrand, L.A. Water District, Lockheed Martin, Pratt & Whitney and Honda R&D. Enroll in this course at Professional Education International