Private: cr-mdaccess

MDAccess

MDAccess is a Charting and Reporting program that displays data in Chart or Grid Report form from Sql Data Sources. MDAccess is the Windows version of Chart It. MDAccess provides easy access, display, and manipulation of selected subsets of that data in a flexible and easy to use manner.

MDAccess reports from either:
Sql Tables and Views
or
MDA databases made from Sql Tables and Views

Within MDAccess subsets of data can easily be selected and rotated by the different Dimensions to display those subsets of data in various Orientations, Plot Types, or Calculations. MDAccess reports from Sql Tables or Views directly, or indirectly thru intermediate MDA database made from those Sql Tables or Views. The source Sql Tables or Views for either direct reporting, or indirect reporting is listed below.

Sql Tables and Views MDAccess reports directly from:

Sql Server Tables or Views
MSAccess Tables
Excel Spreadsheets

Sql Tables and Views MDAccess reports indirectly from:

Sql Server Tables or Views
MSAccess Tables
Excel Spreadsheets
Oracle Databases

MDAccess can report from any of the Sql Tables or View listed above, or it can report from intermediate MDA Databases made from those Sql Tables or Views. Reporting from MDA Databases provides additional functionality to the MDAccess Charts and Reports.

MDA Databases are a type of OLAP Database, which are discussed in Wikipedia under: OLAP Cubes.
MDA Databases can be Constructed by MDAccess, under the Database menu, or when a new Plot is being defined.

The Source Data Table or View can be any query or spreadsheet of data so long as there are columns with character data that can be used to represent the dimensions, and column(s) with numeric data to represent the measure values.

After the intermediate MDA Database is built from the Source Data, it’s available for repeated use in MDAccess.