Introduction to 11 Steps for Advanced Users

Introduction to 11 Steps for Advanced Users

Microsoft Excel is an amazing product.

It brings freedom to business users as allows getting data from anywhere and consume the data in any way.

If you like Microsoft Excel, you definitely have to try the SaveToDB add-in for Microsoft Excel.

The add-in allows database and VBA professionals to create complex corporate applications using Excel.

Moreover, the add-in allows business users to create Excel applications with no SQL or VBA use.

 

In this book, we will create an application and learn 11 steps that you may repeat for your applications:

  1. Publish tables to a database
  2. Configure query parameters
  3. Configure formats and table views
  4. Configure validation lists
  5. Add cursors and form fields
  6. Configure detail tables, windows, and task panes
  7. Configure context and action menus
  8. Add image URLs
  9. Configure LastModified and UserName fields
  10. Integrate with other applications
  11. Manage permissions

 

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

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

 

You may download the initial workbook, the final application, and required SQL codes at

https://www.savetodb.com/downloads/11-steps-for-advanced-users.zip

 

This book contains an example database for Microsoft SQL Server.

You may also use Oracle Database, IBM DB2, MySQL, and other supported databases. The steps remain the same.

 

Best regards,

Sergey Vaselenko

March 20, 2017