home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
High Voltage Shareware
/
high1.zip
/
high1
/
DIR2
/
DBLTE12G.ZIP
/
INTRO.DBN
< prev
next >
Wrap
Text File
|
1993-11-17
|
37KB
|
484 lines
Thank you. The records in this data base are intended to serve as a tutor
to help you learn dbLite. To read these notes you will use the F5 key to
open and close this window. F5 toggles the note window open and closed.
In fact, try it now. Pressing F5 once will close the window and pressing
it once more will open it. In order to read all the notes associated with
records you will use the F5 key (open and close the note window) and the
PgUp and PgDn keys. Those keys will move you from record to record. Once
you close the note window you will be in EDIT MODE. In that mode you can
enter information into your data base. To move from record 1 to record 2,
you should press PgDn. To go back, use PgUp. (not in NOTE mode [now]
only in EDIT mode [when you close this window]) So once you have read this
note window, you can close it with the F5 key. PgDn to record 2 and then
press F5 again to open the note that is associated with (attached to) that
record.
To Review:
F5 opens and closes notes from the EDIT mode and NOTE mode.
PgUp and PgDn moves you from record to record (only in EDIT MODE).
Use that knowledge now to read the next note. (F5, PgDn, F5)
Okay, this window is an example of a note which you can attach to any
record. You will set up records to store information about people, places
and things you want to keep track of. Databases are made up of units of
storage called records. When you look at dbLite's EDIT MODE screen (the
one you see if you use F5 to toggle this window closed) you see four
windows running consecutively down the middle of the screen. These windows
are designed to contain records. They will show you four of your records
somewhere in your database. The second window from the top is the focus
window. This is where you will actually enter and edit your records.
(It's easy to identify because it has arrows pointing toward it)
Each record is made up of five regular fields. The Down Arrow and Up Arrow
keys ( along with ENTER ) will allow you to move from field to field
within each record. The easiest way to enter information into dbLite is to
type it line by line using ENTER to set the field information and move
you down to the next field. When you are finished with field #5, ENTER
will move you to field #1 of the next record. PgDn also moves you down but
you will find yourself in field #5 (if you were in that field when you hit
PgDn). Use PgUp and PgDn to move up and down to view your records. Use
ENTER to enter information a line at a time.
Once you close this window with F5, you can ENTER 5 times to move to the
next record, then F5 to view its note.
The information which you are entering into your database will be organized
into units called records. A record is a unit unto itself. Each record
will then be broken down into sub-units called fields. The best way to
make this concept understandable is to provide an example. Let's use
people as our subject and create an example database. Each person we will
be recording information on will be considered a record. Information about
that person will be contained in fields.
Field One: Alphonse Capone
Field Two: 2121 Apian Way
Field Three: Roman, Illinois
Field Four: 21212
Field Five: (212) 111-1212 fax: 222-2121
Thus we have five fields, broken down into NAME, STREET ADDRESS, CITY &
STATE, ZIP CODE, PHONE NUMBERS. As long as we are consistently entering
information of the same type in the same field of our database, we will be
able to organize that information in unique ways. Close this note and go
to the next record.
F5 PgDn F5
As you can see, Al is a record in this database. Each field in this
database can be used as an index. That is, we can organize the order in
which the records appear by any field. Normally you would organize people
alphbetically. The problem with Al is we have his first name first and his
last name last. When we sort this database by field one, Al could be first
in line even though his last name starts with C. So, we could make him
Capone, Al on line one but if we did that and we produced mailing labels,
it would look pretty formal when we mailed Al his stuff. (that is not to
say that you may not want to simply order people in this manner, there is
no law against it) We have other fields available, however, which allow us
further indexing outside of the what appears on a label. Those fields are
called a memo. The memo gives us four more fields to utilize.
The first 5 fields (lines) in our record are each 35 characters long.
The memo fields are 4 in number and each have 20 characters.
This note window is composed of 21 lines of 75 characters.
Let's see a memo. Close this note window. PgDn to the next record. Then
while holding down the Alt key press V (for View memo)
After you look at the memo window a little, then F5 to open the note.
Okay, we now have an additional four fields to use to help organize our
database. We can order it by: name
age
seniority
job title
One thing to remember: dbLite is a free form database. There are no
"description" titles next to each field. This is to allow you a certain
freedom. You must be consistent with information you wish to sort (index)
by. That is, keeping name on line one. If it is a customer name, such as a
business name, then it will be sortable pretty easily. IBM will sort after
AT&T because "I" comes after "A" in the alphabet. I suggest left justifying
everything at first until you become familiar with the program. (start
typing at column one)
But if you are not interested in ordering (sorting) your information by
every field you create then you can be more flexible in how you use your
fields. You'll notice that Al's phone numbers are both on the same line.
It's of little importance that his fax number isn't separate. You can
search for "fax" to find all customers with fax numbers but you may not be
interested in arranging them that way. (see next note)
Okay, keeping track of people, places and things is one use for dbLite.
Once entered that information is easily retrievable upon demand. You can
add contacts as they become known by appending to the database. Once added
a contact can be put into proper alpha order by sorting. Once enough
contacts are entered, a report can be printed and labels can be made for
address books and envelope addressing. Up to 1,001 contacts can be kept in
any one file. The number of files you can have is up to you. (there is an
ultimate limit but I doubt that you will ever find it using dbLite for a
small business or as a personal database)
Since it is "freeform" you can also use dbLite as a reminder system. Keep a
file called Things or TTD (for things to do). Enter your reminders as they
become known. Delete them as they are accomplished or just change the
number in the priorities field if you want to keep track of your
accomplishments. That is, use one field (obviously always the same line)
to prioritize your things to do. See the next record as an example.