Query Manager for Excel 1.2

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 Microsoft Excel add-in saves you time and money with its easy to use wizard and powerful filtering and sorting tools. The add-in allows you to combine and compare information from Microsoft Excel sheets, Microsoft Access, MySQL, and SQL databases, all in an easy to use application, without leaving Excel or having intimate knowledge of SQL. The value of the Query Manager is demonstrated by its powerful wizard, time-saving reporting, and easy data refreshes, all geared to help you produce quality reports without the help of data analysts.

The Query Manager wizard takes the guesswork out of creating queries. You can create customized queries that combine, filter, and sort data in a simple step by step process. The queries also have a number of criteria operators to choose from (e.g. equal to, greater than, and less than), including one option, the Like operator, that provides a large array of combinations of criteria that can be applied to the data. The wizard breaks down the steps to create a query without using a complicated programming language or VBA (Visual Basic for Applications).

Compiling, comparing, and filtering large amounts of data can be a laborious manual task. The Query Manager helps business reporting by reducing complicated procedures into reusable queries by providing an easy way to get and summarize information from data stored in Excel Data Lists, Access databases, and SQL Server databases based on simple or complex conditions (criteria) that you set.

Keywords: Excel, add-in, database, data list, data, query, criteria, analyze, join, table, fields, filters, purchase, list, addin, report, download, parameter query, information, sort, group, queries, filter, subtotals, summarize, MySQL

Click to enlarge

Author:

Datasoft Solutions     Other programs by Datasoft Solutions

Downloads:

65

Size:

2163K

Cost:

$39.95 US

Users Rating:

    Reviews (0)     Write review

Feedback:

Report broken download     Report spyware [?]

License:

Shareware [?]

Operating Systems:

Release Status:

update (2009-02-17)

Recent Changes:

Now provides support for MySQL databases

Supported Languages:

English

Additional Requirements:

Excel 2000 or later Internet Explorer 4.0 or later

Clix-FX XML Flash Menus
Clix-FX Flash XML Menu Templates the easiest way imaginable to create web menus

TCS
Trends management program for Data Base data and servers internal data

Acc Compact
Utility for Microsoft Access database developers and administrators.

DataTron
DataTron is an easy-to-use visual data base

Golf Handicapper
Stores golf scores for multiple players.Calculates handicap, index, net score

Database Assistant
Manipulate data from a variety of databases including Oracle, SQL Server, et al

Link Web Extractor
Extracts from Search Engines or a list of URLs, E-mails, Phones, Fax and more...

DataPoint
Bring your presentations to life with up-to-date information!

csASPUpload
Upload files using a browser and ASP. Multiple files. Can export binary data.

CMS CRM (5 User)
CMS Customer Relationship Management System

ETL-Tools QlikView Connector
Universal SQL Editor
SQLite Developer
Reportizer
Visual Importer ETL Standard
Small Library Organizer Pro
MyDbExplorer
Advanced XLS Converter
FlowHeater
ESF Database Migration Toolkit Standard

DBDocumentor (591 dl.)
Advanced XML Converter (361 dl.)
CDBF for Windows (351 dl.)
Export Table to Excel for SQL Server (336 dl.)
BBAutoHarvest (329 dl.)
Data Exchange Wizard (305 dl.)
Database Oasis (297 dl.)
Visual Importer ETL Standard (295 dl.)
Export Schema to SQL for SQL Server (287 dl.)
FmPro Script Diff (282 dl.)