Shareware Overload/ShartewareOverload.cdr/finance/payus311.zip/PAYUS31A.ZIP/DBIII.STX

Text File | 1990-03-05 | 4KB | 81 lines

Screenfile DBIII.SCN    Screen# 01

This is the PAYROLL USA screen that appears when translating the Payroll
Register to a dBASE III file.  The .DBF file is written on the output directory
On our machine the data is on drive D, on your machine it may be C or some
other disk drive. Normally, if you have only one employee file, the output data
directory will be \PAYOUT . If you are using multiple employee files it may be
something like \SMITH\PAYOUT where SMITH is the PAYROLL USA configuration file
name for these employees.  If you are unsure of directories run PAYUSA and
access the configuration program to check where the output directory is set to.

Note that several "productivity" programs, as well as dBASE, can read or
translate .DBF files.  Included later in this section is an example of using
.DBF files with our newly purchased copy of QUATTRO PRO Version 1.0, from
Borland International, Inc.  QUATTRO PRO is a new (1989/1990) enhanced version
of the QUATTRO spreadsheet program. QUATTRO PRO is "State of the Art", it has
many advanced features and presentation graphics, it can read many file types
directly, including dBASE and Lotus (both 123 and Symphony), and it can link
multiple spreadsheets together (a 3 dimensional spreadsheet).

Screenfile DBIII.SCN    Screen# 02

Here we are using an old version of dBASE III to look at the \PAYOUT\PAYDB3.DBF
file. Our .DBF files need no further conversion, they are ready to use and all
the regular dBASE functions will work with them.  You can write your own dBASE
programs to print special reports, custom checks, etc. The screens used in this
presentation are electronic photographs of actual dBASE III screens.

Screenfile DBIII.SCN    Screen# 03

The first page of the structure display - as you will see it is quite normal,
just as though you had keyed it in the hard way.  There are several screens of
the structure which you can page through on your own machine.

Screenfile DBIII.SCN    Screen# 04

We have paged down to the end of the structure and are just about to look at
the first record in the file with the "EDIT 1" command.

Screenfile DBIII.SCN    Screen# 05

This is the start of Gillian Davis's record as displayed by the dBASE Edit
function.  There are several screens of this record which we have omitted to
save space.

Screenfile DBIII.SCN    Screen# 06

Here we have paged down to the end of Gillian Davis's record and we are done
with dBASE.  As with all the PAYROLL USA export features you have your choice
of current (most recent pay only) or year to date figures to use for the dBASE
export.

Screenfile DBIII.SCN    Screen# 07

In the remainder of this section we will show you how to use Borland's QUATTRO
PRO spreadsheet with a dBASE file exported from PAYROLL USA.

Screenfile DBIII.SCN    Screen# 08

Just Retrieve the file, real simple, no special translation needed. Even though
it is a dBASE file, QUATTRO PRO Retrieve's it as though it were one of QUATTRO
PRO's own spreadsheet files. Translation must be taking place during the
Retrieve, but it is completely transparent to the user.  However, be sure to
enter the .DBF extension as part of the file name or part of the file search
criteria.

Screenfile DBIII.SCN    Screen# 09

And here we have the dBASE file in a QUATTRO PRO spreadsheet.  The dBASE field
names are automatically used as the titles to each column, the column widths
are automatically set to the dBASE field widths, and the records are set out
one after another ready for use with QUATTRO PRO's Database commands or for
Graphing, etc.

Screenfile DBIII.SCN    Screen# 10

We did not have space here to move all the way across the spreadsheet, but
these are the next few columns. All QUATTRO PRO's features can be used.