Introduction to 10 Steps for Database and VBA Developers

Introduction to 10 Steps for Database and VBA Developers

The SaveToDB add-in allows creating database client applications using Microsoft Excel.

Moreover, application features are being configured in a database and extended using SQL.

So, using the add-in is the best choice to create client applications for database developers.

As a VBA developer, you may create applications using the SaveToDB add-in features or just use it as a library.

You get the fast and reliable platform that solves typical deployment and data layer tasks from-the-box.

 

Here are the basic steps to create a complete client application using Microsoft Excel:

  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

 

This book shows how to make these steps using the add-in wizards, SQL codes, and VBA macros.

We start with a new Excel workbook and finish with a ready-to-use application.

 

You have to download and install the SaveToDB add-in, version 7.2 or higher, at www.savetodb.com.

All features described in this book are available in the free SaveToDB Express edition.

 

You may download workbooks, SQL and VBA codes, used in this book, at

https://www.savetodb.com/downloads/10-steps-for-vba-developers.zip

 

This book contains an example database for Microsoft SQL Server.

You may also use Oracle Database, IBM DB2, MySQL, PostgreSQL, and others. The steps remain the same.

 

Best regards,

Sergey Vaselenko

March 20, 2017