TECHNICAL DETAILS PROFILE VERSION 2 ----------------- POWER o Unlimited number of database files o Link up to four databases to one form; 1 primary database plus up to three refernced databases. o Create Calculated fields in a data entry form. Calculated fields may include other fields, constants, and functions. Nine functions are available to perform sine, consine, square, square root, log and others mathematical operations. o Manage large databases with up to: - 2+ billion records per database file - 10 Index files per database - 4 database files per form - 3,000 characters per record - 150 fields per database - 100 lines for the database entry form o Supports 4 field types; Text, Numeric, Lookup, and Calculation - Text field attributes include, any character, alpha only, digits only, auto date, date, phone number, social, and security number - Number fields attributes are any number, currency, and an incrementing field that automatically increments as new forms are added. o Entry rules for fields; must fill, required, unique, force upper case o Range checking, minimum or maximum, for numeric fields o Powerful search capabilities - Alphabetic/numeric/date range searches - "And", "or", partial, exact, and combination matches o Index on any field - View database in index order - Ten index fields per database - Find any record with index in less than 2 seconds o Create help line for any field o Powerful one-step global search and replace - Replace information - Add to beginning or end of field data - Delete partial information - Substitute partial data in a field o Sorted reports or labels on up to ten fields o Sort reports, labels, or mail-merge file in 3rd class bulk mail order o Print labels up to four across - Print in 3rd class bulk mail order with dividers and summary - Easy-to-use label creation with 31 predefined labels and an "any-style" selection o Reports up to 64 columns or 255 characters - Customized column calculations (running balance, percentages, spreadsheet formulas, etc.) - Column summaries (total, average, count and subtotal, subaverage, subcount) - Invisible columns for intermediate calculations - Perform scientific calculations (sine, cosine, square root,etc.) o Preview reports on screen o Create and save unlimited number of report formats for repeated use PERFORMANCE o Optimized search and sort speeds o Supports virtually all popular printer models o Program files fit on one disk FAST TO LEARN AND EASY TO USE o Free-form database design o Change design easily without losing data o Quick entry "ditto" key to copy information from previous form o Pop-up and Lotus-style menus for easy use o Over 150 screens of context-sensitive help OFFICE INTEGRATION o Dialer function lets you automatically dial any number in your database o Import/export ASCII data in comma-delimited, Standard Data Format, or One-field-per-line format o Convert dBase II/III/III+ files to ProFile format o Create mailmerge file for most popular word processing programs o Easily copy data between different ProFile databases