ASCII

American Standard Code for Information Interchange. One of the standard formats for representing characters so that files can be shared between programs. A DOS text file is usually in ASCII format.

Background record
The most recently displayed record in a panel. You can retrieve data from a background record into the record currently being created by pressing Select [F4].

Backup
      Power outages, computer failures, and disk failures can erase information in your database. To avoid losing time and data, MAKE BACKUP COPIES OF ALL DATA FILES PERIODICALLY.
      The DataPerfect utility DPBackup is included with your database program. It lets you back up your database to a network drive, hard drive, or diskettes. DPBackup lets you split a database backup file across diskettes. DPBackup will use the DOS Label command to name the diskettes and then will ask for the diskettes in sequence when you restore the database.
      To start DPBackup from the DOS prompt type "dpbackup" in the directory where DPBackup is located (usually the same directory as your database files). Then press [Enter]. You can select options interactively from menus as you go.

Browse mode

Lets you look through the records in a panel without making any changes to the records. See also Create Mode and Edit Mode.

Case sensitive
A program or feature that distinguishes between uppercase and lowercase letters. This program is case sensitive only when reading passwords.

Create mode
Lets you make a new record in a panel by pressing Create (F9).  See also Browse Mode and Edit Mode.

Data
Information that makes up a database.

Data checking
When you enter data in a field that contains a data link, this feature checks to see if a related record already exists in the destination panel.

Data Export
     An export copies, but does not delete, records from a data file and saves them under another filename. This file can be in WordPerfect or DOS Delimited Text format. The file can then be imported into another program or used in WordPerfect.
     Performing an export is different than generating a report, even though these two features are both accessed with the Report/Export function key [Shift] + [F7]. An export must be sent to a disk file; a report can be sent to a disk file, to the screen for viewing only, or to the printer. An export is not usually in an easily readable format; a report is usually easy to read. An export can be imported back into a database; a report cannot be imported.
      An export is valuable when you want to transfer a copy of data to another program or location.
      An export can also act as an additional backup of your database BUT SHOULD NOT BE USED IN PLACE OF REGULAR BACKUPS.

Data file
A file that contains data from a database.

Data Import
     Records in WordPerfect 4.2, 5.0, 5.1 merge format (including Notebook files), or a DOS Delimited Text format can be directly imported into the database.
     Data from other database programs (dBase, R:BASE, etc) must be converted to a format that this program can recognize. For help, see the documentation for the other database program. The WordPerfect utility program, CONVERT.EXE, converts files from other formats to WordPerfect merge format, and vice versa.
    Data can be imported into the database panel which you are at, by pressing [Ctrl] + [F5].
    The following example may clarify how this is accomplished:
    Suppose you have a list of titles, publishers, and subjects, typed in WP 5.1 format, which you wish to import.
    The first step is to be sure the appropriate merge codes are inserted in your WP 5.1 document. (At the end of each field, press [F9] (in WP51) to insert the {Field} code. At the end of the last field for each record, press [F9] to end the field, then [Shft] + [F9] and [Enter] to end the record. Now save this file with a name you will remember, and exit WP51.)
     In the "Catalog" panel of this database, press [Ctrl] + [F5]. Press "1" and type in the name of your WP 5.1 file (with the directory path). Press "2" for "WordPerfect Merge" as the "type of import". Press "7" for "Create Import List" (this is necessary to control importing on a field-by-field basis -- because, in his particular example, you are importing only 3 fields of a panel which has many more fields into which data can be imported). Then press "8" to begin the import.

Data link
A feature that lets you interact with more than one panel at a time.  A data link can check to see if identical data exists in other panels.  It is represented on the screen by a Diamond.

Database
A software program that maintains records.  A flat file database (such as Notebook) lets you access only one record at a time.  A relational database (such as DataPerfect) lets you link information from multiple records and may contain a set of programming commands to let the user perform complex tasks.

DATABASE CONCEPTS
     A database is a collection of data.  Databases come in many forms.  Common databases include mailing lists, encyclopedias, and card files.  These examples may not seem to have much in common, but they all share one common feature--they contain information which is sorted or indexed so that it can be retrieved quickly.
     A card file containing customer addresses and telephone numbers is an example of a database.  Usually, the cards are sorted alphabetically and are separated by tabs so you can find basic information (such as a customer's address) quickly.  If the cards were simply scattered in a shoebox, this process would take much longer.
     In the card file, the alphabetized tabs act as an index that can direct you to the needed information.  However, finding related information (such as all the customers on file who live in Colorado) is much more difficult because the cards are not cross-referenced.  Updating the card file is also difficult because it must be performed manually, and the file space often is limited.
     A file cabinet is a more organized database.  Information can be grouped into labeled drawers, with each drawer divided into sections by tabbed folders.  Each folder can then be sorted alphabetically.  This type of organization (or indexing) lets you classify information into groups and subgroups, and then locate specific information easily.  You can also cross-reference information by filing copies of the same material in different tabbed folders.
     Suppose a doctor's office has records for all of its patients in a file cabinet. If the files are arranged in alphabetical order according to last name, it is simple to find the record for a given patient. However, if it is necessary to look up patients' records by billing date, insurance company, or the last date they visited the office, things become more complex. To arrange records according to these other categories as well as by last name would require many duplicate files.
     A computerized database lets you sort records in many different ways. Because of this, the doctor's office could have one record for each patient, but be able to look up that record by name, insurance company, last date visited, and so forth, making record storage and access more efficient.

Database definer
The person who creates the structure of the database.

DATAPERFECT FEATURES
       This program was written using DataPerfect Application Developers Kit (ADK), a product of WordPerfect Corporation.

Default
A setting, value, or response provided by DataPerfect unless an alternative is specified.  Some defaults can be changed for all future work sessions; other defaults can be changed for one use, and will reset when you exit DataPerfect.
Delimiter
A character used to separate records and fields.

Destination panel
The panel you enter through a panel link or a data link.

DOS
Disk Operating System.  Software that oversees disk I/O, video support, keyboard control, and internal commands.  A computer needs a disk operating system to function.

Edit mode
Lets you edit existing records in a panel by pressing Edit (F6).  See also Browse Mode and Create Mode.

Edit order
The order in which the cursor moves from field to field in a panel.

Export
A feature that copies data to a file that can be imported back into a database or that can be stored for backup purposes. See Data Export.

Field
A term used in a database for a piece of information in a record.  For example, a person's first, middle, and last names could be three separate fields.  Fields can be formatted to accept alphanumeric characters, dates, times, and numbers.

Field format
A format that determines how a field is displayed and printed.

File
The largest unit of data in a database.  A file is made of one or more records.

Flat file
A file which has no relationship (links) to any other file in the database.

Import
A feature that transfers the contents of a delimited or exported file back into a database. See Data Import.

Index
A sorted list used to locate records.

Link
A means of sharing information among panels, and of moving between panels without having to exit the current panel.

Lookup
A feature which lets you quickly look through, locate, and retrieve records in a database.

Lookup list
A sorted list of fields that appears at the top or bottom of the screen when you press Lookup or Up Arrow.

Menu
A list of choices.  Built-in menus provide features necessary for database creation, navigation, reporting, and other functions.  You may also see user-defined menus in which the definer provides direct access to panels, reports, or other functions through menu number choices.

Non-text field
A field format (alphanumeric, date, time, floating decimal, or numeric) defined to accept only one fixed-length line.  The field can be defined to contain from 1 to 78 characters (depending on field type), and when the maximum number of characters has been typed, no more characters will be displayed or accepted.  See also Text Field.

Panel
A template or viewing area on your screen used to display records from a file one at a time.

Panel link
A feature that lets you interact with more than one panel a time.  A panel link is represented on the screen by a rectangle.

Path/pathname
A full pathname includes the drive, root directory, and any subdirectory names.  Each name is separated by a backslash (\).  For example, C:\DATA refers to the DATA directory on the C drive.  The pathname C:\DATA\CUSTOMER refers to the CUSTOMER file (or the Customer subdirectory) in the DATA directory on the C drive.

Printer driver
The software that enables a program to communicate with the printer so that the program's information can be printed.

Port
A connection device between a computer and another component such as a printer or modem.

Read-only user
A user who can browse through records in a database, but cannot create, edit, or delete data.  This user can run reports but cannot create new ones.

Read/write user
A user who can create, edit, and delete data from a database.  This user can also create, edit, and run reports.  A read/write user cannot access the System Operations menu or access features that modify the structure of the database.

Record
A group of fields thatt contain related information.  For example, a customer's name and address could be considered as a record.  One or more records make up a file.

Related record
A record which shares one or more common fields with a record in another panel (through a data link or panel link.)

Relationship
The manner in which data in one file relates to data in another file.  DataPerfect allows the following relationships between files: one-to-one, one-to-many, many-to-one, and many-to-many.

Report
A compilation of data from the database which may be sent to a printer, to a disk file, to the screen, or to another panel.

Search template
A word or number pattern used to search for specific information in a panel.

Source panel
The panel in which a panel link or data link originated.

Target field
The field where the cursor appears after you have moved through a data link or a panel link.

Text field
An alphanumeric field format that is defined to have one or more variable-length lines.  The field can be defined to display 1 to 78 characters and 1 to 15 lines.  The display size does not affect the maximum capacity of the field; you can type as many as 32,000 characters in a text field, and then view what is not displayed by scrolling through it.  See also Non-Text Field.

Toggle
A feature which can be turned on and off with the same key.  For example, to turn on Typeover, press Insert; to turn off Typeover, press Insert again.

Wildcard
In a search template, wildcards are characters used to represent variables.  A question mark (?) represents a single character that you want to vary in the sea an asterisk (*) represents zero or more characters in succession.

Window
A viewing area in a source panel that displays records from a destination panel.

Wrap
To move the cursor to the next line without pressing Enter.  DataPerfect wraps in a text field, but does not wrap in a report form.