home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware Overload
/
ShartewareOverload.cdr
/
database
/
arowdb25.zip
/
MANUAL.DOC
< prev
next >
Wrap
Text File
|
1991-02-25
|
99KB
|
3,298 lines
ARROW DATABASE SYSTEM
Copyright (C) 1990 ACLYPSE, INC. All Rights Reserved
This manual is for
ARROW Version 2.5 (Unregistered)
&
ARROW Version 3.0 (Registered).
ARROW DATABASE - TABLE OF CONTENTS
I INTRODUCTION
Information about ARROW 1.1
Help 1.2
Features of ARROW 1.3
Registering for ARROW Version 3.0 1.4
II MASTER MENU BAR
OPENING A DATABASE 2.1
CREATING A NEW DATABASE 2.2
DELETE AN EXISTING DATABASE 2.3
COPY A DATABASE TO DESTINATION 2.4
COPY A DATABASE FROM SOURCE 2.5
EXIT TO DOS 2.6
FORM DESIGN 2.7
REPORT DESIGN 2.8
SCREEN DISPLAY 2.9
KEYS F3-F10 2.10
MACROS F2 2.11
SELECT PRINTER 2.12
SELECT PRINTED OUTPUT DESTINATION 2.13
EJECT PAGE 2.14
LINE FEED 2.15
RUN MS-DOS PROGRAM 2.16
MOUSE CONTROL 2.17
SCREEN SAVE 2.18
CHANGE DATE 2.19
ABOUT ARROW 2.20
III ENTRY MENU BAR
EDIT MODE 3.1
SCAN MODE 3.2
CLOSE THE DATABASE 3.3
SEARCHING THE DATABASE 3.4
SELECT ENTRIES FOR FORM PRINTING 3.5
SELECT ENTRIES FOR REPORT PRINTING 3.6
COPY SELECTED ENTRIES 3.7
SET AND REMOVE ENTRY TAGS 3.8
DELETE AND UNDELETE ENTRIES 3.9
SELECT ENTRIES FOR GLOBAL EDITING 3.10
SELECT ENTRIES FOR MAILMERGE 3.11
TABULATE ENTRIES 3.12
MODIFY CATAGORY DESCRIPTIONS 3.13
MODIFY DATABASE ATTRIBUTES 3.14
SETTING DATABASE ENTRY FILTER 3.15
SELECT SORT FIELD FOR DATABASE 3.16
DATABASE INFORMATION 3.17
DELETE DUPLICATE ENTRIES 3.18
PURGE ENTRIES MARKED FOR DELETION 3.19
IV ENTRY VIEWING & EDITING
DIRECT EDITING MODE FUNCTIONS 4.1
ADDING A NEW ENTRY 4.2
EDITING CURRENT ENTRY 4.3
ADD NOTES TO AN ENTRY 4.4
CHANGING TO EDIT MODE VIEW 4.5
CHANGING TO SCAN MODE VIEWS 4.6
DELETING ENTRIES 4.7
TAGGING ENTRIES 4.8
MODIFY ENTRY AND PRINT DATES 4.9
COPYING ENTRIES TO ANOTHER DATABASE 4.10
FORM & LABEL PRINTING 4.11
REPORT PRINTING 4.12
MOVING BETWEEN DATABASES 4.13
V FORM DESIGN
OPENING A FORM LAYOUT 5.1
CREATING A NEW FORM LAYOUT 5.2
SAVING A FORM LAYOUT 5.3
DELETE A FORM LAYOUT 5.4
EXIT FORM LAYOUT EDITOR 5.5
MODIFY PAGE SIZE A MARGINS 5.6
PRINT SAMPLE FORMS 5.7
COPYING A FORM LAYOUT TO DESTINATION 5.8
COPYING A FORM LAYOUT FROM SOURCE 5.9
FORM LAYOUT VIEWING & EDITING 5.10
VI REPORT DESIGN
OPENING A REPORT LAYOUT 6.1
CREATING A NEW REPORT LAYOUT 6.2
SAVING A REPORT LAYOUT 6.3
DELETE A REPORT LAYOUT 6.4
EXIT REPORT LAYOUT EDITOR 6.5
MODIFY PAGE SIZE A MARGINS 6.6
MODIFY REPORT ATTRIBUTES 6.7
PRINT SAMPLE REPORT 6.8
COPYING A REPORT LAYOUT TO DESTINATION 6.9
COPYING A REPORT LAYOUT FROM SOURCE 6.10
REPORT LAYOUT VIEWING & EDITING 6.11
VII MACROS
OVERVIEW 7.1
CREATE A SAMPLE MACRO 7.2
USING THE SAMPLE MACRO 7.3
AUTO MACROS 7.4
VIII NOTE PAGE FUNCTIONS
STANDARD MATH OPERATORS 8.1
STANDARD MATH FUNCTIONS 8.2
Mailing lists can be one of your most valuable assets,but only if
properly kept and maintained. New sales leads, customer lists,
membership rosters, and press release directories are types of
mailing lists that can be used to accurately distribute your
information and generate maximum response.
1.2 - CONTEXT SENSITIVE HELP
At any time when using ARROW, you can press the F1 Function
key to view a help window. The information displayed in this window
will inform what the current function does and the options available
to you at this point. The page # of the reference manual where you
can read more about the current topic is displayed in the lower left
hand corner of the help window.
1.3 - Features of ARROW
CAPACITY
10,000 of separate databases.
1000 individual entries per database. (Unregistered Version 2.5)
9,000,000 individual entries per database. (Registered Version 3.0)
Copy functions allow back-up of large databases to multiple
floppy diskettes.
EDITING & VIEWING
Single and or multiple entry scan modes.
Work with multiple databases.
Modifiable text function keys.
Automatic entry date stamp.
Selective tagging for printing and copying.
Easy to use pull down menu.
Search by almost any field contents.
Duplicate deletion.
Sort by almost any field.
Select conditional entry operations.
Conditional entry filtering.
Global edit and replace.
CATEGORIES
Up to 3 individual categories.
Each may contain up to 20 selections.
Popup selection window option.
NOTES
Available for every entry.
Full support for mathmatical line formulas.
Able to do sub-text searches.
FORM & LABEL PRINTING
Full screen label & form layout editor.
May be up to 14"x14" in size.
Supports up to 5 labels across.
Full typeface, font, and attribute selection.
Squeeze mode (eliminates blank lines).
Copy function allow tranfer of layouts.
Nth Sampling option.
Automatic print date stamp.
* Note: Version 2.5 (Unregistered) will not save newly designed
forms. Register ARROW to receive ARROW Version 3.0.
REPORT PRINTING
Full screen report editor.
Supports up to 14"x14" in sheet size.
Automatic grouping of entries.
Full typeface, font, and attribute selection.
Squeeze mode (eliminates blank lines).
Copy function allow tranfer of layouts.
* Note: Version 2.5 (Unregistered) will not save newly designed
reports. Register ARROW to receive ARROW Version 3.0.
MACROS
Create up to 26 different macros.
Easy to use record and play modes.
Create autorun startup macros.
Record & Play modes.
ONLINE HELP
Context-sensitive help windows.
MAILMERGE
To all popular word processor formats such as Word Perfect,
Microsoft Word, Wordstar, Volkswriter, Displaywrite, PC Write,
Professional Write, Volkswriter, and others.
SYSTEM REQUIREMENTS
XT, AT, or 386 Compatible.
640K RAM
Hard disk drive (Recommended)
Mouse (Optional)
1.4 - Registering to receive ARROW Version 3.0
For many people ARROW Version 2.5 will be all they need, and it can be
freely distributed. It differs from the ARROW Version 3.0 (Registered)
in the following ways:
ARROW Version 2.5 (Unregistered)
* You may have up to 1,000 records per database.
* You can NOT save your own label, form & report designs.
ARROW Version 3.0 (Registered)
* You may have up to 9,000,000 records per database.
* You CAN save your own label, form & report designs.
* You also receive TOOLBOX 3.0, which is an accessory program
that allows you to import data from other programs such
as: 123, dBase III & III+, Visicalc, Multimate, and from
almost any ASCII text file format.
To register and receive ARROW Version 3.0 and all future updates,
send $ 25 US dollars to the following address:
ACLYPSE CORPORATION
Route 2 Box 213H
Worthington, IN 47471
Please specify desired disk format (5.25" or 3.5"). Site licenses
are available upon request. Thank You.
MASTER MENU BAR - Section II
2.1 - OPENING A DATABASE
Opening an existing database allows you to view, edit, and manipulate
entries it contains. You may open up to two databases at the same
time. The database on the left side of the screen is called the
Primary Database, with the one displayed on the right called the
Secondary Database.
==> Go to the first pull-down menu in the MASTER MENU BAR
titled Database.
==> Type O or use the Up & Down arrow keys to highlight the
selection Open.
==> Press the Enter (or Return) key.
The Database Selection window will appear allowing you to choose a
previously created database. You may use the following keys to help
you highlight and make your selection:
# - Type the # of the database.
Up & Down arrow keys - Allows you to move up and down one at a time
between individual database titles.
PgUp & PgDn - The database selection window will display up to 9
database titles. Use the PgUp and PgDn keys to page one
screen up or down respectively
ESC - Press the Esc key to exit the Database Selection window without
choosing a database.
==> Once the title is highlighted of the database you wish to open,
press the Enter (or Return) key.
The database will now be opened and displayed.
2.2 - CREATING A NEW DATABASE
You will want to create a new database:
==> Go to the first pull-down menu in the MASTER MENU BAR
titled Database.
==> Type C or use the Up & Down arrow keys to highlight the
selection Create.
==> Press the Enter (or Return) key.
A Request window will be displayed and the # of the new database will
be shown. Each database needs a title that will make this database
easy to find when opening it later.
==> Enter the title description and press the Enter (or Return) key.
If you want to use the default current directory:
==> Press the Enter (or Return) key.
or if you would like this database to be placed on a different drive
or directory:
==> Enter a valid drive directory path and press the Enter key.
A Request Window will appear confirming your desire to create the
new database.
To continue and create and display this new database:
==> Highlighting Ok by typing O or move the Up & Down arrow keys.
==> Press the Enter (or Return) key.
To exit without creating this database:
==> Highlighting Cancel by typing C or move the Up & Down arrow keys.
==> Press the Enter (or Return) key.
2.3 - DELETE AN EXISTING DATABASE
If you want to a delete a complete database:
==> Go to the first pull-down menu in the MASTER MENU BAR
titled Database.
==> Type D or use the Up & Down arrow keys to highlight the
selection Delete.
==> Press the Enter (or Return) key.
The Database Selection window will appear allowing you to choose the
database you wish to delete. You may use the following keys to help
you highlight and make your selection:
# - Type the # of the database.
Up & Down arrow keys - Allows you to move up and down one at a time
between individual database titles.
PgUp & PgDn - The database selection window will display up to 9
database titles. Use the PgUp and PgDn keys to page one
screen up or down respectively
ESC - Press the Escape key to exit the Database Selection window
without choosing a database.
==> Once the title is highlighted of the database you
wish to delete, press the Enter (or Return) key.
A Request Window will appear confirming your desire to delete the
selected database. To continue and delete this database:
==> Highlight Ok by typing O or move the Up & Down arrow keys.
==> Press the Enter (or Return) key.
To exit without deleting this database:
==> Highlight Cancel by typing C or move the Up & Down arrow keys.
==> Press the Enter (or Return) key.
2.4 - COPYING A DATABASE TO DESTINATION
The copy To option allows you to copy or back-up a database to
another drive or directory or back-up a database upon multiple floppy
disks if need be. If this database has been opened and is displayed
as the Primary or Secondary Database, you must use the Close option
in the ENTRY BAR MENU under Mode.
==> Go to the first pull-down menu in the MASTER MENU BAR
titled Database.
==> Type T or use the Up & Down arrow keys to highlight the
selection copy To.
==> Press the Enter (or Return) key.
The Database Selection window will appear allowing you to choose the
database you wish to copy or back-up. You may use the following keys
to help you highlight and make your selection:
# - Type the # of the database.
Up & Down arrow keys - Allows you to move up and down one at a time
between individual database titles.
PgUp & PgDn - The database selection window will display up to 9
database titles. Use the PgUp and PgDn keys to page one
screen up or down respectively
ESC - Press the Esc key to exit the Database Selection window without
choosing a database.
==> Once the title of the database you wish to copy is highlighted
press the Enter (or Return) key.
A Request Window will now appear prompting you to enter the desired
destination drive and/or directory, or press the Esc key to exit
without copying database.
Example: A:\
If the enough storage space, ARROW will copy the database to the root
directory of disk in drive A:.
If the database is too large to be copied to a single floppy disk,
a Request window will appear confirming that you desire to copy this
database upon multiple floppy disks. If you want to continue a do
a multiple disk back-up:
==> Highlight Ok by typing O or move the Up & Down arrow keys.
==> Press the Enter (or Return) key.
You will now be prompted to place disk(s) in the drive until a
complete backup is made. Please mark the diskettes in the order
that they were placed into the disk drive.
To exit without copying this database:
==> Highlight Cancel by typing C or move the up and down arrow keys.
==> Press the Enter (or Return) key.
2.5 - COPYING A DATABASE FROM SOURCE
The copy From option allows you to copy a database from another drive
or directory. This option will also recover a database that was copied
with the multiple disk back-up function of the copy To option. If
the database has been opened and is displayed as the Primary or
Secondary Database, you must use the Close option in the ENTRY BAR MENU
titled Mode.
==> Go to the first pull-down menu in the MASTER MENU BAR
titled Database.
==> Type F or use the Up & Down arrow keys to highlight copy From.
==> Press the Enter (or Return) key.
A Request Window will now appear prompting you to enter the desired
source drive and/or directory, or press the ESC key to exit without
copying database.
Example: A:\
This will copy the database from the root directory of diskette in
drive A:.
The Database Selection window will appear allowing you to choose the
database you wish to copy or back-up. You may use the following keys
to help you highlight and make your selection:
# - Type the # of the database.
Up & Down arrow keys - Allows you to move up and down one at a time
between individual database titles.
PgUp & PgDn - The database selection window will display up to 9
database titles. Use the PgUp and PgDn keys to page one
screen up or down respectively
ESC - Press the Esc key to exit the Database Selection window without
choosing a database.
Once your the title highlighted of the database you wish to copy press
the Enter (or Return) key.
ARROW will now copy the database. If the database is saved using the
copy To option's multiple disk back-up option. You will be prompted to
place the diskettes one by one into the disk drive until the complete
database is copied.
2.6 - EXIT TO DOS
When you want to leave the ARROW:
==> Go to the first pull-down menu in the MASTER MENU BAR
titled Database.
==> Type E or use the Up & Down arrow keys to highlight the
selection Exit.
==> Press the Enter (or Return) key.
All databases will be closed and you will return to the MS-DOS prompt.
2.7 - FORM DESIGN
If you would like to create or modify a form:
==> Go to the second pull-down menu in the MASTER MENU BAR
titled Design.
==> Type F or use the Up & Down arrow keys to highlight the
selection Form.
==> Press the Enter (or Return) key.
The Form Editor window will appear allowing you create, edit, or
delete form designs.
Please refer to the FORM DESIGN - Section V, later in this manual
for more information.
2.8 - REPORT DESIGN
If you would like to create or modify a report:
==> Go to the second pull-down menu in the MASTER MENU BAR
titled Design.
==> Type R or use the Up & Down arrow keys to highlight the
selection Report.
==> Press the Enter (or Return) key.
The Report Editor window will appear allowing you create, edit, or
delete report designs.
Please refer to the REPORT DESIGN - Section VI, later in this manual
for more information.
2.9 SCREEN DISPLAY
If you would like to change screen colors and/or the background
pattern:
==> Go to the second pull-down menu in the MASTER MENU BAR
titled Design.
==> Type S or use the Up & Down arrow keys to highlight
the selection Screen.
==> Press the Enter (or Return) key.
The Screen Design Editor window will appear.
To change the current selection's pattern or color:
==> Use the Left & Right arrow keys.
To move between the various selections:
==> Use the Up & Down arrow keys.
To use the ARROW Monochrome default settings:
==> Press the letter M key.
To use the ARROW CGA Color default settings:
==> Press the letter C key.
To use the ARROW VGA Color default settings:
==> Press the letter V key.
When done:
==> Press the Enter (or Return) key to save and use the current pattern
and color settings:
or
==> Press the ESC key to exit without and using the current settings.
2.10 - KEYS F3-F10
Function keys allow you to have the keys F3 thru F10 defined as text
characters to speed entry input. If you would like to modify a
Function Key definitions:
==> Go to the second pull-down menu in the MASTER MENU BAR
titled Design.
==> Type K or use the Up & Down arrow keys to highlight Keys F3-F10.
==> Press the Enter (or Return) key.
The Function Key window will appear allowing you modify the
definitions of keys F3 thru F10.
{ = [RETURN] key in the function key text.
2.11 - MACRO KEY DESIGN
If you would like to create or modify a Macro.
==> Go to the second pull-down menu in the MASTER MENU BAR
titled Design.
==> Type M or use the Up & Down arrow keys to highlight the
selection Macro F2.
==> Press the Enter (or Return) key.
Please refer to the MACROS - Section VII of this manual for
more information.
2.12 - SELECT PRINTER
To designate which printer that you will be using:
==> Go to the third pull-down menu in the MASTER MENU BAR
titled Printer.
==> Type S or use the Up & Down arrow keys to highlight
the selection Select.
==> Press the Enter (or Return) key.
The Printer Selection window will appear allowing you to indicate the
printer connected to your computer system. You may use the following
keys to help you highlight and make a selection:
# - Type the # of the printer selection.
Up & Down arrow keys - Allows to move up and down one at a time
between individual printer titles.
PgUp & PgDn - The printer selection window will display up to 9
titles. Use the PgUp and PgDn keys to page one screen up
or down respectively.
==> Press the Enter (or Return) key when the title is highlighted of
the printer you wish to select.
or
==> Press the ESC key to exit without saving selection change.
2.13 - SELECT PRINTED OUTPUT DESTINATION
Opening an existing database allows you to view, edit, and manipulate
entries it contains. You may open up to two databases at the same time.
The database on the left side of the screen is called the Primary
Database, with the one displayed on the right called the
Secondary Database.
==> Go to the third pull-down menu in the MASTER MENU BAR
titled Printer.
==> Type D or use the Up & Down arrow keys to highlight Destination.
==> Press the Enter (or Return) key.
A Request window will appear allowing you to indicate where printed
output should be directed. To change the current selection:
==> The Left & Right arrow keys allows you to change the
current selection.
To save the any changes made:
==> Press the Enter (or Return) key.
or to exit without saving changes made.
==> Press the Esc key.
2.14 - EJECT PAGE
If you want the selected printer to move to the top of the next page.
==> Go to the third pull-down menu in the MASTER MENU BAR
titled Printer.
==> Type E or use the Up & Down arrow keys to highlight Eject Page.
==> Press the Enter (or Return) key.
This will execute a form feed, placing the paper in the printer at
the top of the next page.
2.15 - LINE FEED
If you want the selected printer to advance one line.
==> Go to the third pull-down menu in the MASTER MENU BAR
titled Printer.
==> Type L or use the Up & Down arrow keys to highlight Line Feed.
==> Press the Enter (or Return) key.
This will execute a line feed, placing the paper in the printer
one line.
2.16 - RUN MS-DOS PROGRAM
If you want to suspend your work and run another MS-DOS program, and
return to ARROW:
==> Go to the fourth pull-down menu in the MASTER MENU BAR
titled Utilities.
==> Type R or use the Up & Down arrow keys to highlight Run Program.
==> Press the Enter (or Return) key.
A Request window will appear prompting you to enter the name of the
program you wish to run.
==> Enter the Directory Path and Filename.
==> Press the Enter (or Return) key.
Your work in ARROW will be suspended and the MS-DOS program
that you requested will begin. After exiting that program you will
be returned to the place you were before using this option.
To exit without running a MS-DOS program.
==> Press the ESC key.
2.17 - MOUSE CONTROL
If you want to speed up or slow down the reaction speed of your mouse:
==> Go to the fourth pull-down menu in the MASTER MENU BAR titled
Utilities.
==> Type M or use the Up & Down arrow keys to highlight Mouse Control.
==> Press the Enter (or Return) key.
A Request window will appear.
You may use the Left & Right arrow keys or move your mouse left or
right to slow or quicken your mouse speed.
If you want to save any changes you have made:
==> Press the left mouse button or the Enter (or Return) key.
or if you want to exit without saving changes:
==> Press the right mouse button or the ESC key.
2.18 - SCREEN SAVE
Screen save can help prevent image burn on monitors. This option
allows you to set ARROW's Screen Saver OFF or ONN with various time
intervals.
==> Go to the fourth pull-down menu in the MASTER MENU BAR
titled Utilities.
==> Type S or use the Up & Down arrow keys to highlight Screen Save.
==> Press the Enter (or Return) key.
A Request Window will appear displaying the current setting.
You can the Left & Right arrow keys to change the setting.
To save the changes you have made:
==> Press the Enter (or Return) key.
To exit without making any changes:
==> Press the ESC key.
2.19 - CHANGE DATE
To change the current date:
==> Go to the fourth pull-down menu in the MASTER MENU BAR
titled Utilities.
==> Type C or use the Up & Down arrow keys to highlight Change Date.
==> Press the Enter (or Return) key.
A Request Window will appear displaying the current date. If you
wish to select a different date.
==> Enter the new date in the format (Month/Day/Year).
==> Press the Enter (or Return) key.
To exit without making any changes to the current date:
==> Press the ESC key.
2.20 - ABOUT ARROW
To display the Aclypse Copyright message for ARROW.
==> Go to the fourth pull-down menu in the MASTER MENU BAR
titled Utilities.
==> Type A or use the Up & Down arrow keys to highlight About ARROW
==> Press the Enter (or Return) key.
The copyright message will be displayed, press Enter (or Return)
to continue.
ENTRY MENU BAR - Section III
3.1 - EDIT MODE
The Edit Mode allows you to view one entry at a time. If you are in
the Scan Mode, simply highlight the entry you wish to view or you
may use an option from the ENTRY MENU BAR. To do this:
==> Go to the first pull-down menu in the ENTRY MENU BAR with the
title Mode.
==> Type E or use the Up & Down arrow keys to highlight the
selection Edit.
==> Press the Enter (or Return) key.
3.2 - SCAN MODE
The Scan Mode allows you to view up to 18 entries at one time. If
you are in the Edit Mode, press S and you will be placed in the Scan
Mode or you may use an option from the ENTRY MENU BAR. To do this:
==> Go to the first pull-down menu in the ENTRY MENU BAR with the
title Mode.
==> Type S or use the Up & Down arrow keys to highlight the
selection Scan.
==> Press the Enter (or Return) key.
3.3 - CLOSE THE DATABASE
When you have completed all work needed to be done on a database:
==> Go to the first pull-down menu in the ENTRY MENU BAR with the
title Mode.
==> Type C or use the Up & Down arrow keys to highlight the
selection Close.
==> Press the Enter (or Return) key.
3.4 - SEARCHING THE DATABASE
To search a database for particular entry:
==> Go to the second pull-down menu in the ENTRY MENU BAR
titled Search.
You must now select the field from which to search.
LAST NAME
To search by the last name:
==> Type L or use the Up & Down arrow keys to highlight the selection
Last Name and press the Enter (or Return) key.
COMPANY
To search by the company:
==> Type C or use the Up & Down arrow keys to highlight the selection
Company and press the Enter (or Return) key.
CITY
To search by the city:
==> Type T or use the Up & Down arrow keys to highlight the selection
ciTy and press the Enter (or Return) key.
STATE
To search by the state:
==> Type S or use the Up & Down arrow keys to highlight the selection
State and press the Enter (or Return) key.
ZIPCODE
To search by the ZIP code:
==> Type Z or use the Up & Down arrow keys to highlight the selection
ZIP code and press the Enter (or Return) key.
OPTION
To search by option field:
==> Type O or use the Up & Down arrow keys to highlight the selection
Option and press the Enter (or Return) key.
PHONE#
To search by the business or home phone #'s:
==> Type # or use the Up & Down arrow keys to highlight the selection
phone # and press the Enter (or Return) key.
ENTRY DATE
To search by the date that the entry was entered:
==> Type E or use the Up & Down arrow keys to highlight the selection
Entry Date and press the Enter (or Return) key.
PRINT DATE
To search by the last date that this entry was printed on a form:
==> Type P or use the Up & Down arrow keys to highlight the selection
Print Date and press the Enter (or Return) key.
NOTES
To search by text entered into note pages:
==> Type N or use the Up & Down arrow keys to highlight the selection
Notes and press the Enter (or Return) key.
A Request window will appear asking you to enter text to match with
the search field you chose. Please note that when searching, it does
not matter whether text is in upper or lower case.
If one or more matching entry(s) are found, they will be displayed
one at a time in a Confirmation window.
If you wish to select the entry displayed to be the current entry
in the database.
==> Type S or use the Up & Down arrow keys to highlight the selection
Select and press the Enter (or Return) key.
If you wish to view other matching entries in the database.
==> Type C or use the Up & Down arrow keys to highlight the selection
Continue and press the Enter (or Return) key.
If you want to return to the current entry before the search.
==> Type E or use the Up & Down arrow keys to highlight the selection
Exit and press the Enter (or Return) key.
3.5 - SELECT ENTRIES FOR FORM PRINTING
To select one or more entries that you want print on forms or labels:
==> Go to the third pull-down menu in the ENTRY MENU BAR with the
title Select.
==> Type F or use the Up & Down arrow keys to highlight the
selection Forms.
==> Press the Enter (or Return) key.
The Select Request window will appear asking for the select condition
to choose which entries you wish to use. To exit this window at
any time without continuing with form printing press the ESC key.
FIELD
OPERATOR
SEARCH KEY
CONFIRMATION
FIELD
The FIELD box allows you to select which field of the database you
wish the select condition to match. You may use your Left & Right
arrow keys to choose one of the fields, which are as follows:
LAST NAME BUS. PHONE #
COMPANY HOME PHONE #
CITY CATEGORY 1
STATE CATEGORY 2
ZIPCODE CATEGORY 3
OPTION ENTRY DATE
PRINT DATE
When the desired FIELD is displayed:
==> Press the Enter (or Return) key.
OPERATOR
The OPERATOR box allows you to select an equation operator for
condition. You may use your Left & Right arrow keys to choose
one of the fields, which are as follows:
IS EQUAL TO search key
IS NOT EQUAL TO search key
IS GREATER THAN search key
IS GREATER OR EQUAL TO search key
IS LESS THAN search key
IS LESS OR EQUAL TO search key
IS GREATER THAN search key1 & IS LESS THAN search key2
IS GREATER OR EQUAL TO search key1 & IS LESS OR EQUAL TO search key2
IS LESS THAN search key1 & IS GREATER THAN search key2
IS LESS OR EQUAL TO search key1 & IS GREATER OR EQUAL TO search key2
When the desired OPERATOR is displayed:
==> Press the Enter (or Return) key.
SEARCH KEY
The SEARCH KEY box contains text for the select condition. There
may be one or two SEARCH KEYS depending on the OPERATOR box. Please
note that when matching the select condition it does not matter
whether text is in upper or lower case.
==> Enter the text for the select condition and press the Enter key.
CONFIRMATION
The CONFIRMATION box can be set ON or OFF by using the Left or Right
arrow keys. By selecting the ON status, all entries matching the
select condition will be displayed and you pick and choose which of
these you wish to be printed. If you select CONFIRMATION OFF status
all entries matching the select condition will be ready to be printed.
The Form Selection window will appear allowing you to choose the form
layout for printing. You may use the following keys to help you
highlight and make your selection:
# - Type the # of the form layout.
Up & Down arrow keys - Allows you to move up and down one at a time
between individual form titles.
PgUp & PgDn - The form selection window will display up to 9 form
titles. Use the PgUp and PgDn keys to page one screen up
or down respectively.
Esc - Press the Esc key to exit the Form Selection window without
choosing a selection.
==> Once your the title highlighted of the form layout you wish to
select, press the Enter (or Return) key.
The Printing Control window will appear allowing you to print your
forms, test for alignment, change printers, and switch form layouts.
3.6 - SELECT ENTRIES FOR REPORT PRINTING
To select one or more entries to be included in a printed report:
==> Go to the third pull-down menu in the ENTRY MENU BAR with the
title Select.
==> Type R or use the Up & Down arrow keys to highlight the
selection Reports.
==> Press the Enter (or Return) key.
The Select Request window will appear asking for the select condition
to choose which entries you wish to use. To exit this window at any
time without continuing with report printing press the ESC key.
FIELD
OPERATOR
SEARCH KEY
CONFIRMATION
FIELD
The FIELD box allows you to select which field of the database you
wish the select condition to match. You may use your Left & Right
arrow keys to choose one of the fields, which are as follows:
LAST NAME BUS. PHONE #
COMPANY HOME PHONE #
CITY CATEGORY 1
STATE CATEGORY 2
ZIPCODE CATEGORY 3
OPTION ENTRY DATE
PRINT DATE
When the desired FIELD is displayed:
==> Press the Enter (or Return) key.
OPERATOR
The OPERATOR box allows you to select an equation operator for
condition. You may use your Left & Right arrow keys to choose
one of the fields, which are as follows:
IS EQUAL TO search key
IS NOT EQUAL TO search key
IS GREATER THAN search key
IS GREATER OR EQUAL TO search key
IS LESS THAN search key
IS LESS OR EQUAL TO search key
IS GREATER THAN search key1 & IS LESS THAN search key2
IS GREATER OR EQUAL TO search key1 & IS LESS OR EQUAL TO search key2
IS LESS THAN search key1 & IS GREATER THAN search key2
IS LESS OR EQUAL TO search key1 & IS GREATER OR EQUAL TO search key2
When the desired OPERATOR is displayed:
==> Press the Enter (or Return) key.
SEARCH KEY
The SEARCH KEY box contains text for the select condition. There
may be one or two SEARCH KEYS depending on the OPERATOR box. Please
note that when matching the select condition it does not matter
whether text is in upper or lower case.
==> Enter the text for the select condition and press the Enter key.
CONFIRMATION
The CONFIRMATION box can be set ON or OFF by using the Left & Right
arrows. By selecting the ON status, all entries matching the select
condition will be displayed and you pick and choose which of these
you wish to be printed. If you select CONFIRMATION OFF status all
entries matching the select condition will be ready to be printed.
The Report Selection window will appear allowing you to choose the
report layout for printing. You may use the following keys to help
you highlight and make your selection:
# - Type the # of the report layout.
Up & Down arrows keys - Allows you to move up and down one at a time
between individual report titles.
PgUp & PgDn - The report selection window will display up to 9 form
titles. Use the PgUp and PgDn keys to page one screen up or
down respectively.
Esc - Press the Esc key to exit the Report Selection window without
choosing a selection.
==> Once your the title highlighted of the report layout you wish to
select, press the Enter (or Return) key.
The Printing Control window will appear allowing you to print your
report, change printers, or switch report layouts.
3.7 - COPY SELECTED ENTRIES
To copy selected entries to another database:
==> Go to the third pull-down menu in the ENTRY MENU BAR with the
title Select.
==> Type C or use the Up & Down arrow keys to highlight the
selection Copy.
==> Press the Enter (or Return) key.
The Select Request window will appear asking for the select condition
to choose which entries to use. To exit this window at any time
without continuing entry copying press the ESC key.
FIELD
OPERATOR
SEARCH KEY
CONFIRMATION
FIELD
The FIELD box allows you to select which field of the database you
wish the select condition to match. You may use your Left & Right
arrow keys to choose one of the fields, which are as follows:
LAST NAME BUS. PHONE #
COMPANY HOME PHONE #
CITY CATEGORY 1
STATE CATEGORY 2
ZIPCODE CATEGORY 3
OPTION ENTRY DATE
PRINT DATE
When the desired FIELD is displayed:
==> Press the Enter (or Return) key.
OPERATOR
The OPERATOR box allows you to select an equation operator for
condition. You may use your Left & Right arrow keys to choose
one of the fields, which are as follows:
IS EQUAL TO search key
IS NOT EQUAL TO search key
IS GREATER THAN search key
IS GREATER OR EQUAL TO search key
IS LESS THAN search key
IS LESS OR EQUAL TO search key
IS GREATER THAN search key1 & IS LESS THAN search key2
IS GREATER OR EQUAL TO search key1 & IS LESS OR EQUAL TO search key2
IS LESS THAN search key1 & IS GREATER THAN search key2
IS LESS OR EQUAL TO search key1 & IS GREATER OR EQUAL TO search key2
==> When the desired OPERATOR is displayed, press the Enter key.
SEARCH KEY
The SEARCH KEY box contains text for the select condition. There
may be one or two SEARCH KEY depending on the OPERATOR box. Please
note that when matching the select condition it does not matter
whether text is in upper or lower case.
==> Enter the text for the select condition and press the Enter key.
CONFIRMATION
The CONFIRMATION box can be set ON or OFF by using your Left & Right
arrow keys. By selecting the ON status, all entries matching the
select condition will be displayed and you pick and choose which of
these you wish to be copied. If you select CONFIRMATION OFF status
all entries matching the select condition will be copied.
A final Confirmation window will be displayed.
To continue and print the copy selected entries:
==> Highlight Ok by typing O or use the Up & Down arrow keys then
press the Enter (or Return) key.
or to exit without copying:
==> Highlight Cancel by typing C or use the Up & Down arrow keys then
press the Enter (or Return) key.
3.8 - SET AND REMOVE ENTRY TAGS
To select one or more entries that you want to set or remove tags:
==> Go to the third pull-down menu in the ENTRY MENU BAR with the
title Select.
If you want the TAG setting to be ON for entries you select:
==> Type S or use the Up & Down arrow keys to highlight the selection
Set tags.
==> Press the Enter (or Return) key.
or if you want the TAG setting to be OFF for entries you select:
==> Type V or use the Up & Down arrow keys to highlight the selection
remoVe tags.
==> Press the Enter (or Return) key.
The Select Request window will appear asking for the select condition
to choose which entries you wish to use. To exit this window at any
time without modifying tags press the ESC key.
FIELD
OPERATOR
SEARCH KEY
CONFIRMATION
FIELD
The FIELD box allows you to select which field of the database you
wish the select condition to match. You may use your Left & Right
arrow keys to choose one of the fields, which are as follows:
LAST NAME BUS. PHONE #
COMPANY HOME PHONE #
CITY CATEGORY 1
STATE CATEGORY 2
ZIPCODE CATEGORY 3
OPTION ENTRY DATE
PRINT DATE
When the desired FIELD is displayed:
==> Press the Enter (or Return) key.
OPERATOR
The OPERATOR box allows you to select an equation operator for
condition. You may use your Up & Down arrow keys to choose one
of the fields, which are as follows:
IS EQUAL TO search key
IS NOT EQUAL TO search key
IS GREATER THAN search key
IS GREATER OR EQUAL TO search key
IS LESS THAN search key
IS LESS OR EQUAL TO search key
IS GREATER THAN search key1 & IS LESS THAN search key2
IS GREATER OR EQUAL TO search key1 & IS LESS OR EQUAL TO search key2
IS LESS THAN search key1 & IS GREATER THAN search key2
IS LESS OR EQUAL TO search key1 & IS GREATER OR EQUAL TO search key2
When the desired OPERATOR is displayed:
==> Press the Enter (or Return) key.
SEARCH KEY
The SEARCH KEY box contains text for the select condition. There
may be one or two SEARCH KEYS depending on the OPERATOR box. Please
note that when matching the select condition it does not matter
whether text is in upper or lower case.
==> Enter the text for the select condition and press the Enter key.
CONFIRMATION
The CONFIRMATION box can be set ON or OFF by using your Left & Right
arrow keys. By selecting the ON status, all entries matching the
select condition will be displayed and you can pick and choose which
of these you wish the tags to be modified. If you select CONFIRMATION
OFF status all entries matching the select condition will have the
tags set or removed.
A final Confirmation window will be displayed.
To continue and modify entrys' tag status:
==> Highlight Ok by typing O or use the Up & Down arrow keys then
press the Enter (or Return) key.
or to exit without modifying tags:
==> Highlight Cancel by typing C or use the Up & Down arrow keys then
press the Enter (or Return) key.
3.9 - DELETE AND UNDELETE ENTRIES
To select one or more entries that you want mark for deletion
for undeletion:
==> Go to the third pull-down menu in the ENTRY MENU BAR with the
title Select.
If you want to mark an selected entries to be deletion:
==> Type D or use the Up & Down arrow keys to highlight the
selection Delete.
==> Press the Enter (or Return) key.
or if you want selected entries to be undeletion.
==> Type U or use the Up & Down arrow keys to highlight the
selection Undelete.
==> Press the Enter (or Return) key.
The Select Request window will appear asking for the select condition
to select which entries to use. To exit this window at any time
without continuing with deleting or undeleting entries press the
ESC key.
FIELD
OPERATOR
SEARCH KEY
CONFIRMATION
FIELD
The FIELD box allows you to select which field of the database you
wish condition to match. You may use your Left & Right arrow keys to
choose one of the fields, which are as follows:
LAST NAME BUS. PHONE #
COMPANY HOME PHONE #
CITY CATEGORY 1
STATE CATEGORY 2
ZIPCODE CATEGORY 3
OPTION ENTRY DATE
PRINT DATE
When the desired FIELD is displayed:
==> Press the Enter (or Return) key.
OPERATOR
The OPERATOR box allows you to select an equation operator for
condition. You may use your Left & Right arrow keys to choose
one of the fields, which are as follows:
IS EQUAL TO search key
IS NOT EQUAL TO search key
IS GREATER THAN search key
IS GREATER OR EQUAL TO search key
IS LESS THAN search key
IS LESS OR EQUAL TO search key
IS GREATER THAN search key1 & IS LESS THAN search key2
IS GREATER OR EQUAL TO search key1 & IS LESS OR EQUAL TO search key2
IS LESS THAN search key1 & IS GREATER THAN search key2
IS LESS OR EQUAL TO search key1 & IS GREATER OR EQUAL TO search key2
When the desired OPERATOR is displayed:
==> Press the Enter (or Return) key.
SEARCH KEY
The SEARCH KEY box contains text for the select condition. There
may be one or two SEARCH KEYS depending on the OPERATOR box. Please
note that when matching the select condition it does not matter
whether text is in upper or lower case.
==> Enter the text for the select condition and press the Enter key.
CONFIRMATION
The CONFIRMATION box can be set ON or OFF by using your Left & Right
arrow keys. By selecting the ON status, all entries matching the
select condition will be displayed and you pick and choose which of
these you wish to be deleted or undeleted. If you select
CONFIRMATION OFF status all entries matching the select condition
will be ready to be deleted or undeleted.
A final Confirmation window will be displayed.
To continue and delete or undelete entries:
==> Highlight Ok by typing O or use the Up & Down arrow keys then
press the Enter (or Return) key.
or to exit without changing delete status:
==> Highlight Cancel by typing C or use the Up & Down arrow keys then
press the Enter (or Return) key.
3.10 - SELECT ENTRIES FOR GLOBAL EDITING
To select all the entries that you want to replace the contents of a
field.
==> Go to the third pull-down menu in the ENTRY MENU BAR with
the title Edit.
==> Type E or use the Up & Down arrow keys to highlight the
selection Edit.
==> Press the Enter (or Return) key.
A Request window will appear prompting you to select which field you
wish to modify and what the new contents should be for the select
condition you determine.
==> Use your Left & Right arrow keys to select the proper field and
press the Enter (or Return) key.
==> Enter what the new field value should be and press the Enter key.
The Select Request window will appear asking for the select condition
to choose which entries you wish to use. To exit this window at any
time without continuing with global edit press the ESC key.
FIELD
OPERATOR
SEARCH KEY
CONFIRMATION
FIELD
The FIELD box allows you to select which field of the database you
wish condition to match. You may use your Left & Right arrow keys to
choose one of the fields, which are as follows:
LAST NAME STATE BUS. PHONE # CATEGORY 2 ENTRY DATE
COMPANY ZIPCODE HOME PHONE # CATEGORY 3 PRINT DATE
CITY OPTION CATEGORY 1
==> When the desired FIELD is displayed press the Enter key.
OPERATOR
The OPERATOR box allows you to select an equation operator for
condition. You may use your Left & Right arrow keys to choose
one of the fields, which are as follows:
IS EQUAL TO search key
IS NOT EQUAL TO search key
IS GREATER THAN search key
IS GREATER OR EQUAL TO search key
IS LESS THAN search key
IS LESS OR EQUAL TO search key
IS GREATER THAN search key1 & IS LESS THAN search key2
IS GREATER OR EQUAL TO search key1 & IS LESS OR EQUAL TO search key2
IS LESS THAN search key1 & IS GREATER THAN search key2
IS LESS OR EQUAL TO search key1 & IS GREATER OR EQUAL TO search key2
==> When the desired OPERATOR is displayed press the Enter key.
SEARCH KEY
The SEARCH KEY box contains text for the select condition. There
may be one or two SEARCH KEY depending on the OPERATOR box. Please
note that when matching the select condition it does not matter
whether text is in upper or lower case.
==> Enter the text for the select condition and press the Enter key.
CONFIRMATION
The CONFIRMATION box can be set ON or OFF by using your Left & Right
arrow keys. By selecting the ON status, all entries matching the
select condition will be displayed and you pick and choose which of
these to global edit. If you select CONFIRMATION OFF status all
entries matching the select condition for global edit.
A final Confirmation window will be displayed.
To continue and global edit:
==> Highlight Ok by typing O or use the Up & Down arrow keys then
press the Enter (or Return) key.
or to exit without doing global edit:
==> Highlight Cancel by typing C or use the Up & Down arrow keys then
press the Enter (or Return) key.
3.11 - SELECT ENTRIES FOR MAILMERGE
To select entries for use in a MailMerge with a word processing
program.
==> Go to the third pull-down menu in the ENTRY MENU BAR with the
title Select.
==> Type M or use the Up & Down arrow keys to highlight MailMerge.
==> Press the Enter (or Return) key.
A Request window will appear asking for which word processor format
to use for this mailmerge.
==> Use the Left & Right arrow keys to select output format.
==> Press the Enter (or Return) key.
The Select Request window will appear asking for the select condition
to choose which entries you wish to use. To exit this window at any
time without continuing with mailmerge press the ESC key.
FIELD
OPERATOR
SEARCH KEY
CONFIRMATION
FIELD
The FIELD box allows you to select which field of the database you
wish condition to match. You may use your Left & Right arrow keys to
choose one of the fields, which are as follows:
LAST NAME BUS. PHONE #
COMPANY HOME PHONE #
CITY CATEGORY 1
STATE CATEGORY 2
ZIPCODE CATEGORY 3
OPTION ENTRY DATE
PRINT DATE
When the desired FIELD is displayed:
==> Press the Enter (or Return) key.
OPERATOR
The OPERATOR box allows you to select an equation operator for
condition. You may use your Left & Right arrow keys to choose
one of the fields, which are as follows:
IS EQUAL TO search key
IS NOT EQUAL TO search key
IS GREATER THAN search key
IS GREATER OR EQUAL TO search key
IS LESS THAN search key
IS LESS OR EQUAL TO search key
IS GREATER THAN search key1 & IS LESS THAN search key2
IS GREATER OR EQUAL TO search key1 & IS LESS OR EQUAL TO search key2
IS LESS THAN search key1 & IS GREATER THAN search key2
IS LESS OR EQUAL TO search key1 & IS GREATER OR EQUAL TO search key2
==> When the desired OPERATOR is displayed, press the Enter key.
SEARCH KEY
The SEARCH KEY box contains text for the select condition. There
may be one or two SEARCH KEY depending on the OPERATOR box. Please
note that when matching the select condition it does not matter
whether text is in upper or lower case.
==> Enter the text for the select condition and press the Enter key.
CONFIRMATION
The CONFIRMATION box can be set ON or OFF by using your Left & Right
arrow keys. By selecting the ON status, all entries matching the
select condition will be displayed and you can pick and choose which
of these you wish mailmerge. If you select CONFIRMATION OFF status
all entries matching the select condition will be ready to be
mailmerged.
A final Confirmation window will be displayed. To continue and
mailmerge:
==> Highlight Ok by typing O or use the Up & Down arrow keys then
press the Enter (or Return) key.
or to exit without doing mailmerge:
==> Highlight Cancel by typing C or use the Up & Down arrow keys then
press the Enter (or Return) key.
3.12 - TABULATE ENTRIES
To find out how many entries there are that match the select condition:
==> Go to the third pull-down menu in the ENTRY MENU BAR with the
title Select.
==> Type T or use the Up & Down arrow keys to highlight the
selection Tabulate.
==> Press the Enter (or Return) key.
The Select Request window will appear asking for the select condition
to choose which entries you wish to use. To exit this window at any
time without continuing with tabulating press the ESC key.
FIELD
OPERATOR
SEARCH KEY
CONFIRMATION
FIELD
The FIELD box allows you to select which field of the database you
wish condition to match. You may use your arrow keys to choose one
of the fields, which are as follows:
LAST NAME BUS. PHONE #
COMPANY HOME PHONE #
CITY CATEGORY 1
STATE CATEGORY 2
ZIPCODE CATEGORY 3
OPTION ENTRY DATE
PRINT DATE
When the desired FIELD is displayed press the Enter (or Return) key.
OPERATOR
The OPERATOR box allows you to select an equation operator for
condition. You may use your Left & Right arrow keys to choose
one of the fields, which are as follows:
IS EQUAL TO search key
IS NOT EQUAL TO search key
IS GREATER THAN search key
IS GREATER OR EQUAL TO search key
IS LESS THAN search key
IS LESS OR EQUAL TO search key
IS GREATER THAN search key1 & IS LESS THAN search key2
IS GREATER OR EQUAL TO search key1 & IS LESS OR EQUAL TO search key2
IS LESS THAN search key1 & IS GREATER THAN search key2
IS LESS OR EQUAL TO search key1 & IS GREATER OR EQUAL TO search key2
When the desired OPERATOR is displayed:
==> Press the Enter (or Return) key.
SEARCH KEY
The SEARCH KEY box contains text for the select condition. There may
be one or two SEARCH KEY depending on the OPERATOR box. Please note
that when matching the select condition it does not matter whether
text is in upper or lower case.
==> Enter the text for the select condition and press the Enter key.
TAG STATUS
The TAG STATUS box can be set to the following three different options
by using the Left & Right arrow keys.
IGNORE TAG STATUS - All entries that match the above select condition
will be used.
ONLY WITH TAG ON - All entries that match the above select condition
and have their tag setting ON will be used.
ONLY WITH TAG OFF- All entries that match the above select condition
and have their tag setting OFF will be used.
A final Confirmation window will be displayed.
==> To continue and tabulate selected entries press the Enter key.
or
==> To exit without tabulating press the ESC key.
3.13 - MODIFY CATEGORY DESCRIPTIONS
Each database can have 3 categories and each category can have up
to 20 different selections. To change category headings and
selections.
==> Go to the fourth pull-down menu in the ENTRY MENU BAR
titled Options.
==> Type C or use the Up & Down arrow keys to highlight Categories.
==> Press the Enter (or Return) key.
A Request window will appear allowing you to modify the title of the
database and the category headings.
The Category selection window will then be displayed in which you
can change or add new selections in each category. When you have
completed your editing in this window:
==> Press the ESC key.
3.14 - MODIFY DATABASE ATTRIBUTES
To change the attribute defaults for the current database:
==> Go to the fourth pull-down menu in the ENTRY MENU BAR with the
title Options.
==> Type A or use the Up & Down arrow keys to highlight Attributes.
==> Press the Enter (or Return) key.
The database Attribute window will appear allowing you to change
the following:
WORK WITH DELETED ENTRIES
This option determines whether entries marked for deletion will be used
when viewing, editing, or printing.
VIEW ENTRY NOTES
This option allows you to decide whether the an entry's note page will
automatically be displayed.
AUTOMATIC CATEGORY HELP
This option allows you to decide whether the categorys' help windows
will automatically be displayed when editing an entry.
CATEGORY 1
This option determines whether Category 1 field is displayed and
active when viewing and editing an entry.
CATEGORY 2
This option determines whether Category 2 field is displayed and
active when viewing and editing an entry.
CATEGORY 3
This option determines whether Category 3 field is displayed and
active when viewing and editing an entry.
==> Press the Enter (or Return) key to save changes made.
or
==> Press the ESC key to exit without saving changes.
3.15 - SETTING DATABASE ENTRY FILTER
If you would like to work with just a certain section of a database,
you can set a filter on to use only the desired entries. To do this:
==> Go to the fourth pull-down menu in the ENTRY MENU BAR
titled Options.
==> Type F or use the Up & Down arrow keys to highlight the
selection Filter.
==> Press the Enter (or Return) key.
The Filter Request window will appear asking for the filter condition
to select which entries to use. To exit this window at any time
without continuing with setting the database filter, press the ESC key.
FIELD
OPERATOR
FILTER KEY
TAG STATUS
FIELD
The FIELD box allows you to select which field of the database you
wish condition to match. You may use your Left & Right arrow keys to
choose one of the fields, which are as follows:
LAST NAME BUS. PHONE #
COMPANY HOME PHONE #
CITY CATEGORY 1
STATE CATEGORY 2
ZIPCODE CATEGORY 3
OPTION ENTRY DATE
PRINT DATE
When the desired FIELD is displayed:
==> Press the Enter (or Return) key.
OPERATOR
The OPERATOR box allows you to select an equation operator for
condition. You may use your Left & Right arrow keys to choose
one of the fields, which are as follows:
IS EQUAL TO filter key
IS NOT EQUAL TO filter key
IS GREATER THAN filter key
IS GREATER OR EQUAL TO filter key
IS LESS THAN filter key
IS LESS OR EQUAL TO filter key
IS GREATER THAN filter key1 & IS LESS THAN filter key2
IS GREATER OR EQUAL TO filter key1 & IS LESS OR EQUAL TO filter key2
IS LESS THAN filter key1 & IS GREATER THAN filter key2
IS LESS OR EQUAL TO filter key1 & IS GREATER OR EQUAL TO filter key2
When the desired OPERATOR is displayed:
==> Press the Enter (or Return) key.
FILTER KEY
The FILTER KEY box contains text for the select condition. There
may be one or two FILTER KEYS depending on the OPERATOR box. Please
note that when matching the filter condition it does not matter
whether text is in upper or lower case.
==> Enter the text for the filter condition and press the Enter key.
TAG STATUS
The TAG STATUS box can be set to the following three different options
by using the Left & Right arrow keys.
IGNORE TAG STATUS
All entries that match the above filter condition will be used.
ONLY WITH TAG ON
All entries that match the above filter condition and have thier tag
setting ON will be used.
ONLY WITH TAG OFF
All entries that match the above filter condition and have thier tag
setting OFF will be used.
3.16 - SELECT SORT FIELD FOR DATABASE
A database can be sorted by almost any field, to change which field
the current database is sorted:
==> Go to the fourth pull-down menu in the ENTRY MENU BAR
titled Options.
==> Type S or use the Up & Down arrow keys to highlight the
selection Sort.
==> Press the Enter (or Return) key.
A Request window will appear prompting you to determine which field
and what direction the database should be sorted.
SORT BY
This selection determines which field is used to sort the database.
It may be any of the following:
NAME BUS. PHONE #
COMPANY HOME PHONE
CITY CATEGORY 1
STATE CATEGORY 2
ZIPCODE CATEGORY 3
OPTION ENTRY DATE
PRINT DATE
==> Press the Enter (or Return) key to save changes made.
or
==> Press the ESC key to exit without saving changes.
3.17 - DATABASE INFORMATION
To view the database and system information:
==> Go to the fourth pull-down menu in the ENTRY MENU BAR
titled Options.
==> Type I or use the Up & Down arrow keys to highlight the
selection Info.
==> Press the Enter (or Return) key.
An Information window will be displayed.
3.18 - DELETE DUPLICATE ENTRIES
Duplicate entries can be marked for deletion by using this option.
Note: To remove entries from a database use the Purge option.
==> Go to the fourth pull-down menu in the ENTRY MENU BAR
titled Options.
==> Type D or use the Up & Down arrow keys to highlight Dup Delete.
==> Press the Enter (or Return) key.
A Request Window will appear confirming your desire to delete
duplicate entries in the database.
To continue and delete duplicate entries:
==> Highlight Ok by typing O or move the Up & Down arrow keys.
==> Press the Enter (or Return) key.
To exit without deleting:
==> Highlight Cancel by typing C or move the Up & Down arrow keys.
==> Press the Enter (or Return) key.
3.19 - PURGE ENTRIES MARKED FOR DELETION
If you want to remove all entries in the database that are marked for
deletion:
==> Go to the fourth pull-down menu in the ENTRY MENU BAR with the
title Options.
==> Type P or use the Up & Down arrow keys to highlight the
selection Purge.
==> Press the Enter (or Return) key.
A Request Window will appear confirming your desire to remove all
entries marked for deletion.
To continue and purge deleted entries in this database:
==> Highlight Ok by typing O or move the Up & Down arrow keys.
==> Press the Enter (or Return) key.
To exit without purge:
==> Highlighting Cancel by typing C or move the Up & Down arrow keys.
==> Press the Enter (or Return) key.
ENTRY VIEWING & EDITING - Section IV
A database in ARROW is similar to a stack of cards, in which the
first entry in the database is the top card and the last entry is
the bottom card. These cards can be sorted in almost any manner by
name, company, city, state, zipcode, and etc.
There are two ways to view a database:
The first way is called the Edit Mode and allows you view one entry
at a time. The Edit Mode is used for all editing of individual
entries. The entry displayed is called the CURRENT ENTRY.
The other way is called the Scan Mode. You can view up to 18 entries
simultaneously. The arrows indicate the CURRENT ENTRY. In the Scan Mode
you can also toggle between the wide view and the narrow view:
Keys for moving between individual entries:
Up arrow key - Moves to the previous entry.
Down arrow key - Moves to the next entry.
Home key - Moves to the top of the database.
End key - Moves to the bottom of the database.
Ctrl PgUp - Continuous display of previous entries until a key is
pressed or the CURRENT ENTRY is at the top of the database.
Ctrl PgUp - Continuous display of next entries until a key is pressed
or the CURRENT ENTRY is at the bottom of the database.
Pg Up - Will display the previous screen of 18 entries in Scan Mode.
Pg Dn - Will display the next screen of 18 entries in Scan Mode.
4.1 - DIRECT EDITING MODE FUNCTIONS
ESC
Pressing the ESC (pronounced 'escape') key once will permit you to
select options in the ENTRY MENU BAR.
Pressing it again will place you at the top MASTER MENU BAR where
you may select among those options. Pressing it a third time will
return the Direct Editing mode of the current database.
4.2 - ADDING A NEW ENTRY
A
To add new entries to the database.
==> Press the A key.
The current database window will be placed in the Edit Mode and
cleared for you to type in a new entry. The Entry Date of the entry
will be set to the todays date. The database window will be returned
to the Scan Mode if you requested to add entries from the it. The
last entry you added will now be the CURRENT ENTRY.
4.3 - EDITING CURRENT ENTRY
E
To edit the CURRENT ENTRY of the database.
==> Press the E key.
The current database window will be placed in the Edit Mode and you
can modify information about this entry. The database window will be
returned to the Scan Mode if you requested to edit the CURRENT ENTRY
from the it.
4.4 - ADD NOTES TO AN ENTRY
N
Each entry in the database can have a page of additional information
attached to it. This information can be entered in a freestyle format
into the NOTES page. Text entered printed in Forms and Reports and
entries can be easily found by using the Search option in the ENTRY
MENU BAR. NOTES also support full math formulas similar to
spreadsheet programs. Lines in notes are is labeled A thru T.
4.5 - CHANGING TO EDIT MODE VIEW
Enter
If the the current database is in either the wide or narrow
Scan Mode view the:
==> Press the Enter (or Return) key.
This will place you in the Edit Mode displaying the CURRENT ENTRY.
4.6 - CHANGING TO SCAN MODE VIEWS
S
If the current database is in the Edit Mode view:
==> Press the S key.
This will place you in the Scan Mode. Further pressing of the S key
will toggle you between the wide and narrow Scan Mode views.
4.7 - DELETING ENTRIES
D
To mark an individual entry for deletion:
==> Press the D key.
If the entry is marked for deletion you may remove the mark of
deletion by again pressing the D key. To mark a series of entries
for deletion at once use the Delete selection in the Select option
in the ENTRY MENU BAR.
4.8 - TAGGING ENTRIES
T
The ability to TAG various entries provides an easy way to print,
copy, or edit in a freeform way. To set TAG ON for an individual entry:
==> Press the T key.
If the TAG is already set ON you may set it OFF by again by pressing
the T key. To set TAGS ON or OFF for a series of entries at once use
the Set tag and remoVe tags selections in the Select option in the
ENTRY MENU BAR.
4.9 - MODIFY ENTRY AND PRINT DATES
M
Entry and Print Dates'are automatically set by ARROW when a entry is
entered or is printed on a Form, respectively. To manually edit these
dates for an individual entry:
==> Press the M key.
To edit the Entry Date or the Print Date for a series of entries at
once use the Edit selection in the Select option in the ENTRY MENU BAR.
4.10 - COPYING ENTRIES TO ANOTHER DATABASE
C
To copy an individual entry, all entries, or to do Nth sample copying
for another database:
==> Press the C key.
A Selection window will then appear allowing to copy entries to
another database.
To copy a series of entries at once use the Copy selection in the
Select option in the ENTRY MENU BAR.
4.11 - FORM & LABEL PRINTING
F
To print Forms for the current entry, all entries, or to do
Nth Sampling:
==> Press the F key.
The Form Selection window will appear allowing you to choose the form
layout for printing. You may use the following keys to help you
highlight and make your selection:
# - Type the # of the form layout.
Up & Down arrow keys - Allows you to move up and down one at a time
between individual form titles.
PgUp & PgDn - The form selection window will display up to 9 form
titles. Use the PgUp and PgDn keys to page one screen up or
down respectively.
Esc - Press the Esc key to exit the Form Selection window without
choosing a selection.
==> Once your the title highlighted of the form layout you wish to
select, press the Enter (or Return) key.
The Printing Control window will appear allowing you to print your
forms, test for alignment, change printers, switch form layouts,
and/or print a Presort Report if you are doing a bulk sort mailing.
NOTE: To print forms for a series of entries at once use the Form
selection in the Select option in the ENTRY MENU BAR.
4.12 - REPORT PRINTING
R
To print Reports for the current entry, all entries, or to do
Nth Sampling:
==> Press the F key.
The Form Selection window will appear allowing you to choose the form
layout for printing. You may use the following keys to help you
highlight and make your selection:
# - Type the # of the report layout.
Up & Down arrow keys - Allows you to move up and down one at a time
between individual report titles.
PgUp & PgDn - The report selection window will display up to 9 report
titles. Use the PgUp and PgDn keys to page one screen up or
down respectively.
Esc - Press the Esc key to exit the Form Selection window without
choosing a selection.
==> Once your the title highlighted of the report layout you wish to
select, press the Enter (or Return) key.
The Printing Control window will appear allowing you to print your
report, change printers, or switch report layouts.
NOTE: To print a report for a series of entries at once use the
Report selection in the Select option in the ENTRY MENU BAR.
4.13 - MOVING BETWEEN DATABASES
1
To view and work with the Primary Database [1]:
==> Press the 1 key.
2
To view and work with the Secondary Database [2]:
==> Press the 2 key.
FORM EDITOR - Section V
ARROW Form Design Editor allows you to custom design layouts
for labels and forms with different font and size options. to
create or modify a form layout.
==>Go to the second pull-down menu in the MASTER MENU BAR
titled Design.
==>Type F or use the Up & Down arrow keys to highlight the
selection Form.
==>Press the Enter (or Return) key.
The Form Editor window will now appear and highlight the first
pull-down menu titled Form. The following will describe each
selection and form editing in detail.
5.1 - OPENING A FORM LAYOUT
Opening an existing form layout which you may view and edit.
==>Go to the first pull-down menu in the FORM EDITOR MENU BAR
titled Form.
==>Type O or use the Up & Down arrow keys to highlight the
selection Open.
==>Press the Enter (or Return) key.
The Form Selection window will appear allowing you to choose a
previously created form layout. You may use the following keys
to help you highlight and make your selection:
# - Type the # of the form.
Up & Down arrow keys - Allows you to move up and down one at a time
between individual titles.
PgUp & PgDn - The Form Selection window will display up to 9 titles.
Use the PgUp and PgDn keys to page one screen up or down
respectively.
Esc - Press the Esc key to exit the Form Selection window without
choosing a form layout.
Once your the title highlighted of the form layout you wish to open,
press the Enter (or Return) key.
The form layout will now be opened and displayed.
5.2 - CREATING A NEW FORM LAYOUT
You will want to create a new form layout:
==>Go to the first pull-down menu in the FORM EDITOR MENU BAR
titled Form.
==>Type C or use the Up & Down arrow keys to highlight the
selection Create.
==>Press the Enter (or Return) key.
The Layout window will be displayed prompting you to enter the
following parameters:
The # of the new database will be shown. Each database needs a title
that will make this database easy to find when opening it later.
PAGE LENGTH
If you are using continous labels then enter 0, otherwise enter the
length of the form in inches.
TOP MARGIN
This is spacing from the top edge of the page the the first line of
the form layout.
BOTTOM MARGIN
This is spacing from the bottom edge of the page the the last line of
the form layout.
LEFT OFFSET
This is allows to offset the first column of the printed page.
WIDTH
This is the width in inches of the label or form page.
HEIGHT
This is the height in inches of the label or form page.
LINES PER INCH
This form layout can be set at either 6 or 8 lines per inch.
FORMS ACROSS PAGE
If you are planning a label layout, this option allows you to have up
to 5 labels across.
SPACING BETWEEN FORMS ACROSS
This is the space in inches between multiple forms across.
SPACING BETWEEN FORMS DOWN
This is the space in inches of multiple forms down a page.
The form layout will now be displayed in the form editor window.
5.3 - SAVING A FORM LAYOUTS
*** This option is disabled in ARROW Version 2.5 (UNREGISTERED) ***
*** To get ARROW Version 3.0 (REGISTERED) see Section 1.4 ***
To save an new form layout or resave existing form layout:
==>Go to the first pull-down menu in the FORM EDITOR MENU BAR
titled Form.
==>Type S or use the Up & Down arrow keys to highlight the
selection Save.
==>Press the Enter (or Return) key.
or to save an existing form layout as a new one:
==>Go to the first pull-down menu in the FORM EDITOR MENU BAR
titled Form.
==>Type A or use the Up & Down arrow keys to highlight the
selection save As.
==>Press the Enter (or Return) key.
The Form Selection window will appear allowing you to choose a
previously created form layout. You may use the following keys to
help you highlight and make your selection:
# - Type the # of the form.
Up & Down arrow keys - Allows you to move up and down one at a time
between individual titles.
PgUp & PgDn - The Form Selection window will display up to 9 titles.
Use the PgUp and PgDn keys to page one screen up or down
respectively.
Esc - Press the Esc key to exit the Form Selection window without
choosing a form layout.
Once your the title highlighted of the form layout you wish to open,
press the Enter (or Return) key.
The form layout will now be opened and displayed.
5.4 - DELETE A FORM LAYOUT
To delete a form layout:
==>Go to the first pull-down menu in the FORM EDITOR MENU BAR
titled Form.
==>Type D or use the Up & Down arrow keys to highlight the
selection Delete.
==>Press the Enter (or Return) key.
The Form Selection window will appear allowing you to choose the form
layout you want to delete. You may use the following keys to help you
highlight and make your selection:
# - Type the # of the form.
Up & Down arrow keys - Allows you to move up and down one at a time
between individual titles.
PgUp & PgDn - The Form Selection window will display up to 9 titles.
Use the PgUp and PgDn keys to page one screen up or down
respectively.
Esc - Press the Esc key to exit the Form Selection window without
choosing a form layout.
Once your the title highlighted of the form layout you wish to delete,
press the Enter (or Return) key.
A Request Window will appear confirming your desire to delete the
selected form layout. To continue and delete this form:
==>Highlight Ok by typing O or move the Up & Down arrow keys.
==>Press the Enter (or Return) key.
To exit without deleting:
==>Highlighting Cancel by typing C or move the Up & Down arrow keys.
==>Press the Enter (or Return) key.
5.5 - EXIT FORM LAYOUT EDITOR
To exit the Form Layout Editor:
==>Go to the first pull-down menu in the FORM EDITOR MENU BAR
titled Form.
==>Type E or use the Up & Down arrow keys to highlight the
selection Exit.
==>Press the Enter (or Return) key.
You now be returned to the MASTER MENU BAR.
5.6 - MODIFY PAGE SIZE & MARGINS
You will want to modify the size of the current form layout:
==>Go to the second pull-down menu in the FORM EDITOR MENU BAR
titled Options.
==>Type L or use the Up & Down arrow keys to highlight the
selection Layout.
==>Press the Enter (or Return) key.
The Layout window will be displayed prompting you to enter the
following parameters:
The # of the new database will be shown. Each database needs a title
that will make this database easy to find when opening it later.
PAGE LENGTH
If you are using continous labels then enter 0, otherwise enter the
length of the form in inches.
TOP MARGIN
This is spacing from the top edge of the page the the first line of
the form layout.
BOTTOM MARGIN
This is spacing from the bottom edge of the page the the last line of
the form layout.
LEFT OFFSET
This is allows to offset the first column of the printed page.
WIDTH
This is the width in inches of the label or form page.
HEIGHT
This is the height in inches of the label or form page.
LINES PER INCH
This form layout can be set at either 6 or 8 lines per inch.
FORMS ACROSS PAGE
If you are planning a label layout, this option allows you to have up
to 5 labels across.
SPACING BETWEEN FORMS ACROSS
This is the space in inches between multiple forms across.
SPACING BETWEEN FORMS DOWN
This is the space in inches of multiple forms down a page.
The new form layout will now be displayed in the form editor window.
5.7 - PRINT SAMPLE FORMS
You will want to print a sample of the current form layout:
==>Go to the second pull-down menu in the FORM EDITOR MENU BAR
titled Options.
==>Type S or use the Up & Down arrow keys to highlight the
selection Sample.
==>Press the Enter (or Return) key.
5.8 - COPYING A FORM LAYOUT TO DESTINATION
The copy To option allows you to copy a form layout to another drive
or directory.
==>Go to the second pull-down menu in the FORM EDITOR BAR
titled Options.
==>Type T or use the Up & Down arrow keys to highlight the
selection copy To.
==>Press the Enter (or Return) key.
The Form Selection window will appear allowing you to choose the
form layout you wish to copy. You may use the following keys
to help you highlight and make your selection:
# - Type the # of the form layout.
Up & Down arrow keys - Allows you to move up and down one at a time
between individual form titles.
PgUp & PgDn - The Form Selection window will display up to 9 form
titles. Use the PgUp and PgDn keys to page one screen up or
down respectively.
Esc - Press the Esc key to exit the Form Selection window without
choosing a form layout.
Once you have the title highlighted of the form layout you wish to copy
press the Enter (or Return) key.
A Request Window will now appear prompting you the desired destination
drive and/or directory or press the Esc key to exit without copying
form layout.
Example: A:\
A Request window will appear confirming you desire to copy this
form layout. To continue and copy:
==>Highlighting Ok by typing O or move the Up & Down arrow keys.
==>Press the Enter (or Return) key.
To exit without copying this form layout:
==>Highlighting Cancel by typing C or move the Up & Down arrow keys.
==>Press the Enter (or Return) key.
5.9 - COPYING A FORM LAYOUT FROM SOURCE
The copy From option allows you to copy a form layout from another
drive or directory.
==>Go to the second pull-down menu in the FORM EDITOR MENU BAR
titled Options.
==>Type F or use the Up & Down arrow keys to highlight the selection
copy From.
==>Press the Enter (or Return) key.
A Request Window will now appear prompting you the desired source drive
and/or directory or press the Esc key to exit without copying the form
layout.
Example: A:\
This will copy the form layout from the root directory of diskette in
drive A:.
The Form Selection window will appear allowing you to choose the form
layout you wish to copy. You may use the following keys to help you
highlight and make your selection:
# - Type the # of the form layout.
Up & Down arrow keys - Allows you to move up and down one at a time
between individual form titles.
PgUp & PgDn - The Form Selection window will display up to 9 form
layout titles. Use the PgUp and PgDn keys to page one screen
up or down respectively.
Esc - Press the Esc key to exit the Form Selection window without
choosing a form layout.
Once you have the title highlighted of the form layout you wish to copy
press the Enter (or Return) key.
ARROW will now copy the form layout.
Keys for moving between individual entries:
Up arrow key - Moves to the previous entry.
Down arrow key - Moves to the next entry.
5.10 - FORM LAYOUT VIEWING & EDITING
Keys for moving around the form layout:
Up arrow key - Moves up 1 line.
Down arrow key - Moves down 1 line.
Left arrow key - Moves left 1 space.
Right arrow key - Moves right 1 space.
SHIFT-TAB - Moves left 5 spaces.
TAB - Moves right 5 spaces.
ADDING A PRINT FIELD
To add a print field:
==>Move cursor to the desired print position.
==>Press the Enter (or Return) key.
A Request Window will appear allowing you to choose what is to
printed. You may select:
TEXT
NAME (FIRST LAST)
NAME (LAST, FIRST)
COMPANY
1ST ADDRESS LINE
2ND ADDRESS LINE
CITY, STATE ZIP
CITY
STATE
ZIP
OPTION
BUS. PHONE #
HOME PHONE #
CATEGORY 1
CATEGORY 2
CATEGORY 3
ENTRY DATE
PRINT DATE
NOTE PAD LINES A-T
==>Use the Left & Right arrow keys to select print field.
==>Press the Enter (or Return) key.
The next Request Window will allow you to modify the following
settings:
TYPEFACE
You may select to up to 4 typefaces.
FONT PITCH
Select from PICA, ELITE, CONDENSED.
ALIGNMENT
Select between LEFT and CENTER. The latter will center text between
the current cursor position and the right edge of the form or label.
CASE
Select from the following:
VERBATIM - Prints just as it was entered.
PROPER - Capitalizes first character of all words.
UPPER - Prints in all upper case.
LOWER - Prints in all lower case.
SQUEEZE
You may turn the Squeeze mode ON or OFF. All lines below this line
move up if the database entry field is blank when this is set ON.
This option allows you to print forms without having empty blank lines
in the middle of the form.
Examples:
SQUEEZE MODE OFF
Jane Doe
123 Main Street
Waterbury, CT 06705
SQUEEZE MODE ON
Jane Doe
123 Main Street
Waterbury, CT 06705
Now the last Request Window will appear allowing you to change the
following print attributes.
BOLDFACE
ITALICS
NEAR LETTER QUALITY
UNDERLINE
DOUBLE WIDTH
DOUBLE HEIGHT
USER DEFINE
EDITING A PRINT FIELD
To edit an existing print field:
==>Move cursor on top of desired print field.
==>Press the Enter (or Return) key.
The Request Windows will now appear allowing you to change the
settings of this print field.
DELETE A PRINT FIELD
To delete an existing print field:
==>Move cursor on top of desired print field.
==>Press the Delete key.
GOING TO THE EDITOR MENU BAR
==>Press the ESC key.
REPORT EDITOR - Section VI
ARROW Report Design Editor allows you to custom design layouts
for reports with different font and size options. to create or modify
a report layout.
==>Go to the second pull-down menu in the MASTER MENU BAR
titled Design.
==>Type R or use the Up & Down arrow keys to highlight the
selection Report.
==>Press the Enter (or Return) key.
The Report Editor window will now appear and highlight the first
pull-down menu titled Report. The following will describe each
selection and report editing in detail.
6.1 - OPENING A REPORT LAYOUT
Opening an existing report layout which you may view and edit.
==>Go to the first pull-down menu in the FORM EDITOR MENU BAR
titled Report.
==>Type O or use the Up & Down arrow keys to highlight the
selection Open.
==>Press the Enter (or Return) key.
The Report Selection window will appear allowing you to choose a
previously created report layout. You may use the following keys
to help you highlight and make your selection:
# - Type the # of the report.
Up & Down arrow keys - Allows you to move up and down one at a time
between individual titles.
PgUp & PgDn - The Report Selection window will display up to 9 titles.
Use the PgUp and PgDn keys to page one screen up or down
respectively.
Esc - Press the Esc key to exit the Report Selection window without
choosing a report layout.
Once your the title highlighted of the report layout you wish to open,
press the Enter (or Return) key.
The report layout will now be opened and displayed.
6.2 - CREATING A NEW REPORT LAYOUT
You will want to create a new report layout:
==>Go to the first pull-down menu in the FORM EDITOR MENU BAR
titled Report.
==>Type C or use the Up & Down arrow keys to highlight the
selection Create.
==>Press the Enter (or Return) key.
The Layout window will be displayed prompting you to enter the
following parameters:
PAGE LENGTH
This is the length in inches of the report page.
WIDTH
This is the width in inches of the report page.
TOP MARGIN
This is spacing from the top edge of the page the the first line of
the report layout.
BOTTOM MARGIN
This is spacing from the bottom edge of the page the the last line of
the report layout.
LEFT OFFSET
This is allows to offset the first column of the printed page.
HEIGHT
This is the # of lines for each entry on the report page.
LINES PER INCH
This report layout can be set at either 6 or 8 lines per inch.
REPORT HEADLINE
This is the title that will appear at the top of each report page.
The report layout will now be displayed in the report editor window.
6.3 - SAVING A REPORT LAYOUTS
*** This option is disabled in ARROW Version 2.5 (UNREGISTERED) ***
*** To get ARROW Version 3.0 (REGISTERED) see Section 1.4 ***
To save a new report layout or resave an existing report layout:
==>Go to the first pull-down menu in the FORM EDITOR MENU BAR
titled Report.
==>Type S or use the Up & Down arrow keys to highlight the
selection Save.
==>Press the Enter (or Return) key.
or to save an existing report layout as a new one:
==>Go to the first pull-down menu in the FORM EDITOR MENU BAR
titled Report.
==>Type A or use the Up & Down arrow keys to highlight the
selection save As.
==>Press the Enter (or Return) key.
The Report Selection window will appear allowing you to choose
a previously created report layout. You may use the following
keys to help you highlight and make your selection:
# - Type the # of the report.
Up & Down arrow keys - Allows you to move up and down one at a time
between individual titles.
PgUp & PgDn - The Report Selection window will display up to 9 titles.
Use the PgUp and PgDn keys to page one screen up or down
respectively.
Esc - Press the Esc key to exit the Report Selection window without
choosing a report layout.
Once your the title highlighted of the report layout you wish to open,
press the Enter (or Return) key.
The report layout will now be opened and displayed.
6.4 - DELETE A REPORT LAYOUT
To delete a report layout:
==>Go to the first pull-down menu in the FORM EDITOR MENU BAR
titled Report.
==>Type D or use the Up & Down arrow keys to highlight the
selection Delete.
==>Press the Enter (or Return) key.
The Report Selection window will appear allowing you to choose the
report layout you want to delete. You may use the following keys to
help you highlight and make your selection:
# - Type the # of the report.
Up & Down arrow keys - Allows you to move up and down one at a time
between individual titles.
PgUp & PgDn - The Report Selection window will display up to 9 titles.
Use the PgUp and PgDn keys to page one screen up or down
respectively.
Esc - Press the Esc key to exit the Report Selection window without
choosing a report layout.
Once your the title highlighted of the report layout you wish to
delete, press the Enter (or Return) key.
A Request Window will appear confirming your desire to delete the
selected report layout. To continue and delete this report:
==>Highlighting Ok by typing O or move the Up & Down arrow keys.
==>Press the Enter (or Return) key.
To exit without deleting:
==>Highlighting Cancel by typing C or move the Up & Down arrow keys.
==>Press the Enter (or Return) key.
6.5 - EXIT REPORT LAYOUT EDITOR
To exit the Report Layout Editor:
==>Go to the first pull-down menu in the FORM EDITOR MENU BAR
titled Report.
==>Type E or use the Up & Down arrow keys to highlight the
selection Exit.
==>Press the Enter (or Return) key.
You now be returned to the MASTER MENU BAR.
6.6 - MODIFY PAGE SIZE & MARGINS
To modify the size of the current report layout:
==>Go to the second pull-down menu in the FORM EDITOR MENU BAR
titled Options.
==>Type L or use the Up & Down arrow keys to highlight the
selection Layout.
==>Press the Enter (or Return) key.
The Layout window will be displayed prompting you to enter the
following parameters:
PAGE LENGTH
This is the length in inches of the report page.
WIDTH
This is the width in inches of the report page.
TOP MARGIN
This is spacing from the top edge of the page the the first line of
the report layout.
BOTTOM MARGIN
This is spacing from the bottom edge of the page the the last line of
the report layout.
LEFT OFFSET
This is allows to offset the first column of the printed page.
HEIGHT
This is the # of lines for each entry on the report page.
LINES PER INCH
This report layout can be set at either 6 or 8 lines per inch.
REPORT HEADLINE
This is the title that will appear at the top of each report page.
The new report layout will now be displayed in the report
editor window.
6.7 - MODIFY REPORT ATTRIBUTES
To change the heading,title, or grouping of entries in the current
report layout:
==>Go to the second pull-down menu in the REPORT EDITOR MENU BAR
titled Options.
==>Type A or use the Up & Down arrow keys to highlight the
selection Attributes.
==>Press the Enter (or Return) key.
PRINT REPORT TITLE
If enabled, the report headline will be printed on the top line of
every page.
PRINT REPORT DATE
If enabled, the date of the report will be printed on the top line of
every page.
PRINT PAGE NUMBERS
If enabled, the report page # will be printed on the top line of
every page.
PRINT FIELD TITLES
If enabled, the field titles will be printed on the top line of
every page.
GROUP ENTRIES
If enabled, entries will be grouped together determined by the field
that the database is sorted.
6.8 - PRINT SAMPLE REPORT
To print a sample of the current report layout:
==>Go to the second pull-down menu in the REPORT EDITOR MENU BAR
with the title Options.
==>Type S or use the Up & Down arrow keys to highlight the
selection Sample.
==>Press the Enter (or Return) key.
6.9 - COPYING A REPORT LAYOUT TO DESTINATION
The copy To option allows you to copy a report layout to another drive
or directory.
==>Go to the second pull-down menu in the FORM EDITOR BAR
titled Options.
==>Type T or use the Up & Down arrow keys to highlight the
selection copy To.
==>Press the Enter (or Return) key.
The Report Selection window will appear allowing you to choose the
report layout you wish to copy. You may use the following keys to
help you highlight and make your selection:
# - Type the # of the report layout.
Up & Down arrow keys - Allows you to move up and down one at a time
between individual report titles.
PgUp & PgDn - The Report Selection window will display up to 9 report
titles. Use the PgUp and PgDn keys to page one screen
up or down respectively.
Esc - Press the Esc key to exit the Report Selection window without
choosing a report layout.
Once you have the title highlighted of the report layout you wish
to copy press the Enter (or Return) key.
A Request Window will now appear prompting you the desired destination
drive and/or directory or press the Esc key to exit without copying
report layout.
Example: A:\
A Request window will appear confirming you desire to copy this report
layout. To continue and copy:
==>Highlighting Ok by typing O or move the Up & Down arrow keys.
==>Press the Enter (or Return) key.
To exit without copying this report layout:
==>Highlighting Cancel by typing C or move the Up & Down down
arrow keys.
==>Press the Enter (or Return) key.
6.10 - COPYING A REPORT LAYOUT FROM SOURCE
The copy From option allows you to copy a report layout from another
drive or directory.
==>Go to the second pull-down menu in the REPORT EDITOR MENU BAR
titled Options.
==>Type F or use the Up & Down arrow keys to highlight the
selection copy From.
==>Press the Enter (or Return) key.
A Request Window will now appear prompting you the desired source
drive and/or directory or press the Esc key to exit without copying
the report layout.
Example: A:\
This will copy the report layout from the root directory of diskette
in drive A:.
The Report Selection window will appear allowing you to choose the
report layout you wish to copy. You may use the following keys to
help you highlight and make your selection:
# - Type the # of the report layout.
Up & Down arrow keys - Allows you to move up and down one at a time
between individual report titles.
PgUp & PgDn - The Report Selection window will display up to 9 report
layout titles. Use the PgUp and PgDn keys to page one screen
up or down respectively.
Esc - Press the Esc key to exit the Report Selection window without
choosing a report layout.
Once you have the title highlighted of the report layout you wish to
copy press the Enter (or Return) key.
ARROW will now copy the report layout.
6.11 - REPORT LAYOUT VIEWING & EDITING
Keys for moving around the report layout:
Up arrow key - Moves up 1 line.
Down arrow key - Moves down 1 line.
Left arrow key - Moves left 1 space.
Right arrow key - Moves right 1 space.
SHIFT-TAB - Moves left 5 spaces.
TAB - Moves right 5 spaces.
ADDING A PRINT FIELD
To add a print field:
==>Move cursor to the desired print position.
==>Press the Enter (or Return) key.
A Request Window will appear allowing you to choose what is to
printed. You may select:
TEXT
NAME (FIRST LAST)
NAME (LAST, FIRST)
COMPANY
1ST ADDRESS LINE
2ND ADDRESS LINE
CITY, STATE ZIP
CITY
STATE
ZIP
OPTION
BUS. PHONE #
HOME PHONE #
CATEGORY 1
CATEGORY 2
CATEGORY 3
ENTRY DATE
PRINT DATE
NOTE PAD LINES A-T
Use the Left & Right arrow keys to select print field.
==>Press the Enter (or Return) key.
The next Request Window will allow you to modify the
following settings:
TYPEFACE
You may select to up to 4 typefaces.
FONT PITCH
Select from PICA, ELITE, CONDENSED.
ALIGNMENT
Select between LEFT and CENTER. The latter will center text between
the current cursor position and the right edge of the report.
CASE
Select from the following:
VERBATIM - Prints just as it was entered.
PROPER - Capitalizes first character of all words.
UPPER - Prints in all upper case.
LOWER - Prints in all lower case.
SQUEEZE
You may turn the Squeeze mode ON or OFF. All lines below this line
move up if the database entry field is blank when this is set ON. This
option allows you to print forms without having empty blank lines.
Examples:
SQUEEZE MODE OFF
Jane Doe
123 Main Street
Waterbury, CT 06705
SQUEEZE MODE ON
Jane Doe
123 Main Street
Waterbury, CT 06705
Now the last Request Window will appear allowing you to change the
following print attributes.
BOLDFACE
ITALICS
NEAR LETTER QUALITY
UNDERLINE
DOUBLE WIDTH
DOUBLE HEIGHT
USER DEFINE
EDITING A PRINT FIELD
To edit an existing print field:
==>Move cursor on top of desired print field.
==> Press the Enter (or Return) key.
The Request Windows will now appear allowing you to change
the settings of this print field.
DELETE A PRINT FIELD
To delete an existing print field:
==>Move cursor on top of desired print field.
==>Press the Delete key.
GOING TO THE EDITOR MENU BAR
==>Press the ESC key.
MACROS - Section VII
OVERVIEW
Macros allow you to learn and play back your frequently use procedures.
You can create and use up to 26 Macros which assigned to the keys
Alt-A thru Alt-Z. A Macro can contain up to 250 individual keystrokes
and may include a function key or another Macro key.
The following example will show you how to create and then use a Macro:
CREATE A SAMPLE MACRO
==>Go to the first pull-down menu in the MASTER MENU BAR
titled Database.
==>Press the F2 Function Key.
The Macro Selection Window will appear allowing you to select which
key (ALT-A thru ALT-Z) to assign the macro to. We will assign our
Macro to the ALT-A key which is currently displayed, so:
==>Press the Enter (or Return) key.
All key strokes are now being recorded for use in this Macro.
==>Type O or use the Up & Down arrow keys to highlight
the selection Open.
==>Press the Enter (or Return) key.
The Database Selection window will now appear.
==>Select a database by typing the # of database or use the Up & Down
arrow keys to highlight the selection.
==>Press the Enter (or Return) key.
The database will now be opened an displayed. We will now close the
database, so:
==>Press the ESC key to go to the ENTRY MENU BAR.
==>Type C or use the Up & Down arrow keys to highlight
the selection Close.
==>Press the Enter (or Return) key.
The database will now close. We will now stop the Macro recording
mode, to do this:
==>Press the F2 Function Key.
A Request window will now appear allowing you to enter a description
of the Macro you just created.
==>Type SAMPLE MACRO.
==>Press the Enter (or Return) key.
The macro has now been saved for later use.
7.3 - USING THE SAMPLE MACRO
The sample MACRO that was created is a very simple one.
To use a macro:
==>Press and hold the ALT key then at the same time press the A key.
The MACRO will run very quickly opening and displaying the database,
then closing it.
7.4 - AUTO MACROS
Macros can be made so they can be automatically run when you
start ARROW. The sample Macro that was created previously in
this chapter can do this.
To automatically run this Macro.
==>At the DOS prompt type ARROW A and press the Enter (or Return) key.
ARROW will be begin and the Macro assigned to the ALT-A key will
start running.
NOTE PAGE FORMULAS - Section VIII
All note page formulas must start with an = (equal sign).
8.1 - STANDARD MATH OPERATORS:
+ Addition
- Subtraction
* Multiplication
/ Division
^ Exponential
You may have up 7 levels of parenthesises.
8.2 - STANDARD MATH FUNCTIONS:
ABS(x) absolute value of x
COS(x) cosine of x in radiants
LOG(x) base 10 logarithm of x
RND(x) x rounded to the nearest whole number
SIN(x) sine of x in radiants
SQR(x) square root of x
SUM(x..y) sums values of lines x thru y
TAN(x) tangent of x in radiants
TRC(x) whole number of x