Session Details

Session Details2019-01-07T06:21:08+00:00

Building a Full CRUD Application in Excel with VBA and SQL Integration

Presented by: Derek Mulhausen

In this talk, we will build a full application from scratch in Excel to store customer discounts in Excel. We will start with recording a macro to quickly prototype some of our actions and then dig into the underlying code to polish the formatting and produce a product that can be put into production. Through this process we will link to a SQL Express database and learn how to programmatically build form controls and place them on a worksheet. Prerequisites: Basic knowledge of SQL is recommended but not required. Excel with VBA(Windows is best as VBA for Excel on a Mac has some limitations) SQL Server Express

Room: Tags: Design (UI/UX/CSS), Functional ProgrammingLevel: Intermediate