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.
| Updated: | 2007-06-16 |
| License: | Free |
| Publisher: | Logic Software and Systems Limited |
| Size: | 4.8 Mb |
| Require: | Microsoft Excel ( 2000 - 2007 ) |
| System: | Win98, WinME, WinXP |
| Language: | English |
|
|||
| Close |