ms query Office Suites and Tools

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 to master Boolean algebra.

Tags: excel, data, ms query, query builder, sql, queries, data analyst, data analysis

Data Manager allows you to convert worksheets into tables, conduct queries, and create forms all within Excel. It offers a 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, open hyperlinks, and send data to Microsoft Word. Current Excel Data List users can easily convert those lists into Data Manager tables.

Tags: Excel, Database, Spreadsheet, Data List, Relational, Add-in, Field, Validation, Query, data management

DataLinks for Access only query tool allows business and IT users to quickly and easily access their Access databases. 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. Additional data sources available at www.bidata.net. Excel based data access, integration, query, plus dashboards and reporting.

Tags: Excel Data Access, Query, Dashboards, Reporting

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.

Tags: Excel, SQL, Database, Query