Query Manager - Information at your fingertips

In today's competitive economy it essential to gain every edge you can have over your competitors. One of the keys of staying competive is to take advantge of the information that is collected by your business. The problem is much of the data that is a potential source of this valuable information is not organized or summarized in a way that one can glean any meaningful information from it. Query Manager for Excel helps you to make sense out of that data easily and get the information that you want to collect and aggregate quickly.

Summarize, Sort, and Analyze your Small Business or Corporate data 

Query Manager is a powerful reporting solution for corporate and small business users of Microsoft Excel. The task of extracting subsets of data, comparing lists, or sorting information 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 summarizing tools for less than the cost of other query related tools. The add-in allows you to combine and compare information from Microsoft Excel sheets, Microsoft Access, 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.

Powerful Wizard 

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).

Time-Saving Reporting 

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. In addition to having multiple criteria to choose from, you can query and combine results from multiple tables (lists) that share common fields.

Easy Report Updates 

Once the report for your department or management is complete, data updates have never been easier. The Query Manager allows you to save queries including one that can vary based on the value or values you enter into a sheet. The latter feature allows you to create a Microsoft Excel sheet based form that automatically populates part of the form with the results of the query based on the user's input. Queries can be opened and refreshed at any time or repeatedly after a pre-set interval (1 to 32,000 minutes). The query can be refreshed whether or not the workbook containing the query is open, reducing time spent updating a report.

Features  

• Query Wizard - Turns a complicated process of compiling, filtering, and sorting of data into an easy one.
• Multi-Database Support - Extract information from Microsoft Excel, Microsoft Access, or SQL Server databases.
• Data Refresh- One click is all it takes to update that weekly management report. A number of automatic refresh options are also available.
• Data Filtering- The power of extracting the subset of necessary data with time and effort.
• Summarizing and Grouping Data - Has a number of functions available to summarize the data.
• Automatic Sort - Eliminate the need to “massage” the data after the fact by defining the format ahead of time.
• Leveraging Excel - Familiar environment with the powerful data analysis tools such as pivot tables, charts, and functions.

You can go to Screen Prints to see an example that walks you through the steps of creating a new query.

Try Query Manager today 

Download the 45 day trial version for free! Query Manager comes with a comprehensive help file that provides instructions and tips for using the software. Also try Data Manager(part of the Data Management suite) for an end to end data management and reporting solution.