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.

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:

Table with Foreagn Keys

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

Master-Details in Excel

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

And much more...

We will do much more. Take a look.

Best regards,

Sergey Vaselenko

Share This