Lesson 1: Starting a Tools for Visual Basic Project

• How to start a new Tools for Visual Basic project.
• Understand the use of the Visual Basic Project Template

Lesson 2: Creating a Program with One 'Normal' Level

• How to add a "Normal Level" to a Tools for Visual Basic Program.
• Understand the concept of levels.
• Learn how a "Normal Level" is implemented.
• Learn the Microsoft Solomon API calls needed to register your program with the Microsoft Solomon Kernel.
• Explore data navigation provided by the Microsoft Solomon Kernel

Lesson 3: Adding a New Table

• How to add a new table to the Microsoft Solomon database.
• Learn the Required Database Objects for adding a new table.
• Understand Naming Requirements for Tables and Indexes.
• Learn the Structure for Stored Procedures used by the Microsoft Solomon Kernel

Lesson 4: Adding a Detail Level

• Learn what a "detail" level is and how it works.
• Implement a "detail" level, using the SAFGrid control

Lesson 5: Adding a Possible Values Lookup

• Learn the properties required for a possible values (F3) lookup.
• How to format the Possible Values window.
• How to Use the Possible Values Import program

Lesson 6: Adding a Second Table to a Detail Level

• How to add a secondary table to a detail level.
• Creating an SQL Statement that Joins the tables in a query.
• How to populate the secondary buffer when a value changes

Lesson 7: Starting a New Project

• How to start a new Tools for Visual Basic project .
• Understand the use of the Visual Basic Project Template

Lesson 8: Adding a Detail Level

• Add a detail level to a Tools for Visual Basic project when it is the first level (LEVEL0).
• Implement an indexed spreadsheet

Lesson 9: Adding an Unbound Non-String Control

• Learn how the Microsoft Solomon Kernel links controls to buffer variables.
• Learn how to add a Microsoft Solomon custom data control that is not attached to a field from any tables in the database.
• Learn to use the Microsoft Solomon Code Inspector utility

Lesson 10: Adding an Unbound String Control

• Learn how to add a Microsoft Solomon custom data control that displays a string value that is not attached to any fields from tables in the database.
• Learn how to implement an unbound control in a spreadsheet.
• Learn why a user defined type (UDT) is required when the unbound control holds a string value

Lesson 11: Manipulating Toolbar Buttons

• Add a control to the project from the Visual Basic toolbar.
• Add program code to implement the unbound control.
• Create an new User Defined Type (UDT).

Lesson 12: Working With Memory Arrays

• Learn how memory arrays are accessed in the program.
• Learn how memory arrays are created.
• Learn Microsoft Solomon Kernel API calls to navigate memory arrays.
• Learn how to manipulate and update data in memory arrays

Lesson 13: Updating Rows in the Database

• Learn how to retrieve and update rows in the database, using Microsoft Solomon Kernel API calls.
• Explore the Microsoft Solomon Kernel API calls for performing floating point math.
• Learn Microsoft Solomon Kernel API calls for database manipulation.
• Learn Microsoft Solomon Kernel API calls Start and End a database transaction

Lesson 14: Using the Process Status Form

• Learn how display a status window while a process is running.
• Learn to log events and errors during a process

Lesson 15: Giving Users Access

• Learn how to properly name a Tools for Visual Basic program.
• Learn how to make the executable program.
• Learn how to add programs and reports to the Classic Microsoft Solomon menu.
• Learn how to add program and reports to the new Microsoft Solomon Menu dashboard.
• Learn How to implement security in a Tools for Visual Basic program

Lesson 16: Printing Reports

• Learn how reports are printed in Microsoft Solomon.
• Learn How to add a new report Microsoft Solomon's report control table.
• Explore the processing logic of the Report Options Interpreter program (ROI.EXE).
• Learn how to print a report from within a Tools for Visual Basic program

Lesson 17: Working with the Microsoft Solomon Object Model

• Learn how to instantiate and use the Microsoft Solomon Common Object Model (COM).
• Learn how to add "drill down" capability from a Tools for Visual Basic Tools program to another Tools for Visual Basic program.
• Explore manipulation of controls in the instantiated program