home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 36 Tips
/
36-Tips.zip
/
DBINST.FAX
< prev
next >
Wrap
Text File
|
1995-01-09
|
5KB
|
146 lines
OSOTDBASE - USING THE DATABASE
10/10/94
================================================================
DATABASE
================================================================
Please Read Entire Document For Full Explanation of Procedures
----------------------------------------------------------------
The Database is a general-purpose flat file database program.
It consists of a group of one or more records with each record
containing eight lines (fields) with 30 characters in each field.
A Database file can contain up to 5000 records.
Limitations:
APAR PJ04796: Selecting File, Print, then selecting All
Records and selecting File, then Print List Format
only prints as many records that fit on one page -- not the
entire database. This fix is included in ServicePack XR06200
as of 3/1/94.
Example:
Creating a computer-based Rolodex.
To open the Database mini app:
1. Open OS/2 System.
2. Open Productivity.
3. Open Database.
Creating a new database:
1. Select File; then select New.
2. Type headings for your database fields:
a) Select Edit; then select Edit line headings.
b) Type the following headings, pressing
Enter after each:
Company Contact Address
City State Zip
Phone Fax
c) Select File and Save to save the files.
3. Enter records:
a) Select Edit, Add a new record.
b) Type information into each field accordingly:
Company : ABC Company
Contact : Your Name
Address : Your Address
City : Your City
State : Your State
Zip : Your Zip Code
Phone : Your Telephone Number
Fax : Your Fax Number
4. After completing each field, select File then Save to save
the information.
* Notice that the field view area of the database now shows
ABC Company. After additional records are added, other
company names appear.
5. Repeat steps 3 and 4 for each record.
6. After the records are in the database, select File and
Save As. Type the name you want to use for the database file.
The names of the companies are automatically sorted by company
name.
7. After saving the database file, exit Database by closing the
window.
Viewing and Sorting an Existing Database:
1. Open OS/2 System.
2. Open Productivity.
3. Open Database.
4. Select File, then Open.
5. Select the filename you want and select Open.
The records can be sorted by any of the headings using the
the View pull-down menu. This also changes the field that
appears in the field view.
Using the Search key field: (You can search on any of the
database headings.)
1. Move your cursor to the Search key field.
2. Begin typing in your search word. You will notice that upon
entering the first letter, the cursor
in the field view will move to the corresponding record. The
list gets narrowed down with each
letter you type in. The record view also changes as you
narrow the list, giving you positive
feedback on your searches.
Editing a database file:
1. Select a record from the Search Key list. The file
appears in the Database Edit window.
2. Select Edit.
3. Modify the the record.
4. Select File, then Save to save the changes or Exit to exit
without saving the changes.
Printing the database file:
1. Select File, then Print.
Select Current Record Only or All Records.
2. Select File then Print List Format for a table-style printout
of the information.
Depending on the width of your printer, you can show one to
eight fields on your report.
Using the Auto Dial Feature:
This feature is only available if you have a modem.
1. Select Customize, then Dial setup.
2. Select the com port to be used.
3. Type the Dialing Control Text. If you have a
Hayes-compatible modem enter ATDT.
4. Type the HangUp Control Text. Enter +++ATH0 (0 is the number
zero) for all Hayes- compatible modems.
NOTE: If you have a special asynchronous or non-Hayes
compatible modem, refer to the user's manual
for the correct strings.
5. Select the Set push button to set the dialing functions.
6. To use the auto dialer, locate the record on the database
file and select File and Dialing Function. A menu appears
showing all numbers in the record. Study the numbers
carefully-- no line headings tell you which number is the
telephone number..
7. Select the telephone number by clicking on the button next to
it with your mouse.
8. When you click on Select, the database automatically dials
the number for you. Make certain to have a hand set ready
to listen for the phone to ring. Whenr you have verified
the phone is ringing, press Enter.
Please refer to the on-line help for further information.