Do you need a user-friendly, powerful, and multipurpose program to store, edit and retrieve your data? Do you currently house your data in Excel worksheets as Data Lists? If you answered yes to either of these questions, then Data Manager is the tool to meet all of your data management needs. Data Manager is a powerful Excel add-in which enables you to transform worksheets into tables and create customized forms all within the familiar Excel environment.
Data Manager has a robust set of data validation options to ensure that only valid data is added to your database. With Data Manager you can leverage Excel's numerous database related features for further data analysis and reporting. If you currently use Excel Data Lists to store data, you can quickly and easily convert them into Data Manager tables. For efficient mass mailing, you can use data stored in your Data Manager database as the source for Mail Merge in Word to quickly and easily generate form letters, invoices, mailing labels, envelopes and contact directories along with mass e-mail and fax distributions.
Data Manager provides the user with a number of valuable features. With Data Manager you can create a simple database with a single table or a complex database containing multiples tables (up to 20). You can also designate relationships between tables. In addition to the ability to create multiple tables, you can create multiple customized forms for each table. Each form consists of fields (from a single or multiple tables), customizable command buttons, and or user-defined labels. Data Manager offers a wide range of different types of controls for data entry to choose from including list controls and check boxes.
Along with the typical database related tasks (e.g. saving data), command buttons can be assigned functions that provide you with added capabilities to interact with the database or the Excel environment. For example you could have a command button that opens another form or runs an Excel macro. Users with knowledge of Visual Basic for Applications can create macros for command buttons that read data from a form, process that data and then return data to the form. Data Manager also includes a query reporting tool that allows you to display data that meets a particular criterion.
Here are some key features of "Data Manager for Excel":
· Sorting tables by any combination of fields in ascending or descending order
· Filter data by any combination of fields
· Import data from multiple sources
· Create fields that contain formulas
· Subtotals
· Group data according to specific criteria
· Advanced data selection using Microsoft Query
· Pivot Chart and Tables
· And much more...
Requirements:
· Excel 2000 or above Internet Explorer 4.0 or above
Limitations:
· 45 days trial