Vision Word is an intelligent, intuitive add-in for Microsoft Word that provides a fast, easy and more adaptable method to interact with your SunSystems database. Vision Word enhances the already extensive functionality of Microsoft Word, enabling powerful presentation and reporting. Vision Word provides a dynamic link that allows current information to be incorporated in Microsoft Word from multiple SunSystems tables into a single document.
With its flexibility and ease-of-use Vision Word allows non-technical and non-accounting staff to effectively analyze SunSystems data, providing enhanced analytical power and assisting the decision-making process. Data from other applications may be combined with SunSystems data within a single report.
• Vision Word optimizes queries and presents information in a simplified view, enabling you to extract data from tables within databases.
• Vision Word facilitates the easy integration of data into monthly, management or statutory reports with highly formatted narrative content.
• Vision Word incorporates built-in calculation logic enabling you to define your own reports more easily. Dynamic links extract information from multiple databases to a single document.
A Dynamic Link
Vision Word provides a dynamic link, by allowing information to be extracted from multiple databases to a single document. With its flexibility and ease-of-use, Vision Word allows non-technical staff to effectively analyze data from within a familiar word processing environment. Vision Word is an add-in that appears as an additional menu item on your Word menu.
Accessing Data Within Word
Vision Word optimizes queries and presents information in a simplified view, enabling you to extract data from tables within your databases. Vision Word facilitates the easy integration of data into monthly reports, management reports, statutory reports and other documents allowing you to combine information from your database with highly formatted narrative content.
Comprehensive Reporting and Analysis
With Vision Word, information can be extracted to a Microsoft Word document from multiple database tables. By incorporating an understanding of the relationship between database tables, you simply define a parent table to display related data items and dependent tables for filtering and outputting to Word. This use of Word allows for more comprehensive and wider ranging analysis and reporting.
Perform Multi-Dimensional Analysis
Use Cube Analysis to perform multidimensional analysis and drill down on live relational data. Vision enables any query to be output as a cube. This provides the capability to slice and dice data held in relational databases. Analyze a report, cell or group of cells by performing ad hoc drills and save cubes for offline browsing.
Vision Mail Merge
Merge is an implementation of Microsoft Word’s Mail Merge that works with Vision Word. It allows you to specify a data source for the main merge document, insert, delete or move Vision Merge and Vision Command fields, setup the main document, and execute a Merge. Vision Mail Merge supports Equation Editor Fields, which can be calculated each time a record is extracted, using the recalculate command fields.
SecureE Access and Control
Vision provides security features to ensure that only authorized users can access sensitive data. User privileges assigned to users in your database are fully respected in Vision. The user profile in Vision can match the same profile in your database. The information a user can access will depend on the privileges assigned to that user in your database. Further data and access restrictions can be applied within Vision if required.