Query Tools Microsoft Excel Excel will allow you to connect to the data warehouse by selecting 'Get External Data' from the 'Data' pull down menu. Excel launches Microsoft Query which is where you will create your query. Once your query is complete and the records you want displayed, select 'Return Data To Microsoft Excel' from the 'File' pull-down menu and the results of your query will be loaded into Excel. When your results have been returned to Microsoft Excel you can further manipulate your query results, print a report or create charts. Visit the Microsoft Product web site for more information on Excel. Information on purchasing Microsoft Excel is available from Penn State's Computer Store. Microsoft Query Microsoft Query is an application that comes packaged with the Microsoft Office suite of software and can be used to access the data warehouse. Microsoft Query will allow you to develop a query and analyze the results, but if you need to print or save the results you'll need to pull the information into Excel. Microsoft Query does not have any printing capabilities. Microsoft Access Using Microsoft Access 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. To connect to the data warehouse with Access select 'Attach Table' from the 'File' pull-down menu. Select your data source, and enter your login information and you should be connected to the data warehouse. Visit the Microsoft Product web site for more information on Access. Information on purchasing Microsoft Access is available from Penn State's Computer Store. Microsoft Visual FoxPro Visual FoxPro is a relational database system that allows you to connect to the data warehouse. FoxPro allows you to create forms, queries and reports with the visual design tools and wizards. You can organize data, define database rules, as well as build full-featured applications by providing an integrated development environment with powerful object-oriented programming tools, client/server capabilities and OLE support. Visit the Microsoft Product web site on Visual FoxPro or visit the FoxPro Users' Web page for more information. Information on purchasing Microsoft Access is available from Penn State's Computer Store. Impromptu Impromptu is a Interactive Reporting tool that can be used to access the data warehouse. Impromptu will allow you to create sophisticated reports, queries and charts. Visit the Cognos web site for more information about Impromptu. FileMaker Pro Filemaker Pro has been approved for use with the DataWarehouse! AIS will be coordinating training sessions, a Filemaker Pro volume license purchase and ODBC SequeLink Client purchases.  For further information on using Filemaker Pro with the Data Warehouse, please contact the AIS Support Center.

Printer friendly view