Selecting your Query Tool. The query tools discussed in the next several slides represent the most commonly used query tools at Penn State. A Data Warehouse user is free to select any query tool, and is not limited to the ones mentioned. Selecting your Query Tool. What is a “Query Tool”?
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
The query tools discussed in the next several slides represent the most commonly used query tools at Penn State.
A Data Warehouse user is free to select any query tool, and is not limited to the ones mentioned.
There are many query tools to choose from. Below is a listing of what is currently being used on the PC:
Using FileMaker Pro to connect to the data warehouse gives the user different ways of handling the results of a query. You can create reports, charts, or load the information into a database for future use.
Query Tools purchased to connect to the Data Warehouse, must meet the following specifications.
Note: Microsoft Access, Microsoft Excel, Cognos Impromptu,
and Microsoft FoxPro all meet these specs
If you would like to evaluate other query tools, here are some suggestions.
You’ve selected your query tool, now what?
Before you begin to develop queries you need to be familiar with how your query tool works.
Visit the following web site for a current schedule
or call HRDC at: 865-8216
Web Training is available from CAC for:
Visit the following web sites for more information:
For information on ordering any of these software packages visit the Microcomputer Order Center’s web site:
If you have any questions on the information that was covered in this module, suggestions or comments please feel free to send an email to: