home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
DP Tool Club 26
/
CD_ASCQ_26_1295.iso
/
vrac
/
ez_db015.zip
/
TUTORIAL.DOC
< prev
Wrap
Text File
|
1995-09-13
|
6KB
|
140 lines
EZ-DB v1.5
Petrie Software Co.
is an ASP approved Publisher
- I -
Tutorial
Using CREATE ................................. 1
Using EZ-DB .................................. 2
EZ-DB / CREATE (C) Copyright Petrie Software 1994,95
- 1 -
TUTORIAL
This is a simple step by step procedure to help you get started with this
software. EZ-DB and CREATE are very simple to use programs made for
people with little or no experience using or creating databases. If you
have some experience with using this type of software you may want to
skip over this tutorial and read over the more in-depth information
located in the manual. This section is not explained very much just step
by step instructions to get you started. Everything is fully explained
later.
Following is a short 20 minute tutorial that will take you step by step
through the process of building a database. This tutorial is very short
and to the point. Every procedure is explained in detail in the manaual.
The commands in UPPER CASE and double quotes (example: "DIR") are to be
executed without the double quotes or in upper case. Double quotes and
upper case are just used for clarity! Also if you press return by
mistake or want to go back to a field just use the arrow keys.
use CREATE to define a structure
STEP
#
1. Copy the EZ-DB & CREATE files to a directory using install or
manually copy them using dos commands.
2. Enter the directory that houses EZ-DB & CREATE files.
3. Type "CREATE" at the dos prompt and press enter.
4. Enter the name of the database you want to create. If you do not
have a name yet type "TFILE", short for test file, and press return.
5. Type y or n, I type "Y" return is not necessary.
6. Enter a field name like "SALESMAN" and press return.
7. Press return because the name of the salesman are characters.
8. Enter "25" and press return, this is how long the field will be.
9. You have just moved down to field #2, enter "SM_NUMBER" and press the
return key. ID_NUMBER is going to give use his ID number.
10. Press the letter "N" , now this category is a numeric field.
11. Enter "5" and press return, now this category can be up to five
numbers in length.
12. Press return for I am not using decimals in their ID category.
13. Enter "SALES_AMNT" no need to press return you filled the field and
create automatically enters you into the next field.
14. Enter "N" for Numeric, no need to press return.
15. Enter "9" and press return.
16. Enter "2" and press return, This is the amount he has made in sales.
Being an amount a decimal is used to point out cents
17. Enter "THE_DATE" and press return.
18. Press "D" you will see that the field type filled in with date and
the field length filled in with an eight. It also sent you to a
a new field number.
EZ-DB / CREATE (C) Copyright Petrie Software 1994,95
- 2 -
Tutorial Cont.
19. Enter "CUS_SATISF" meaning Customer Satisfaction, no need to press
the return key.
20. Enter "L" notice that it filled in the fields like the date did and
sent you to another field.
21. Press the "F1 key" and then the "ENTER" key. This will send you out
to your dos prompt.
Now lets run EZ-DB with the new database file we just created!
22. From the dos prompt type "EZ-DB TFILE" and press return. You will
get an error a the lower left hand side of the screen. Disregard
this for it is just telling you that the database is empty.
23. Press the "F1 key" this will pull down a menu with add new record
highlighted, press return to add a new record.
24. Enter the salesman name "DANIEL PETRIE", or your name, this is case
sensitive you should capitalize proper names etc....
25. Enter his ID number "01234" and press return
26. Enter "1234.22" and press enter. He made $1,234.22 on this sale.
27. Enter "081295" and press return. There is no need to move the cursor
over the / mark EZ-DB will enter the field properly for you.
28. Enter y or n I am entering "Y" and press return.
29. Press "F1 key" to save your entry
30. DO NOT be alarmed if you do not see anything press the "F1 key" again
and use the right arrow key and highlight All Records under the select
menu, and press return. There is the data you just entered, try steps 23
through 29 a few times and then perform step 30 to see everything you
have entered.
Now that you have this exercise working, exit out of the main menu by
pressing F10 and start at step 1 and create a database that you will use.
Remember that you can always come back to this database that you created
and experiment with it.
EZ-DB / CREATE (C) Copyright Petrie Software 1994,95