|
Logic Architect enables you to bring Microsoft Excel's speed of development to the creation of systems far beyond the range of normal spreadsheets. It provides a complete development environment which is entirely worksheet based, and normally requires no user VBA programming. It includes a full relational database (multi-user if required) which can be retrieved through functions, browsed, queried and updated entirely within worksheets; a powerful report generator and worksheet-based file processing and program logic tools.Any area in your worksheets can be used to display data from a database file, either as a form (one record at a time) or as an independently scrollable table. Controls are provided to select and browse the data, which may also (optionally) be updated. There is extensive validation, generation of default values, automatic generation of drop-down lists and user help text. Optional automatic formatting can give the worksheet the look and feel of a forms-based system, and windows can be created and sized automatically. Temporary database files can be generated dynamically. In the multi-user version, the data may be simultaneously updated by many users on a network.The report generator produces multi-sheet report sets with user selection and drill-down capability, which can be used by any Excel user even without Logic Architect installed. Reports can include lists, cross-tabs and charts, all of which are regenerated dynamically in response to user selections. Excel formatting can be used.A system's processing is handled through Logic Sheets (worksheets in a predefined format), which provide extensive capabilities to handle and update data from worksheets, database files and other types of file. Data can easily be sorted, merged, joined or cross-tabbed in a variety of ways. Logic is defined using Excel formulae, and processes can be run using buttons or menus, or automatically in response to worksheet events.. Logic Architect - From Excel spreadsheets to systems.... Logic Architect for Microsoft Excel
|
|
 New Downloads of Business / Misc Tools
|
| |
|
|
