Excel Applications. 10 Steps for Database and VBA Developers

www.savetodb.com

© 2017-2023 Sergey Vaselenko

Contents
Introduction
01. Example Application
02. Excel as Table Editor
03. SaveToDB Framework Installer
04. Configuration Workbook
05. Tables with Foreign Keys
06. Query Parameters
07. Column Name Translation
08. Object Name Translation
09. Table Views
10. Table Format Wizard
11. Framework Query List
12. Configuring Views
13. Configuring Stored Procedures
14. Configuring Saving Changes
15. Cursors
16. Form Fields
17. Master-Details
18. Detail Windows and Task Panes
19. Context Menus
20. Actions Menus
21. Creating and Removing Apps
Conclusion
Appendix A. Database Source Code

Excel Applications. 10 Steps for Database and VBA Developers

This e-book shows how to create Excel applications with the SaveToDB add-in and VBA.

As a VBA developer, you can get great benefits and create larger applications in less time.

Download PDF Version Download Examples

Contents

Introduction
Chapter 1. Example Application
Chapter 2. Excel as Table Editor
Chapter 3. SaveToDB Framework Installer
Chapter 4. Configuration Workbook
Chapter 5. Tables with Foreign Keys
Chapter 6. Query Parameters
Chapter 7. Column Name Translation
Chapter 8. Object Name Translation
Chapter 9. Table Views
Chapter 10. Table Format Wizard
Chapter 11. Framework Query List
Chapter 12. Configuring Views
Chapter 13. Configuring Stored Procedures
Chapter 14. Configuring Saving Changes
Chapter 15. Cursors
Chapter 16. Form Fields
Chapter 17. Master-Details
Chapter 18. Detail Windows and Task Panes
Chapter 19. Context Menus
Chapter 20. Actions Menus
Chapter 21. Creating and Removing Applications
Conclusion
Appendix A. Database Source Code

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.