Software Search, Categories and Specials
Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download

 

AnalyserXL - Download

 

DownloaderXL - Download

 

Smart VBA - Download

 

TraderXL - Download

You can interact with the database directly through worksheets to set up data or to provide a display of results.

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

 

Download Demo

Worksheet Functions

  • Database data can be retrieved directly through Logic Architect functions.
  • Individual records or summaries can be obtained, with data selection.
  • Existing worksheets using functions such as VLOOKUP, SUMIF or DSUM can be easily converted.

Data Display

  • Data can be displayed either as a table, or one record at a time using the worksheet as a form.
  • There is full control over the choice of fields, record sequence, layout and format of the data on the worksheet.
  • Data can be placed anywhere within any worksheet which can contain whatever other information is required.
  • Controls are provided to browse through the data.
  • For tabular data, if there are more records to display than space provided, a scrollbar is placed beside the table.

Updating

  • Data may be read-only or can be updated, and standard formats are available for each of these.
  • Records can also be inserted or deleted.
  • Formats can be changed dynamically, so fields may be displayed/updated depending on values in other fields.
  • There is extensive validation both on individual data fields and on the relationship between database files.

Dropdown Lists

  • Where a data field is based on values from a second database file, a dropdown list may be automatically generated for the field values, and may be based on any fields from the second file.
  • Dropdown lists can also be generated for use anywhere in a worksheet, and contents can be selected based on other worksheet values.

Selection

  • Data may be selected either directly by the user or based on values on a worksheet.
  • Where multiple linked database files are displayed, values in one file may be automatically based on the current record in a second file.

Windows

  • Worksheets can be shown in windows, either singly (with or without sheet tabs) or popup windows may be generated.
  • Windows are sized automatically and scrollbars included only if needed.

The display of data is illustrated below:

When Logic Architect is started, selected fields from the database file are displayed. The Logic Architect command bar is docked at the top of the screen, and unnecessary screen elements have been hidden. This example shows default formats. Only sufficient records to fill the defined space are displayed, and controls are provided to browse the remaining records.

More information | Logic Architect Start

Worksheets | Reports | Logic Sheets | Database | Development Tools

Download Demo | Developers Site | Logic Architect   $125.95 Secure Payment Options | Special! Free Choice of Complete Excel Training Course and Excel Add-ins Collection on all purchases. Purchase MUST be made via this site. Send payment proof to [email protected].

See Also: Excel Add-ins Index


Instant Download and Money Back Guarantee on Most Software

Try out: Analyzer XL | Downloader XL | Smart VBA | Trader XL Pro (best value) | ConsoXL | MergeXL | O2OLAP for Excel | MORE>>

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft