Excel Applications. 10 Steps for Database Developers

This e-book shows how to create feature-rich database client applications using Microsoft Excel.

As a database developer, you may create such applications with the SaveToDB add-in using SQL knowledge only.

Download PDF Version Download Examples Read Online

10 Steps

Here are ten steps described in the book:

  1. Connect to tables, views, and stored procedures
  2. Configure validation lists
  3. Configure ribbon parameters
  4. Translate field, parameter, and object names
  5. Configure formats, formulas, and table views
  6. Configure saving changes
  7. Add cursors and form fields
  8. Create master-detail forms
  9. Configure detail windows and task panes
  10. Configure context and action menus

Example Database

We will create an applicaiton for this sample database:

Example database

Table with Foreagn Keys

For example, we will configure an Excel table to edit the underlying table with foreagn keys.

Excel form for editing tables with foreagn keys

Master-Details in Excel

Also, we will implement the master-detail form with cursors and editable fields in Excel:

Master-details in Excel

And much more...

We will do much more. Take a look.

Download PDF Version Download Examples Read Online

Best regards,

Sergey Vaselenko