Transform Excel into a fully functional database application with this powerful Excel add-in. Data Manager allows you to convert worksheets into tables, conduct queries, and create forms all within the Excel environment. It offers a wide range of data validation options to ensure that only valid data is added to your database. Using customized buttons that can be added to your forms, you can open other forms, run macros, and open hyperlinks to files or internet addresses. Because the software is integrated into Excel, you can take advantage of Excel's numerous database related features to analyze your data. For those who currently store data in Excel Data Lists, Data Manager enables you to quickly and easily convert those lists into Data Manager tables. If you have Microsoft Word, you can use its Mail Merge, as well as Data Manager's Send Data capabilities, to create form letters, mailing labels, envelopes, directories, e-mails and fax distributions with the data from your Data Manager database.
Features:
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.
Query Manager for Excel 1.0
Summarize and analyze your data with this powerful Excel addin. Query Manager is a powerful reporting solution for corporate and small business users of Microsoft Excel. The task of extracting subsets of data, summarizing data, comparing lists, or analyzing data is simplified with the Query Manager software. This ...
DataLinks: xSeries 1.5
Excel based business query, easy data navigation and biz wizards like de-dupe. DataLinks query tool allows business and IT users to quickly and easily access their data. No ODBC, writes SQL, easiest UI on the market today with simple preview data review. Data direct to Excel or XML on the fly and easily create live links. Added ...
ES DB Access 1.0
Excel Add-in that allows you to query any ODBC Data Source from inside Excel. This add-in creates a new function that allows you to directly query any ODBC data source on the machine and displays the results in Excel. ...
Excel Server 2005 Enterprise Edition v3.9.1
Excel Server is an easy tool of MS Excel networked. Excel Server 2005 is an integral information platform built on Excel, MS SQL Server, and Windows OS. It is an easy tool of MS Excel networked and EAI. Its features are:
1. Data Fetcher allow users to freely use or query all the authorized data or records ...
XL-DBQuery 1.1.0
XL-DBQuery, an Add-In for Microsoft Excel and Alternative to MS Query. XL-DBQuery is a powerful add-in for Microsoft Excel that makes it easy to perform data analysis and reporting. Unlike Excel's built-in "MS Query" function, XL-DBQuery offers an intuitive query syntax that lets users build complex queries, without having ...
Excel Server 2005 Standard Edition v3.9.1
Excel Server is an easy tool of MS Excel networked. Excel Server 2005 is an integral information platform built on Excel, MS SQL Server, and Windows OS. It is an easy tool of MS Excel networked and EAI. Its features are:
1. Data Fetcher allow users to freely use or query all the authorized data or records ...
SQL Excel 1.01
Freeware Excel Add-In - Simplify data retrieval from SQL Server, Oracle, Sybase. The points below gives you a brief overview of the SQL Excel Add-in.
- SQL Excel adds easy database access to MS Excel. SQL Excel has a very easy to use interface and you will only take minutes to set up and start to use. After install an Extra ...
Pivot Table Helper 1.0
Pivot Table Helper makes working with pivot tables comfortable and fast. Pivot Table Helper adds its own toolbar to Excel with the following buttons:
- Select page fields area of the current pivot table
- Select header of the current pivot table
- ...
Merge Tables Wizard for Microsoft Excel 1.6.9
Lookup and copy matching data from one Excel worksheet to another. With this handy plugin you can easily lookup and copy matching data from one Excel table to another. Two tables can be located in the same or two different Microsoft Excel files. The intuitive and user-friendly interface of the wizard makes the join process ...
CDXStreamer 2.0.0.1707
CDXStreamer analyzes census, zip-code and stock data in Microsoft Excel CDXStreamer imports census, zip-code, stock data and more into Microsoft Excel with a click of your mouse. No programming, complex database queries or awkward cut and paste is required. Using an intuitive, patented interface, you simply specify the data ...
