A Charting/Reporting program that reads data from Multi-Dimensional Access/Sql Server databases
MDA (Multi-Dimensional) Access/Sql Server databases can be constructed from simple Excel spreadsheets that have several columns, at least one of which is numeric. They can also be built from data queried from a Sql database that results in multiple columns with at least one numeric column. The option to build these databases is available in MDAccess under the 'Database' menu item.
Features offered by MDAccess include...
1. Flexible Element Selector
- allows for easy manipulation of available database elements with various searching, sorting, sub setting capabilities.
2. Seamless Plot Type Conversion
- allows for easy change of one plot type to another.
3. Easy Axis Rotation
- allows for easy data view alteration.
4. Calculations
- allows for minor algebraic calculations including subtotaling of elements by attributes or individual selections, which combined with the MDA Database export function, allow for easy access to pre-calculated values.
5. Change History
- allows for easy Undo and Redo of alterations.
6. Multiple Document Forms
- allows for multiple forms showing multiple plots from multiple databases.
7. Multiple Plots per Form
- allows for multiple plots to be displayed in same form.
8. Multi-Page Plots
- allows for easy arrangement of multiple pages of plots within a plot.
9. Plot and Plot Section Positioning as well as Plot and Plot Section Drag and Drop
10. Easy Plot Form Definiton Save and Restore
11. Excel Export Functionality
- provides for easy export of data to Excel.
12. Editable MDA Databases by Access or Sql Server Management Studio
13. MDA Database Builds from External Data
- allows data in Excel, Oracle, Sql Server, or Access databases to be used as input to build MDA Databases.
14. MDA Database Builds from Existing MDA Databases
- allows data to be subset or add Elements to MDA Databases.
15. MDA Database Direct Editing
- to build MDA Databases from Scratch or alter existing MDA Database Values.
16. Context Sensitive Help
17. Print Preview
18. Annotations
- easily positioned and arranged.
19. Annotations with Background Pictures
20. Pictures
- easily added and positioned.
21. Same Scaling across Multiple Plot Pages
- optionally allows auto-scaling across any number of pages of plots.
22. Text Group Formatting
- allows various fonts, colors, and appearance features to be added to groups of function related text.
23. Plot Sections with Coloration or Background Pictures
24. Dynamic Plot Section, Plot Piece Tooltips
- includes tabular as well as plot section tooltips.
25. Statistical Lines