What's New In Q&A Version 4.0 ÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ Increased Database Power ÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ POST -Post data to multiple fields in external databases. Editable Table View - Edit records while in table view. View every field in the database using horizontal scroll for quick and easy editing. Direct Link to SQL - Link directly to an SQL database for easy querying and reporting on SQL data. Retrieve the exact data you need and then use Q&A to manipulate the data. Servers supported are Oracle Server and Gupta SQLBase. dBASE III/IV XLOOKUP - Retrieve information directly from a dBASE file without importing. XLOOKUP to Multiple Fields - Perform an XLOOKUP to multiple fields within a database, eliminating the need for repetitive programming statements. Query Programming - Query data using programming functions like @DATE, @TIME, and @XLOOKUP to automate queries. Saved Specs - Save retrieve, sort, merge, update, import, export, and table view specs, eliminating the need to retype an often used or complex spec. Field Templates - Create pre-defined field templates for information such as phone numbers and social security numbers for fast and consistent data entry. Field Editor - A pop-up window with word processing capabilities allows you to easily enter long data values up to 32K (16 pages) per field. Field Names - Define your own field names and attach them to field labels for more readable programming. Print Text Enhancements - Create professional looking invoices and order forms using fonts and other text enhancements. Print Preview - Preview your records on screen before printing for accurate free form and coordinate output. Case Formatting - Format text for forced lowercase and initial capitalization, in addition to Q&A's support for forced uppercase text. Q & A Application Note Rev. 6/92 #2001 Page 1 of 6 Delete Duplicate Records - Delete duplicate records in a database. Field Restriction List - Fill a field by selecting from a pop-up list of values from the Restrict Spec to ensure accurate data entry. Additional Import/Export Conversions: dBASE IV Import/Export Paradox 2.0/3.0/3.5 Import/Export Lotus 1-2-3 2.2 Import Professional File 2.0 Import ÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ All-New Application Programming Tools ÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ Custom Application Menus - Customize your database application by creating custom menus specific to your database. Program Editor - Create complex programming statements using a 32K pop-up window with word processing functionality, including search and replace, move, insert and spell check. Concurrent Custom Help - Enter data into fields concurrently as help is displayed. Menu and Macro Encoder - Protect custom application menus and macros from user changes by encoding the file. Field Navigation - Separate field navigation statements like GOTO's from your core programming statements. Run Macros From a List - Run named macros from a list for easy macro execution. Read Only Fields - Give fields Read Only access to protect data from unwanted changes. Required Fields - Require that information be entered into a field before the user is allowed to continue completing the form. @SELECT - Provides conditional logic. @MOD - Returns the remainder from a divisor. @ERROR - Returns an error message if an external lookup is unsuccessful. @REPLACE - Replaces a field with different data. CLEAR - Clears a field or range of fields. Q & A Application Note Rev. 6/92 #2001 Page 2 of 6 Indirect Field Reference - Identifies a field based on a field value, field name, or field identifier. Shorter Function Names - Decrease the amount of programming space used by function names. Print Programming Spec - Prints program specs, assisting you in editing and documenting lengthy statements. Gosub-Return - Use these commands to easily perform subroutines to eliminate retyping repetitive programming statements. ÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ An Even Easier Way to Use the Intelligent Assistant ÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ Query Guide - Use the Query Guide to assist you in building 100% accurate requests. New IA Grammar - Expanded vocabulary helps the IA understand more requests and eliminates re-phrasing. ÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ Better Database Protection ÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ Custom Database Lock - Protect your database's design, programming, and customization by assigning a password to the database. Field Level Security - Provide data security at the field level. Assign up to three levels of access to field information; Read/Write, Read Only, or Hidden. Up to 8 different views of the data can be created depending upon the user's access rights. ÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ Global Improvements ÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ Mouse Support - Use a mouse to select items from menus and lists, navigate through fields and forms, and perform word processing operations. Detailed File Description Tag - Attach a 72 character description to a Q&A document or database file for easier file identification. Temporary Files Directory - Q&A's temporary files can be written to a user-specified directory for added flexibility on networks. Q & A Application Note Rev. 6/92 #2001 Page 3 of 6 Document Default Import - A default import type can be specified by the user so that Q&A will automatically import those documents without questioning the file format. Virtual Memory Management - Q&A will use expanded memory to increase the efficiency of memory usage, allowing you to create more complex queries and reports. Printer Support - Enhancements include cut sheet feeder support, graphical representation of box characters and color PostScript printing. ÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ More Flexible Reporting ÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ Cross Tab Reports - Cross tabulate multiple fields in a report. The report shows the summary of fields based upon user defined ranges for row and column values. Report Text Enhancements - Create presentation quality reports using bold, italics, underline, superscript, subscript, strikeout, and fonts in your reports. Report Preview - Preview your columnar and cross tab reports on screen before printing. Split Record Control - Choose whether record values are split across pages or moved to the next page. Double Spaced Reports - Print reports with double or single spacing for easy to read results. Standard Deviation and Variance - Calculate standard deviation and variance in reports for easy statistical analysis. Multi-Line Text Formatting - Indent second and subsequent lines of multi-line text values in a report. User-defined Report Field Names - Use your own custom names for your report summary labels like sub-total, total,etc. ÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ Word Processing Enhancements ÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ On-Screen Page Attributes - View on-screen variable line spacing, real tabs, accurate line and page breaks for proportional fonts, carriage returns, and tabs. Page Preview - View your entire document on-screen before printing to check the placement of all your fonts, graphics, and page layout. Q & A Application Note Rev. 6/92 #2001 Page 4 of 6 Scalable Fonts - Assign a point size for any font, using Cannon and Hewlett-Packard scalable font technology. Integrated Thesaurus - Look up synonyms in a document or select a word from the 660,000 word thesaurus. Mail Merge Programming Functions - Use functions like @SUM and @AVG to perform calculations on merged data. Merge Documents with Multiple Databases - Perform a mail merge using data from multiple databases. Print Multiple Mailing Labels - specify how many copies of a label or set of labels to print. Document Switching - Switch from your current document to a document previously opened in that session. Right Alignment of Text - In addition to left and full justification, you can now right justify text in word processing documents. Predesigned Mailing Label Templates - Choose from over 50 pre-designed label formats including support for all Avery label formats. Search and Replace Across Joined Documents - Use search and replace capabilities across documents that are joined together. Word Processing Case Formatting - Assign text as uppercase, lowercase, or title. Word Processor Document Recovery - Recover damaged word processing documents in ASCII format. Define Page for Imported Documents - Create a second page definition for imported documents. This includes defaults for ASCII documents. Integrated Document Conversions - directly import from and export to the most popular word processing formats on the market. WordPerfect Microsoft Word WordStar MultiMate Professional Write ASCII/Special ASCII/Macintosh ASCII Q & A Application Note Rev. 6/92 #2001 Page 5 of 6 ÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ System Requirements ÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ IBM PC/XT/AT,PS/2 or 100% compatibles. 512K RAM, 640K recommended. 640K required for DOS 4.0 or higher and network use. EMS required for SQL use. PC/MS-DOS 2.0 or higher. DOS 3.1 required for network use. DOS 3.3 required for PS/2 models. Requires a hard disk drive. Requires monochrome or color monitor. Runs under Windows in character mode. Order Your Upgrade Today ÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ In the U.S., call (800) 228-4122, ext 101 TS TO PLACE YOUR UPGRADE ORDER. $79.00 upgrade price. In Canada, call (800) 465-2266. Outside North America, call (408) 252-3570. Symantec Corporation 10201 Torre Avenue Cupertino, CA 95014-2132 For further information: Outside California: (800) 441-7234 Inside California: (800) 626-8847 Outside the US: (408) 253-9600 Q & A Application Note Rev. 6/92 #2001 Page 6 of 6