Category : Dbase (Clipper, FoxBase, etc) Languages Source Code
Archive   : CANS_101.ZIP
Filename : USR_GUID.DOC

BEER CANS INVENTORY SYSTEM

Version 1.01

26 February 1988










USER GUIDE













Developed by:

Eric L. Poole
7517 Camp Alger Avenue
Falls Church, VA 22042

Copyright (c) 1988














FOREWORD



Users of this guide are assumed to have a basic understanding of
microcomputer components and operations.

The Beer Cans Inventory System is an application system which
runs under Ashton Tate's dBASE III Plus data base management
system on an IBM PC or compatible computer. In order for it to
work, you must have your own licensed copy of dBASE III Plus.

The system has been reasonably tested and, to my knowledge, it
works reliably. However, I will not be held responsible or
liable to you for any loss of data or any other consequential
damages arising from your use (or misuse) of this software.

I hope that this system will be useful to you. Enjoy!































-2-




TABLE OF CONTENTS


Page

1. Purpose ............................................. 4

2. Operating Environment ............................... 4

a. Hardware ........................................ 4
b. Software ........................................ 4

3. Data Base Structure ................................. 4

4. Basic Operating Instructions ........................ 5

a. Initial Set-up .................................. 5
(1) Hard Disk Systems .......................... 5
(2) Dual Floppy Disk Systems ................... 6
b. Getting Started ................................. 6
(1) Hard Disk Users............................. 6
(2) Floppy Disk Users........................... 7
c. Logo Screen ..................................... 8
d. Menu Options .................................... 9
(1) Main Menu .................................. 9
(2) Reports menu .............................. 11
(3) Backup Files Menu ......................... 14
(4) System Documentation Menu ................. 15
e. Shutdown ....................................... 15

5. System Documentation ............................... 16

a. General System Architecture .................... 16
b. dBASE III Plus Program Listings ................ 17
c. Report Documentation ........................... 18
d. Sample Reports ................................. 18

6. Backup Procedures .................................. 29

a. Data Base Backup ............................... 29
b. dBASE III Plus Program Backup .................. 29
c. Backup All of the Above ........................ 30

7. Comments ........................................... 30





-3-




BEER CANS INVENTORY SYSTEM
--------------------------



1. Purpose.
-------

To provide a flexible, easy-to-use system for beer can collectors
to collect, manage, and report information about beer cans
through the use of a personal computer and a data base management
system.


2. Operating Environment.
---------------------

This system was developed to operate in the following computer
environment:


a. Hardware.
--------

IBM PC, PC/XT, PC/AT, or compatible microcomputer system with color
monitor (a monochrome monitor will work, but the colors embedded
in the programs may cause certain areas of text not to show on
the screen very well, or at all), preferably hard disk storage
(although 2 floppy disks will work fine), at least 384K RAM
(required to run dBASE III Plus), and an 80-column dot-matrix
printer (if you want to print anything).


b. Software.
--------

MS/DOS or IBM PC/DOS (hereinafter referred to as "DOS") operating
system (Version 2.0 or higher), and Ashton Tate dBASE III Plus
(Version 1.0 or higher).


3. Data Base Structure.
-------------------

Data Base Name = CANS.DBF

Structure is as follows:


-4-

Decimal
Field Field Name Type Width Places Description
----- ---------- ---- ----- ------ -----------
1 Brand C 30 Brand Name
2 Brewery C 20 Brewery Name
3 Location C 20 Brewery Location
4 Size N 5 1 Size of Can
5 Bev C 2 Type of Beverage
6 US_F C 1 US or Foreign
7 Type C 4 Type of Can
8 Grade C 2 Grade of Can
9 BCCA N 4 BCCA No.
10 BCU C 6 BCU No.
11 BIB N 4 Bible No.
12 CLS C 6 Class Book No.
13 Value N 7 2 Estimated Value
14 Comments C 30 Comments


Record size = 141 positions


Note: CANS.DBF is indexed on Brand, Brewery, Location
and Size (BROWSE.NDX).

The data base has been loaded with sample data
for illustration purposes.


4. Basic Operating Instructions.
----------------------------

a. Initial Set-up.
--------------

(1) Hard Disk Systems.
-----------------

(a) Assuming that your dBASE III Plus software
resides in a hard disk directory called C:\DBASE, make a sub-
directory under C:\DBASE called C:\DBASE\CANS. Change from the
C:\DBASE directory to the C:\DBASE\CANS subdirectory. Put the
floppy diskette containing the Beer Cans Inventory System into
the A: drive. At the C:\DBASE\CANS> prompt, type COPY A:*.* to
copy all programs for the Beer Cans Inventory System from the
floppy diskette to the C:\DBASE\CANS sub-directory on the hard
disk.

(b) Make sure that the DOS PATH command, which
should be set up in your AUTOEXEC.BAT file in the root directory


-5-

(C:\), includes C:\DBASE so that the dBASE III Plus programs can
be found by DOS while operating out of the C:\DBASE\CANS sub-
directory.

(c) Make sure that you have a CONFIG.SYS file in
your root directory and that it contains:

FILES = 20
BUFFERS = 15

Note: If you don't have a CONFIG.SYS file, you
can copy the one from the Beer Cans Inventory System disk to your
root directory as follows. With the Beer Cans Inventory System
disk in the A: drive, type COPY A:CONFIG.SYS C:\ and press the
Enter key.


(2) Dual Floppy Disk Systems.
------------------------

(a) Make sure that you have a CONFIG.SYS file in
your root directory (A:\) on the floppy disk containing your
operating system which you use to boot the system up with. The
CONFIG.SYS file must contain:

FILES = 20
BUFFERS = 15

Note: If you don't have a CONFIG.SYS file, you
can copy the one from the Beer Cans Inventory System disk to your
root directory as follows. With the your DOS disk in the A:
drive and the Beer Cans Inventory System disk in the B: drive,
type COPY B:CONFIG.SYS A:\ and press the Enter key.


b. Getting Started.
---------------

(1) Hard Disk Users.
---------------

(a) Boot up your system.

(b) Change to the C:\DBASE\CANS subdirectory. Then
type DBASE and press the Enter key.

(c) You will then see the dBASE III Plus License
Agreement screen. Depending on how you have your particular
dBASE III Plus package set up, [1] you must then press the Enter
key to go to the dBASE III Assist Menu, or [2] you will be


-6-

presented with a Dot Prompt (.) and can enter a dBASE III
command. If the case is [1], press the ESC key to exit Assist
mode and go to the Dot Prompt mode.

(d) At the Dot Prompt, type DO MENU and press the
Enter key. This starts the programs for the Beer Cans Inventory
System.

(e) At this point, the system operates in a menu-
driven mode. You will first be presented with a Logo screen
which displays the system name, version, and date. Press any key
to exit the Logo screen and go to the Main Menu. From that
point, simply follow the menus and on-screen instructions
provided by the system for all standard operations.

Note: If you get hung up on anything, pressing the ESC key once
or twice will usually get you out of the loop and you can type DO
MENU and press the Enter key to start again.


(2) Floppy Disk Users.
-----------------

(a) Place your DOS diskette in the A: drive and
boot up the system.

(b) Remove the DOS diskette from the A: drive and
replace it with the dBASE III Plus System Disk #1. Then place
the Beer Cans Inventory System floppy diskette in the B: drive.

(c) At the A:\> prompt, type DBASE and press the
Enter key to start dBASE III Plus.

(d) You will be prompted to remove dBASE III Plus
System Disk #1 and replace it with dBASE III Plus System Disk #2.
Press the Enter key and then the dBASE III Plus License Agreement
screen will appear. Depending on how you have your particular
dBASE III Plus package set up, [1] you must then press the Enter
key to go to the dBASE III Assist Menu, or [2] you will be
presented with a Dot Prompt (.) and can enter a dBASE III
command. If the case is [1], press the ESC key to exit Assist
mode and go to the Dot Prompt mode.

(e) At the Dot Prompt, type SET DEFAULT TO B: and
press the Enter key. This tells dBASE III Plus to run all
programs from the B: drive. Then type DO MENU and press the
Enter key. This starts the programs for the Beer Cans Inventory
System.

(f) At this point, the system operates in a menu-


-7-

driven mode. You will first be presented with a Logo screen
which displays the system name, version, and date. Press any key
to exit the Logo screen and go to the Main Menu. From that
point, simply follow the Menus and on-screen instructions
provided by the system for all standard operations.

Note: If you get hung up on anything, pressing the ESC key once
or twice will usually get you out of the loop and you can type DO
MENU to start again.


c. Logo Screen.
-----------


ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»
º ºÍ»
º ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» ººº
º º BEER CANS INVENTORY SYSTEM º ººº
º ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ ººº
º ººº
ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼºº
ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ

ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»
º ºÍ»
º Version 1.01 ººº
º 26 February 1988 ººº
º ººº
º By Eric L. Poole ººº
º Copyright 1988 ººº
º ººº
ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼºº
ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ

Press any key to continue...
















-8-

d. Menu Options.
------------

(1) Main Menu.
---------

ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»
º 02/22/88 * * * Main Menu * * * 17:31:15 º
ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ

1. Add New Records
2. Edit/Delete Existing Records
3. Browse Records in Data Base
4. Reports Menu
5. dBASE Assist Mode
6. dBASE Dot Prompt Mode
7. Backup Files Menu
8. System Documentation Menu
9. Exit to DOS



ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»
º Highlight option by using  or  and press Ù º
º or press appropriate menu number º
ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ


(a) Select choice "1" to add new records to the data
base using the standard dBASE III Plus Append format. The default
data entry format spans two screens and contains a Help Menu at
the top of the screen. The Help Menu can be toggled off and on by
pressing the F1 key. When the Help Menu is toggled off, the data
entry format fits on one screen. To add a record, simply type in
new data in each field, pressing the Enter key to tab to the next
field. After completing a record, a blank screen will be
presented for you to continue with the next record. When finished
adding data, press the Ctrl End key combination to save the data.
At that point, you will be returned to the Main Menu.

(b) Select choice "2" to change or delete existing
records in the data base using the standard dBASE III Plus edit
format. The file is indexed on Brand, Brewery, Location and Size.
You will be prompted to enter a character string containing a
portion of the Brand name (beginning from the left of the field)
of the can whose record is to be changed or deleted. You only
need to enter as much as you think is necessary to find the Brand
that you're searching for. For example, if you're looking for
Regal Beer, you could enter Reg, REG, or reg (the search is case
insensitive) and the program would find the first occurrence of


-9-

any Brand beginning with the uppercase equivalent of that character
string. If the first record displayed is not the one you wanted,
simply page down through the file using the PgDn key until you
find the one you're looking for. If in your haste, you pass it,
then press PgUp to page back up. The edit format also contains a
Help Menu at the top which can be toggled off and on by pressing
the F1 key. You can quickly tab through the fields of the record
that remain unchanged by pressing the Down Arrow key or the Enter
key. You can edit a field by typing over existing data, or by
inserting new data (toggle Insert mode off and on by pressing the
Ins key), or by deleting existing data (press the Del key to
delete). You can delete the entire record by pressing Ctrl U.
Deleted records are marked for deletion but they remain in the
file until the file is packed. When finished editing/deleting,
press the Ctrl End key combination to save the changes. At that
point, you will will be asked whether you wish to edit another
record or not. If no, you will then be asked whether you wish to
pack the file or not. Then you will be returned to the Main
Menu.

(c) Select choice "3" to browse through the data
base and review the data contents of each record. Records
appear in the standard dBASE III browse line format (one line
per record). Since the records are wider than 80 positions, not
all data elements will be displayed on the screen at once. You
may pan or horizontal scroll to the right using the Ctrl Right
Arrow key combination to view all data fields. Pan back to the
left using the Ctrl Left Arrow key combination. You can make
changes to the fields if desired using standard edit techniques
(typeover, insert, delete, Ctrl End to save, etc.). When
finished browsing, press the ESC key to return to the Main Menu.

(d) Select choice "4" to produce standard reports
from the data base. A Reports Menu will be displayed to show
you what report options are available. Reports may be displayed
on the screen (default) or optionally printed on the printer.
See Reports Menu in paragraph 4.c.(2) below for more detail
concerning the Reports Menu and the reporting options available.

(e) Select choice "5" to exit the Main Menu and go
to dBASE III Plus Assist mode. In Assist mode, users who have
had some basic training in dBASE III Plus, can use the "Pull-down"
menus to do any dBASE III Plus operation desired. (Users who
have little or no dBASE III Plus experience should probably stick
to the standard menus established until they get some basic
training.) When finished in Assist mode, press the ESC key to
return to the Main Menu.

(f) Select choice "6" to exit the Main Menu and go
to dBASE III Dot Prompt mode. At the dBASE III Dot Prompt (.),


-10-

experienced users can bypass the Beer Cans Inventory System menus
and programs, as well as the Pull-down Menus of Assist mode, and
directly enter dBASE III Plus commands for any operations desired.
When finished in Dot Prompt mode, type DO MENU and press the Enter
key to return to the Beer Cans Inventory System.

(g) Select choice "7" to create backup files of the
data base, indexes, and/or dBASE III Plus programs on floppy
diskette. The Backup Files Menu will be displayed to show you
what backup options are available. The process is menu-driven and
easy to use. See Backup Files Menu in paragraph 4.c.(3) below for
more detail concerning the Backup Menu and the backup options
available.

(h) Select choice "8" to display or print out the
Data Element Dictionary, User Guide, or dBASE III Plus program
listings for all Beer Cans Inventory System programs. A menu will
be displayed to show you what options are available. See paragraph
4.c.(4) below for more detail concerning the System Documentation
Menu and the options available.

(i) Select choice "9" to quit dBASE III Plus and exit
to DOS.


(2) Reports Menu.
------------


ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»
º 02/22/88 * * * Reports Menu * * * 17:32:02 º
ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ

1. List Cans by Brand and Size
2. List Cans by Brewery, Brand and Size
3. List Cans by Type, Brand and Size
4. List Cans by Beverage, Brand and Size
5. List Cans by Grade, Brand and Size
6. List Cans by Size, Brand and Type
7. List Cans by US/Foreign, Brand and Size
8. Search for Data in Any Field
9. Return to Main Menu



ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»
º Highlight option by using  or  and press Ù º
º or press appropriate menu number º
ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ



-11-

(a) Select choice "1" to list all cans by Brand and
Size. You will be prompted whether to send the report to the
screen (default) or the printer. Just press the Enter key for
screen output, or type P and then press the Enter key for printer
output. (Note: While listing reports, use the Crtl S key
combination to toggle Suspend Screen off and on so you can stop
the scrolling and read what's on the screen.) Report 1 will then
be produced using a standard report format (REPORT1.FRM). See
section 5.d for a sample printout which illustrates the type of
information provided by Report 1. After the report is completed,
you will be returned to the Reports Menu.

(b) Select choice "2" to list all cans by Brewery,
Brand and Size. You will be prompted whether to send the report
to the screen (default) or the printer. Report 2 will then be
produced using a standard report format (REPORT2.FRM). See
section 5.d for a sample printout which illustrates the type of
information provided by Report 2.

(c) Select choice "3" to list all cans by Type,
Brand and Size. You will be prompted whether to send the report
to the screen (default) or the printer. Report 3 will then be
produced using a standard report format (REPORT3.FRM). See
section 5.d for a sample printout which illustrates the type of
information provided by Report 3.

(d) Select choice "4" to list all cans by Beverage,
Brand and Size. You will be prompted whether to send the report
to the screen (default) or the printer. Report 4 will then be
produced using a standard report format (REPORT4.FRM). See
section 5.d for a sample printout which illustrates the type of
information provided by Report 4.

(e) Select choice "5" to list all cans by Grade,
Brand and Size. You will be prompted whether to send the report
to the screen (default) or the printer. Report 5 will then be
produced using a standard report format (REPORT5.FRM). See
section 5.d for a sample printout which illustrates the type of
information provided by Report 5.

(f) Select choice "6" to list all cans by Size,
Brand and Type. You will be prompted whether to send the report
to the screen (default) or the printer. Report 6 will then be
produced using a standard report format (REPORT6.FRM). See
section 5.d for a sample printout which illustrates the type of
information provided by Report 6.

(g) Select choice "7" to list all cans by
US/Foreign, Brand and Size. You will be prompted whether to send
the report to the screen (default) or the printer. Report 7 will


-12-

then be produced using a standard report format (REPORT7.FRM).
See section 5.d for a sample printout which illustrates the type
of information provided by Report 7.

(h) Select choice "8" to perform simple queries
for any range of data in most fields in the data base.


SEARCH MENU

ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»
º º
º Fields are: 1. Brand Name º
º 2. Brewery º
º 3. Location º
º 4. Size of Can º
º 5. Type of Beverage º
º 6. US or Foreign º
º 7. Type of Can º
º 8. Grade º
º º
ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ

Enter Number (1-8) of field to search on? 1


You will be prompted for field and search criteria (Note:
Search criteria may be entered in upper or lower case. For
example, to search on Brand for Regal Beer, you only need to
enter Reg, REG, or reg to find it; to search for Old German
Brand Beer, you only need to enter German, GERM, or brand, etc.
to find it) and whether to send the report to the screen
(default) or the printer. A report will then be produced using
one of the established standard report formats (REPORT1.FRM
through REPORT7.FRM).

(g) Select choice "9" to exit the Reports Menu and
return to the Main Menu.














-13-

(3) Backup Files Menu.
-----------------

ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»
º 02/22/88 * * * Backup Files Menu * * * 17:32:47 º
ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ

1. Backup Data Base and Indexes
2. Backup dBASE III Plus Programs
3. Backup All of the Above
4. Return to Main Menu








ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»
º Highlight option by using  or  and press Ù º
º or press appropriate menu number º
ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ


(a) Select choice "1" to create a backup of the
data base (CANS.DBF) and its index (BROWSE.NDX) on floppy
diskette. See instructions for performing backups in paragraph 6
of this guide.

(b) Select choice "2" to create a backup of all
Beer Cans Inventory System dBASE III Plus programs on floppy
diskette. See instructions for performing backups in paragraph 6
of this guide.

(c) Select choice "3" to create backups of the data
base, indexes, and dBASE III Plus programs, as specified in
paragraphs 4.c.(3)(a) and 4.c.(3)(b) above, in one continuous
operation.

(d) Select choice "4" to exit the Backup Files Menu
and return to the Main Menu.










-14-

(4) System Documentation Menu.
-------------------------


SYSTEM DOCUMENTATION MENU

ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»
º º
º Choices are: º
º º
º 1. List Data Element Dictionary º
º 2. List User Guide º
º 3. List DBASE III Plus Programs º
º 4. Return to Main Menu º
º º
ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ

Enter your choice: 1


(a) Select choice "1" to list the Data Element
Dictionary. You will be prompted whether to send the report to the
screen (default) or the printer. Just press the Enter key for
screen output, or type P and then press the Enter key for printer
output. When finished, you will be returned to the System
Documentation Menu.

(b) Select choice "2" to list this user guide. You
will be prompted whether to send the report to the screen
(default) or the printer. Just press the Enter key for screen
output, or type P and then press the Enter key for printer output.
When finished, you will be returned to the System Documentation
Menu.

(c) Select choice "3" to list all dBASE III Plus
programs associated with the Beer Cans Inventory System. You
will be prompted whether to send the report to the screen
(default) or the printer. Just press the Enter key for screen
output, or type P and then press the Enter key for printer output.
When finished, you will be returned to the System Documentation
Menu.

(d) Select choice "4" to exit the System
Documentation Menu and return to the Main Menu.


e. Shut-down.
---------

(1) When all required processing is finished using the


-15-

Beer Cans Inventory System, select choice "9" (Exit to DOS) from
the Main Menu, or type QUIT from the Dot Prompt. All dBASE III
Plus programs and Beer Cans Inventory System files will be
properly closed and you will be returned to DOS.

(2) Be sure to put your backup diskettes in a safe place
in case a contingency occurs and you need them for recovery
purposes.


5. System Documentation.
--------------------

a. General System Architecture.
---------------------------

The following top-down schematic depicts how the Beer Cans
Inventory System dBASE III Plus program modules are structured.


































-16-

SYSTEM ARCHITECTURE
-------------------



Main Menu
|
|
|--- Logo
|
|
------------------------------------------------------------------------
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
| | | | | | | | |
| | | Reports Assist Dot Backup System |
Add Update Browse Menu Mode Prompt Menu Doc. Quit
| | |
| | |
| | |
---------------------------- -------------------------- |
| | 2 | 1 | 4 | 3 | 2 | 1 |
| | | | | | | |
| | | | | | Data |
| Report2 Report1 Return Both Programs Base |
| |
| |
| |
-------------------------------------------------------- |
| 3 | 4 | 5 | 6 | 7 | 8 |
| | | | | | |
| | | | | | |
Report3 Report4 Report5 Report6 Report7 Return |
|
|
|
------------------------------------
| 4 | 3 | 2 | 1
| | | |
| Prog. User Data Element
Return Listing Guide Dictionary



b. dBASE III Program Listings.
--------------------------

Choice 3 on the System Documentation Menu provides a listing of
the following dBASE III Plus programs which make up the Beer Cans
Inventory System:



-17-

(1) MENU.PRG
(2) LOGO.PRG
(3) ADD.PRG
(4) UPDATE.PRG
(5) REPORTS.PRG
(6) REPORT1.PRG
(7) REPORT2.PRG
(8) REPORT3.PRG
(9) REPORT4.PRG
(10) REPORT5.PRG
(11) REPORT6.PRG
(12) REPORT7.PRG
(13) REPORT8.PRG
(14) BACKUP.PRG
(15) BACKFILE.PRG
(16) BACKPROG.PRG
(17) LISTDOC.PRG
(18) LISTDOC1.PRG
(19) LISTDOC2.PRG
(20) LISTDOC3.PRG


c. Report Documentation.
--------------------

Special formats (REPORT1.FRM through REPORT7.FRM) for Reports 1,
through 7, were created using the MODIFY REPORT command. The
documentation may be accessed on-line by using the MODIFY REPORT
command in dBASE III Dot Prompt mode. For example, to see the
documentation for Report 1, enter MODIFY REPORT REPORT1.


d. Sample Reports.
--------------

The following pages contain sample printouts for standard Reports
1 through 7:















-18-

Page No. 1
02/17/88

Beer Cans Inventory System

Report 1 - List Cans by Brand and Size



Brand Size Type Gr BCCA BCU Bible Class Value
----- ---- ---- -- ---- --- ----- ----- -----


Acme Beer 12.0 2FO 3 60-7 12.00
Acme Beer 12.0 2R 1 60-9 1.25
Acme The Light Dry Beer 12.0 2F 2 60-8 6.00
Billy Beer 12.0 2TA 1 63-2 1.00
Buffalo Brand Beer 12.0 1FOX 2- 10 52-18 384 100.00
Colt 45 Malt Liquor 8.0 2T 2 80 54-15 8.00
Croft Cream Ale 32.0 1FOX 2+ 33-1 225.00
Dixie 45 Beer 12.0 2F 2 73-3 50.00
Dixie Beer 12.0 2TA 1 73-4 1.00
Dixie Lager 12.0 2T 1 73-5 1.00
Dixie Light Light Light Beer 12.0 2T 1 73-6 1.00
Erlanger's Pilsner Beer 32.0 1CX 3+ 20 53-06 90.00
Fort Pitt Beer 12.0 1K 1- 28-8 125.00
Harvard Ale 12.0 1FOX 3- 90 79-35 1267 15.00
Lion Beer 12.0 1FX 1- 40 89-39 1634 150.00
Lone Star Beer 12.0 2R 3 310 90-9 1653 1.50
National Bohemian 12.0 2A 1+ 1140 91-21 1.00
Pabst Blue Ribbon Beer 16.0 2F 2 3000 145-29 4.00
Regal Light Lager Beer 12.0 1CH 3 40 33-05 591 25.00
Scheidt's Rams Head Ale 32.0 1CX 2- 32-2 200.00
Schlitz Beer 12.0 2T 1 140 115-11 2573 1.00
Schlitz Beer 14.0 2T 1 150 129-12 1.00
Schlitz Beer 16.0 2T 1 160 148-27 1.00
Tru-Blu Ten Star Ale 12.0 1CJX 3+ 28-9 300.00
Younger's Tartan Special Ale 9.6 2T 1 3389 3.00
*** Total ***
1323.75












-19-

Page No. 1
02/17/88

Beer Cans Inventory System

Report 2 - List Cans by Brewery, Brand and Size



Brand Size Type Gr BCCA BCU Bible Class Value
----- ---- ---- -- ---- --- ----- ----- -----


** Brewery: Acme, San Francisco, CA
Acme Beer 12.0 2FO 3 60-7 12.00
Acme The Light Dry Beer 12.0 2F 2 60-8 6.00
** Subtotal **
18.00

** Brewery: Adam Scheidt, Norristown, PA
Scheidt's Rams Head Ale 32.0 1CX 2- 32-2 200.00
** Subtotal **
200.00

** Brewery: American Brewing, Miami, FL
Regal Light Lager Beer 12.0 1CH 3 40 33-05 591 25.00
** Subtotal **
25.00

** Brewery: Blitz-Weinhard, Portland, OR
Acme Beer 12.0 2R 1 60-9 1.25
** Subtotal **
1.25

** Brewery: Buffalo, Sacramento, CA
Buffalo Brand Beer 12.0 1FOX 2- 10 52-18 384 100.00
** Subtotal **
100.00

** Brewery: Croft, Cranston, RI
Croft Cream Ale 32.0 1FOX 2+ 33-1 225.00
** Subtotal **
225.00

** Brewery: Dixie, New Orleans, LA
Dixie 45 Beer 12.0 2F 2 73-3 50.00
Dixie Beer 12.0 2TA 1 73-4 1.00
Dixie Lager 12.0 2T 1 73-5 1.00
Dixie Light Light Light Beer 12.0 2T 1 73-6 1.00
** Subtotal **
53.00

-20-

Page No. 2
02/17/88

Beer Cans Inventory System

Report 2 - List Cans by Brewery, Brand and Size



Brand Size Type Gr BCCA BCU Bible Class Value
----- ---- ---- -- ---- --- ----- ----- -----


** Brewery: Fort Pitt, Pittsburgh, PA
Fort Pitt Beer 12.0 1K 1- 28-8 125.00
** Subtotal **
125.00

** Brewery: Harvard, Lowell, MA
Harvard Ale 12.0 1FOX 3- 90 79-35 1267 15.00
** Subtotal **
15.00

** Brewery: Jos. Schlitz, Winston Salem, NC
Schlitz Beer 12.0 2T 1 140 115-11 2573 1.00
Schlitz Beer 14.0 2T 1 150 129-12 1.00
Schlitz Beer 16.0 2T 1 160 148-27 1.00
** Subtotal **
3.00

** Brewery: Lion, New York, NY
Lion Beer 12.0 1FX 1- 40 89-39 1634 150.00
** Subtotal **
150.00

** Brewery: Lone Star, San Antonio, TX
Lone Star Beer 12.0 2R 3 310 90-9 1653 1.50
** Subtotal **
1.50

** Brewery: National, Baltimore, MD
Colt 45 Malt Liquor 8.0 2T 2 80 54-15 8.00
National Bohemian 12.0 2A 1+ 1140 91-21 1.00
** Subtotal **
9.00

** Brewery: Northampton, Northampton, PA
Tru-Blu Ten Star Ale 12.0 1CJX 3+ 28-9 300.00
** Subtotal **
300.00


-21-

Page No. 3
02/17/88

Beer Cans Inventory System

Report 2 - List Cans by Brewery, Brand and Size



Brand Size Type Gr BCCA BCU Bible Class Value
----- ---- ---- -- ---- --- ----- ----- -----


** Brewery: Otto Erlanger, Philadelphia, PA
Erlanger's Pilsner Beer 32.0 1CX 3+ 20 53-06 90.00
** Subtotal **
90.00

** Brewery: Pabst, Milwaukee, WI
Pabst Blue Ribbon Beer 16.0 2F 2 3000 145-29 4.00
** Subtotal **
4.00

** Brewery: Scottish & Newcastle, Edinburgh, Scotland
Younger's Tartan Special Ale 9.6 2T 1 3389 3.00
** Subtotal **
3.00

** Brewery: West End, Utica, NY
Billy Beer 12.0 2TA 1 63-2 1.00
** Subtotal **
1.00
*** Total ***
1323.75


















-22-

Page No. 1
02/17/88

Beer Cans Inventory System

Report 3 - List Cans by Type, Brand and Size



Type Brand Size Gr BCCA BCU Bible Class Value
---- ----- ---- -- ---- --- ----- ----- -----


2A National Bohemian 12.0 1+ 1140 91-21 1.00
1CH Regal Light Lager Beer 12.0 3 40 33-05 591 25.00
1CJX Tru-Blu Ten Star Ale 12.0 3+ 28-9 300.00
1CX Erlanger's Pilsner Beer 32.0 3+ 20 53-06 90.00
1CX Scheidt's Rams Head Ale 32.0 2- 32-2 200.00
2F Acme The Light Dry Beer 12.0 2 60-8 6.00
2F Dixie 45 Beer 12.0 2 73-3 50.00
2F Pabst Blue Ribbon Beer 16.0 2 3000 145-29 4.00
2FO Acme Beer 12.0 3 60-7 12.00
1FOX Buffalo Brand Beer 12.0 2- 10 52-18 384 100.00
1FOX Croft Cream Ale 32.0 2+ 33-1 225.00
1FOX Harvard Ale 12.0 3- 90 79-35 1267 15.00
1FX Lion Beer 12.0 1- 40 89-39 1634 150.00
1K Fort Pitt Beer 12.0 1- 28-8 125.00
2R Acme Beer 12.0 1 60-9 1.25
2R Lone Star Beer 12.0 3 310 90-9 1653 1.50
2T Colt 45 Malt Liquor 8.0 2 80 54-15 8.00
2T Dixie Lager 12.0 1 73-5 1.00
2T Dixie Light Light Light Beer 12.0 1 73-6 1.00
2T Schlitz Beer 12.0 1 140 115-11 2573 1.00
2T Schlitz Beer 14.0 1 150 129-12 1.00
2T Schlitz Beer 16.0 1 160 148-27 1.00
2T Younger's Tartan Special Ale 9.6 1 3389 3.00
2TA Billy Beer 12.0 1 63-2 1.00
2TA Dixie Beer 12.0 1 73-4 1.00
*** Total ***
1323.75












-23-

Page No. 1
02/17/88

Beer Cans Inventory System

Report 4 - List Cans by Beverage, Brand and Size



Bev Brand Size Gr BCCA BCU Bible Class Value
--- ----- ---- -- ---- --- ----- ----- -----

** Beverage: A
A Croft Cream Ale 32.0 2+ 33-1 225.00
A Harvard Ale 12.0 3- 90 79-35 1267 15.00
A Scheidt's Rams Head Ale 32.0 2- 32-2 200.00
A Tru-Blu Ten Star Ale 12.0 3+ 28-9 300.00
A Younger's Tartan Special Ale 9.6 1 3389 3.00
** Subtotal **
743.00
** Beverage: B
B Acme Beer 12.0 3 60-7 12.00
B Acme Beer 12.0 1 60-9 1.25
B Acme The Light Dry Beer 12.0 2 60-8 6.00
B Billy Beer 12.0 1 63-2 1.00
B Buffalo Brand Beer 12.0 2- 10 52-18 384 100.00
B Dixie 45 Beer 12.0 2 73-3 50.00
B Dixie Beer 12.0 1 73-4 1.00
B Dixie Lager 12.0 1 73-5 1.00
B Erlanger's Pilsner Beer 32.0 3+ 20 53-06 90.00
B Fort Pitt Beer 12.0 1- 28-8 125.00
B Lion Beer 12.0 1- 40 89-39 1634 150.00
B Lone Star Beer 12.0 3 310 90-9 1653 1.50
B National Bohemian 12.0 1+ 1140 91-21 1.00
B Pabst Blue Ribbon Beer 16.0 2 3000 145-29 4.00
B Regal Light Lager Beer 12.0 3 40 33-05 591 25.00
B Schlitz Beer 12.0 1 140 115-11 2573 1.00
B Schlitz Beer 14.0 1 150 129-12 1.00
B Schlitz Beer 16.0 1 160 148-27 1.00
** Subtotal **
571.75
** Beverage: LB
LB Dixie Light Light Light Beer 12.0 1 73-6 1.00
** Subtotal **
1.00
** Beverage: ML
ML Colt 45 Malt Liquor 8.0 2 80 54-15 8.00
** Subtotal **
8.00
*** Total ***
1323.75

-24-

Page No. 1
02/17/88

Beer Cans Inventory System

Report 5 - List Cans by Grade, Brand and Size



Gr Brand Size Type BCCA BCU Bible Class Value
-- ----- ---- ---- ---- --- ----- ----- -----


** Grade: 1
1 Acme Beer 12.0 2R 60-9 1.25
1 Billy Beer 12.0 2TA 63-2 1.00
1 Dixie Beer 12.0 2TA 73-4 1.00
1 Dixie Lager 12.0 2T 73-5 1.00
1 Dixie Light Light Light Beer 12.0 2T 73-6 1.00
1 Schlitz Beer 12.0 2T 140 115-11 2573 1.00
1 Schlitz Beer 14.0 2T 150 129-12 1.00
1 Schlitz Beer 16.0 2T 160 148-27 1.00
1 Younger's Tartan Special Ale 9.6 2T 3389 3.00
1+ National Bohemian 12.0 2A 1140 91-21 1.00
1- Fort Pitt Beer 12.0 1K 28-8 125.00
1- Lion Beer 12.0 1FX 40 89-39 1634 150.00
** Subtotal **
287.25

** Grade: 2
2 Acme The Light Dry Beer 12.0 2F 60-8 6.00
2 Colt 45 Malt Liquor 8.0 2T 80 54-15 8.00
2 Dixie 45 Beer 12.0 2F 73-3 50.00
2 Pabst Blue Ribbon Beer 16.0 2F 3000 145-29 4.00
2+ Croft Cream Ale 32.0 1FOX 33-1 225.00
2- Buffalo Brand Beer 12.0 1FOX 10 52-18 384 100.00
2- Scheidt's Rams Head Ale 32.0 1CX 32-2 200.00
** Subtotal **
593.00

** Grade: 3
3 Acme Beer 12.0 2FO 60-7 12.00
3 Lone Star Beer 12.0 2R 310 90-9 1653 1.50
3 Regal Light Lager Beer 12.0 1CH 40 33-05 591 25.00
3+ Erlanger's Pilsner Beer 32.0 1CX 20 53-06 90.00
3+ Tru-Blu Ten Star Ale 12.0 1CJX 28-9 300.00
3- Harvard Ale 12.0 1FOX 90 79-35 1267 15.00
** Subtotal **
443.50

*** Total ***
1323.75
-25-

Page No. 1
02/17/88

Beer Cans Inventory System

Report 6 - List Cans by Size, Brand and Type



Size Brand Type Gr BCCA BCU Bible Class Value
---- ----- ---- -- ---- --- ----- ----- -----

** Size: 8.0
8.0 Colt 45 Malt Liquor 2T 2 80 54-15 8.00
** Subtotal **
8.00

** Size: 9.6
9.6 Younger's Tartan Special Ale 2T 1 3389 3.00
** Subtotal **
3.00

** Size: 12.0
12.0 Acme Beer 2FO 3 60-7 12.00
12.0 Acme Beer 2R 1 60-9 1.25
12.0 Acme The Light Dry Beer 2F 2 60-8 6.00
12.0 Billy Beer 2TA 1 63-2 1.00
12.0 Buffalo Brand Beer 1FOX 2- 10 52-18 384 100.00
12.0 Dixie 45 Beer 2F 2 73-3 50.00
12.0 Dixie Beer 2TA 1 73-4 1.00
12.0 Dixie Lager 2T 1 73-5 1.00
12.0 Dixie Light Light Light Beer 2T 1 73-6 1.00
12.0 Fort Pitt Beer 1K 1- 28-8 125.00
12.0 Harvard Ale 1FOX 3- 90 79-35 1267 15.00
12.0 Lion Beer 1FX 1- 40 89-39 1634 150.00
12.0 Lone Star Beer 2R 3 310 90-9 1653 1.50
12.0 National Bohemian 2A 1+ 1140 91-21 1.00
12.0 Regal Light Lager Beer 1CH 3 40 33-05 591 25.00
12.0 Schlitz Beer 2T 1 140 115-11 2573 1.00
12.0 Tru-Blu Ten Star Ale 1CJX 3+ 28-9 300.00
** Subtotal **
791.75

** Size: 14.0
14.0 Schlitz Beer 2T 1 150 129-12 1.00
** Subtotal **
1.00





-26-

Page No. 2
02/17/88

Beer Cans Inventory System

Report 6 - List Cans by Size, Brand and Type



Size Brand Type Gr BCCA BCU Bible Class Value
---- ----- ---- -- ---- --- ----- ----- -----


** Size: 16.0
16.0 Pabst Blue Ribbon Beer 2F 2 3000 145-29 4.00
16.0 Schlitz Beer 2T 1 160 148-27 1.00
** Subtotal **
5.00

** Size: 32.0
32.0 Croft Cream Ale 1FOX 2+ 33-1 225.00
32.0 Erlanger's Pilsner Beer 1CX 3+ 20 53-06 90.00
32.0 Scheidt's Rams Head Ale 1CX 2- 32-2 200.00
** Subtotal **
515.00

*** Total ***
1323.75
























-27-

Page No. 1
02/17/88

Beer Cans Inventory System

Report 7 - List Cans by US/Foreign, Brand and Size



US/F Brand Size Type Gr BCCA BCU Bible Class
---- ----- ---- ---- -- ---- --- ----- -----


** US or Foreign: F
F Younger's Tartan Special Ale 9.6 2T 1 3389

** US or Foreign: U
U Acme Beer 12.0 2FO 3 60-7
U Acme Beer 12.0 2R 1 60-9
U Acme The Light Dry Beer 12.0 2F 2 60-8
U Billy Beer 12.0 2TA 1 63-2
U Buffalo Brand Beer 12.0 1FOX 2- 10 52-18 384
U Colt 45 Malt Liquor 8.0 2T 2 80 54-15
U Croft Cream Ale 32.0 1FOX 2+ 33-1
U Dixie 45 Beer 12.0 2F 2 73-3
U Dixie Beer 12.0 2TA 1 73-4
U Dixie Lager 12.0 2T 1 73-5
U Dixie Light Light Light Beer 12.0 2T 1 73-6
U Erlanger's Pilsner Beer 32.0 1CX 3+ 20 53-06
U Fort Pitt Beer 12.0 1K 1- 28-8
U Harvard Ale 12.0 1FOX 3- 90 79-35 1267
U Lion Beer 12.0 1FX 1- 40 89-39 1634
U Lone Star Beer 12.0 2R 3 310 90-9 1653
U National Bohemian 12.0 2A 1+ 1140 91-21
U Pabst Blue Ribbon Beer 16.0 2F 2 3000 145-29
U Regal Light Lager Beer 12.0 1CH 3 40 33-05 591
U Scheidt's Rams Head Ale 32.0 1CX 2- 32-2
U Schlitz Beer 12.0 2T 1 140 115-11 2573
U Schlitz Beer 14.0 2T 1 150 129-12
U Schlitz Beer 16.0 2T 1 160 148-27
U Tru-Blu Ten Star Ale 12.0 1CJX 3+ 28-9











-28-

6. Backup Procedures.
-----------------

a. Data Base Backup.
----------------

When Backup File Menu choice "1" (Backup Data Base and Indexes)
is selected, you will be prompted to insert a floppy diskette
into the B: drive (NOTE: if you don't have a B: drive, don't
worry, your A: drive will work also). You should format two
floppy diskettes for use in this backup operation. Label one as
"Backup Diskette for CANS.DBF and INDEXES #1" and the other as
"Backup Diskette for CANS.DBF and INDEXES #2". They should be
used on an alternating basis (use #1 the first time; use #2 the
second time; use #1 the third time, etc.) for backing up the data
base. After the backup is completed, enter the date and # of the
diskette which was used into the CANS.DBF Backup Log which should
look something like this:


CANS.DBF Backup Log
-------------------


Date of Backup Disk #
-------------- ------

2/11/88 1
2/12/88 2
2/13/88 1
etc.


b. dBASE III Plus Program Backup.
-----------------------------

When Backup File Menu choice "2" (Backup dBASE III Plus Programs)
is selected, you will be prompted to insert a floppy diskette
into the B: drive (NOTE: again, if you don't have a B: drive,
don't worry, your A: drive will work also). You should format
two floppy diskettes for use in this backup operation. Label one
as "Backup Diskette for dBASE III Plus Programs #1" and the other
as "Backup Diskette for dBASE III Plus Programs #2". They should
be used on an alternating basis (use #1 the first time; use # 2
the second time; use # 1 the third time, etc.) for backing up the
dBASE III programs. After the backup is completed, enter the date
and # of the diskette which was used into the dBASE III Plus
programs Backup Log similar to the one shown below. Backups of
the dBASE III Plus programs are normally done only when one or more
of the programs have been updated by the programmer. However,


-29-

regardless of whether they been changed or not, it makes good
sense to keep a backup copy for contingency purposes.


dBASE III Plus Programs Backup Log
----------------------------------


Date of Backup Disk #
-------------- ------

2/11/88 1
2/12/88 2
2/13/88 1
etc.


c. Backup All of the Above.
-----------------------

When Backup File Menu choice "3" is selected, the data base,
indexes, and dBASE III Plus programs are all backed up in one
continuous process as specified in paragraphs 6.a. and 6.b.
above.


7. Comments.
--------

a. The Beer Cans Inventory System was designed to be "user
friendly" and hopefully it is. Enhancements to the system may be
developed as I begin to get some feedback from users. Any
suggestions for improvement will be appreciated.

b. The screen colors I used may not be pleasing to all
users. No matter how hard you try, you can't please everyone!
The colors can be changed, but since the color commands (SET
COLOR TO) are embedded in each individual program, each program
would have to be revised to make any color changes or to make the
system run in "black and white".

c. The "lite bar" menus run a little slow on PC and PC/XT
class machines (4.77 MHZ). You really need the speed of an PC/AT
or Turbo XT (8 MHZ and higher) to make it tolerable for use.
However, you still have the option of just pressing the number of
your choice (which is more efficient anyway!).





-30-

d. Please report any problems in using the system, or the
user guide, and any suggestions for improvement to me by mail at
the address shown on the front cover of this guide.


Happy collecting,

Eric L. Poole












































-31-