Dec 162017
 
NameVm is an extensive name/address program. Stores information in dBase compatible files.
File NAMEVM.ZIP from The Programmer’s Corner in
Category Databases and related files
NameVm is an extensive name/address program. Stores information in dBase compatible files.
File Name File Size Zip Size Zip Type
ACCT.NTX 2048 488 deflated
APPT.DBF 488 221 deflated
APPT.DBT 1132 407 deflated
APPTDATE.NTX 2048 700 deflated
APPTUSER.NTX 2048 701 deflated
BUSINESS.LBL 1034 140 deflated
COMPANY.NTX 2048 498 deflated
FORM.DBF 160 58 deflated
FORM.DBT 1287 480 deflated
HOME.LBL 1034 108 deflated
LNAME.NTX 2048 436 deflated
MANUAL.DOC 149015 35790 deflated
NAME.DBF 4841 1346 deflated
NAME.DBT 3109 1277 deflated
PLIST.DBF 344 39 deflated
QUERIES.DBF 131 46 deflated
README.1ST 1075 636 deflated
ROLODEX.LBL 1034 209 deflated
ST.NTX 2048 580 deflated
STATE.DBF 1640 618 deflated
S_ROLO.LBL 1034 153 deflated
TODO.DBF 227 88 deflated
TODO.NTX 2048 154 deflated
TODOD.NTX 2048 125 deflated
TODOP.NTX 2048 226 deflated
VMCNA.EXE 370635 167409 deflated

Download File NAMEVM.ZIP Here

Contents of the MANUAL.DOC file

























NAME AND ADDRESS SYSTEM

USER MANUAL AND REFERENCE GUIDE








By: VITRON Management Consulting, Inc.
11-33 Jackson Avenue
Scarsdale, New York 10583
(914) 793-0042

Electronic Bulletin Board: (914) 779-4273




(c) Copyright 1991, VITRON Management Consulting, Inc.
All Rights Reserved.




TABLE OF CONTENTS

LICENSE AGREEMENT ................................... i.

INSTALLATION INSTRUCTIONS ........................... ii.

NAME/ADDRESS SYSTEM FILES ........................... iii.

STARTING NAME & ADDRESS ............................. 1.

THE MAIN MENU ....................................... 3.
The Delete Option ................................. 4.
The Search Option ................................. 4.
- Fields Contents Match ......................... 5.
- Memo Contents ................................. 8.
The Key Option .................................... 8.
The Table Option .................................. 9.
- Business Data and Home Data ...................10.
- Browse All or Select Certain Fields ...........10.
-- Select Certain Fields ....................11.
-- The Browse Window (Table-View) ...........11.
-- Navigation Keys ..........................13.
-- Quit .....................................14.
-- Goto .....................................14.
-- Locate ...................................15.
-- Vertical View ............................15.
-- Pressing ENTER When in Browse ............16.
-- Delete ...................................16.
-- What is a Record "Flagged" for Deletion? .16.
The Hard Option ...................................17.
- Record Had Memo Attached? .....................17.
The View Option ...................................19.
The Query Option ..................................19.
- Build a New Query .............................21.
The Memo Option ...................................26.
The Other Option ..................................27.
1) Index Files ..................................29.
2) Change Sequence ..............................29.
3) Produce Reports ..............................29.
- Labels & Rolodex ..........................29.
-- Open Label File ......................31.
-- Tag Records to Print .................32.
-- Build or Modify Query ................32.
- Reports & Lists ...........................33.
-- Pick Fields to List ..................34.
-- Output List ..........................34.
4) ToDo List ....................................35.
- Add .......................................37.
- Edit ......................................37.
- F2 For Lookups ............................37.
- Delete ....................................37.
- Filter ....................................38.
- Memo ......................................38.
- Print .....................................38.
- Order .....................................38.

TABLE OF CONTENTS (continued)

5) Form Letters .................................38.
- Select Form ...............................39.
- Create New Form ...........................40.
- Delete Forms ..............................41.
- About Packing Memo Files ..................42.
- Edit Current Form .........................42.
- Print Form Letters ........................42.
- Width of Form .............................43.
- Output To .................................43.
- Assign Printer Port .......................43.
- Filter ....................................43
6) Appointments .................................44.
- Direction Keys ............................44.
- Selection Keys ............................44
- Menu Keys .................................45.
- Adding/Editing/Viewing Appointments .......45.
- Printing Appointments .....................46.
- Deleting Appointments .....................46.
- Browse Appointments .......................47.
The Add Option ....................................47.
The Update Option .................................47.
Starting Fresh ....................................47.
A Note About the Codes Fields .....................48.

ACKNOWLEDGEMENTS ....................................49.

REGISTRATION ........................................50.

REGISTRATION FORM ...................................51.






















(c) Copyright 1991, VITRON Management Consulting, Inc.
All Rights Reserved.

IMPORTANT! READ THIS BEFORE USING THE NAME/ADDRESS SYSTEM
END-USER LICENCE AGREEMENT

The software and documentation are distributed as "SHAREWARE" and are
provided to you on the condition that you agree with VITRON Management Con-
sulting, Inc., hereinafter referred to as VITRON, to the terms and conditions
as set forth below. READ THIS USER LICENSE AGREEMENT CAREFULLY. YOU WILL BE
BOUND BY THE TERMS OF THIS AGREEMENT IF YOU USE THE SYSTEM EVEN ONLY ONCE.
If you do not agree to the terms contained herein, do not use the system.
VITRON grants, and you hereby accept, a personal non-exclusive license
to use the software program and associated documentation in this package, or
any part of it ("Licensed Product"), subject to the following terms and con-
ditions:

1. LICENSE
You may use this system and its associated documentation for a period of
thirty days (30) on a trial basis only. If you decide to keep it and continu-
ing using it, you must register and pay for this Licensed Product. The soft-
ware and its associated documentation are copyrighted by VITRON and are on
file with the Copyright Office of the Library of Congress. Modifications to
the software or its documentation without the expressed, written approval of
VITRON are in violation of Federal Copyright Law and may subject the in-
fringer to both civil and criminal penalties.

2. The software program and its associated documentation are provided
"AS IS" without warranty of any kind, either expressed or implied, including
but not limited to the implied warranty of merchantability and fitness for a
particular purpose. The entire risk as to the quality and performance of the
program is with you. Should the program prove defective, you and not VITRON
assume the entire cost of all necessary servicing, repair or correction.
Some states do not allow the exclusion of implied warranties, so the
above exclusion may not apply to you. This warranty gives you specific legal
rights, and you may also have other rights which vary from state to state.
VITRON does not warrant that the functions contained in the program will
meet your requirements or that the operation of the program will be uninter-
rupted or error free. Neither VITRON or anyone else who has been involved in
the creation or production of this product will be liable for any direct, in-
direct, incidental, special or consequential damages, whether arising out of
the use or inability to use this product, or any breach of a warranty, and
VITRON will have no responsibility except to replace the diskette pursuant to
this limited warranty (or, at its option, provide another copy) to REGISTERED
USERS ONLY. UNREGISTERED USERS ARE ENTITLED TO NO WARRANTIES AND TO NO SUP-
PORT WHATSOEVER.
No sales personnel or other representatives of any party involved in the
distribution of the Licensed Product is authorized by VITRON to make any war-
ranties with respect to the diskette or the Licensed Product beyond those
contained in this Agreement. Oral statements do not constitute warranties,
shall not be relied upon by you, and are not part of this Agreement. The en-
tire agreement between VITRON and you is embodied in this Agreement.
If any provision of this license agreement is determined to be invalid
under any applicable statute or rule of law, it shall be deemed omitted and
the remaining provisions shall continue in full force and effect. This Agree-
ment is governed by and construed in accordance with the laws of the State of
New York.
i.

INSTALLATION INSTRUCTIONS

This system is specifically intended to run on a hard disk. If you do
not have a hard disk, do not attempt to run this system since no provisions
have been made to operate this system on a diskette-based-only computer.
The system includes an installation batch file program that does the
following:

(a) creates the appropriate directory on the C: drive
(b) copies the files into that directory
(c) decompresses the files copied into the directory

The files on the distribution diskette are COMPRESSED. You must use the
INSTALL procedure to install the system. Do NOT attempt to run the system
from the diskette as it will not function.
If you are familiar with DOS BATCH files, you may change the INSTALL.BAT
file to change the drive and/or directory on your own.
However, do not attempt to change this file unless you know what you are
doing.
To install VITRON's Name/Address System, start you computer as normal.
At you DOS prompt, insert the diskette into your A: drive. Then, type the
following:

A:INSTALL and press ENTER

Don't forget to put the colon (:) after the letter A. No spaces in the above
command either.
That's all there is to it. The install procedure first will create a di-
rectory on your C: drive named:

\VMCNA

It will then copy the files from the diskette into this directory. It
will then decompress the system files.
You are now ready to begin running VITRON's NAME/ADDRESS SYSTEM. (See
page 1 of this manual.)


IMPORTANT! IMPORTANT! IMPORTANT!

THE BULLETIN BOARD VERSION DOES NOT INCLUDE THE INSTALL.BAT PROGRAM.

FOR THOSE OF YOU WHO RECEIVED THIS SYSTEM FROM A BULLETIN BOARD,

CREATE YOUR OWN DIRECTORY AND RUN THE SYSTEM FROM THERE.










ii.

NAME/ADDRESS SYSTEM FILES

The following files, included with the archive, are absolutely essential
in order to run NAME/ADDRESS (if you are missing any of them, please let us
know as the system will not run without all of them):

MANUAL.DOC .............. the documentation file (this file you're
reading)
STATE.DBF ............... the State database file
NAME.DBF ................ the Master Name & Address database file
NAME.DBT ................ the Master Name & Address Memo file
ROLODEX.LBL ............. large rolodex label file
S_ROLO.LBL .............. small rolodex label file
BUSINESS.LBL ............ Business Address Mailing Labels file
HOME.LBL ................ Home Address Mailing Labels file
NAME.EXE ................ the NAME/ADDRESS Program
INSTALL.BAT ............. the Install program

The following files are included in the archive. However, if one or more
of them happen(s) to be missing, the system will create it/them as and when
needed:

APPT.DBF ............... the Appointments database file
APPT.DBT ............... the Appointments Memo file
TODO.DBF ............... the TODO database file
QUERIES.DBF ............ the Query database file
FORM.DBF ............... the Forms database file
FORM.DBT ............... the Forms Memo file
PLIST.DBF .............. the Print List database file

The following files are included in the archive. They are the varous IN-
DEX files for the system's database files. However, if one or more of them is
missing, the system will create it/them as and when needed:

APPTUSER.NTX
APPTDATE.NTX
TODOD.NTX
TODOP.NTX
TODO.NTX
LNAME.NTX
ST.NTX
COMPANY.NTX
ACCT.NTX

All of these files need to be located in the same directory in which you
install NAME/ADDRESS. The install procedure takes care of this.
However, if you install the system manually, make sure you copy all of
these files onto the drive and into the directory you create.






iii.

STARTING NAME & ADDRESS
-----------------------
To start the system, first change to the directory into which you in-
stalled it. Assumming that you did not change the installation procedure, and
that your default drive is the C: drive, simply type:

CD \VMCNA and press ENTER

Then, at the DOS prompt, type:

VMCNA and press ENTER

You are presented with the opening screen, which includes our copyright
notice.

VMC's NAME & ADDRESS

WELCOME TO

VITRON'S NAME & ADDRESS SYSTEM


(c) Copyright 1991, VITRON Management Consulting, Inc.
All Rights Reserved.



Press ENTER to proceed...


As you can see, you are prompted to "Press ENTER to proceed...". So,

PRESS: ENTER (actually, pressing any key will do)

You are presented with the system's Main Display Window, with the
system's Main Menu at the bottom of the screen. (See top of next page.) The
system comes to you with ten (10) initial test data records. You can delete
these records and begin adding your own "live" data at any time. But, we do
recommend that before you do, please take the tour with us so that you are
familiar with all of the system's features and facilities.
Each of the Main Display's fields should be fairly self-explanatory with
the possible exception of the "Codes:" fields. We'll explain "Codes:" a
little later. The current (default) index -- i.e., file sequence -- is Last
Name + First Name. This sequence can be changed, as we'll see later. The cur-
rent record (first record) is the record for a Michael Donner of the ABC Com-
pany in Philadelphia, PA.









VITRON's NAME & ADDRESS SYSTEM 1.

Number of Records: 10 04/01/91
VITRON'S NAME & ADDRESS SYSTEM
Account Number:
First Name: Michael MI: Last Name: Donner

Title:
Company: The Abc Manufacturing Co
Company Dept: Human Resources
Business Addr1: 3245 Leonard St
Addr2:
City: Philadelphia State: PA Zip: 29809
Telephone: (402) 898-3737 Ext: 35 Fax: (402) 809-3787

Home Addr1: 3 Wall St
Addr2:
City: King Of Prussia State: PA Zip: 29898
Telephone: (402) 666-9872 Fax:

Comments: Memo Attached Codes: , , ,


Next Prev Add Update Delete Search Key Table Hard View Query Memo Other Exit

Next Record






























VITRON's NAME & ADDRESS SYSTEM 2.

THE MAIN MENU
-------------
The Main Menu includes fourteen (14) choices. These choices are as fol-
lows.

NEXT ................. to advance to next record

PREV ................. to go back one record

ADD .................. to add a new record

UPDATE ............... to edit/update/change current record

DELETE ............... to flag current record for deletion or to
unflag (undelete) current record if
flagged for deletion

SEARCH ............... to search file based on specified criterion

KEY .................. to find particular record based on value of
current index key (provides a pick-list --
a "lookup" table -- upon request)

TABLE ................ to display "full-screen browse" window --
multiple records on screen that can be
scrolled through

HARD ................. to print out entire contents of current
record on printer

VIEW ................. to view (display) attached memo of current
record (if any)

QUERY ................ to build a "query-by-example" set of
criteria; to find and display record(s)
meeting criteria; provides for multiple
criteria and selections

MEMO ................. to add/edit/update/change current record's
memo

OTHER ................ to provide Auxiliary (Secondary) System
Menu -- includes addition system features
and facilities

EXIT ................. Quit system and return to DOS (the same is
accomplished by pressing ESC at Main Menu)

For those of you who may be new to database types of applications, a
"memo" item is typically a free-form text annotation that is attached to a
given record. "Memo" fields permit you to add notes, comments, and the like



VITRON's NAME & ADDRESS SYSTEM 3.

to individual records. Typical "memo" items are from 1 to 24 lines of
free-form text, though, technically, each "memo" item can be up to 64,000
text characters (800 lines) that can be created and scrolled through much the
same way as you would create and scroll through a document in a word process-
ing window (display screen).
There are two ways in which you select a Main Menu item. (In fact, most
of the menus in the system work the same way.) The way you choose is a matter
of personal preference.
The first way is to press the RIGHT or LEFT ARROW key to highlight your
choice, and then press ENTER.
The second way is to simply press the FIRST LETTER of your choice with-
out pressing ENTER. (Note: Each of the menu items begins with a unique let-
ter.)
Several of the Main Menu items have their own sub-menus.
For now, as you might expect, NEXT, PREV, ADD, and UPDATE should be
self-explanatory. We'll see ADD and UPDATE later.

THE DELETE OPTION

To select DELETE, either highlight it and press ENTER, or simply type D.
The Delete Menu consists of two choices. If the current record is not flagged
for deletion, the choices are: "Delete Record" and "No Action". If se-
lected, the menu is displayed in the middle of the screen.


Delete Record No Action


If, on the other hand, the current record is already flagged for dele-
tion, the menu displays "Undelete Record" and "No Action".


Undelete Record No Action


You select "Delete Record" or "No Action" by either pressing the RIGHT
or LEFT ARROW key to highlight your choice and then press ENTER, or by simply
typing a "D" for "Delete Record" or an "N" for "No Action".
By the same token, you select "Undelete Record" or "No Action" by press-
ing the RIGHT or LEFT ARROW to highlight your choice and then press ENTER, or
by simply typing a "U" for "Undelete Record" or an "N" for "No Action".
If you press ESC, you will cancel the menu selection process, and will
be returned to the Main Menu.

THE SEARCH OPTION

To select SEARCH, highlight it and press ENTER, or simply type S.
When you select "Search" you are presented with the "Search for:" menu.






VITRON's NAME & ADDRESS SYSTEM 4.

[Search for:]
Field Contents Match
End of file
Beginning of File
Deleted Records
Memo contents
Never Mind


This menu consists of six (6) options.

FIELD CONTENTS MATCH ............. prompts you to select a field
on which to search

END OF FILE ...................... takes you to the last record in
sequence

BEGINNING OF FILE ................ takes you to the first record
in sequence

DELETED RECORDS .................. takes you to the first record
in sequence that is flagged
for deletion

MEMO CONTENTS .................... prompts you to enter the memo
contents to search on; you
can enter a character string
of up to sixty (60) charac-
ters

NEVER MIND ....................... quits the "Search for:" menu
and returns you to the Main
Menu

You select your choice by pressing the DOWN or UP ARROW key and pressing
ENTER, or by typing the FIRST LETTER of the choice -- that is, F or E or B or
D or M or N.
The choices END OF FILE, BEGINNING OF FILE, DELETED RECORDS, and NEVER
MIND are self-explanatory.
The remaining two selections, FIELD CONTENTS MATCH and MEMO CONTENTS,
have their own sub-menus.

FIELD CONTENTS MATCH

If you select "Field Contents Match" you are presented with a menu of
field names from which you select a field.








VITRON's NAME & ADDRESS SYSTEM 5.

[ Select Search Field ]
Acct Num
Code-1
Code-2
Code-3
Code-4
First Name
Middl Init
Last Name
Title
Company
Compny Dpt
Bus. Addr1
Bus. Addr2
Bus. City


There are more fields below the "Bus. City" field from which you can
choose. To view the additional fields, press DOWN arrow or PGDN. To go back
up the list, press PGUP. If you continue to press PGDN at the end of the
list, it wraps around back to the top of the list.
Define the field you want to select by highlighting it with the ARROW
keys, then select it by pressing ENTER.
Since more than one field name may begin with the same letter, if you
use the FIRST LETTER technique, you are taken to the first occurrence of that
letter in a field name. To select that field, press ENTER. If you press that
letter key again, the highlight bar moves to the next occurrence of that let-
ter in the field name list, and so on.
After you select a field, you are presented with the "Locate record
where..." menu. This menu contains nine (9) choices.

[ Locate record where ]
= is equal to
> is greater than
< is less than
>= is greater than or equal to
<= is less than or equal to
# is not equal to
$ contains
S starts with (up to 5 letters)
Q Quit this


Make your selection by pressing DOWN or UP ARROW to highlight your
choice and then press ENTER, or simply type the FIRST SYMBOL and press ENTER.
(Here you need to press ENTER to confirm your choice.)

= finds the first record whose selected field contents is
equal to what you will be prompted to type in





VITRON's NAME & ADDRESS SYSTEM 6.

> finds the first record whose selected field contents is
greater than what you will be prompted to type in

< finds the first record whose selected field contents is
less than what you will be prompted to type in

>= finds the first record whose selected field contents is
greater than or equal to what you will be prompted to type
in

<= finds the first record whose selected field contents is
less than or equal to what you will be prompted to type in

# finds the first record whose selected field contents is
not equal to what you will be prompted to type in

$ finds the first record whose selected field contents
contains anywhere in the field the string of characters
you will be prompted to type in

S finds the first record whose selected field contents
starts with (begins with) the one-to-five characters you
will be prompted to type in

Q quits the "Search" and returns to the Main Menu

After you select one of the above options, you are prompted to type in
the characters to search for. The length of the prompt field is the same
length of the particular field you selected at the outset. You can enter the
characters, if letters, in either upper- or lower-case. (The search is not
case-sensitive.)


Locate for....



If you select the "= equal to" option, you must type in all of the nec-
essary characters. For example, if you want to search for a particular "Last
Name equal to" a value, you must type in the complete last name you want to
find. Your spelling of the name must be accurate in order to find it.
You, therefore, might find it more convenient to use the "S starts
with" option instead of the "= equal to" option. With "S starts with" you
can enter the first one-to-five characters of a last name. The search will
find the first occurrence of the last name that starts with the particular
characters you enter. Again, you may use upper- or lower-case.
If the search is unsuccessful, you are so informed; you are prompted to
press a key and are returned to the Main Menu. You can, of course, initiate a
new search by selecting "Search" from the Main Menu again.
However, if your search is successful, the system displays the first
record that meets the criteria and returns you to the Main Menu. There might



VITRON's NAME & ADDRESS SYSTEM 7.

very well be more than one record that meets your criteria. If the search is
successful and you select "Search" from the Main Menu again, the system dis-
plays:


Continue.. New Search


To find the next occurrence, if any, select "Continue..". If there is
another match, that record is displayed, and so forth. If you want to define
new search criteria, select "New Search". The search-definition process is,
then, repeated.

MEMO CONTENTS

To select "Memo contents" either press DOWN ARROW to highlight it and
press ENTER, or simply type M. When you select "Memo contents" the system
displays the following menu with three (3) options:

Locate record where memoCOMMENTS:
$ contains
E is empty
N is not empty


$ finds the first record whose selected memo field contains
anywhere in the entire memo field the string of characters
you will be prompted to type in

E finds the first record whose selected memo field is empty
(blank) -- that is, contains nothing

N finds the first record whose selected memo field is not
empty (not blank) -- that is, contains something

You can terminate any menu and return to the Main Menu by pressing ESC
(Escape). If you press ESC at the Main menu, you quit the system and are re-
turned to DOS.


THE KEY OPTION

To select "Key" from the Main Menu, either highlight it and press ENTER
or simply type K. When you select "Key" the system displays a data entry box.


Last Name to seek (ENTER for Lookup Table - ESC quits):



The actual item you are prompted to enter depends on the current file
index (file sequence).


VITRON's NAME & ADDRESS SYSTEM 8.

The system provides for three indexes (sequences). The default (and cur-
rent) sequence is by Last Name. (More about the other sequences later.) This
is why you are prompted to enter in the "Last Name" at this time.
Fortunately, you do not have to enter in an entire last name. Just a few
letter may suffice for you (even one letter may be enough). However, the more
letters you enter, the more precise the search. The system will jump to the
first record that matches the last name letters you enter. If you type in
letters, don't forget to press ENTER when you are finished with your entry.
If you leave the data entry box empty -- that is, blank -- and press EN-
TER on the blank field, as the prompt suggests, you are presented with a
"Lookup Table" -- that is, a pick-list of all the Names on file.

Lookup Table of Key
DONNER MICHAEL
JACKSON JANET
JOHNSON HARRY
MARSHALL EDWARD
O'CONNOR FRANK H
PETERSON PAUL
ROOSEVELT THEORDORE
SMITH JOHN
THOMAS LORAINE
WILSON PETER


The box displays ten (10) names at a time. If there are more than ten
names on file (look at the top of the screen where you are told how many
records are on file), use the DOWN/UP ARROW, PGDN, PGUP, END and HOME keys to
scroll through the list.
In addition to highlighting the name of your choice, you can, with the
box displayed, start to type in a last name. As you type, you will see an en-
try area appear at the bottom of the box, with the letters displayed as you
type them. After you have entered the letters (you can enter from one to sev-
enteen letters) of your choice, press ENTER. The highlight bar will jump to
the first occurrence of the letters you enter. To select the name highlighted
-- that is, to go to that record -- press ENTER again. The more letters you
enter, the more precise the search.

THE TABLE OPTION

To select "Table" either highlight it and press ENTER or simply type T.
When you select "Table" the system displays the "Tableview of:" menu.

Tableview of:
Business Data
Home Data
All Data
Quit to Main


You are presented with four (4) options.



VITRON's NAME & ADDRESS SYSTEM 9.

BUSINESS DATA ................. presents a Browse Window
(Tableview) of business data
only

HOME DATA ..................... presents a Browse Winbdow
(Tableview) of home data only

ALL DATA ...................... presents a Browse Window with all
record data available

QUIT TO MAIN .................. returns to the Main Menu

Memos and the Codes fields are not accessed or viewed in "Table" mode in
this version of the system. (NOTE: Such features will be part of our next
version, which will include additional features and facilities as well. Stay
tuned.)

BUSINESS DATA and HOME DATA

To select "Business Data" either highlight it and press ENTER or simply
type B. To select "Home Data" either highlight it and press ENTER or simply
type H. To select "All Data", either highlight it and press ENTER or type A.
To quit, highlight "Quit to main" and press ENTER or type Q.

BROWSE ALL or SELECT CERTAIN FIELDS...

Regardless of whether you select "Business Data" or "Home Data" the sys-
tem then displays a Browse request.


Browse all fields
Select certain fields to browse


The choices are:

BROWSE ALL FIELDS ............... displays the fields of all
records across the screen
and down the columns

SELECT CERTAIN FIELDS ........... displays only the fields you
select for all records
across the screen and down
the columns

In a Browse Window, each record is displayed across the row and the
fields are displayed down the columns.
To select "Browse all fields" either highlight it and press ENTER or
simply type B. To select "Select certain fields..." either highlight it and
press ENTER or simply type S.




VITRON's NAME & ADDRESS SYSTEM 10.

The Browse Window display is essentially the same format for either
choice except that the "Select certain fields" option displays the data for
only the specific fields you select from a field pick-list.

SELECT CERTAIN FIELDS

When you choose "Select certain fields" the system displays a field
pick-list in the middle of the screen.

ENTER to select
First Name
Last Name
Company
Title
Address 1
Address 2
City
State
Zip
Telephone
Ext
Fax
F10 when done

The box displays twelve (12) field names at a time. Since there are only
12 field names for business data, and only 9 field names included for home
data, all of the fields represented in the Browse Window are displayed in the
box without your having to scroll DOWN to see more field names.
The illustration above shows the field pick-list for business data. You
select the fields by pressing DOWN/UP ARROW to highlight the field and then
press ENTER.
When you select a field in this manner, the system places a CHECKMARK
in front of the field name selected. This indicates that the field has been
selected to be displayed in the Browse Window. Only those fields specifically
selected will be displayed in the Browse Window when you select "Select Cer-
tain Fields."
Our example above indicates that we have selected First Name, Last Name
and Telephone. (See the checkmarks?)
If you want to DESELECT a selected field, highlight it again and press
ENTER again. This will erase the checkmark, indicating that the field is not
selected.
When you have finished selecting one or more fields, press the F10 Func-
tion key to proceed to the actual Browse Window.

THE BROWSE WINDOW (TABLE-VIEW)

After you choose either "Browse all fields" or "Select certain fields"
the system presents you with the Browse Window (Tableview). Depending on the
number of fields selected (ALL or CERTAIN), there may be additional fields
out to the right, currently off the screen.




VITRON's NAME & ADDRESS SYSTEM 11.


[Record # 9] (F1 for Navigation keys)


First Name Last Name Company

Michael Donner The Abc Manufacturing Co
Janet Jackson American Judges Association
Harry Johnson Office Of Weights & Measures
Edward Marshall American Alpine Club
Frank O'Connor
Paul Peterson The National Bank
Theordore Roosevelt The Us Company
John Smith A Philip Randolph Institute
Loraine Thomas The Morgan Company
Peter Wilson Airport Security Council







(Q)uit (G)oto (L)ocate (V)ertical View (E)dit (A)dd (D)elete


To view the additional fields, if any, you can scroll out to the right
by pressing RIGHT ARROW. You can scroll back to the left by pressing LEFT AR-
ROW. When you reach the end of the field display, the highlight bar will not
go any further to the right or left.
You can scroll down to the next 15 records (but not in our case, since
there are only 10 test records on file) by pressing DOWN ARROW or PGDN. You
can scroll up 15 records by pressing UP ARROW or PGUP.
There are additional "Navigation" keys available. Press the F1 Function
key to see what they are and what they can do. (The list of navigation keys
also appears on the next page in this manual.)
The Browse Window provides its own "menu" of facilities, which is dis-
played at the bottom of the screen.
Your options are:

QUIT ....................... to return to the previous menu

GOTO ....................... to go to a specific record based on
its record number (assumming, of-
course, you know its number)









VITRON's NAME & ADDRESS SYSTEM 12.



Press this Key: To Do This:

| (Up arrow) ............... Move up one row.
| (Down arrow) ............. Move down one row.
<-(Left arrow) ............. Move left one column.
->(Right arrow) ............ Move right one column.
^<-(Ctrl-Left arrow) ....... Pan left one column.
^->(Ctrl-Right arrow) ...... Pan right one column.
Home ....................... Leftmost current screen column.
End ........................ Rightmost current screen column.
^Home (Ctrl-Home) .......... Leftmost column.
^End (Ctrl-End) ............ Rightmost column.
PgUp ....................... Scroll up one screen.
PgDn ....................... Scroll down one screen.
^PgUp (Ctrl-PgUp) .......... First row of current column.
^PgDn (Ctrl-PgDn) .......... Last row of current column.

Press ESC or ENTER to return to TableView

You can PAN right/left if there are columns out there.


NAVIGATION KEYS LIST


VERTICAL VIEW .............. to view all of the business or
home data of the currently
highlighted record on the screen
in a display box

EDIT ....................... to edit/update/change data in the
currently highlighted record
(presents the same display as
the "Update" selection from the
Main Menu)

ADD ........................ to add a new record (presents the
same display as the "Add"
selection from the Main Menu)

DELETE ..................... to flag the current record for
deletion

NOTE: The highlight bar indicates two things:

(a) the CURRENT RECORD, and
(b) the CURRENT FIELD in the current record

To select a menu item in the Browse Window at this point, you simply
type the LETTER of your choice.


VITRON's NAME & ADDRESS SYSTEM 13.

Let's examine the selections other than EDIT and ADD since these are
explained later from the same choices on the Main Menu.

QUIT

If you type Q to Quit, the system asks you to confirm by selecting "Yes"
or "No." You can either highlight your choice and press ENTER or simply type
Y or N.


Quit ?
YES NO


If you select "NO" you are returned to the Browse Window. If you select
"YES" you are returned to the previous menu ("Tableview of:").

GOTO

If you type G to Goto, you are prompted to enter the number of the
record to jump to -- that is, to the specific record to highlight.


Go to record # :
0



Of course, if you don't know the actual record numbers for the records
on file, this method is not too helpful.
Notice, at the top right of the screen, when the highlight bar is on the
first record (for Michael Donner), the screen displays:

Record # 9

Since the file is sequenced (indexed) by Last Name, the record number
displayed may or may not (generally will not) correspond to the actual posi-
tion in the display. Record numbers are generated at the time you first cre-
ate the record and represent the actual physical location of a record in the
file.
However, when you use an index (a sequence), records are "logically re-
arranged" to display in their appropriate sequence. As such, record numbers
reflect only the physical position of each record in the file and not neces-
sarily the logical (displayed) position.










VITRON's NAME & ADDRESS SYSTEM 14.

LOCATE

[Search for:]
Field Contents Match
End of file
Beginning of File
Deleted Records
Memo contents
Never Mind


If you select "Locate" by typing L, our familiar "Search for:" menu is
displayed. (See "IV. THE SEARCH OPTION" on page 4 of this manual for more de-
tails. Everything you can do there you can do here.)
The only difference between the search performed in the Browse Window
and the search performed at the Main Menu is that in the Browse Window, if a
record containing your criteria is found, the highlight bar jumps to the
first record matching the criteria, making it the current record while you
remain in the Browse Window. When you return to the Main Menu, the system re-
turns to the first record on file (in sequence).

VERTICAL VIEW


First Name Michael
Last Name Donner
Company The Abc Manufacturing Co
Title
Address 1 3245 Leonard St
Address 2
City Philadelphia
State PA
Zip 29809
Telephone (402) 898-3737
Ext 35
Fax (402) 809-3787


If you select "Vertical View" by typing V, the data for the current
record is displayed in a box on the screen. This feature is useful when you
want to view all of the pertinent data of a given record at one time rather
than have to scroll RIGHT and LEFT to view the same data.

NOTE: When in Vertical View and you press DOWN or UP ARROW to
highlight a particular field in the vertical view window and
then press ENTER, upon returning to the Browse Window, which
happens after you press ENTER, you will find that the high-
light bar is sitting on the field of that record, which you
highlighted in vertical view. To return to the Browse Window
while keeping the highlight bar in the first field of the
first record, simply press ESC, as prompted, instead of EN-
TER.


VITRON's NAME & ADDRESS SYSTEM 15.

SPECIAL NOTE: PRESSING THE ENTER KEY WHEN IN THE BROWSE WINDOW

Whenever you are in the actual Browse Window itself, you can perform dy-
namic field/record editing. What this means is that you can actually edit
data in any of the records displayed in the Browse Window. To do this, simply
highlight the field of the record you want to edit, and press ENTER.
When you do this, you'll notice that:

(a) the color of the highlight bar changes from pale blue to white,
(b) the cursor blinks in the field, and
(c) the system displays the following in the middle of the screen:


Enter to Save -- Escape to cancel


At this point, you can change the data in the highlighted field by sim-
ply typing in the new data.
To save your change(s), simply press ENTER. To abort (cancel) the
change, press ESC instead of ENTER. (Should you change something accidently,
simply repeat the process and make it correct.) But, do be careful using this
method to edit data since you might inadvertantly change something and not
notice it. Remember, when in doubt, press ESC or type Q to Quit the Browse
Window facilities. (You will probably be better off using the EDIT feature at
the Browse Window display -- i.e., typing E at the Browse Window.)

DELETE

When you select "Delete" by typing D, the system prompts you as to
whether you want to "Delete Record" or take "No Action." If you select "De-
lete" (since it's already highlighted, just press ENTER or type D), the
record is flagged for deletion. The "Delete" option of the menu at the bottom
of your screen will change to "Un(D)elete" indicating that the highlighted
record has been flagged. In addition, the word "Delete" will be displayed at
the top of the screen whenever the highlight bar is in any field of a record
flagged for deletion.
If you want to "Undelete" a flagged record, simply select "Delete" again
from the menu at the bottom of the screen by typing D. The record will then
be "unflagged."

WHAT EXACTLY IS A RECORD "FLAGGED" FOR DELETION?

When you flag a record for deletion, you inform the system that you in-
tend to eventually physically delete the record from the file. A flagged
record is a "logical" delete, not a physical delete. By allowing you the op-
portunity to flag records before physically deleting them, the system per-
mits you to change your mind and unflag -- that is, "logically undelete"
-- the record.
Flagged records will remain on the file -- you'll see "Delete" at the
top of the screen whenever the highlight bar is on any field of a flagged
record when in the Browse Window -- until you "pack and reindex" the
database. Packing and reindexing is an option in the "Other" menu choice of
the Main Menu. More about this when we get to the "Other" option.

VITRON's NAME & ADDRESS SYSTEM 16.

THE HARD OPTION

You can obtain a listing of the total contents of the currently dis-
played record by selecting "Hard" from the Main Menu. You select "Hard" by
highlighting it and pressing ENTER or by simply typing H.
When you select "Hard" the system displays the "Hardcopy of:" menu.

Hardcopy of:
Current record
Attached Memo field


The two choices are:

CURRENT RECORD ............... to list the contents of the
current record -- all fields
except the Memo field

ATTACHED MEMO FIELD .......... to list the contents of the
current record's memo field,
if any

HOW DO YOU KNOW THE RECORD HAS AN ASSOCIATED MEMO ITEM?

Look at the bottom of the display window, next to "Comments:". If the
current record has a memo attached, the words "Memo Attached" is displayed.
Otherwise, the "Comments:" field is blank. Every record can have an associ-
ated memo item if, when you add the record to the file, you indicate that you
want it to have a memo item. Also, you can add memos to records already on
the file by selecting "Update" and then responding "Yes" when prompted to
add/change a memo; or you can select the "Memo" option from the Main Menu.
To select "Current Record" either highlight it and press ENTER or simply
type C. To select "Attached Memo field" either highlight it and press ENTER
or type A.
Regardless of your selection, the system then asks you where you want to
send the output -- that is, to the "Printer" or to a "Text File."

Send hardcopy to:
Printer
Text File


If you select "Text File" (by highlighting it and pressing ENTER or by
typing T), you are asked to enter in the name of the file.


File to send output to







VITRON's NAME & ADDRESS SYSTEM 17.

File names are from one (1) to eight (8) characters, and you may add an
extension. The typical extension is .TXT. Enter the name and press ENTER. You
can use any text editor, word processor or even the DOS PRINT command, DOS
COPY command or DOS TYPE command to print out the file at a later time. (See
your DOS manual for the syntax of the various DOS commands.)
If you change your mind and don't want to create a text file, simply
press ESC at the "File to send output to" prompt.
If you select "Printer" you are requested to select the "Printer Port."


LPT1
LPT2
COM1


In most instances, "LPT1" is the appropriate choice, so, with the high-
light on "LPT1" simply press ENTER.
The report will be printed. (NOTE: If your printer is not ready to
print, you'll be so informed and prompted to correct the situation and to
proceed.) If you change your mind and don't want to print, simply press ESC.
Your listing, if you selected "Current Record" will look something like
this (at least the field names will be the same while the actual data will
reflect the record displayed):

Acct Num :
Code-1 :
Code-2 :
Code-3 :
Code-4 :
First Name : Michael
Middl Init :
Last Name : Donner
Title :
Company : The Abc Manufacturing Co
Compny Dpt : Human Resources
Bus. Addr1 : 3245 Leonard St
Bus. Addr2 :
Bus. City : Philadelphia
Bus. State : PA
Bus. Zip : 29809
Bus. Phone : (402) 898-3737
Bus. Ext : 35
Bus. Fax : (402) 809-3787
Home Addr1 : 3 Wall St
Home Addr2 :
Home City : King Of Prussia
Home State : PA
Home Zip : 29898
Home Phone : (402) 666-9872
Home Fax :
Comments : (memo)
Setup-Date : 04/02/91


VITRON's NAME & ADDRESS SYSTEM 18.

Your listing, if you selected "Attached Memo" and the memo field has
data in it, will look something like the following:

ATTACHED MEMO FOR: Michael Donner ACCOUNT #:

Wish we knew what the real area code and zip code are.

THE VIEW OPTION

When you select "View" from the Main Menu (by either highlighting it and
pressing ENTER or by simply typing V), the system displays the current
record's memo field. If there is no memo associated with the record (if the
memo field is blank), an empty window is displayed.

[MEMO PAD]
Wish we knew what the real area code and zip code are.






[ ESC:EXIT ]

To return to the Main Menu, simply press ESC.

THE QUERY OPTION

Without much doubt, this feature is probably the most interesting aspect
of the system, and, we dare say (unfortunately), perhaps it's also the most
complex.
We'll try to simplify its access and use as much as possible. But, the
best way for you to become acquainted with "Query" is to play with it.
To select "Query" either highlight it and press ENTER or simply type Q.
When you select "Query" the system displays the "Ad-Hoc Query Builder" menu.

[Ad-Hoc Query Builder]

Build a new query
Add to current query
Count matching records
Zap (remove) existing query
Save current query to disk
Restore query from disk
Delete stored queries
What is current query
Edit current query
View records matching query
Quit this Query

No Query Active



VITRON's NAME & ADDRESS SYSTEM 19.

As you can see, the menu provides you with eleven (11) options. Let's
define at each of them.

BUILD A NEW QUERY ................. to build a new query, that
is, define a new set of
criteria to search on

ADD TO CURRENT QUERY .............. allows you to add additional
criteria to the current
active query

COUNT MATCHING RECORDS ............ to count the number of
records that match the
current active query

ZAP EXISTING QUERY ................ to remove the current active
query

SAVE CURRENT QUERY ................ to save the current active

query to disk for later
use

RESTORE QUERY ..................... to retrieve from disk a
particular query defini-
tion saved with the SAVE
CURRENT QUERY option; this
option makes the retrieved
query the current active
query

DELETE STORED QUERY ............... to erase saved queries from
disk

WHAT IS CURRENT QUERY ............. to display the parameters of
the current active query
as you defined them

EDIT CURRENT QUERY ................ this option is best left to
those of you who are fam-
iliar with dBASE and/or
Clipper; this option
allows you to modify the
previously defined param-
eters of the current
active query

VIEW MATCHING RECORDS ............. displays the records that
meet the current active
query's conditions

QUIT THIS QUERY ................... returns to the Main Menu.



VITRON's NAME & ADDRESS SYSTEM 20.

NOTE: When you quit the "Query" menu and return to the Main Menu, if you
did not ZAP the current query, when you select "Query" again, you will find
that the previously defined query (which was the "active" query) is still de-
fined as the current active query. Query's conditions are only active when
you are in the Query facility. It has no effect when you are at the Main
Menu.
If no query is active, at the bottom of the "Ad-Hoc Query Builder" menu,
you will see displayed:

No Query Active

If there is an active query -- one you defined and did not ZAP -- the
following will be displayed at the bottom of the "Ad-Hoc Query Builder" menu,
and it will be blinking:

Query Active

Whenever you ZAP (remove) an active query, "No Query Active" will again
be displayed.
NOTE: ZAPping active queries has no effect on those queries you SAVEd to
disk. If you RESTORE a query from disk, making it active, and then ZAP it, it
still resides on the disk. The only way in which you can delete queries saved
to disk is by selecting the DELETE option from the "Ad-Hoc Query Builder"
menu. You will then be provided with a menu of saved (stored) queries from
which you will select those you want to delete. Queries deleted from disk are
not flagged. Rather, they are actually physically deleted.
You can save as many queries as you want. When you save a query, you are
prompted to enter in a description. Queries are saved via their description
text and not via "file" names. As such, your descriptions can and should be
clear as to what the particular query does.
Let's look at the first option.

BUILD A NEW QUERY

To select "Build a new query" either highlight it and press ENTER or
simply type B.
When you select this option, the system displays the "Database Field
List" menu. You use this menu to select the various database fields for which
you will define the search criteria. Unlike the "Search" item from the Main
Menu, here in "Query" you can define multiple-field criteria.
The first item in the "Database Field List" menu is "?". Yes,
you can search on records currently flagged for deletion as criteria.












VITRON's NAME & ADDRESS SYSTEM 21.

[Ad-Hoc Query Builder]

Build a new query
Add to current query
Count matching records [Database Field List]
Zap (remove) existing query < Deleted? >
Save current query to disk Acct Num
Restore query from disk Code-1
Delete stored queries Code-2
What is current query Code-3
Edit current query Code-4
View records matching query First Name
Quit this Query Middl Init
Last Name
No Query Active Title
Company
Compny Dpt

ENTER to select


Since there are more fields to choose from below "Compny Dpt" you can
scroll down through the table by pressing DOWN ARROW or PGDN. If you press
END, you go to the end of the table menu. To go back up, use the UP ARROW,
PGUP or HOME. (HOME brings you to the top of the table.)
Use the highlight bar to highlight the field of your choice, then press
ENTER.
To see how the more interesting aspects of "Query" work, let's try an
example. Slide the highlight bar down to the "Last Name" field and press EN-
TER. This selects "Last Name" as the field. The system now displays a crite-
ria qualification menu.

[Ad-Hoc Query Builder]

Build a new query
Add to current query
Count matching records = (Equal to)
Zap (remove) existing query<> (Not Equal To)
Save current query to disk < (Less Than)
Restore query from disk > (Greater Than)
Delete stored queries <= (Less Than or Equal To)
What is current query >= (Greater Than or Equal To)
Edit current query $ (Contains)
View records matching query! (Does Not Contain)
Quit this Query * (Wildcard Match)
S (Starts With)
No Query Active







VITRON's NAME & ADDRESS SYSTEM 22.

Each choice works in basically the same way as it works in the "Search"
option from the Main Menu. (See "Locate Record Where") However, there are
two choices that should be pointed out.

! (Does Not Contain) ......... to select a field that does
NOT contain the data you will
be prompted to enter

* (Wildcard Match) ........... like the DOS wildcards, can
use them in place of char-
acters

Let's look at an example for the wildcards. There are two wildcards. One
is the asterisk (*), which is used in the place of any number of characters;
the other is the question mark (?) which is used in the place of one charac-
ter. When using wildcards, you MUST account for all characters in the field.
Since we previously selected "Last Name," slide the highlight bar down
and highlight "* (Wildcard Match)" and press ENTER. The system now displays
the "Compare to" menu.

Compare to
Type in a value to compare
Select a single value from the database (scroll)
Compare to another field in the same record


We want to select "Type in a value to compare." Select it by highlight-
ing it (it should already be highlighted) and pressing ENTER or simply type
T.
You are now prompted to enter in a value to compare to.


VALUE TO COMPARE (TYPE CHARACTER)





What is not shown above is that the box has two additional lines
(since we selected WILDCARD MATCH) that are not displayed in the box
above. This is because you selected WILDCARDS.
Okay. We want to find all Last Names that start with a J and contain an
N somewhere after the J. (Remember, we have to account for all the characters
in a field.) We need to recognize that there can be letters (or blanks) after
the N.
Type the following:

J*N* and press ENTER

NOTE: You can enter the characters in either UPPER- or lower-case.
The system now asks if you want to ignore case-sensitivity. WE STRONGLY
RECOMMEND THAT YOU ALWAYS SELECT YES! Otherwise, the search will be conducted
in exactly the way in which you enter the data in response to the prompt.

VITRON's NAME & ADDRESS SYSTEM 23.

Next, you are provided with what is called the "Boolean" (logical)
expressions.


DONE
AND
OR
AND NOT
OR NOT


These "combiners" allow you to create compound (multiple) sets of crite-
ria, like a "compound" sentence. In otherwords, you can combine criteria. For
example:

a AND b

a OR b

a AND NOT b

a OR NOT b

For those of you who are new to these combinations, we recommend that
you use AND and/or OR and try to avoid the "NOTs." Positives (AND and OR) are
easier to deal with than negatives (NOT). With a little forethought, you can
always construct a positive logical relationship that will work the way you
want and expect. The OR NOTs are particularly confusing if you are not used
to writing programs, so avoid the OR NOT option if at all possible.
Since we don't want any more criteria, select DONE by highlighting it
and pressing ENTER or simply type D.
Notice now "Query Active" is blinking in the box. This tells you that
you have defined a query and that it is currently active while you stay in
Query. (If you were to Quit Query, the criteria you defined would not apply
to record selection at the Main Menu. But, when you enter Query again, the
current Query remains active and you can use it to "View" the records that
match it.)
Let's view the records that meet our criteria, that is, Last Names that
start with a J and contain at least one N somewhere after the J. The last as-
terisk accounts for any characters that should occur after the N, including
blanks. To view records that match our query criteria, we need to remain in
Query.
From the menu, select "View records matching query" by highlighting it
and pressing ENTER or simply by typing V.
The system starts to look for matches. The first record found is for
Harry Johnson. (See the "J" and the "N" in the name?)
Notice the options at the bottom of your screen.

( N ) Next .................... goes to next record that meets
criteria, if any

( P ) Prior ................... goes to prior record that
meets criteria, if any

VITRON's NAME & ADDRESS SYSTEM 24.

( Q ) Quit .................... returns to Query menu

( V ) View Memo ............... displays attached memo for
the record, if any

You make your choice by typing in the letter of your choice. Since there
is no memo attached for Johnson, if you press V you'd see an empty display
window.

Press: N (for NEXT)

We see that there is another record that meets our criteria -- Janet
Jackson. (See the "J" and the "N" in the name?)
Now, when you press N for NEXT, you are told that there are no more
matches and are returned to the Query menu. To run through the records again,
simply select "View" again.
Let's ZAP this query.

Press: Z (to select ZAP)

The query is deactivated. You could have saved the query to disk and
later recalled it from disk.
There are other ways you can select records. In the "Compare to" menu we
previously selected "Type in a value to compare." If, instead, you select
"Select a single value from the database (scroll)," you are presented with a
pick-list of Last Names from which to choose.


Donner
Jackson
Johnson
Marshall
O'Connor
Peterson
Roosevelt
Smith
Thomas
Wilson


If you select a particular Last Name from the list (which you can scroll
since there may be more names in the table than are initially displayed), you
tell Query to search on records of that particular last name and that last
name only. It's a good technique if you want to pick out all Smith's, for ex-
ample, or if you are searching on State, to select all people in NY. (Of
course, you could also type in the value NY. But, if you're like us, it's
easier to pick from lists than to type stuff in.)
The final option in the "Compare to" menu is "Compare to another field
in the same record." This option allows you to compare the value in one field
to the value in another. (This is good if you want to search for all people
who both work and live in NY, for example. You can compare the Business State
to the Home State.)


VITRON's NAME & ADDRESS SYSTEM 25.

[Pick Field]
ACCT
CODE1
CODE2
CODE3
CODE4
FIRST
MI
LAST
TITLE


Note that in this pick-list, the system uses actual dBASE-file field
names rather than the "pseudo-names" used everywhere else. (You can scroll
through the list by pressing PGDN and PGUP.)
If you find Query fun and interesting, we encourage you to play with it
and experiment. The more you use it, trying different things and different
combinations, the more you'll learn about it.

THE MEMO OPTION

The "Memo" option of the Main Menu permits you to (a) view and edit cur-
rent attached memos and (b) create a memo for the current record had you not
done so when you initially created the record.
To select "Memo," either highlight it with the CURSOR keys and press EN-
TER or simply type M.
A memo window is displayed. The window displays nine (9) lines at a
time. Each memo item can be up to twenty-six (26) lines, which you can scroll
through with the UP/DOWN ARROW keys.
The line length is set at sixty-five (65) characters and is in automatic
wrap-around mode as you type.
If you want to delete a current line, put the cursor anywhere on the
line you want to delete and press CTRL Y. If you want to insert a line, put
the cursor at the line you want to insert at and press CTRL N.
Look at the bottom of the memo window. See the menu of keys?

F10: SAVE
ESC: EXIT (No Save)
F5: IMPORT
F6: EXPORT

[MEMO PAD]Line: 1Col: 0
Wish we knew what the real area code and zip code are.








[ F10:SAVE | ESC:EXIT | F5:IMPORT |F6:EXPORT]


VITRON's NAME & ADDRESS SYSTEM 26.

In addition, the top of the window tells you what line you are on and
what column you are in -- i.e., the location of the cursor.
After you have finished typing your entry, press the F10 function key to
save your edits.
When you press F10, a small prompt window is diplayed in the middle of
the screen:

Save and exit?
Save/Exit Don't Exit

If you select "Save/Exit" your memo is saved and you are returned to the
Main Menu. If you select "Don't Exit" the memo is still saved, but you remain
in the memo window.
If you press ESC instead of F10, a small prompt box appears:

Exit without saving changes?
YES NO

If you select "YES" the changes are NOT saved and you are returned to
the Main Menu. If you select "NO" you remain in the memo window.
Notice the additional function keys?

F5: IMPORT
F6: EXPORT

If you press F5, you are permitted to import -- i.e., read into the
current memo -- any .TXT file that resides in the current directory on
the current default drive. (NOTE: Due to Clipper requirements, the .TXT file
must not exceed 64K -- a maximum of 10-15K is strongly recommended.) This is
a nice facility in that you can prepare a "boiler-plate" .TXT file and then
read it in as a memo. You are provided with a pick-list of .TXT files.
When you press F5, you are prompted to enter the name of the file you
want to import. Since the system assumes that the file is a .TXT file, you
need only type in the filename. DOS wildcards are permitted. If you use
wildcards or if you leave the field blank and press ENTER, the system dis-
plays a .TXT file pick-list from which you can choose the file you wish to
import.
If you press F6 (to EXPORT), you are permitted to export -- i.e., write
out -- the memo item to an external .TXT file. When you press F6, you ae
prompted to enter in the name of the file you wish to export. The system as-
sumes the extension to be .TXT. Therefore, you need only type in the filename
(one to eight characters -- a DOS requirement). If the file already exists,
you are asked if you want to replace it. If NO, you are asked to type in a
different name.

THE OTHER OPTION

When you select "Other" from the Main Menu, you are presented with the
system's Auxiliary Menu -- a menu of some real nice system facilities.





VITRON's NAME & ADDRESS SYSTEM 27.

Auxiliary Menu
Index Files
Change Sequence
Produce Reports
ToDo List
Form Letters
Appointments
Quit


We believe that these features are what set our system apart from the
others. And these auxiliary facilities are not "Mickey Mouse" facilities.
Each one is a full, comprehensive sub-system in its own right. (That's why
our system is a bit memory-hungry.)
The options on the Auxiliary menu are as follows:

INDEX FILES ....................... to pack and reindex ALL of the
system's files. (NOTE: When
the system's files are
"packed," all records that
are flagged for deletion are
permanently deleted.)

CHANGE SEQUENCE ................... as we mentioned at the outset,
the system's default
sequence is Last Name. This
option allows you to change
the sequence for the current
session.

PRODUCE REPORTS ................... permits you to produce Rolo-
dex-type reports, mailing
labels and true AD-HOC
reports (lists).

TODO LIST ......................... a full, powerful, sophistica-
ted ToDo List manager, with
some real nice features.

FORM LETTERS ...................... permits you to define and
produce true AD-HOC form
letters and mail-merge
reports.

APPOINTMENTS ...................... a full, powerful Appointment
scheduler and manager that
has some real nice features
not found in some of the
other appointment systems.

QUIT .............................. return to the Main Menu.



VITRON's NAME & ADDRESS SYSTEM 28.

1. INDEX FILES

Select "Index Files" whenever you want to pack and reindex all of the
database files. Do not interrupt this process when it begins. Remember, when
you "pack," you permanently remove all records that you previously flagged
for deletion.

2. CHANGE SEQUENCE

Sequence By:
Last Name
Company Name
Account Number
Quit


When you select "Change Sequence" you are presented with the "Sequence
By: menu. Your choices are:

LAST NAME .................. to present the displays in Last
Name sequence -- the default

COMPANY NAME ............... to present the displays in
Company Name sequence

ACCOUNT NUMBER ............. to present the displays in
Account Number sequence

Select the sequence you desire. From that point on, the database will be
displayed in the selected sequence for the duration of the current session or
until you change the sequence again. Selecting "Quit" leaves whatever index
is currently active as the current active sequence.
NOTE: Whenever you Exit the system and return to it later, the sequence
is by Last Name, which is the default at system start-up.

3. PRODUCE REPORTS

When you select "Produce Reports, you are presented with a "Pick One:"
menu.

Pick One:
Labels & Rolodex
Reports & Lists
Quit


LABELS & ROLODEX

When you select "Labels & Rolodex" you are presented with the
"Labels/Rolodex" menu.




VITRON's NAME & ADDRESS SYSTEM 29.

[Labels/Rolodex]
Open Label File [No Query]
New Label File
Erase Label File
Dimensions of Label File
Contents of Label File
Print Test Pattern
Generate Mailing Labels
Set Printer Port VITRON's
Quit
Name & Address System
Tag Records to Print
Build or Modify Query

Info on using Laser Printers *


[Label File:]
Label file in use : []
Dbf file in use : [NAME]
Default Printer : [LPT1]



Your choices are:

OPEN LABEL FILE ..................... to select a defined
label file from disk

NEW LABEL FILE ...................... to create a new label
file and save to disk

ERASE LABEL FILE .................... to erase an existing
label file from disk

DIMENSIONS OF LABEL FILE ............ to define/edit the dimen-
sions of a new/existing
label file

CONTENTS OF LABEL FILE .............. to define the actual
contents of a label
file. (NOTE: This
facility should be
used only by those who
have an understanding
of dBASE. Since there
already are four label
files provided, most
of your label needs
are accounted for with
the existing files.)



VITRON's NAME & ADDRESS SYSTEM 30.

PRINT TEST PATTERN .................. prints a test pattern
for you to properly
align your labels and
rolodex forms

GENERATE MAILING LABELS ............. to print out the labels
and rolodex forms

SET PRINTER PORT .................... to set your printer
port. In most in-
stances, the default,
LPT1, should be accep-
table

TAG RECORDS TO PRINT ................ allows you to select --
"tag" -- specific rec-
ords for printing

BUILD OR MODIFY QUERY ............... to define an ad-hoc
query for selecting
specific records for
printing

INFORMATION ON...LASER PRINTERS ..... some information useful
for laser printer
users

OPEN LABEL FILE

The system includes predefined label and rolodex files for you. When you
select "Open Label File" the system displays a menu of four (4) label files
that include the necessary data for you to create your rolodex cards and
mailing labels.

Label Files
ROLODEX.LBL
HOME.LBL
BUSINESS.LBL
S_ROLO.LBL


The files are:

ROLODEX.LBL .................. produces large rolodex-type
lists

HOME.LBL ..................... mailing labels with home
addresses

BUSINESS.LBL ................. mailing labels with business
addresses



VITRON's NAME & ADDRESS SYSTEM 31.

S_ROLO.LBL ................... produces small rolodex-type
lists

TAG RECORDS TO PRINT

This facility is similar to "Query" but instead you are presented with a
pick-list of actual records from which to choose. To "tag" -- i.e., select --
a record, move the highlight bar (the blinking cursor) anywhere in the par-
ticular record(s) you want to select, then press the SPACEBAR once. A
checkmark appears at the beginning of the record -- the extreme left-side of
the window -- indicating that the record has been tagged (selected). To dese-
lect and tagged record, move the highlight bar to the tagged record and press
SPACEBAR again.
If you type C, you clear all tags. If you type S, you are presented with
our familiar "Search for:" menu (see "Search" on page 4). This "tagging win-
dow" can be scrolled with the LEFT/RIGHT ARROW keys, the DOWN/UP ARROW keys
and the PGDN/PGUP keys.
Before a record is tagged, the words "NOT TAGGED" are displayed at the
top right of the tag window. When a record is tagged, each time you move the
highlight bar to it, the word "TAGGED" is displayed for that record.
When you are done tagging or viewing, press ESC. (Any records tagged re-
main tagged while you are using this part of the system. But, as soon as you
return to the Auxiliary Menu or to the Main Menu, all tags are turned off au-
tomatically.) When you press ESC at the tagging window, you are returned to
the "Label/Rolodex" menu for printing or whatever you decide to do.

BUILD OR MODIFY QUERY

This is our familiar "Query" menu. For more information, see "Query."
NOTE: Whatever queries are defined here in this part of the system will
apply to not only records for Labels and Rolodex lists, but wherever else you
can access "Query." That is, if you define a "Query" as active ANYWHERE in
the system, that query will remain active EVERYWHERE in the system from where
you can build or access a query. Of course, you can always ZAP the active
query to build a new one, or simply build a new one, which will then become
the new, active query until it is ZAPped.
Since Query is so powerful, you can define one anywhere, and use it any-
where you can access it. We find this feature very useful in that we build
queries to access/display specific records from the "Query" menu. We then go
into Labels and produce labels for only those records. It saves us from hav-
ing to define the the same query again. Of course, you can save it to disk
and then retrieve it whenever you want it.
The system will always tell you if/when a query is active.











VITRON's NAME & ADDRESS SYSTEM 32.

REPORTS & LISTS

[Ad-Hoc Report Builder]
Pick fields to list [No Query ]
Modify fields to list
Output list
Save list definition to disk
Restore list definition from disk
Delete stored definitions
Choose Printer Port (now LPT1)
Quit VITRON's

Name & Address System



Current Fields to List:




[ # of columns needed: 0]


When you select "Reports & Lists" from the "Pick One:" menu, you are
presented with the above menu -- the "Ad-Hoc Report Builder" menu.
This is a true ad-hoc list builder. Your options are:

PICK FIELDS TO LIST .................. to select the fields
you want to include in
your listing

MODIFY FIELDS TO LIST ................ modify the field list

OUTPUT LIST .......................... to print/display the
listing

SAVE...TO DISK ....................... save the list you
picked to disk for
future use

RESTORE LIST DEFINITION .............. retrieve a saved list
from disk to be used

DELETE STORED DEFINITIONS ............ deletes saved lists from
disk

CHOOSE PRINTER PORT .................. normally, the default,
LPT1, is acceptable

QUIT ................................. return to Auxiliary
Menu


VITRON's NAME & ADDRESS SYSTEM 33.

PICK FIELDS TO LIST

[Enter - Select/Deselect Fields]
Acct Num
Code-1
Code-2
Code-3
Code-4
First Name
Middl Init
Last Name
Title
Company
Compny Dpt
Bus. Addr1
Bus. Addr2
Bus. City
Bus. State
[Press F10 when done ]

When you select "Pick fields to list" you are presented with a pick-list
of field names from which to choose. Keep in mind that the number of fields
you select will have a direct impact on the report. If you printer can print
80 columns, try to limit your fields to fit in 80 columns. As you select each
field, the system knows the size of that field and displays a counter at the
bottom of the screen. This counter tells you the number of columns that are
needed to print out the report as you are defining it.
NOTE: We are already working on the next release of this system. It will
include the ability to more precisely define your particular printer options,
including compressed print and, for you laser users, landscape printing. It
will include a printer-option table for over 30 different printers. You reg-
istered users, watch for our announcement in the mail soon. The upgrade will
be free to all registered users.

OUTPUT LIST

When you select this option, you are presented with the "Send to:" menu.

[Send to: ]

Printer
Text File
Screen
Quit



You can send the output to the printer, to your screen, or to a .TXT
file.
When you select where you want the output to go to, you are presented
with the "Record Selection:" menu.



VITRON's NAME & ADDRESS SYSTEM 34.

[Record Selection]
All Records
Query Matches
Tagged Records


This menu should be familiar to you by now. You can list all records,
records that match a query, or all records you tag. If you select "Query
Matches," you are provided with our familiar "Query" menu. If you select
"Tagged Records," you are presented with our familiar "tag window." However,
if you selected "Printer," after you tell the system about "Record Selec-
tion," you are presented the the following prompt window:


Maximum line length to print: 78
Spaces between columns (fields) 1
Maximum records to print (default = ALL) 10


Normally, the defaults as displayed should suffice. To accept the de-
faults, simply press ENTER when the cursor is in the appropriate area. To
change a default, type in the new value then press ENTER.
The "Maximum records to print" defaults to ALL, which shows you the to-
tal number of records on file. If you used "Query" or tagged records, or have
decided to otherwise limit the number of records to print, simply enter the
new number to override what the system has defined for you.
When all is ready, you are provided with the following prompt:


Print/Display this list now ?
YES NO


If you select "YES" the system will determine if your printer is ready
-- if you selected "Printer" -- and will begin the operation. If you opted to
display the list on the screen, it will be displayed. To return to the menu,
press ESC. If you opted to create a .TXT file and that filename already ex-
ists, you'll be asked if you want to overwrite it.

4. TODO LIST

When you select "Todo List" you are presented with the ToDo Screen.
The screen (illustrated on the next page) is divided into three areas. The
top area lists your todo items, categories, priorities, date and do-by
fields.
The middle portion of the screen is the data entry area.
The bottom portion of the screen is the "menu" area. The menu provides
the following options:

Q)uit ..................... to return to the Auxiliary Menu




VITRON's NAME & ADDRESS SYSTEM 35.

E)dit ..................... to edit the currently highlighted
item

A)dd ...................... to add a new item to the list

D)elete ................... to flag an item for deletion


Item Category Priority Do by Done














Item........
Category.... Priority.. Do By..03/29/91 Done?..N

(Press F2 to lookups)



Q)uit E)dit A)dd D)elete F)ilter M)emo P)rint O)rder


F)ilter .................. to define a filter -- that is, to
limit the display to records
of a specific category, priority,
date or completed status.

M)emo .................... to attach a brief memo to the
current item

P)rint ................... to print the items using a specific
order; lists may be "filtered" or
"unfiltered"

O)rder ................... to change the sequence -- the
default is by category

To select a menu item, simply type the first letter of the item you want
to select.




VITRON's NAME & ADDRESS SYSTEM 36.

ADD

When you select "A)dd", the cursor moves down to the data entry area.
Also note that the item area in the data entry field is longer than the item
field in the top part of the screen. That's okay. The top portion of the
screen will display only a portion of the item entered. But, whenever you

highlight an item in the top portion of the screen, the complete item is
displayed in the data entry area as well.
Also notice that when you select "A)dd" (and "Edit" too for that
matter), the system displays "Press F2 for lookups."
Enter your items accordinly.
The "Category" field is up to you. Define your own categories. Just try
to be consistent, however. Categories may include such things as Software,
Hardware, Personal, Business, Client, Household, Notes, Family, etc., etc.
Priorities are numeric, from 01 to 99.
When you complete your entry, the item is listed in the upper portion of
the screen as well as in the data entry area. Whenever you highlight an item,
it is listed in both areas of the screen.
The item can now be edited. For example, when you complete it, you may
want to change the "Done?" indicator from "N" to "Y".

EDIT

You can edit an item in one of two ways.
The first way is to move the highlight bar to the item you want to edit,
and then type E. Or you can move the highlight bar to the item you want to
edit -- indeed, you can move the highlight bar to the field of the item you
want to edit -- and press ENTER. The cursor drops down to the data entry area
of the screen, in the field that was highligted at the time you pressed EN-
TER.

F2 FOR LOOKUPS

If you press the F2 function key when in either ADD or EDIT mode, you
are presented with a pick-list of field contents that correspond to the field
highlighted by the highlight bar in the upper portion of the screen. You can
then scroll through the items, picking the one you want.

DELETE

To delete an item, move the highlight bar to the item you want to flag
for deletion, then press D. You will be prompted to confirm the deletion. If
you opt to delete it, it will be displayed in the upper area of the screen
prefixed with an asterixk (*), indicating that it has been flagged for dele-
tion. You can, of course, undelete it the same same way you deleted it.
However, when you finally decide to Quit and return to the Auxiliary
Menu, and you have items flagged for deletion, the system will permanently
remove (delete) all flagged items. You'll know this because the system will
tell you that it is packing and reindexing the ToDo file.





VITRON's NAME & ADDRESS SYSTEM 37.

FILTER

When you type F, you are prompted to set the "filter" based on Category,
Date or Priority, based on the currently highlighted item. If you select a
filter, only records that match that filter are displayed.

MEMO

When you select "M)emo" you can enter a brief memo in the data entry
area for the highlighted record. Save the memo by pressing F10; abort the
memo by pressing ESC. Keep you memos to a maximum of three lines.

PRINT

When you select "P)rint" you'll be first asked to decide on the sequence
of display -- i.e., by Category (the default), Priority or Date.

ORDER

When you select "O)rder" you can change the sequenc of the display items
-- by Category (the default), by Priority or by Date.

5. FORM LETTERS

When you select "Form Letters" from the Auxiliary Menu, you are pre-
sented with a menu asking if you want Business Data or Home Data.

Using:
Business Data
Home Data
Quit to Main


After you make your selection, you are presented with the "Form Letter
Utility" menu. Your options are:

SELECT FORM ................... to select a predefined form
from disk

CREATE NEW FORM ............... to create a new form letter














VITRON's NAME & ADDRESS SYSTEM 38.

[Form Letters Utility] [No Query ]
Select form
Create new Form
Delete Forms
Edit current form
Print form letters
Width of Form : 79
Output to :PRINTER
Assign Printer Port
Filter :ALL RECORDS

Quit




CURRENT FORM ->
DATAFILE ->NAME



EDIT CURRENT FORM ............. edit the current form

PRINT FORM LETTERS ............ print the current form using
the database records
selected

WIDTH OF FORM ................. set the printer width

OUTPUT TO ..................... send the output to the
Printer or to a .TXT file

ASSIGN PRINTER PORT ........... assign the printer port

FILTER ........................ define the record selection
criteria -- default is ALL
records

QUIT .......................... return to the Auxiliary Menu

We have created a sample form letter for you to look at.

SELECT FORM

This options displays a pick-list of forms on disk -- forms you created
and saved. If you select a stored form from disk, the name of the selected
form is displayed at the bottom of the screen. Once a form is selected (or
created), it can be edited and printed.
(If you want to see what a typical form looks like, select "Select." The
form we created is called "TEST." It's the only form currently available. Se-
lect it from the list and then "Edit" it.)



VITRON's NAME & ADDRESS SYSTEM 39.

CREATE NEW FORM


Enter a description for the form letter



When you choose "Create," you are prompted to enter a brief descrip-
tion for the new form. This description is used to identify all saved forms,
so be as specific as you can. When you create the form, it is saved auto-
matically for you under the description you enter. Then, when you choose
"Select Form," you are presented with a pick-list of saved descriptions.
After you enter a description, you are asked if you want to use another
form as a shell -- a template (a sample).


Use another form letter as a shell ?
No Yes


If you select YES, you are presented with a pick-list of saved forms. If
you select NO, you are asked if you want to import (bring in) a text file as
a shell.


Import a text file as a shell ?
No Yes


If you select YES, you are prompted to enter in the name of the file to
import. You can use wildcards, like in DOS. If you leave the field blank and
press ENTER, in a few seconds you are presented with a pick-list of available
.TXT files in the current directory. If you select NO, you are immediately
taken to the forms entry screen.
When in the forms entry screen, you'll see function keys displayed at
the top of the screen. The keys represent the following:

F1 ............... to display some help

F2 ............... provide a pick-list of busiess/home address
data to choose

F10 .............. save the current form

ESC .............. cancel and return to the Forms menu

Each of these keys should be fairly obvious. However, let's discuss the
F2 function key in a bit more detail.






VITRON's NAME & ADDRESS SYSTEM 40.


Use || to point to field
Press ENTER to accept
Press ESCAPE to abandon

Assumes that First Name
Business Data Last Name
was selected Company
Title
Address 1
Address 2
City
State
Zip
Telephone
Ext
Fax




Pressing F2 provides you with a pick-list of fields. To select -- that
is, insert a field in the form -- move the cursor to the area of the form
where you want to insert that field. Then press F2. Select the field you
want by highlighting it and pressing ENTER. A special field reference is
then inserted at the cursor position. This field reference is used to insert
actual file contents when you print the form -- print it or display it on
the screen. Continue selecting desired fields in the same way.
You will be asked if you want to convert the field to "Proper" format.
Generally, you can respond NO since all fields have already been converted to
"proper" format when you entered the data. "Proper" format means that each
word starts with a capital letter.
If you decide to select -- i.e., reference -- both Address 1 and Address
2 (line 1 and line 2 of the address) and line 2 is blank for a record, the
system will take care of that situation by skipping the field when it pro-
duces the form for the specific record(s). Inotherwords, it prints the ad-
dresses properly. NOTE: This is true for all reports, not just form letters.
To look at a sample form, select the form "TEST" from the disk and
"Edit" it. You'll see what we mean by "field references." This feature pro-
vides a true mail-merge facility when you decide to print the records.

DELETE FORMS

Selecting this option presents you with a pick-list of current saved
forms from which you can choose those to tag. First, you tag each form you
want deleted. When you have completed the tagging operation, press ESC.
You are then prompted whether or not you wish to flag the tagged forms
for deletion. IF you select NO, they are not flagged. If you select YES, they
are flagged for deletion. IF you select YES for deletion, you are then asked
if you want to permanently remove them from disk. If you select NO, they re-
main on disk as flagged for deletion. If you select YES, they are erased from
the disk. In addition, if you select YES, the file is packed and reindexed.


VITRON's NAME & ADDRESS SYSTEM 41.

Again, if you select YES, you are asked if you want the system to pack
the memo file. We strongly recommend that you always respond YES to this
prompt -- i.e., pack the memo file.

A NOTE ABOUT PACKING MEMO FILES

dBASE-related systems, such as this one, have one flaw with memo files.
When you delete and pack corresponding database file records, the memos for
those records are flagged in the memo file, but are never actually removed.
As such, Memo files grow in size even if database file records have been
erased. To prevent this wasting of disk space, we encourage you to pack the
memo file whenever you delete forms. This way, the memo file is properly
maintained.
NOTE: We have not as yet included this "memo packing" feature in the
other parts of the system. But, we shall in our next release to registered
users only.

EDIT CURRENT FORM

This option permits you to edit/change/update the current form.

PRINT FORM LETTERS

This option prints the forms, one form per record selected. When you se-
lect this option, you are first prompted to enter the left and top margins
for printing. You are then asked if you want to pause between each form's
printing. If you select YES, the system pauses before printing each form
while showing you on the screen the form it is about to print, with the ref-
erenced fields filled in. It's like a preview of the printed form before ac-
tual printing it.
You are provided with a menu at the bottom right of the screen. This
menu has the following selections:

PRINT THIS LETTER ................. to go ahead and print the
displayed form

EDIT THIS LETTER .................. allows you to first edit
the displayed form
before printing it

SKIP THIS LETTER .................. don't print the currently
displayed form

NO MORE PAUSING ................... to cancel pausing and
print continuously

QUIT PRINT ........................ to stop printing and
return to the Forms
Menu





VITRON's NAME & ADDRESS SYSTEM 42.

WIDTH OF FORM

Select this option to change the column width of your form. Normally,
the displayed defaults are adequate.

OUTPUT TO

This option is two-fold, as a toggle. Select it once to change from
"Printer" to "File." Select it again to return to "Printer."

ASSIGN PRINTER PORT

Select this option to change the printer port. Normally, the default,
LPT1, is correct.

FILTER

If you select this option, you can define the specific records to in-
clude and exclude those not selected.
You can select records based on a "query" or you can "tag" specific
records. (See page 19 for "Query" and page 32 for "tagging.")

Filter type
None - All records
Query Matches
Tagged Records


If you select "Tagged Records" you are asked if you want to begin the
tagging process now. If NO, you are returned to the Forms menu. If you select
YES, you are presented with the "tagging window."


| | > < SPACE = tag C = clear S = search ESC = done
[NOT TAGGED]
| First Name Last Name

Michael Donner
Janet Jackson
Harry Johnson
Edward Marshall
Frank O'Connor
Paul Peterson
Theordore Roosevelt
John Smith
Loraine Thomas
Peter Wilson







VITRON's NAME & ADDRESS SYSTEM 43.

6. APPOINTMENTS

When you select "Appointments" from the Auxiliary Menu, you are pre-
sented with a powerful, integrated appointment tracker and manager. You can
point to any date to add, edit or view appointments for that date. You may
also print or delete appointments for any range of dates. More advanced fea-
tures include a BROWSE MODE (a somewhat unique feature of our system that is
not quite the same in other similar systems -- in Browse you can do every-
thing: add, edit, delete, locate, etc., etc.); the ability to add peri-
odically recurring appointments and other nice facilities.
When you first select "Appointments" from the Auxiliary menu, you are
presented with a calendar display of the current month and the first two
weeks of the following month. The current DOS system date will be blinking.
If there are any current appointments already scheduled for the current
month, you'll see their dates highlighted. If there are any appointments for
the current day, the first seven (7) of them will be displayed in a window
underneath the calendar.


March 1991 <> move by day || by week
PgUp/PgDn move by month
Su Mo Tu We Th Fr Sa Home/End first/last day
add/edit Esc exit
1 2 S Search for text
3 4 5 6 7 8 9 P Print appointments
10 11 12 13 14 15 16 D Delete appointments
17 18 19 20 21 22 23 B Browse thru appts
24 25 26 27 28 29 30 C Current date: 03/29/91
31 1 2 3 4 5 6
7 8 9 10 11 12 13


As the display on the right indicates, there are several "active" keys.

(1) The DIRECTION KEYS
------------------
LEFT ARROW .................. go back one day
RIGHT ARROW .................. go forward one day
UP ARROW ..................... go back one week
DOWN ARROW ................... go forward one week
PGUP ......................... go back one month
PGDN ......................... go forward one month
HOME ......................... go to first day of displayed
month
END .......................... go to last day of displayed month

(2) The SELECTION KEYS
------------------
ENTER ........................ select current (blinking) day to
add/edit/view appointments




VITRON's NAME & ADDRESS SYSTEM 44.

(3) The MENU KEYS
-------------
S ............................ search for text in either the
description or notes of an
appointment

P ............................ print appointments

D ............................ delete appointments

B ............................ present a TABLEVIEW (Browse
Window) of appointments

C ............................ jump to the current date (current
DOS system date)

ADDING/EDITING/VIEWING APPOINTMENTS

Use the direction key to move to the desired date, then press ENTER.


Who Start End Appointment Description = Notes

: :


Ctrl W=Saves Esc=Quits

A data entry window appears. Enter the "Who" the Start and End times
(for example, as 09:00) and a brief description. If you attempt to add an ap-
pointment that creates a conflict with an already existing appointment, you
will be so informed. To save the appointment, press CTRL W.
If there already are appointments for the selected date, you will see a
small browse window at the bottom of the screen showing the time and descrip-
tion of appointments for that date.

Appointments for 03/29/91
JAMES 09:00 - 05:00 see the man about a horse








If there already are appointments for the selected date, the data entry
window is slightly different from the one above. (See the illustration on the
next page.)





VITRON's NAME & ADDRESS SYSTEM 45.


Who Start End Appointment Description = Notes

JAMES 09:00 05:00 see the man about a horse


A add E edit D delete M move R recurring appt N notes Esc exit

If the above is displayed, to add a new appointment, press A. Enter the
data in the same way as described above.
To edit the highlighted appointment, press E. As with adding appoint-
ments, you won't be permitted to enter conflicting appointments. Press CTRL W
to save your changes or ESC to exit without saving.
To delete the highlighted appointment, press D. You will be asked to
confirm. Press Y for YES or N for NO.
You may move appointments from one day to another by pressing M. A win-
dow will appear and you'll be asked to type in the new date for the appoint-
ment.
To add recurring appointments, press R. Follow the same steps as when
adding a single appointment. After you press CTRL W to save the appointment,
you will be provided with the following options:

- Every day-of-week (Mon., Tue., etc.)
- Every other day-of-week
- Every nth day of the month (e.g., 1st day of every month)
- Every day
- Every nth day-of-week (e.g., 3rd Tues. of every month)
- Every weekday only (excluding weekends)

Use the ARROW keys to select the desired option then press ENTER.
You may add notes (memos) for the highlighted appointment. Simply press
N. A window will appear below the appointment entry screen into which you can
enter whatever notes about the appointment you wish. Press CTRL W to save the
note, or press ESC to cancel the note.
Any appointments that have notes attached will be displayed in the entry
window with a checkmark at the extreme right side of the description.
To return to the calendar, press ESC.

PRINTING APPOINTMENTS

To print appointments, press P at the calendar display. You can print
for the current week, or for a range of dates that you enter in. If you print
for just a week, you'll be prompted to enter a specific UserId (Who), or ALL
for all users.
If you want to print for a range of dates, you'll be asked to enter both
the starting and ending dates to print. If there are no appointments within
the range, the system will tell you. You'll also be asked if you want to in-
clude the notes (memos) in the listing.

DELETING APPOINTMENTS

You can delete appointments for a range of dates. To select "Delete"


VITRON's NAME & ADDRESS SYSTEM 46.

type D. You'll be prompted to enter in both the starting date and the ending
date for deletion. If there are no appointments for the range, the system will
tell you. When you proceed to delete a range of appointments, the system will
display the number of affected appointments and the system will ask you to
confirm each delete request. To delete, select YES; otherwise, select NO.

BROWSE APPOINTMENTS

This is the feature that we feel makes our system unique. It works the
same as the "Table" selection from the system's Main Menu. For more informa-
tion on TABLEVIEW (Browsing, etc.) see "Table" on page 9.

=============================================================================
THE ADD OPTION

When you select "Add" from the Main Menu, you are presented with the
main data entry screen.
Enter your data accordingly. If you leave both the Last Name field AND
the Company field blank, the system assumes that you don't intend to add any-
thing, so that when you proceed to try to save the record (pressing PGDN or
pressing CTRL W) you are immediately returned to the Main Menu.
When you select "Add", make your entries. To save, press PGDN. Press ESC
to cancel your entry.
The system will then display a prompt asking if you want to save the
data. If you select YES, the data will be saved and you'll be asked if you
want to attach a memo to the current entry.
If you selected to save your data and also selected to add a memo item,
you are presented with the Memo-entry window. Enter your memo, keeping it to
less than 26 lines. Press the F10 function key to save the memo; press ESC to
cancel the memo. You can always go back and edit the memo later, using the
"Memo" option of the Main Menu or the "Update" option.
There is one feature we should point out. When you get to the State
field and you enter an invalid State abbreviation (we have also accounted for
some countries), the system will display a pick-list of valid state abbre-
viations. You can scroll through the list to select the state you want, then
press ENTER. The system will insert the state abbreviation into the record
for you.

THE UPDATE OPTION

Selecting "Update" from the Main Menu works essentially the same as Add-
ing records, except that you can change the data in the current record. Press
PGDN to save your changes; press ESC to cancel your changes.

STARTING FRESH

As you have determined by now, there are ten test records on the file
already. You can delete each of these records in preparation for your own
data. Simply press N (for Next) or P (for Previous) and go to each record.
Then select "Delete" from the Main Menu to flag each test record for dele-
tion.



VITRON's NAME & ADDRESS SYSTEM 47.

When you have flagged each test record, select "Other" from the Main
Menu. This presents you with the Auxiliary Menu.
At the Auxiliary Menu, select "Index Files." This will pack and reindex
all of the files and will permanently remove the test records so that you can
begin with a nice, clean file for your own entries.

A NOTE ABOUT THE CODES FIELDS

The system data entry screen provides you with four codes, three spaces
per code. These can be extremely useful for generating custom lists and la-
bels. For example, if you want to create a top priority contact list, you
might enter VIP in one of the code fields. Later, you can ask the system to
generate a list of all VIPs in the database. The code field can also be used
to identify a person's specialty. Dr. Jones, for example, might have the code
RES for researcher, and a second code, MB, for molecular biologist. The ap-
plications of the code fields are limited only by your imagination.
You may structure the codes any way you like, as long as you are CON-
SISTENT. We stronly recommend that you keep a list of codes handy so that you
will always use the codes properly and consistently. If you would like us to
develop a custom Code File Cross reference, just let us know and provide us
with the codes and their meanings. There will be a nominal charge for this
effort -- for registered users only.
































VITRON's NAME & ADDRESS SYSTEM 48.

ACKNOWLEDGEMENTS

We would like to thank both Greg Lief and Gary Prefontaine for what are
perhaps the two best Clipper Function Libraries available -- at least for
what we want to do.
This system is based on heavy use of both libraries. Yet, we have made
many -- and we mean MANY -- changes so that a great deal more functionality
and features have been included in our system. The changes were necessary to
accommodate additional features and to eliminate several deficiencies that we
found (personal preference, of course). The changes and modifications we
made, however, cannot take away from our appreciation and respect for these
two Clipper experts, without whose underlying functions many of the features
contained herein would have been too costly and time-consuming to reinvent.
Also, we want to thank several of our clients -- who shall, for good
reason, remain nameless herein, yet, you know who you all are -- for the many
hours you spent helping us test and validate this system and for making it
what we trust is a true user-friendly system. Special thanks to Eileen, for
all of her confidence and support, especially when we needed it most -- de-
ciding to release the system into the shareware market. Eileen, we hope you
were right!


































VITRON's NAME & ADDRESS SYSTEM 49.

REGISTRATION

Well, folks, this is the hard part -- asking you to register.
This system is provided to you as"shareware." It is NOT public domain
and it is NOT free. (You know the spiel....)
You may try NAME/ADDRESS for a period not to exceed thirty (30) days
from the time you first receive it from us or from when you first downloaded
it from a bulletin board. (We wish we had a way to verify this -- but, we
don't -- and we are sure you know this anyway.) If you find the system useful
and want to keep on using it, guess what? Yes, you must register it and, as
with all things we like to keep and use, you must also pay for it. It's inex-
pensive enough to warrant your consideration.
Of course, we at VITRON are realists and we know that in many instances
requests for registration and payment simply fall on deaf ears. But, we be-
lieve that this system is worth it. You are on the honor system and no one,
especially us, can make you do what you what you don't want to do.
The system is fully functional. There are no shareware messages, no
shareware screens, no code numbers, no authorization codes and no time bombs.
This system is the very same one we at VITRON use every day and is very much
like those which many of our clients use -- though they have more customized
versions. (Yes, we can customize the system for you. Call us for a price
quote and to discuss your needs.)
We are in the process of completing a major upgrade to the system --
with many additional features and facilities. This upgrade will be provided
to all registered users free of charge. However, if you plan on waiting for
the upgrade to be posted on bulletin boards, you're out of luck since only
registered users will be notified and provided with it.
It's up to you now. If you like the system and use it, register it. At
least you'll have the peace-of-mind that comes with being honest. The ball is
in your court.
If you don't register and run into any problem, you'll find that we'll
not be able to help you. Support is provided to registered users only.
To register your copy, simply complete the form on the next page and
send it to us along with your check or money order for $39.95 at your earli-
est convenience.
We would like to thank you in advance for your support of the shareware
concept.
In any case, we hope you enjoy this system and, if nothing else, con-
tinue exploring the world of microcomputers. Happy computing!















VITRON's NAME & ADDRESS SYSTEM 50.

NAME/ADDRESS REGISTRATION FORM

VITRON Management Consulting, Inc.
11-33 Jackson Ave.
Scarsdale. NY 10583
(914) 793-0042

Electronic Bulletin Board: (914) 779-4273


YOUR NAME: ________________________________________________________

COMPANY: __________________________________________________________

TITLE: ____________________________________________________________

ADDRESS: __________________________________________________________

__________________________________________________________

CITY: __________________________ STATE: __________ ZIP: ___________

TELEPHONE: ________________________________ EXT: __________________

Is this telephone Number your Home [ ] or Business [ ] ?


QUANTITY ITEM COST
-------- ---- -----

______ Copies of NAME/ADDRESS SYSTEM @ $39.95 each ___________


Please indicate desired diskette medium for upgrade distribution:

[ ] 5.25" [ ] 3.5"


Make check or money order payable to: VITRON, Inc.

No CODs, No Purchase Orders. U.S. funds drawn on U.S. banks only.

Corporate site licenses available on request.


From where or from whom did you receive your copy of NAME/ADDRESS:

____________________________________________________________________

Telephone Number (if known): _______________________________________



Contents of the README.1ST file

























NAME AND ADDRESS SYSTEM

USER MANUAL AND REFERENCE GUIDE








By: VITRON Management Consulting, Inc.
11-33 Jackson Avenue
Scarsdale, New York 10583
(914) 793-0042

Electronic Bulletin Board: (914) 779-4273




(c) Copyright 1991, VITRON Management Consulting, Inc.
All Rights Reserved.




TABLE OF CONTENTS

LICENSE AGREEMENT ................................... i.

INSTALLATION INSTRUCTIONS ........................... ii.

NAME/ADDRESS SYSTEM FILES ........................... iii.

STARTING NAME & ADDRESS ............................. 1.

THE MAIN MENU ....................................... 3.
The Delete Option ................................. 4.
The Search Option ................................. 4.
- Fields Contents Match ......................... 5.
- Memo Contents ................................. 8.
The Key Option .................................... 8.
The Table Option .................................. 9.
- Business Data and Home Data ...................10.
- Browse All or Select Certain Fields ...........10.
-- Select Certain Fields ....................11.
-- The Browse Window (Table-View) ...........11.
-- Navigation Keys ..........................13.
-- Quit .....................................14.
-- Goto .....................................14.
-- Locate ...................................15.
-- Vertical View ............................15.
-- Pressing ENTER When in Browse ............16.
-- Delete ...................................16.
-- What is a Record "Flagged" for Deletion? .16.
The Hard Option ...................................17.
- Record Had Memo Attached? .....................17.
The View Option ...................................19.
The Query Option ..................................19.
- Build a New Query .............................21.
The Memo Option ...................................26.
The Other Option ..................................27.
1) Index Files ..................................29.
2) Change Sequence ..............................29.
3) Produce Reports ..............................29.
- Labels & Rolodex ..........................29.
-- Open Label File ......................31.
-- Tag Records to Print .................32.
-- Build or Modify Query ................32.
- Reports & Lists ...........................33.
-- Pick Fields to List ..................34.
-- Output List ..........................34.
4) ToDo List ....................................35.
- Add .......................................37.
- Edit ......................................37.
- F2 For Lookups ............................37.
- Delete ....................................37.
- Filter ....................................38.
- Memo ......................................38.
- Print .....................................38.
- Order .....................................38.

TABLE OF CONTENTS (continued)

5) Form Letters .................................38.
- Select Form ...............................39.
- Create New Form ...........................40.
- Delete Forms ..............................41.
- About Packing Memo Files ..................42.
- Edit Current Form .........................42.
- Print Form Letters ........................42.
- Width of Form .............................43.
- Output To .................................43.
- Assign Printer Port .......................43.
- Filter ....................................43
6) Appointments .................................44.
- Direction Keys ............................44.
- Selection Keys ............................44
- Menu Keys .................................45.
- Adding/Editing/Viewing Appointments .......45.
- Printing Appointments .....................46.
- Deleting Appointments .....................46.
- Browse Appointments .......................47.
The Add Option ....................................47.
The Update Option .................................47.
Starting Fresh ....................................47.
A Note About the Codes Fields .....................48.

ACKNOWLEDGEMENTS ....................................49.

REGISTRATION ........................................50.

REGISTRATION FORM ...................................51.






















(c) Copyright 1991, VITRON Management Consulting, Inc.
All Rights Reserved.

IMPORTANT! READ THIS BEFORE USING THE NAME/ADDRESS SYSTEM
END-USER LICENCE AGREEMENT

The software and documentation are distributed as "SHAREWARE" and are
provided to you on the condition that you agree with VITRON Management Con-
sulting, Inc., hereinafter referred to as VITRON, to the terms and conditions
as set forth below. READ THIS USER LICENSE AGREEMENT CAREFULLY. YOU WILL BE
BOUND BY THE TERMS OF THIS AGREEMENT IF YOU USE THE SYSTEM EVEN ONLY ONCE.
If you do not agree to the terms contained herein, do not use the system.
VITRON grants, and you hereby accept, a personal non-exclusive license
to use the software program and associated documentation in this package, or
any part of it ("Licensed Product"), subject to the following terms and con-
ditions:

1. LICENSE
You may use this system and its associated documentation for a period of
thirty days (30) on a trial basis only. If you decide to keep it and continu-
ing using it, you must register and pay for this Licensed Product. The soft-
ware and its associated documentation are copyrighted by VITRON and are on
file with the Copyright Office of the Library of Congress. Modifications to
the software or its documentation without the expressed, written approval of
VITRON are in violation of Federal Copyright Law and may subject the in-
fringer to both civil and criminal penalties.

2. The software program and its associated documentation are provided
"AS IS" without warranty of any kind, either expressed or implied, including
but not limited to the implied warranty of merchantability and fitness for a
particular purpose. The entire risk as to the quality and performance of the
program is with you. Should the program prove defective, you and not VITRON
assume the entire cost of all necessary servicing, repair or correction.
Some states do not allow the exclusion of implied warranties, so the
above exclusion may not apply to you. This warranty gives you specific legal
rights, and you may also have other rights which vary from state to state.
VITRON does not warrant that the functions contained in the program will
meet your requirements or that the operation of the program will be uninter-
rupted or error free. Neither VITRON or anyone else who has been involved in
the creation or production of this product will be liable for any direct, in-
direct, incidental, special or consequential damages, whether arising out of
the use or inability to use this product, or any breach of a warranty, and
VITRON will have no responsibility except to replace the diskette pursuant to
this limited warranty (or, at its option, provide another copy) to REGISTERED
USERS ONLY. UNREGISTERED USERS ARE ENTITLED TO NO WARRANTIES AND TO NO SUP-
PORT WHATSOEVER.
No sales personnel or other representatives of any party involved in the
distribution of the Licensed Product is authorized by VITRON to make any war-
ranties with respect to the diskette or the Licensed Product beyond those
contained in this Agreement. Oral statements do not constitute warranties,
shall not be relied upon by you, and are not part of this Agreement. The en-
tire agreement between VITRON and you is embodied in this Agreement.
If any provision of this license agreement is determined to be invalid
under any applicable statute or rule of law, it shall be deemed omitted and
the remaining provisions shall continue in full force and effect. This Agree-
ment is governed by and construed in accordance with the laws of the State of
New York.
i.

INSTALLATION INSTRUCTIONS

This system is specifically intended to run on a hard disk. If you do
not have a hard disk, do not attempt to run this system since no provisions
have been made to operate this system on a diskette-based-only computer.
The system includes an installation batch file program that does the
following:

(a) creates the appropriate directory on the C: drive
(b) copies the files into that directory
(c) decompresses the files copied into the directory

The files on the distribution diskette are COMPRESSED. You must use the
INSTALL procedure to install the system. Do NOT attempt to run the system
from the diskette as it will not function.
If you are familiar with DOS BATCH files, you may change the INSTALL.BAT
file to change the drive and/or directory on your own.
However, do not attempt to change this file unless you know what you are
doing.
To install VITRON's Name/Address System, start you computer as normal.
At you DOS prompt, insert the diskette into your A: drive. Then, type the
following:

A:INSTALL and press ENTER

Don't forget to put the colon (:) after the letter A. No spaces in the above
command either.
That's all there is to it. The install procedure first will create a di-
rectory on your C: drive named:

\VMCNA

It will then copy the files from the diskette into this directory. It
will then decompress the system files.
You are now ready to begin running VITRON's NAME/ADDRESS SYSTEM. (See
page 1 of this manual.)


IMPORTANT! IMPORTANT! IMPORTANT!

THE BULLETIN BOARD VERSION DOES NOT INCLUDE THE INSTALL.BAT PROGRAM.

FOR THOSE OF YOU WHO RECEIVED THIS SYSTEM FROM A BULLETIN BOARD,

CREATE YOUR OWN DIRECTORY AND RUN THE SYSTEM FROM THERE.










ii.

NAME/ADDRESS SYSTEM FILES

The following files, included with the archive, are absolutely essential
in order to run NAME/ADDRESS (if you are missing any of them, please let us
know as the system will not run without all of them):

MANUAL.DOC .............. the documentation file (this file you're
reading)
STATE.DBF ............... the State database file
NAME.DBF ................ the Master Name & Address database file
NAME.DBT ................ the Master Name & Address Memo file
ROLODEX.LBL ............. large rolodex label file
S_ROLO.LBL .............. small rolodex label file
BUSINESS.LBL ............ Business Address Mailing Labels file
HOME.LBL ................ Home Address Mailing Labels file
NAME.EXE ................ the NAME/ADDRESS Program
INSTALL.BAT ............. the Install program

The following files are included in the archive. However, if one or more
of them happen(s) to be missing, the system will create it/them as and when
needed:

APPT.DBF ............... the Appointments database file
APPT.DBT ............... the Appointments Memo file
TODO.DBF ............... the TODO database file
QUERIES.DBF ............ the Query database file
FORM.DBF ............... the Forms database file
FORM.DBT ............... the Forms Memo file
PLIST.DBF .............. the Print List database file

The following files are included in the archive. They are the varous IN-
DEX files for the system's database files. However, if one or more of them is
missing, the system will create it/them as and when needed:

APPTUSER.NTX
APPTDATE.NTX
TODOD.NTX
TODOP.NTX
TODO.NTX
LNAME.NTX
ST.NTX
COMPANY.NTX
ACCT.NTX

All of these files need to be located in the same directory in which you
install NAME/ADDRESS. The install procedure takes care of this.
However, if you install the system manually, make sure you copy all of
these files onto the drive and into the directory you create.






iii.

STARTING NAME & ADDRESS
-----------------------
To start the system, first change to the directory into which you in-
stalled it. Assumming that you did not change the installation procedure, and
that your default drive is the C: drive, simply type:

CD \VMCNA and press ENTER

Then, at the DOS prompt, type:

VMCNA and press ENTER

You are presented with the opening screen, which includes our copyright
notice.

VMC's NAME & ADDRESS

WELCOME TO

VITRON'S NAME & ADDRESS SYSTEM


(c) Copyright 1991, VITRON Management Consulting, Inc.
All Rights Reserved.



Press ENTER to proceed...


As you can see, you are prompted to "Press ENTER to proceed...". So,

PRESS: ENTER (actually, pressing any key will do)

You are presented with the system's Main Display Window, with the
system's Main Menu at the bottom of the screen. (See top of next page.) The
system comes to you with ten (10) initial test data records. You can delete
these records and begin adding your own "live" data at any time. But, we do
recommend that before you do, please take the tour with us so that you are
familiar with all of the system's features and facilities.
Each of the Main Display's fields should be fairly self-explanatory with
the possible exception of the "Codes:" fields. We'll explain "Codes:" a
little later. The current (default) index -- i.e., file sequence -- is Last
Name + First Name. This sequence can be changed, as we'll see later. The cur-
rent record (first record) is the record for a Michael Donner of the ABC Com-
pany in Philadelphia, PA.









VITRON's NAME & ADDRESS SYSTEM 1.

Number of Records: 10 04/01/91
VITRON'S NAME & ADDRESS SYSTEM
Account Number:
First Name: Michael MI: Last Name: Donner

Title:
Company: The Abc Manufacturing Co
Company Dept: Human Resources
Business Addr1: 3245 Leonard St
Addr2:
City: Philadelphia State: PA Zip: 29809
Telephone: (402) 898-3737 Ext: 35 Fax: (402) 809-3787

Home Addr1: 3 Wall St
Addr2:
City: King Of Prussia State: PA Zip: 29898
Telephone: (402) 666-9872 Fax:

Comments: Memo Attached Codes: , , ,


Next Prev Add Update Delete Search Key Table Hard View Query Memo Other Exit

Next Record






























VITRON's NAME & ADDRESS SYSTEM 2.

THE MAIN MENU
-------------
The Main Menu includes fourteen (14) choices. These choices are as fol-
lows.

NEXT ................. to advance to next record

PREV ................. to go back one record

ADD .................. to add a new record

UPDATE ............... to edit/update/change current record

DELETE ............... to flag current record for deletion or to
unflag (undelete) current record if
flagged for deletion

SEARCH ............... to search file based on specified criterion

KEY .................. to find particular record based on value of
current index key (provides a pick-list --
a "lookup" table -- upon request)

TABLE ................ to display "full-screen browse" window --
multiple records on screen that can be
scrolled through

HARD ................. to print out entire contents of current
record on printer

VIEW ................. to view (display) attached memo of current
record (if any)

QUERY ................ to build a "query-by-example" set of
criteria; to find and display record(s)
meeting criteria; provides for multiple
criteria and selections

MEMO ................. to add/edit/update/change current record's
memo

OTHER ................ to provide Auxiliary (Secondary) System
Menu -- includes addition system features
and facilities

EXIT ................. Quit system and return to DOS (the same is
accomplished by pressing ESC at Main Menu)

For those of you who may be new to database types of applications, a
"memo" item is typically a free-form text annotation that is attached to a
given record. "Memo" fields permit you to add notes, comments, and the like



VITRON's NAME & ADDRESS SYSTEM 3.

to individual records. Typical "memo" items are from 1 to 24 lines of
free-form text, though, technically, each "memo" item can be up to 64,000
text characters (800 lines) that can be created and scrolled through much the
same way as you would create and scroll through a document in a word process-
ing window (display screen).
There are two ways in which you select a Main Menu item. (In fact, most
of the menus in the system work the same way.) The way you choose is a matter
of personal preference.
The first way is to press the RIGHT or LEFT ARROW key to highlight your
choice, and then press ENTER.
The second way is to simply press the FIRST LETTER of your choice with-
out pressing ENTER. (Note: Each of the menu items begins with a unique let-
ter.)
Several of the Main Menu items have their own sub-menus.
For now, as you might expect, NEXT, PREV, ADD, and UPDATE should be
self-explanatory. We'll see ADD and UPDATE later.

THE DELETE OPTION

To select DELETE, either highlight it and press ENTER, or simply type D.
The Delete Menu consists of two choices. If the current record is not flagged
for deletion, the choices are: "Delete Record" and "No Action". If se-
lected, the menu is displayed in the middle of the screen.


Delete Record No Action


If, on the other hand, the current record is already flagged for dele-
tion, the menu displays "Undelete Record" and "No Action".


Undelete Record No Action


You select "Delete Record" or "No Action" by either pressing the RIGHT
or LEFT ARROW key to highlight your choice and then press ENTER, or by simply
typing a "D" for "Delete Record" or an "N" for "No Action".
By the same token, you select "Undelete Record" or "No Action" by press-
ing the RIGHT or LEFT ARROW to highlight your choice and then press ENTER, or
by simply typing a "U" for "Undelete Record" or an "N" for "No Action".
If you press ESC, you will cancel the menu selection process, and will
be returned to the Main Menu.

THE SEARCH OPTION

To select SEARCH, highlight it and press ENTER, or simply type S.
When you select "Search" you are presented with the "Search for:" menu.






VITRON's NAME & ADDRESS SYSTEM 4.

[Search for:]
Field Contents Match
End of file
Beginning of File
Deleted Records
Memo contents
Never Mind


This menu consists of six (6) options.

FIELD CONTENTS MATCH ............. prompts you to select a field
on which to search

END OF FILE ...................... takes you to the last record in
sequence

BEGINNING OF FILE ................ takes you to the first record
in sequence

DELETED RECORDS .................. takes you to the first record
in sequence that is flagged
for deletion

MEMO CONTENTS .................... prompts you to enter the memo
contents to search on; you
can enter a character string
of up to sixty (60) charac-
ters

NEVER MIND ....................... quits the "Search for:" menu
and returns you to the Main
Menu

You select your choice by pressing the DOWN or UP ARROW key and pressing
ENTER, or by typing the FIRST LETTER of the choice -- that is, F or E or B or
D or M or N.
The choices END OF FILE, BEGINNING OF FILE, DELETED RECORDS, and NEVER
MIND are self-explanatory.
The remaining two selections, FIELD CONTENTS MATCH and MEMO CONTENTS,
have their own sub-menus.

FIELD CONTENTS MATCH

If you select "Field Contents Match" you are presented with a menu of
field names from which you select a field.








VITRON's NAME & ADDRESS SYSTEM 5.

[ Select Search Field ]
Acct Num
Code-1
Code-2
Code-3
Code-4
First Name
Middl Init
Last Name
Title
Company
Compny Dpt
Bus. Addr1
Bus. Addr2
Bus. City


There are more fields below the "Bus. City" field from which you can
choose. To view the additional fields, press DOWN arrow or PGDN. To go back
up the list, press PGUP. If you continue to press PGDN at the end of the
list, it wraps around back to the top of the list.
Define the field you want to select by highlighting it with the ARROW
keys, then select it by pressing ENTER.
Since more than one field name may begin with the same letter, if you
use the FIRST LETTER technique, you are taken to the first occurrence of that
letter in a field name. To select that field, press ENTER. If you press that
letter key again, the highlight bar moves to the next occurrence of that let-
ter in the field name list, and so on.
After you select a field, you are presented with the "Locate record
where..." menu. This menu contains nine (9) choices.

[ Locate record where ]
= is equal to
> is greater than
< is less than
>= is greater than or equal to
<= is less than or equal to
# is not equal to
$ contains
S starts with (up to 5 letters)
Q Quit this


Make your selection by pressing DOWN or UP ARROW to highlight your
choice and then press ENTER, or simply type the FIRST SYMBOL and press ENTER.
(Here you need to press ENTER to confirm your choice.)

= finds the first record whose selected field contents is
equal to what you will be prompted to type in





VITRON's NAME & ADDRESS SYSTEM 6.

> finds the first record whose selected field contents is
greater than what you will be prompted to type in

< finds the first record whose selected field contents is
less than what you will be prompted to type in

>= finds the first record whose selected field contents is
greater than or equal to what you will be prompted to type
in

<= finds the first record whose selected field contents is
less than or equal to what you will be prompted to type in

# finds the first record whose selected field contents is
not equal to what you will be prompted to type in

$ finds the first record whose selected field contents
contains anywhere in the field the string of characters
you will be prompted to type in

S finds the first record whose selected field contents
starts with (begins with) the one-to-five characters you
will be prompted to type in

Q quits the "Search" and returns to the Main Menu

After you select one of the above options, you are prompted to type in
the characters to search for. The length of the prompt field is the same
length of the particular field you selected at the outset. You can enter the
characters, if letters, in either upper- or lower-case. (The search is not
case-sensitive.)


Locate for....



If you select the "= equal to" option, you must type in all of the nec-
essary characters. For example, if you want to search for a particular "Last
Name equal to" a value, you must type in the complete last name you want to
find. Your spelling of the name must be accurate in order to find it.
You, therefore, might find it more convenient to use the "S starts
with" option instead of the "= equal to" option. With "S starts with" you
can enter the first one-to-five characters of a last name. The search will
find the first occurrence of the last name that starts with the particular
characters you enter. Again, you may use upper- or lower-case.
If the search is unsuccessful, you are so informed; you are prompted to
press a key and are returned to the Main Menu. You can, of course, initiate a
new search by selecting "Search" from the Main Menu again.
However, if your search is successful, the system displays the first
record that meets the criteria and returns you to the Main Menu. There might



VITRON's NAME & ADDRESS SYSTEM 7.

very well be more than one record that meets your criteria. If the search is
successful and you select "Search" from the Main Menu again, the system dis-
plays:


Continue.. New Search


To find the next occurrence, if any, select "Continue..". If there is
another match, that record is displayed, and so forth. If you want to define
new search criteria, select "New Search". The search-definition process is,
then, repeated.

MEMO CONTENTS

To select "Memo contents" either press DOWN ARROW to highlight it and
press ENTER, or simply type M. When you select "Memo contents" the system
displays the following menu with three (3) options:

Locate record where memoCOMMENTS:
$ contains
E is empty
N is not empty


$ finds the first record whose selected memo field contains
anywhere in the entire memo field the string of characters
you will be prompted to type in

E finds the first record whose selected memo field is empty
(blank) -- that is, contains nothing

N finds the first record whose selected memo field is not
empty (not blank) -- that is, contains something

You can terminate any menu and return to the Main Menu by pressing ESC
(Escape). If you press ESC at the Main menu, you quit the system and are re-
turned to DOS.


THE KEY OPTION

To select "Key" from the Main Menu, either highlight it and press ENTER
or simply type K. When you select "Key" the system displays a data entry box.


Last Name to seek (ENTER for Lookup Table - ESC quits):



The actual item you are prompted to enter depends on the current file
index (file sequence).


VITRON's NAME & ADDRESS SYSTEM 8.

The system provides for three indexes (sequences). The default (and cur-
rent) sequence is by Last Name. (More about the other sequences later.) This
is why you are prompted to enter in the "Last Name" at this time.
Fortunately, you do not have to enter in an entire last name. Just a few
letter may suffice for you (even one letter may be enough). However, the more
letters you enter, the more precise the search. The system will jump to the
first record that matches the last name letters you enter. If you type in
letters, don't forget to press ENTER when you are finished with your entry.
If you leave the data entry box empty -- that is, blank -- and press EN-
TER on the blank field, as the prompt suggests, you are presented with a
"Lookup Table" -- that is, a pick-list of all the Names on file.

Lookup Table of Key
DONNER MICHAEL
JACKSON JANET
JOHNSON HARRY
MARSHALL EDWARD
O'CONNOR FRANK H
PETERSON PAUL
ROOSEVELT THEORDORE
SMITH JOHN
THOMAS LORAINE
WILSON PETER


The box displays ten (10) names at a time. If there are more than ten
names on file (look at the top of the screen where you are told how many
records are on file), use the DOWN/UP ARROW, PGDN, PGUP, END and HOME keys to
scroll through the list.
In addition to highlighting the name of your choice, you can, with the
box displayed, start to type in a last name. As you type, you will see an en-
try area appear at the bottom of the box, with the letters displayed as you
type them. After you have entered the letters (you can enter from one to sev-
enteen letters) of your choice, press ENTER. The highlight bar will jump to
the first occurrence of the letters you enter. To select the name highlighted
-- that is, to go to that record -- press ENTER again. The more letters you
enter, the more precise the search.

THE TABLE OPTION

To select "Table" either highlight it and press ENTER or simply type T.
When you select "Table" the system displays the "Tableview of:" menu.

Tableview of:
Business Data
Home Data
All Data
Quit to Main


You are presented with four (4) options.



VITRON's NAME & ADDRESS SYSTEM 9.

BUSINESS DATA ................. presents a Browse Window
(Tableview) of business data
only

HOME DATA ..................... presents a Browse Winbdow
(Tableview) of home data only

ALL DATA ...................... presents a Browse Window with all
record data available

QUIT TO MAIN .................. returns to the Main Menu

Memos and the Codes fields are not accessed or viewed in "Table" mode in
this version of the system. (NOTE: Such features will be part of our next
version, which will include additional features and facilities as well. Stay
tuned.)

BUSINESS DATA and HOME DATA

To select "Business Data" either highlight it and press ENTER or simply
type B. To select "Home Data" either highlight it and press ENTER or simply
type H. To select "All Data", either highlight it and press ENTER or type A.
To quit, highlight "Quit to main" and press ENTER or type Q.

BROWSE ALL or SELECT CERTAIN FIELDS...

Regardless of whether you select "Business Data" or "Home Data" the sys-
tem then displays a Browse request.


Browse all fields
Select certain fields to browse


The choices are:

BROWSE ALL FIELDS ............... displays the fields of all
records across the screen
and down the columns

SELECT CERTAIN FIELDS ........... displays only the fields you
select for all records
across the screen and down
the columns

In a Browse Window, each record is displayed across the row and the
fields are displayed down the columns.
To select "Browse all fields" either highlight it and press ENTER or
simply type B. To select "Select certain fields..." either highlight it and
press ENTER or simply type S.




VITRON's NAME & ADDRESS SYSTEM 10.

The Browse Window display is essentially the same format for either
choice except that the "Select certain fields" option displays the data for
only the specific fields you select from a field pick-list.

SELECT CERTAIN FIELDS

When you choose "Select certain fields" the system displays a field
pick-list in the middle of the screen.

ENTER to select
First Name
Last Name
Company
Title
Address 1
Address 2
City
State
Zip
Telephone
Ext
Fax
F10 when done

The box displays twelve (12) field names at a time. Since there are only
12 field names for business data, and only 9 field names included for home
data, all of the fields represented in the Browse Window are displayed in the
box without your having to scroll DOWN to see more field names.
The illustration above shows the field pick-list for business data. You
select the fields by pressing DOWN/UP ARROW to highlight the field and then
press ENTER.
When you select a field in this manner, the system places a CHECKMARK
in front of the field name selected. This indicates that the field has been
selected to be displayed in the Browse Window. Only those fields specifically
selected will be displayed in the Browse Window when you select "Select Cer-
tain Fields."
Our example above indicates that we have selected First Name, Last Name
and Telephone. (See the checkmarks?)
If you want to DESELECT a selected field, highlight it again and press
ENTER again. This will erase the checkmark, indicating that the field is not
selected.
When you have finished selecting one or more fields, press the F10 Func-
tion key to proceed to the actual Browse Window.

THE BROWSE WINDOW (TABLE-VIEW)

After you choose either "Browse all fields" or "Select certain fields"
the system presents you with the Browse Window (Tableview). Depending on the
number of fields selected (ALL or CERTAIN), there may be additional fields
out to the right, currently off the screen.




VITRON's NAME & ADDRESS SYSTEM 11.


[Record # 9] (F1 for Navigation keys)


First Name Last Name Company

Michael Donner The Abc Manufacturing Co
Janet Jackson American Judges Association
Harry Johnson Office Of Weights & Measures
Edward Marshall American Alpine Club
Frank O'Connor
Paul Peterson The National Bank
Theordore Roosevelt The Us Company
John Smith A Philip Randolph Institute
Loraine Thomas The Morgan Company
Peter Wilson Airport Security Council







(Q)uit (G)oto (L)ocate (V)ertical View (E)dit (A)dd (D)elete


To view the additional fields, if any, you can scroll out to the right
by pressing RIGHT ARROW. You can scroll back to the left by pressing LEFT AR-
ROW. When you reach the end of the field display, the highlight bar will not
go any further to the right or left.
You can scroll down to the next 15 records (but not in our case, since
there are only 10 test records on file) by pressing DOWN ARROW or PGDN. You
can scroll up 15 records by pressing UP ARROW or PGUP.
There are additional "Navigation" keys available. Press the F1 Function
key to see what they are and what they can do. (The list of navigation keys
also appears on the next page in this manual.)
The Browse Window provides its own "menu" of facilities, which is dis-
played at the bottom of the screen.
Your options are:

QUIT ....................... to return to the previous menu

GOTO ....................... to go to a specific record based on
its record number (assumming, of-
course, you know its number)









VITRON's NAME & ADDRESS SYSTEM 12.



Press this Key: To Do This:

| (Up arrow) ............... Move up one row.
| (Down arrow) ............. Move down one row.
<-(Left arrow) ............. Move left one column.
->(Right arrow) ............ Move right one column.
^<-(Ctrl-Left arrow) ....... Pan left one column.
^->(Ctrl-Right arrow) ...... Pan right one column.
Home ....................... Leftmost current screen column.
End ........................ Rightmost current screen column.
^Home (Ctrl-Home) .......... Leftmost column.
^End (Ctrl-End) ............ Rightmost column.
PgUp ....................... Scroll up one screen.
PgDn ....................... Scroll down one screen.
^PgUp (Ctrl-PgUp) .......... First row of current column.
^PgDn (Ctrl-PgDn) .......... Last row of current column.

Press ESC or ENTER to return to TableView

You can PAN right/left if there are columns out there.


NAVIGATION KEYS LIST


VERTICAL VIEW .............. to view all of the business or
home data of the currently
highlighted record on the screen
in a display box

EDIT ....................... to edit/update/change data in the
currently highlighted record
(presents the same display as
the "Update" selection from the
Main Menu)

ADD ........................ to add a new record (presents the
same display as the "Add"
selection from the Main Menu)

DELETE ..................... to flag the current record for
deletion

NOTE: The highlight bar indicates two things:

(a) the CURRENT RECORD, and
(b) the CURRENT FIELD in the current record

To select a menu item in the Browse Window at this point, you simply
type the LETTER of your choice.


VITRON's NAME & ADDRESS SYSTEM 13.

Let's examine the selections other than EDIT and ADD since these are
explained later from the same choices on the Main Menu.

QUIT

If you type Q to Quit, the system asks you to confirm by selecting "Yes"
or "No." You can either highlight your choice and press ENTER or simply type
Y or N.


Quit ?
YES NO


If you select "NO" you are returned to the Browse Window. If you select
"YES" you are returned to the previous menu ("Tableview of:").

GOTO

If you type G to Goto, you are prompted to enter the number of the
record to jump to -- that is, to the specific record to highlight.


Go to record # :
0



Of course, if you don't know the actual record numbers for the records
on file, this method is not too helpful.
Notice, at the top right of the screen, when the highlight bar is on the
first record (for Michael Donner), the screen displays:

Record # 9

Since the file is sequenced (indexed) by Last Name, the record number
displayed may or may not (generally will not) correspond to the actual posi-
tion in the display. Record numbers are generated at the time you first cre-
ate the record and represent the actual physical location of a record in the
file.
However, when you use an index (a sequence), records are "logically re-
arranged" to display in their appropriate sequence. As such, record numbers
reflect only the physical position of each record in the file and not neces-
sarily the logical (displayed) position.










VITRON's NAME & ADDRESS SYSTEM 14.

LOCATE

[Search for:]
Field Contents Match
End of file
Beginning of File
Deleted Records
Memo contents
Never Mind


If you select "Locate" by typing L, our familiar "Search for:" menu is
displayed. (See "IV. THE SEARCH OPTION" on page 4 of this manual for more de-
tails. Everything you can do there you can do here.)
The only difference between the search performed in the Browse Window
and the search performed at the Main Menu is that in the Browse Window, if a
record containing your criteria is found, the highlight bar jumps to the
first record matching the criteria, making it the current record while you
remain in the Browse Window. When you return to the Main Menu, the system re-
turns to the first record on file (in sequence).

VERTICAL VIEW


First Name Michael
Last Name Donner
Company The Abc Manufacturing Co
Title
Address 1 3245 Leonard St
Address 2
City Philadelphia
State PA
Zip 29809
Telephone (402) 898-3737
Ext 35
Fax (402) 809-3787


If you select "Vertical View" by typing V, the data for the current
record is displayed in a box on the screen. This feature is useful when you
want to view all of the pertinent data of a given record at one time rather
than have to scroll RIGHT and LEFT to view the same data.

NOTE: When in Vertical View and you press DOWN or UP ARROW to
highlight a particular field in the vertical view window and
then press ENTER, upon returning to the Browse Window, which
happens after you press ENTER, you will find that the high-
light bar is sitting on the field of that record, which you
highlighted in vertical view. To return to the Browse Window
while keeping the highlight bar in the first field of the
first record, simply press ESC, as prompted, instead of EN-
TER.


VITRON's NAME & ADDRESS SYSTEM 15.

SPECIAL NOTE: PRESSING THE ENTER KEY WHEN IN THE BROWSE WINDOW

Whenever you are in the actual Browse Window itself, you can perform dy-
namic field/record editing. What this means is that you can actually edit
data in any of the records displayed in the Browse Window. To do this, simply
highlight the field of the record you want to edit, and press ENTER.
When you do this, you'll notice that:

(a) the color of the highlight bar changes from pale blue to white,
(b) the cursor blinks in the field, and
(c) the system displays the following in the middle of the screen:


Enter to Save -- Escape to cancel


At this point, you can change the data in the highlighted field by sim-
ply typing in the new data.
To save your change(s), simply press ENTER. To abort (cancel) the
change, press ESC instead of ENTER. (Should you change something accidently,
simply repeat the process and make it correct.) But, do be careful using this
method to edit data since you might inadvertantly change something and not
notice it. Remember, when in doubt, press ESC or type Q to Quit the Browse
Window facilities. (You will probably be better off using the EDIT feature at
the Browse Window display -- i.e., typing E at the Browse Window.)

DELETE

When you select "Delete" by typing D, the system prompts you as to
whether you want to "Delete Record" or take "No Action." If you select "De-
lete" (since it's already highlighted, just press ENTER or type D), the
record is flagged for deletion. The "Delete" option of the menu at the bottom
of your screen will change to "Un(D)elete" indicating that the highlighted
record has been flagged. In addition, the word "Delete" will be displayed at
the top of the screen whenever the highlight bar is in any field of a record
flagged for deletion.
If you want to "Undelete" a flagged record, simply select "Delete" again
from the menu at the bottom of the screen by typing D. The record will then
be "unflagged."

WHAT EXACTLY IS A RECORD "FLAGGED" FOR DELETION?

When you flag a record for deletion, you inform the system that you in-
tend to eventually physically delete the record from the file. A flagged
record is a "logical" delete, not a physical delete. By allowing you the op-
portunity to flag records before physically deleting them, the system per-
mits you to change your mind and unflag -- that is, "logically undelete"
-- the record.
Flagged records will remain on the file -- you'll see "Delete" at the
top of the screen whenever the highlight bar is on any field of a flagged
record when in the Browse Window -- until you "pack and reindex" the
database. Packing and reindexing is an option in the "Other" menu choice of
the Main Menu. More about this when we get to the "Other" option.

VITRON's NAME & ADDRESS SYSTEM 16.

THE HARD OPTION

You can obtain a listing of the total contents of the currently dis-
played record by selecting "Hard" from the Main Menu. You select "Hard" by
highlighting it and pressing ENTER or by simply typing H.
When you select "Hard" the system displays the "Hardcopy of:" menu.

Hardcopy of:
Current record
Attached Memo field


The two choices are:

CURRENT RECORD ............... to list the contents of the
current record -- all fields
except the Memo field

ATTACHED MEMO FIELD .......... to list the contents of the
current record's memo field,
if any

HOW DO YOU KNOW THE RECORD HAS AN ASSOCIATED MEMO ITEM?

Look at the bottom of the display window, next to "Comments:". If the
current record has a memo attached, the words "Memo Attached" is displayed.
Otherwise, the "Comments:" field is blank. Every record can have an associ-
ated memo item if, when you add the record to the file, you indicate that you
want it to have a memo item. Also, you can add memos to records already on
the file by selecting "Update" and then responding "Yes" when prompted to
add/change a memo; or you can select the "Memo" option from the Main Menu.
To select "Current Record" either highlight it and press ENTER or simply
type C. To select "Attached Memo field" either highlight it and press ENTER
or type A.
Regardless of your selection, the system then asks you where you want to
send the output -- that is, to the "Printer" or to a "Text File."

Send hardcopy to:
Printer
Text File


If you select "Text File" (by highlighting it and pressing ENTER or by
typing T), you are asked to enter in the name of the file.


File to send output to







VITRON's NAME & ADDRESS SYSTEM 17.

File names are from one (1) to eight (8) characters, and you may add an
extension. The typical extension is .TXT. Enter the name and press ENTER. You
can use any text editor, word processor or even the DOS PRINT command, DOS
COPY command or DOS TYPE command to print out the file at a later time. (See
your DOS manual for the syntax of the various DOS commands.)
If you change your mind and don't want to create a text file, simply
press ESC at the "File to send output to" prompt.
If you select "Printer" you are requested to select the "Printer Port."


LPT1
LPT2
COM1


In most instances, "LPT1" is the appropriate choice, so, with the high-
light on "LPT1" simply press ENTER.
The report will be printed. (NOTE: If your printer is not ready to
print, you'll be so informed and prompted to correct the situation and to
proceed.) If you change your mind and don't want to print, simply press ESC.
Your listing, if you selected "Current Record" will look something like
this (at least the field names will be the same while the actual data will
reflect the record displayed):

Acct Num :
Code-1 :
Code-2 :
Code-3 :
Code-4 :
First Name : Michael
Middl Init :
Last Name : Donner
Title :
Company : The Abc Manufacturing Co
Compny Dpt : Human Resources
Bus. Addr1 : 3245 Leonard St
Bus. Addr2 :
Bus. City : Philadelphia
Bus. State : PA
Bus. Zip : 29809
Bus. Phone : (402) 898-3737
Bus. Ext : 35
Bus. Fax : (402) 809-3787
Home Addr1 : 3 Wall St
Home Addr2 :
Home City : King Of Prussia
Home State : PA
Home Zip : 29898
Home Phone : (402) 666-9872
Home Fax :
Comments : (memo)
Setup-Date : 04/02/91


VITRON's NAME & ADDRESS SYSTEM 18.

Your listing, if you selected "Attached Memo" and the memo field has
data in it, will look something like the following:

ATTACHED MEMO FOR: Michael Donner ACCOUNT #:

Wish we knew what the real area code and zip code are.

THE VIEW OPTION

When you select "View" from the Main Menu (by either highlighting it and
pressing ENTER or by simply typing V), the system displays the current
record's memo field. If there is no memo associated with the record (if the
memo field is blank), an empty window is displayed.

[MEMO PAD]
Wish we knew what the real area code and zip code are.






[ ESC:EXIT ]

To return to the Main Menu, simply press ESC.

THE QUERY OPTION

Without much doubt, this feature is probably the most interesting aspect
of the system, and, we dare say (unfortunately), perhaps it's also the most
complex.
We'll try to simplify its access and use as much as possible. But, the
best way for you to become acquainted with "Query" is to play with it.
To select "Query" either highlight it and press ENTER or simply type Q.
When you select "Query" the system displays the "Ad-Hoc Query Builder" menu.

[Ad-Hoc Query Builder]

Build a new query
Add to current query
Count matching records
Zap (remove) existing query
Save current query to disk
Restore query from disk
Delete stored queries
What is current query
Edit current query
View records matching query
Quit this Query

No Query Active



VITRON's NAME & ADDRESS SYSTEM 19.

As you can see, the menu provides you with eleven (11) options. Let's
define at each of them.

BUILD A NEW QUERY ................. to build a new query, that
is, define a new set of
criteria to search on

ADD TO CURRENT QUERY .............. allows you to add additional
criteria to the current
active query

COUNT MATCHING RECORDS ............ to count the number of
records that match the
current active query

ZAP EXISTING QUERY ................ to remove the current active
query

SAVE CURRENT QUERY ................ to save the current active

query to disk for later
use

RESTORE QUERY ..................... to retrieve from disk a
particular query defini-
tion saved with the SAVE
CURRENT QUERY option; this
option makes the retrieved
query the current active
query

DELETE STORED QUERY ............... to erase saved queries from
disk

WHAT IS CURRENT QUERY ............. to display the parameters of
the current active query
as you defined them

EDIT CURRENT QUERY ................ this option is best left to
those of you who are fam-
iliar with dBASE and/or
Clipper; this option
allows you to modify the
previously defined param-
eters of the current
active query

VIEW MATCHING RECORDS ............. displays the records that
meet the current active
query's conditions

QUIT THIS QUERY ................... returns to the Main Menu.



VITRON's NAME & ADDRESS SYSTEM 20.

NOTE: When you quit the "Query" menu and return to the Main Menu, if you
did not ZAP the current query, when you select "Query" again, you will find
that the previously defined query (which was the "active" query) is still de-
fined as the current active query. Query's conditions are only active when
you are in the Query facility. It has no effect when you are at the Main
Menu.
If no query is active, at the bottom of the "Ad-Hoc Query Builder" menu,
you will see displayed:

No Query Active

If there is an active query -- one you defined and did not ZAP -- the
following will be displayed at the bottom of the "Ad-Hoc Query Builder" menu,
and it will be blinking:

Query Active

Whenever you ZAP (remove) an active query, "No Query Active" will again
be displayed.
NOTE: ZAPping active queries has no effect on those queries you SAVEd to
disk. If you RESTORE a query from disk, making it active, and then ZAP it, it
still resides on the disk. The only way in which you can delete queries saved
to disk is by selecting the DELETE option from the "Ad-Hoc Query Builder"
menu. You will then be provided with a menu of saved (stored) queries from
which you will select those you want to delete. Queries deleted from disk are
not flagged. Rather, they are actually physically deleted.
You can save as many queries as you want. When you save a query, you are
prompted to enter in a description. Queries are saved via their description
text and not via "file" names. As such, your descriptions can and should be
clear as to what the particular query does.
Let's look at the first option.

BUILD A NEW QUERY

To select "Build a new query" either highlight it and press ENTER or
simply type B.
When you select this option, the system displays the "Database Field
List" menu. You use this menu to select the various database fields for which
you will define the search criteria. Unlike the "Search" item from the Main
Menu, here in "Query" you can define multiple-field criteria.
The first item in the "Database Field List" menu is "?". Yes,
you can search on records currently flagged for deletion as criteria.












VITRON's NAME & ADDRESS SYSTEM 21.

[Ad-Hoc Query Builder]

Build a new query
Add to current query
Count matching records [Database Field List]
Zap (remove) existing query < Deleted? >
Save current query to disk Acct Num
Restore query from disk Code-1
Delete stored queries Code-2
What is current query Code-3
Edit current query Code-4
View records matching query First Name
Quit this Query Middl Init
Last Name
No Query Active Title
Company
Compny Dpt

ENTER to select


Since there are more fields to choose from below "Compny Dpt" you can
scroll down through the table by pressing DOWN ARROW or PGDN. If you press
END, you go to the end of the table menu. To go back up, use the UP ARROW,
PGUP or HOME. (HOME brings you to the top of the table.)
Use the highlight bar to highlight the field of your choice, then press
ENTER.
To see how the more interesting aspects of "Query" work, let's try an
example. Slide the highlight bar down to the "Last Name" field and press EN-
TER. This selects "Last Name" as the field. The system now displays a crite-
ria qualification menu.

[Ad-Hoc Query Builder]

Build a new query
Add to current query
Count matching records = (Equal to)
Zap (remove) existing query<> (Not Equal To)
Save current query to disk < (Less Than)
Restore query from disk > (Greater Than)
Delete stored queries <= (Less Than or Equal To)
What is current query >= (Greater Than or Equal To)
Edit current query $ (Contains)
View records matching query! (Does Not Contain)
Quit this Query * (Wildcard Match)
S (Starts With)
No Query Active







VITRON's NAME & ADDRESS SYSTEM 22.

Each choice works in basically the same way as it works in the "Search"
option from the Main Menu. (See "Locate Record Where") However, there are
two choices that should be pointed out.

! (Does Not Contain) ......... to select a field that does
NOT contain the data you will
be prompted to enter

* (Wildcard Match) ........... like the DOS wildcards, can
use them in place of char-
acters

Let's look at an example for the wildcards. There are two wildcards. One
is the asterisk (*), which is used in the place of any number of characters;
the other is the question mark (?) which is used in the place of one charac-
ter. When using wildcards, you MUST account for all characters in the field.
Since we previously selected "Last Name," slide the highlight bar down
and highlight "* (Wildcard Match)" and press ENTER. The system now displays
the "Compare to" menu.

Compare to
Type in a value to compare
Select a single value from the database (scroll)
Compare to another field in the same record


We want to select "Type in a value to compare." Select it by highlight-
ing it (it should already be highlighted) and pressing ENTER or simply type
T.
You are now prompted to enter in a value to compare to.


VALUE TO COMPARE (TYPE CHARACTER)





What is not shown above is that the box has two additional lines
(since we selected WILDCARD MATCH) that are not displayed in the box
above. This is because you selected WILDCARDS.
Okay. We want to find all Last Names that start with a J and contain an
N somewhere after the J. (Remember, we have to account for all the characters
in a field.) We need to recognize that there can be letters (or blanks) after
the N.
Type the following:

J*N* and press ENTER

NOTE: You can enter the characters in either UPPER- or lower-case.
The system now asks if you want to ignore case-sensitivity. WE STRONGLY
RECOMMEND THAT YOU ALWAYS SELECT YES! Otherwise, the search will be conducted
in exactly the way in which you enter the data in response to the prompt.

VITRON's NAME & ADDRESS SYSTEM 23.

Next, you are provided with what is called the "Boolean" (logical)
expressions.


DONE
AND
OR
AND NOT
OR NOT


These "combiners" allow you to create compound (multiple) sets of crite-
ria, like a "compound" sentence. In otherwords, you can combine criteria. For
example:

a AND b

a OR b

a AND NOT b

a OR NOT b

For those of you who are new to these combinations, we recommend that
you use AND and/or OR and try to avoid the "NOTs." Positives (AND and OR) are
easier to deal with than negatives (NOT). With a little forethought, you can
always construct a positive logical relationship that will work the way you
want and expect. The OR NOTs are particularly confusing if you are not used
to writing programs, so avoid the OR NOT option if at all possible.
Since we don't want any more criteria, select DONE by highlighting it
and pressing ENTER or simply type D.
Notice now "Query Active" is blinking in the box. This tells you that
you have defined a query and that it is currently active while you stay in
Query. (If you were to Quit Query, the criteria you defined would not apply
to record selection at the Main Menu. But, when you enter Query again, the
current Query remains active and you can use it to "View" the records that
match it.)
Let's view the records that meet our criteria, that is, Last Names that
start with a J and contain at least one N somewhere after the J. The last as-
terisk accounts for any characters that should occur after the N, including
blanks. To view records that match our query criteria, we need to remain in
Query.
From the menu, select "View records matching query" by highlighting it
and pressing ENTER or simply by typing V.
The system starts to look for matches. The first record found is for
Harry Johnson. (See the "J" and the "N" in the name?)
Notice the options at the bottom of your screen.

( N ) Next .................... goes to next record that meets
criteria, if any

( P ) Prior ................... goes to prior record that
meets criteria, if any

VITRON's NAME & ADDRESS SYSTEM 24.

( Q ) Quit .................... returns to Query menu

( V ) View Memo ............... displays attached memo for
the record, if any

You make your choice by typing in the letter of your choice. Since there
is no memo attached for Johnson, if you press V you'd see an empty display
window.

Press: N (for NEXT)

We see that there is another record that meets our criteria -- Janet
Jackson. (See the "J" and the "N" in the name?)
Now, when you press N for NEXT, you are told that there are no more
matches and are returned to the Query menu. To run through the records again,
simply select "View" again.
Let's ZAP this query.

Press: Z (to select ZAP)

The query is deactivated. You could have saved the query to disk and
later recalled it from disk.
There are other ways you can select records. In the "Compare to" menu we
previously selected "Type in a value to compare." If, instead, you select
"Select a single value from the database (scroll)," you are presented with a
pick-list of Last Names from which to choose.


Donner
Jackson
Johnson
Marshall
O'Connor
Peterson
Roosevelt
Smith
Thomas
Wilson


If you select a particular Last Name from the list (which you can scroll
since there may be more names in the table than are initially displayed), you
tell Query to search on records of that particular last name and that last
name only. It's a good technique if you want to pick out all Smith's, for ex-
ample, or if you are searching on State, to select all people in NY. (Of
course, you could also type in the value NY. But, if you're like us, it's
easier to pick from lists than to type stuff in.)
The final option in the "Compare to" menu is "Compare to another field
in the same record." This option allows you to compare the value in one field
to the value in another. (This is good if you want to search for all people
who both work and live in NY, for example. You can compare the Business State
to the Home State.)


VITRON's NAME & ADDRESS SYSTEM 25.

[Pick Field]
ACCT
CODE1
CODE2
CODE3
CODE4
FIRST
MI
LAST
TITLE


Note that in this pick-list, the system uses actual dBASE-file field
names rather than the "pseudo-names" used everywhere else. (You can scroll
through the list by pressing PGDN and PGUP.)
If you find Query fun and interesting, we encourage you to play with it
and experiment. The more you use it, trying different things and different
combinations, the more you'll learn about it.

THE MEMO OPTION

The "Memo" option of the Main Menu permits you to (a) view and edit cur-
rent attached memos and (b) create a memo for the current record had you not
done so when you initially created the record.
To select "Memo," either highlight it with the CURSOR keys and press EN-
TER or simply type M.
A memo window is displayed. The window displays nine (9) lines at a
time. Each memo item can be up to twenty-six (26) lines, which you can scroll
through with the UP/DOWN ARROW keys.
The line length is set at sixty-five (65) characters and is in automatic
wrap-around mode as you type.
If you want to delete a current line, put the cursor anywhere on the
line you want to delete and press CTRL Y. If you want to insert a line, put
the cursor at the line you want to insert at and press CTRL N.
Look at the bottom of the memo window. See the menu of keys?

F10: SAVE
ESC: EXIT (No Save)
F5: IMPORT
F6: EXPORT

[MEMO PAD]Line: 1Col: 0
Wish we knew what the real area code and zip code are.








[ F10:SAVE | ESC:EXIT | F5:IMPORT |F6:EXPORT]


VITRON's NAME & ADDRESS SYSTEM 26.

In addition, the top of the window tells you what line you are on and
what column you are in -- i.e., the location of the cursor.
After you have finished typing your entry, press the F10 function key to
save your edits.
When you press F10, a small prompt window is diplayed in the middle of
the screen:

Save and exit?
Save/Exit Don't Exit

If you select "Save/Exit" your memo is saved and you are returned to the
Main Menu. If you select "Don't Exit" the memo is still saved, but you remain
in the memo window.
If you press ESC instead of F10, a small prompt box appears:

Exit without saving changes?
YES NO

If you select "YES" the changes are NOT saved and you are returned to
the Main Menu. If you select "NO" you remain in the memo window.
Notice the additional function keys?

F5: IMPORT
F6: EXPORT

If you press F5, you are permitted to import -- i.e., read into the
current memo -- any .TXT file that resides in the current directory on
the current default drive. (NOTE: Due to Clipper requirements, the .TXT file
must not exceed 64K -- a maximum of 10-15K is strongly recommended.) This is
a nice facility in that you can prepare a "boiler-plate" .TXT file and then
read it in as a memo. You are provided with a pick-list of .TXT files.
When you press F5, you are prompted to enter the name of the file you
want to import. Since the system assumes that the file is a .TXT file, you
need only type in the filename. DOS wildcards are permitted. If you use
wildcards or if you leave the field blank and press ENTER, the system dis-
plays a .TXT file pick-list from which you can choose the file you wish to
import.
If you press F6 (to EXPORT), you are permitted to export -- i.e., write
out -- the memo item to an external .TXT file. When you press F6, you ae
prompted to enter in the name of the file you wish to export. The system as-
sumes the extension to be .TXT. Therefore, you need only type in the filename
(one to eight characters -- a DOS requirement). If the file already exists,
you are asked if you want to replace it. If NO, you are asked to type in a
different name.

THE OTHER OPTION

When you select "Other" from the Main Menu, you are presented with the
system's Auxiliary Menu -- a menu of some real nice system facilities.





VITRON's NAME & ADDRESS SYSTEM 27.

Auxiliary Menu
Index Files
Change Sequence
Produce Reports
ToDo List
Form Letters
Appointments
Quit


We believe that these features are what set our system apart from the
others. And these auxiliary facilities are not "Mickey Mouse" facilities.
Each one is a full, comprehensive sub-system in its own right. (That's why
our system is a bit memory-hungry.)
The options on the Auxiliary menu are as follows:

INDEX FILES ....................... to pack and reindex ALL of the
system's files. (NOTE: When
the system's files are
"packed," all records that
are flagged for deletion are
permanently deleted.)

CHANGE SEQUENCE ................... as we mentioned at the outset,
the system's default
sequence is Last Name. This
option allows you to change
the sequence for the current
session.

PRODUCE REPORTS ................... permits you to produce Rolo-
dex-type reports, mailing
labels and true AD-HOC
reports (lists).

TODO LIST ......................... a full, powerful, sophistica-
ted ToDo List manager, with
some real nice features.

FORM LETTERS ...................... permits you to define and
produce true AD-HOC form
letters and mail-merge
reports.

APPOINTMENTS ...................... a full, powerful Appointment
scheduler and manager that
has some real nice features
not found in some of the
other appointment systems.

QUIT .............................. return to the Main Menu.



VITRON's NAME & ADDRESS SYSTEM 28.

1. INDEX FILES

Select "Index Files" whenever you want to pack and reindex all of the
database files. Do not interrupt this process when it begins. Remember, when
you "pack," you permanently remove all records that you previously flagged
for deletion.

2. CHANGE SEQUENCE

Sequence By:
Last Name
Company Name
Account Number
Quit


When you select "Change Sequence" you are presented with the "Sequence
By: menu. Your choices are:

LAST NAME .................. to present the displays in Last
Name sequence -- the default

COMPANY NAME ............... to present the displays in
Company Name sequence

ACCOUNT NUMBER ............. to present the displays in
Account Number sequence

Select the sequence you desire. From that point on, the database will be
displayed in the selected sequence for the duration of the current session or
until you change the sequence again. Selecting "Quit" leaves whatever index
is currently active as the current active sequence.
NOTE: Whenever you Exit the system and return to it later, the sequence
is by Last Name, which is the default at system start-up.

3. PRODUCE REPORTS

When you select "Produce Reports, you are presented with a "Pick One:"
menu.

Pick One:
Labels & Rolodex
Reports & Lists
Quit


LABELS & ROLODEX

When you select "Labels & Rolodex" you are presented with the
"Labels/Rolodex" menu.




VITRON's NAME & ADDRESS SYSTEM 29.

[Labels/Rolodex]
Open Label File [No Query]
New Label File
Erase Label File
Dimensions of Label File
Contents of Label File
Print Test Pattern
Generate Mailing Labels
Set Printer Port VITRON's
Quit
Name & Address System
Tag Records to Print
Build or Modify Query

Info on using Laser Printers *


[Label File:]
Label file in use : []
Dbf file in use : [NAME]
Default Printer : [LPT1]



Your choices are:

OPEN LABEL FILE ..................... to select a defined
label file from disk

NEW LABEL FILE ...................... to create a new label
file and save to disk

ERASE LABEL FILE .................... to erase an existing
label file from disk

DIMENSIONS OF LABEL FILE ............ to define/edit the dimen-
sions of a new/existing
label file

CONTENTS OF LABEL FILE .............. to define the actual
contents of a label
file. (NOTE: This
facility should be
used only by those who
have an understanding
of dBASE. Since there
already are four label
files provided, most
of your label needs
are accounted for with
the existing files.)



VITRON's NAME & ADDRESS SYSTEM 30.

PRINT TEST PATTERN .................. prints a test pattern
for you to properly
align your labels and
rolodex forms

GENERATE MAILING LABELS ............. to print out the labels
and rolodex forms

SET PRINTER PORT .................... to set your printer
port. In most in-
stances, the default,
LPT1, should be accep-
table

TAG RECORDS TO PRINT ................ allows you to select --
"tag" -- specific rec-
ords for printing

BUILD OR MODIFY QUERY ............... to define an ad-hoc
query for selecting
specific records for
printing

INFORMATION ON...LASER PRINTERS ..... some information useful
for laser printer
users

OPEN LABEL FILE

The system includes predefined label and rolodex files for you. When you
select "Open Label File" the system displays a menu of four (4) label files
that include the necessary data for you to create your rolodex cards and
mailing labels.

Label Files
ROLODEX.LBL
HOME.LBL
BUSINESS.LBL
S_ROLO.LBL


The files are:

ROLODEX.LBL .................. produces large rolodex-type
lists

HOME.LBL ..................... mailing labels with home
addresses

BUSINESS.LBL ................. mailing labels with business
addresses



VITRON's NAME & ADDRESS SYSTEM 31.

S_ROLO.LBL ................... produces small rolodex-type
lists

TAG RECORDS TO PRINT

This facility is similar to "Query" but instead you are presented with a
pick-list of actual records from which to choose. To "tag" -- i.e., select --
a record, move the highlight bar (the blinking cursor) anywhere in the par-
ticular record(s) you want to select, then press the SPACEBAR once. A
checkmark appears at the beginning of the record -- the extreme left-side of
the window -- indicating that the record has been tagged (selected). To dese-
lect and tagged record, move the highlight bar to the tagged record and press
SPACEBAR again.
If you type C, you clear all tags. If you type S, you are presented with
our familiar "Search for:" menu (see "Search" on page 4). This "tagging win-
dow" can be scrolled with the LEFT/RIGHT ARROW keys, the DOWN/UP ARROW keys
and the PGDN/PGUP keys.
Before a record is tagged, the words "NOT TAGGED" are displayed at the
top right of the tag window. When a record is tagged, each time you move the
highlight bar to it, the word "TAGGED" is displayed for that record.
When you are done tagging or viewing, press ESC. (Any records tagged re-
main tagged while you are using this part of the system. But, as soon as you
return to the Auxiliary Menu or to the Main Menu, all tags are turned off au-
tomatically.) When you press ESC at the tagging window, you are returned to
the "Label/Rolodex" menu for printing or whatever you decide to do.

BUILD OR MODIFY QUERY

This is our familiar "Query" menu. For more information, see "Query."
NOTE: Whatever queries are defined here in this part of the system will
apply to not only records for Labels and Rolodex lists, but wherever else you
can access "Query." That is, if you define a "Query" as active ANYWHERE in
the system, that query will remain active EVERYWHERE in the system from where
you can build or access a query. Of course, you can always ZAP the active
query to build a new one, or simply build a new one, which will then become
the new, active query until it is ZAPped.
Since Query is so powerful, you can define one anywhere, and use it any-
where you can access it. We find this feature very useful in that we build
queries to access/display specific records from the "Query" menu. We then go
into Labels and produce labels for only those records. It saves us from hav-
ing to define the the same query again. Of course, you can save it to disk
and then retrieve it whenever you want it.
The system will always tell you if/when a query is active.











VITRON's NAME & ADDRESS SYSTEM 32.

REPORTS & LISTS

[Ad-Hoc Report Builder]
Pick fields to list [No Query ]
Modify fields to list
Output list
Save list definition to disk
Restore list definition from disk
Delete stored definitions
Choose Printer Port (now LPT1)
Quit VITRON's

Name & Address System



Current Fields to List:




[ # of columns needed: 0]


When you select "Reports & Lists" from the "Pick One:" menu, you are
presented with the above menu -- the "Ad-Hoc Report Builder" menu.
This is a true ad-hoc list builder. Your options are:

PICK FIELDS TO LIST .................. to select the fields
you want to include in
your listing

MODIFY FIELDS TO LIST ................ modify the field list

OUTPUT LIST .......................... to print/display the
listing

SAVE...TO DISK ....................... save the list you
picked to disk for
future use

RESTORE LIST DEFINITION .............. retrieve a saved list
from disk to be used

DELETE STORED DEFINITIONS ............ deletes saved lists from
disk

CHOOSE PRINTER PORT .................. normally, the default,
LPT1, is acceptable

QUIT ................................. return to Auxiliary
Menu


VITRON's NAME & ADDRESS SYSTEM 33.

PICK FIELDS TO LIST

[Enter - Select/Deselect Fields]
Acct Num
Code-1
Code-2
Code-3
Code-4
First Name
Middl Init
Last Name
Title
Company
Compny Dpt
Bus. Addr1
Bus. Addr2
Bus. City
Bus. State
[Press F10 when done ]

When you select "Pick fields to list" you are presented with a pick-list
of field names from which to choose. Keep in mind that the number of fields
you select will have a direct impact on the report. If you printer can print
80 columns, try to limit your fields to fit in 80 columns. As you select each
field, the system knows the size of that field and displays a counter at the
bottom of the screen. This counter tells you the number of columns that are
needed to print out the report as you are defining it.
NOTE: We are already working on the next release of this system. It will
include the ability to more precisely define your particular printer options,
including compressed print and, for you laser users, landscape printing. It
will include a printer-option table for over 30 different printers. You reg-
istered users, watch for our announcement in the mail soon. The upgrade will
be free to all registered users.

OUTPUT LIST

When you select this option, you are presented with the "Send to:" menu.

[Send to: ]

Printer
Text File
Screen
Quit



You can send the output to the printer, to your screen, or to a .TXT
file.
When you select where you want the output to go to, you are presented
with the "Record Selection:" menu.



VITRON's NAME & ADDRESS SYSTEM 34.

[Record Selection]
All Records
Query Matches
Tagged Records


This menu should be familiar to you by now. You can list all records,
records that match a query, or all records you tag. If you select "Query
Matches," you are provided with our familiar "Query" menu. If you select
"Tagged Records," you are presented with our familiar "tag window." However,
if you selected "Printer," after you tell the system about "Record Selec-
tion," you are presented the the following prompt window:


Maximum line length to print: 78
Spaces between columns (fields) 1
Maximum records to print (default = ALL) 10


Normally, the defaults as displayed should suffice. To accept the de-
faults, simply press ENTER when the cursor is in the appropriate area. To
change a default, type in the new value then press ENTER.
The "Maximum records to print" defaults to ALL, which shows you the to-
tal number of records on file. If you used "Query" or tagged records, or have
decided to otherwise limit the number of records to print, simply enter the
new number to override what the system has defined for you.
When all is ready, you are provided with the following prompt:


Print/Display this list now ?
YES NO


If you select "YES" the system will determine if your printer is ready
-- if you selected "Printer" -- and will begin the operation. If you opted to
display the list on the screen, it will be displayed. To return to the menu,
press ESC. If you opted to create a .TXT file and that filename already ex-
ists, you'll be asked if you want to overwrite it.

4. TODO LIST

When you select "Todo List" you are presented with the ToDo Screen.
The screen (illustrated on the next page) is divided into three areas. The
top area lists your todo items, categories, priorities, date and do-by
fields.
The middle portion of the screen is the data entry area.
The bottom portion of the screen is the "menu" area. The menu provides
the following options:

Q)uit ..................... to return to the Auxiliary Menu




VITRON's NAME & ADDRESS SYSTEM 35.

E)dit ..................... to edit the currently highlighted
item

A)dd ...................... to add a new item to the list

D)elete ................... to flag an item for deletion


Item Category Priority Do by Done














Item........
Category.... Priority.. Do By..03/29/91 Done?..N

(Press F2 to lookups)



Q)uit E)dit A)dd D)elete F)ilter M)emo P)rint O)rder


F)ilter .................. to define a filter -- that is, to
limit the display to records
of a specific category, priority,
date or completed status.

M)emo .................... to attach a brief memo to the
current item

P)rint ................... to print the items using a specific
order; lists may be "filtered" or
"unfiltered"

O)rder ................... to change the sequence -- the
default is by category

To select a menu item, simply type the first letter of the item you want
to select.




VITRON's NAME & ADDRESS SYSTEM 36.

ADD

When you select "A)dd", the cursor moves down to the data entry area.
Also note that the item area in the data entry field is longer than the item
field in the top part of the screen. That's okay. The top portion of the
screen will display only a portion of the item entered. But, whenever you

highlight an item in the top portion of the screen, the complete item is
displayed in the data entry area as well.
Also notice that when you select "A)dd" (and "Edit" too for that
matter), the system displays "Press F2 for lookups."
Enter your items accordinly.
The "Category" field is up to you. Define your own categories. Just try
to be consistent, however. Categories may include such things as Software,
Hardware, Personal, Business, Client, Household, Notes, Family, etc., etc.
Priorities are numeric, from 01 to 99.
When you complete your entry, the item is listed in the upper portion of
the screen as well as in the data entry area. Whenever you highlight an item,
it is listed in both areas of the screen.
The item can now be edited. For example, when you complete it, you may
want to change the "Done?" indicator from "N" to "Y".

EDIT

You can edit an item in one of two ways.
The first way is to move the highlight bar to the item you want to edit,
and then type E. Or you can move the highlight bar to the item you want to
edit -- indeed, you can move the highlight bar to the field of the item you
want to edit -- and press ENTER. The cursor drops down to the data entry area
of the screen, in the field that was highligted at the time you pressed EN-
TER.

F2 FOR LOOKUPS

If you press the F2 function key when in either ADD or EDIT mode, you
are presented with a pick-list of field contents that correspond to the field
highlighted by the highlight bar in the upper portion of the screen. You can
then scroll through the items, picking the one you want.

DELETE

To delete an item, move the highlight bar to the item you want to flag
for deletion, then press D. You will be prompted to confirm the deletion. If
you opt to delete it, it will be displayed in the upper area of the screen
prefixed with an asterixk (*), indicating that it has been flagged for dele-
tion. You can, of course, undelete it the same same way you deleted it.
However, when you finally decide to Quit and return to the Auxiliary
Menu, and you have items flagged for deletion, the system will permanently
remove (delete) all flagged items. You'll know this because the system will
tell you that it is packing and reindexing the ToDo file.





VITRON's NAME & ADDRESS SYSTEM 37.

FILTER

When you type F, you are prompted to set the "filter" based on Category,
Date or Priority, based on the currently highlighted item. If you select a
filter, only records that match that filter are displayed.

MEMO

When you select "M)emo" you can enter a brief memo in the data entry
area for the highlighted record. Save the memo by pressing F10; abort the
memo by pressing ESC. Keep you memos to a maximum of three lines.

PRINT

When you select "P)rint" you'll be first asked to decide on the sequence
of display -- i.e., by Category (the default), Priority or Date.

ORDER

When you select "O)rder" you can change the sequenc of the display items
-- by Category (the default), by Priority or by Date.

5. FORM LETTERS

When you select "Form Letters" from the Auxiliary Menu, you are pre-
sented with a menu asking if you want Business Data or Home Data.

Using:
Business Data
Home Data
Quit to Main


After you make your selection, you are presented with the "Form Letter
Utility" menu. Your options are:

SELECT FORM ................... to select a predefined form
from disk

CREATE NEW FORM ............... to create a new form letter














VITRON's NAME & ADDRESS SYSTEM 38.

[Form Letters Utility] [No Query ]
Select form
Create new Form
Delete Forms
Edit current form
Print form letters
Width of Form : 79
Output to :PRINTER
Assign Printer Port
Filter :ALL RECORDS

Quit




CURRENT FORM ->
DATAFILE ->NAME



EDIT CURRENT FORM ............. edit the current form

PRINT FORM LETTERS ............ print the current form using
the database records
selected

WIDTH OF FORM ................. set the printer width

OUTPUT TO ..................... send the output to the
Printer or to a .TXT file

ASSIGN PRINTER PORT ........... assign the printer port

FILTER ........................ define the record selection
criteria -- default is ALL
records

QUIT .......................... return to the Auxiliary Menu

We have created a sample form letter for you to look at.

SELECT FORM

This options displays a pick-list of forms on disk -- forms you created
and saved. If you select a stored form from disk, the name of the selected
form is displayed at the bottom of the screen. Once a form is selected (or
created), it can be edited and printed.
(If you want to see what a typical form looks like, select "Select." The
form we created is called "TEST." It's the only form currently available. Se-
lect it from the list and then "Edit" it.)



VITRON's NAME & ADDRESS SYSTEM 39.

CREATE NEW FORM


Enter a description for the form letter



When you choose "Create," you are prompted to enter a brief descrip-
tion for the new form. This description is used to identify all saved forms,
so be as specific as you can. When you create the form, it is saved auto-
matically for you under the description you enter. Then, when you choose
"Select Form," you are presented with a pick-list of saved descriptions.
After you enter a description, you are asked if you want to use another
form as a shell -- a template (a sample).


Use another form letter as a shell ?
No Yes


If you select YES, you are presented with a pick-list of saved forms. If
you select NO, you are asked if you want to import (bring in) a text file as
a shell.


Import a text file as a shell ?
No Yes


If you select YES, you are prompted to enter in the name of the file to
import. You can use wildcards, like in DOS. If you leave the field blank and
press ENTER, in a few seconds you are presented with a pick-list of available
.TXT files in the current directory. If you select NO, you are immediately
taken to the forms entry screen.
When in the forms entry screen, you'll see function keys displayed at
the top of the screen. The keys represent the following:

F1 ............... to display some help

F2 ............... provide a pick-list of busiess/home address
data to choose

F10 .............. save the current form

ESC .............. cancel and return to the Forms menu

Each of these keys should be fairly obvious. However, let's discuss the
F2 function key in a bit more detail.






VITRON's NAME & ADDRESS SYSTEM 40.


Use || to point to field
Press ENTER to accept
Press ESCAPE to abandon

Assumes that First Name
Business Data Last Name
was selected Company
Title
Address 1
Address 2
City
State
Zip
Telephone
Ext
Fax




Pressing F2 provides you with a pick-list of fields. To select -- that
is, insert a field in the form -- move the cursor to the area of the form
where you want to insert that field. Then press F2. Select the field you
want by highlighting it and pressing ENTER. A special field reference is
then inserted at the cursor position. This field reference is used to insert
actual file contents when you print the form -- print it or display it on
the screen. Continue selecting desired fields in the same way.
You will be asked if you want to convert the field to "Proper" format.
Generally, you can respond NO since all fields have already been converted to
"proper" format when you entered the data. "Proper" format means that each
word starts with a capital letter.
If you decide to select -- i.e., reference -- both Address 1 and Address
2 (line 1 and line 2 of the address) and line 2 is blank for a record, the
system will take care of that situation by skipping the field when it pro-
duces the form for the specific record(s). Inotherwords, it prints the ad-
dresses properly. NOTE: This is true for all reports, not just form letters.
To look at a sample form, select the form "TEST" from the disk and
"Edit" it. You'll see what we mean by "field references." This feature pro-
vides a true mail-merge facility when you decide to print the records.

DELETE FORMS

Selecting this option presents you with a pick-list of current saved
forms from which you can choose those to tag. First, you tag each form you
want deleted. When you have completed the tagging operation, press ESC.
You are then prompted whether or not you wish to flag the tagged forms
for deletion. IF you select NO, they are not flagged. If you select YES, they
are flagged for deletion. IF you select YES for deletion, you are then asked
if you want to permanently remove them from disk. If you select NO, they re-
main on disk as flagged for deletion. If you select YES, they are erased from
the disk. In addition, if you select YES, the file is packed and reindexed.


VITRON's NAME & ADDRESS SYSTEM 41.

Again, if you select YES, you are asked if you want the system to pack
the memo file. We strongly recommend that you always respond YES to this
prompt -- i.e., pack the memo file.

A NOTE ABOUT PACKING MEMO FILES

dBASE-related systems, such as this one, have one flaw with memo files.
When you delete and pack corresponding database file records, the memos for
those records are flagged in the memo file, but are never actually removed.
As such, Memo files grow in size even if database file records have been
erased. To prevent this wasting of disk space, we encourage you to pack the
memo file whenever you delete forms. This way, the memo file is properly
maintained.
NOTE: We have not as yet included this "memo packing" feature in the
other parts of the system. But, we shall in our next release to registered
users only.

EDIT CURRENT FORM

This option permits you to edit/change/update the current form.

PRINT FORM LETTERS

This option prints the forms, one form per record selected. When you se-
lect this option, you are first prompted to enter the left and top margins
for printing. You are then asked if you want to pause between each form's
printing. If you select YES, the system pauses before printing each form
while showing you on the screen the form it is about to print, with the ref-
erenced fields filled in. It's like a preview of the printed form before ac-
tual printing it.
You are provided with a menu at the bottom right of the screen. This
menu has the following selections:

PRINT THIS LETTER ................. to go ahead and print the
displayed form

EDIT THIS LETTER .................. allows you to first edit
the displayed form
before printing it

SKIP THIS LETTER .................. don't print the currently
displayed form

NO MORE PAUSING ................... to cancel pausing and
print continuously

QUIT PRINT ........................ to stop printing and
return to the Forms
Menu





VITRON's NAME & ADDRESS SYSTEM 42.

WIDTH OF FORM

Select this option to change the column width of your form. Normally,
the displayed defaults are adequate.

OUTPUT TO

This option is two-fold, as a toggle. Select it once to change from
"Printer" to "File." Select it again to return to "Printer."

ASSIGN PRINTER PORT

Select this option to change the printer port. Normally, the default,
LPT1, is correct.

FILTER

If you select this option, you can define the specific records to in-
clude and exclude those not selected.
You can select records based on a "query" or you can "tag" specific
records. (See page 19 for "Query" and page 32 for "tagging.")

Filter type
None - All records
Query Matches
Tagged Records


If you select "Tagged Records" you are asked if you want to begin the
tagging process now. If NO, you are returned to the Forms menu. If you select
YES, you are presented with the "tagging window."


| | > < SPACE = tag C = clear S = search ESC = done
[NOT TAGGED]
| First Name Last Name

Michael Donner
Janet Jackson
Harry Johnson
Edward Marshall
Frank O'Connor
Paul Peterson
Theordore Roosevelt
John Smith
Loraine Thomas
Peter Wilson







VITRON's NAME & ADDRESS SYSTEM 43.

6. APPOINTMENTS

When you select "Appointments" from the Auxiliary Menu, you are pre-
sented with a powerful, integrated appointment tracker and manager. You can
point to any date to add, edit or view appointments for that date. You may
also print or delete appointments for any range of dates. More advanced fea-
tures include a BROWSE MODE (a somewhat unique feature of our system that is
not quite the same in other similar systems -- in Browse you can do every-
thing: add, edit, delete, locate, etc., etc.); the ability to add peri-
odically recurring appointments and other nice facilities.
When you first select "Appointments" from the Auxiliary menu, you are
presented with a calendar display of the current month and the first two
weeks of the following month. The current DOS system date will be blinking.
If there are any current appointments already scheduled for the current
month, you'll see their dates highlighted. If there are any appointments for
the current day, the first seven (7) of them will be displayed in a window
underneath the calendar.


March 1991 <> move by day || by week
PgUp/PgDn move by month
Su Mo Tu We Th Fr Sa Home/End first/last day
add/edit Esc exit
1 2 S Search for text
3 4 5 6 7 8 9 P Print appointments
10 11 12 13 14 15 16 D Delete appointments
17 18 19 20 21 22 23 B Browse thru appts
24 25 26 27 28 29 30 C Current date: 03/29/91
31 1 2 3 4 5 6
7 8 9 10 11 12 13


As the display on the right indicates, there are several "active" keys.

(1) The DIRECTION KEYS
------------------
LEFT ARROW .................. go back one day
RIGHT ARROW .................. go forward one day
UP ARROW ..................... go back one week
DOWN ARROW ................... go forward one week
PGUP ......................... go back one month
PGDN ......................... go forward one month
HOME ......................... go to first day of displayed
month
END .......................... go to last day of displayed month

(2) The SELECTION KEYS
------------------
ENTER ........................ select current (blinking) day to
add/edit/view appointments




VITRON's NAME & ADDRESS SYSTEM 44.

(3) The MENU KEYS
-------------
S ............................ search for text in either the
description or notes of an
appointment

P ............................ print appointments

D ............................ delete appointments

B ............................ present a TABLEVIEW (Browse
Window) of appointments

C ............................ jump to the current date (current
DOS system date)

ADDING/EDITING/VIEWING APPOINTMENTS

Use the direction key to move to the desired date, then press ENTER.


Who Start End Appointment Description = Notes

: :


Ctrl W=Saves Esc=Quits

A data entry window appears. Enter the "Who" the Start and End times
(for example, as 09:00) and a brief description. If you attempt to add an ap-
pointment that creates a conflict with an already existing appointment, you
will be so informed. To save the appointment, press CTRL W.
If there already are appointments for the selected date, you will see a
small browse window at the bottom of the screen showing the time and descrip-
tion of appointments for that date.

Appointments for 03/29/91
JAMES 09:00 - 05:00 see the man about a horse








If there already are appointments for the selected date, the data entry
window is slightly different from the one above. (See the illustration on the
next page.)





VITRON's NAME & ADDRESS SYSTEM 45.


Who Start End Appointment Description = Notes

JAMES 09:00 05:00 see the man about a horse


A add E edit D delete M move R recurring appt N notes Esc exit

If the above is displayed, to add a new appointment, press A. Enter the
data in the same way as described above.
To edit the highlighted appointment, press E. As with adding appoint-
ments, you won't be permitted to enter conflicting appointments. Press CTRL W
to save your changes or ESC to exit without saving.
To delete the highlighted appointment, press D. You will be asked to
confirm. Press Y for YES or N for NO.
You may move appointments from one day to another by pressing M. A win-
dow will appear and you'll be asked to type in the new date for the appoint-
ment.
To add recurring appointments, press R. Follow the same steps as when
adding a single appointment. After you press CTRL W to save the appointment,
you will be provided with the following options:

- Every day-of-week (Mon., Tue., etc.)
- Every other day-of-week
- Every nth day of the month (e.g., 1st day of every month)
- Every day
- Every nth day-of-week (e.g., 3rd Tues. of every month)
- Every weekday only (excluding weekends)

Use the ARROW keys to select the desired option then press ENTER.
You may add notes (memos) for the highlighted appointment. Simply press
N. A window will appear below the appointment entry screen into which you can
enter whatever notes about the appointment you wish. Press CTRL W to save the
note, or press ESC to cancel the note.
Any appointments that have notes attached will be displayed in the entry
window with a checkmark at the extreme right side of the description.
To return to the calendar, press ESC.

PRINTING APPOINTMENTS

To print appointments, press P at the calendar display. You can print
for the current week, or for a range of dates that you enter in. If you print
for just a week, you'll be prompted to enter a specific UserId (Who), or ALL
for all users.
If you want to print for a range of dates, you'll be asked to enter both
the starting and ending dates to print. If there are no appointments within
the range, the system will tell you. You'll also be asked if you want to in-
clude the notes (memos) in the listing.

DELETING APPOINTMENTS

You can delete appointments for a range of dates. To select "Delete"


VITRON's NAME & ADDRESS SYSTEM 46.

type D. You'll be prompted to enter in both the starting date and the ending
date for deletion. If there are no appointments for the range, the system will
tell you. When you proceed to delete a range of appointments, the system will
display the number of affected appointments and the system will ask you to
confirm each delete request. To delete, select YES; otherwise, select NO.

BROWSE APPOINTMENTS

This is the feature that we feel makes our system unique. It works the
same as the "Table" selection from the system's Main Menu. For more informa-
tion on TABLEVIEW (Browsing, etc.) see "Table" on page 9.

=============================================================================
THE ADD OPTION

When you select "Add" from the Main Menu, you are presented with the
main data entry screen.
Enter your data accordingly. If you leave both the Last Name field AND
the Company field blank, the system assumes that you don't intend to add any-
thing, so that when you proceed to try to save the record (pressing PGDN or
pressing CTRL W) you are immediately returned to the Main Menu.
When you select "Add", make your entries. To save, press PGDN. Press ESC
to cancel your entry.
The system will then display a prompt asking if you want to save the
data. If you select YES, the data will be saved and you'll be asked if you
want to attach a memo to the current entry.
If you selected to save your data and also selected to add a memo item,
you are presented with the Memo-entry window. Enter your memo, keeping it to
less than 26 lines. Press the F10 function key to save the memo; press ESC to
cancel the memo. You can always go back and edit the memo later, using the
"Memo" option of the Main Menu or the "Update" option.
There is one feature we should point out. When you get to the State
field and you enter an invalid State abbreviation (we have also accounted for
some countries), the system will display a pick-list of valid state abbre-
viations. You can scroll through the list to select the state you want, then
press ENTER. The system will insert the state abbreviation into the record
for you.

THE UPDATE OPTION

Selecting "Update" from the Main Menu works essentially the same as Add-
ing records, except that you can change the data in the current record. Press
PGDN to save your changes; press ESC to cancel your changes.

STARTING FRESH

As you have determined by now, there are ten test records on the file
already. You can delete each of these records in preparation for your own
data. Simply press N (for Next) or P (for Previous) and go to each record.
Then select "Delete" from the Main Menu to flag each test record for dele-
tion.



VITRON's NAME & ADDRESS SYSTEM 47.

When you have flagged each test record, select "Other" from the Main
Menu. This presents you with the Auxiliary Menu.
At the Auxiliary Menu, select "Index Files." This will pack and reindex
all of the files and will permanently remove the test records so that you can
begin with a nice, clean file for your own entries.

A NOTE ABOUT THE CODES FIELDS

The system data entry screen provides you with four codes, three spaces
per code. These can be extremely useful for generating custom lists and la-
bels. For example, if you want to create a top priority contact list, you
might enter VIP in one of the code fields. Later, you can ask the system to
generate a list of all VIPs in the database. The code field can also be used
to identify a person's specialty. Dr. Jones, for example, might have the code
RES for researcher, and a second code, MB, for molecular biologist. The ap-
plications of the code fields are limited only by your imagination.
You may structure the codes any way you like, as long as you are CON-
SISTENT. We stronly recommend that you keep a list of codes handy so that you
will always use the codes properly and consistently. If you would like us to
develop a custom Code File Cross reference, just let us know and provide us
with the codes and their meanings. There will be a nominal charge for this
effort -- for registered users only.
































VITRON's NAME & ADDRESS SYSTEM 48.

ACKNOWLEDGEMENTS

We would like to thank both Greg Lief and Gary Prefontaine for what are
perhaps the two best Clipper Function Libraries available -- at least for
what we want to do.
This system is based on heavy use of both libraries. Yet, we have made
many -- and we mean MANY -- changes so that a great deal more functionality
and features have been included in our system. The changes were necessary to
accommodate additional features and to eliminate several deficiencies that we
found (personal preference, of course). The changes and modifications we
made, however, cannot take away from our appreciation and respect for these
two Clipper experts, without whose underlying functions many of the features
contained herein would have been too costly and time-consuming to reinvent.
Also, we want to thank several of our clients -- who shall, for good
reason, remain nameless herein, yet, you know who you all are -- for the many
hours you spent helping us test and validate this system and for making it
what we trust is a true user-friendly system. Special thanks to Eileen, for
all of her confidence and support, especially when we needed it most -- de-
ciding to release the system into the shareware market. Eileen, we hope you
were right!


































VITRON's NAME & ADDRESS SYSTEM 49.

REGISTRATION

Well, folks, this is the hard part -- asking you to register.
This system is provided to you as"shareware." It is NOT public domain
and it is NOT free. (You know the spiel....)
You may try NAME/ADDRESS for a period not to exceed thirty (30) days
from the time you first receive it from us or from when you first downloaded
it from a bulletin board. (We wish we had a way to verify this -- but, we
don't -- and we are sure you know this anyway.) If you find the system useful
and want to keep on using it, guess what? Yes, you must register it and, as
with all things we like to keep and use, you must also pay for it. It's inex-
pensive enough to warrant your consideration.
Of course, we at VITRON are realists and we know that in many instances
requests for registration and payment simply fall on deaf ears. But, we be-
lieve that this system is worth it. You are on the honor system and no one,
especially us, can make you do what you what you don't want to do.
The system is fully functional. There are no shareware messages, no
shareware screens, no code numbers, no authorization codes and no time bombs.
This system is the very same one we at VITRON use every day and is very much
like those which many of our clients use -- though they have more customized
versions. (Yes, we can customize the system for you. Call us for a price
quote and to discuss your needs.)
We are in the process of completing a major upgrade to the system --
with many additional features and facilities. This upgrade will be provided
to all registered users free of charge. However, if you plan on waiting for
the upgrade to be posted on bulletin boards, you're out of luck since only
registered users will be notified and provided with it.
It's up to you now. If you like the system and use it, register it. At
least you'll have the peace-of-mind that comes with being honest. The ball is
in your court.
If you don't register and run into any problem, you'll find that we'll
not be able to help you. Support is provided to registered users only.
To register your copy, simply complete the form on the next page and
send it to us along with your check or money order for $39.95 at your earli-
est convenience.
We would like to thank you in advance for your support of the shareware
concept.
In any case, we hope you enjoy this system and, if nothing else, con-
tinue exploring the world of microcomputers. Happy computing!















VITRON's NAME & ADDRESS SYSTEM 50.

NAME/ADDRESS REGISTRATION FORM

VITRON Management Consulting, Inc.
11-33 Jackson Ave.
Scarsdale. NY 10583
(914) 793-0042

Electronic Bulletin Board: (914) 779-4273


YOUR NAME: ________________________________________________________

COMPANY: __________________________________________________________

TITLE: ____________________________________________________________

ADDRESS: __________________________________________________________

__________________________________________________________

CITY: __________________________ STATE: __________ ZIP: ___________

TELEPHONE: ________________________________ EXT: __________________

Is this telephone Number your Home [ ] or Business [ ] ?


QUANTITY ITEM COST
-------- ---- -----

______ Copies of NAME/ADDRESS SYSTEM @ $39.95 each ___________


Please indicate desired diskette medium for upgrade distribution:

[ ] 5.25" [ ] 3.5"


Make check or money order payable to: VITRON, Inc.

No CODs, No Purchase Orders. U.S. funds drawn on U.S. banks only.

Corporate site licenses available on request.


From where or from whom did you receive your copy of NAME/ADDRESS:

____________________________________________________________________

Telephone Number (if known): _______________________________________


Welcome to VITRON's NAME/ADDRESS System.

Hopefully, you'll take a few moments to read this file and also to
take some time and at least skim through the MANUAL.DOC file -- the
system's User Manual.

In any case, we just want to let you know that this system is a
relatively large database application system that likes as much RAM as
it can grab. In order to effectively run this system, you'll need at least
503K of available RAM. Otherwise, you may risk seeing the infamous "Out
of Memory" error message at some point in its operation.

How do you know if you have sufficient free RAM? Run the DOS CHKDSK
command. If the amount of RAM (on the last line of the display) is
greater than or equal to 503,000, you should be okay. If not, you are
probably running some TSRs that should be removed BEFORE you start
NAME/ADDRESS.

If you run into a problem, and you are a registered user, don't
hesitate to give us a call.

VITRON Management Consulting, Inc.
(914) 793-0042

Electronic Bulletin Board: (914) 779-4273

ENJOY!




 December 16, 2017  Add comments

Leave a Reply