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.

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:

Multi-user Database Application

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

Master-Details in Excel

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

Permission Management

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

And much more...

We will do much more. Take a look.

Best regards,

Sergey Vaselenko

Share This