Q+E for Microsoft Excel User's Guide [antikvár]

m Q+E™ is an easy-to-use yet powerful database application that allows you to manipulate and update database files from a variety of database systems. These include dBASE, Microsoft® SQL Server, Oracle, and OS/2 Extended Edition, as well as text files and Microsoft® Excel files containing a defined database. Q+E makes working with your database files a breeze. By using Q+E's intuitíve menu structure, the database novice, as well as the expert, can get right to work creating reports and updating records. And, since Q+E runs under Microsoft Windows or OS/2, you can take full advantage of the windows environment. You can open several database files at once, and copy data from one to another or to a different application. If you copy data to Microsoft Excel, or any other application that supports Dynamic Data Exchange (DDE), you can link the data to Q+E so that the data is updated automatically whenever the database information changes. When you open a database file in Q+E, its records are displayed in a Query window. In this window, you can construct a question, or query, to get specific information from your database files. You can sort, select, and formát records, as well as make calculations to analyze your data. All your command choices can be saved in a query file, so you can quickly execute them again to reproduce the same view with the most up-to-date information. When you want to create a report, you simply print the results displayed in the Query window. Q+E alsó provides tools to edit and maintain your database files. You can update fields, and add and delete records using the custom view you have created. You can alsó create new database files from scratch, or modify or delete the field definitions in existing ones. The Q+E for Microsoft Excel User's Guide is organized to make Q+E easy to learn, as well as to provide a convenient reference guide. ¦ Part I, "Getting Started," explains how to install and start Q+E, and how to open database files and look at your data. ¦ Part II, "Querying Database Files," explains how to define queries to get specific information from your database files, and how to formát, save, and print the results. ¦ Part III, "Maintaining Database Files," explains how to update, add, and delete records, and how to create new database files and modify or delete existing ones.