Excel Applications. 11 Steps for Advanced Users

This e-book shows how to create feature-rich multi-user Excel applications with no SQL or VBA use.

You may repeat the steps and create a lot of applications for your team yourself.

Download PDF Version Download Examples Read Online

11 Steps

Here are eleven steps described in the book:

  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

Example Applications

We will create an applicaiton for this sample table of payments:

Sample table of payments in Excel

Multi-user Database Application

For example, we will create a table in a database and configure an editable Excel table:

Editable Excel table with validation lists

Master-Details in Excel

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

Master-details in Excel

Permission Management

Moreover, you will be able to manage user permissions for your applications in Excel:

Editing database permissions in Excel

And much more...

We will do much more. Take a look.

Download PDF Version Download Examples Read Online

Best regards,

Sergey Vaselenko