Course Description
This course features an integrated relationship between Excel, Access and VBA. The Microsoft Office/VBA working environment is used to establish a platform for performing engineering data and information storage, maintenance, and retrieval. Excel is used for small flat files and Access is used in a supporting role for relational and large tables. This approach leads to methodologies, which are applicable to any data intensive engineering project where Excel is used for overall project command and control. Using this approach, Access plays a supporting role for engineering information storage, maintenance, validation and retrieval. The elements of Visual Basic Programming are used throughout the course. Graphical User Interfaces are used to modularize and control inputs using User forms and Active X controls. This course emphasizes the use of ADO (ActiveX Data Objects), which is expected to replace DAO (Data Access Objects) due to its simpler object model and superior flexibility in the syntax for updating field values in a record set. Discussion of recordsets; exporting record sets to excel via VBA; using JET to run queries; use of domain functions (DLookup, DSum, Dcount) to run basic queries (3-days-McDaniel, Bodnar)

Instructor
Tom R. Mincer, Ph.D., Founder and President of SpreadsheetWorld, Inc. (www.spreadsheetworld.com) and Professor of Mechanical Engineering, California State University, Northridge (CSUN). Dr. Mincer is widely recognized as an early pioneer in the extensive use of Excel, VBA and FORTRAN DLLs in engineering. In 1985, he initiated extensive use of Excel into the curriculum at CSUN by integrating it into the courses on systems design, computational methods and computer-aided-engineering. For the past 15 years he has worked extensively in the areas of systems design, simulation and optimization using the Excel Structured Spreadsheet environment. In 1995, he extended his efforts to industry by launching his popular hands-on workshop on Spreadsheet Aided Engineering, which has now been taught 210 times to engineers from over 100 companies worldwide. Alumni from these workshops exceed 3,000 engineers. This workshop is offered on a regular basis at over 50 companies. Dr. Mincer founded SpreadsheetWorld to extend the training services to include development of new and commercialization of existing Excel/VBA Toolboxes, and services to enhance the implementation of the best practices and methods taught in his workshops.

Enroll in this course at Professional Education International