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

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