1 0 2 yf 0 0 Welcome to d BBB A SSS EEE IIIIIIIIIIII d B B A A S E II II II ddd BBB A A SS EE II II II d d B B AAAAA S E II II II d d B B A A S E II II II ddd BBB A A SSS EEE IIIIIIIIIIII ; 2 11 5 yf 2 0 ~L dBASE III The dBASE III relational database management system is designed to be the industry standard for office personal computers. ; 1 0 1 yf 0 0 dBASE III is for EVERYONE - The Novice User ; 2 4 5 yf 0 0 ~L dBASE III The dBASE III Assistant guides you through basic dBASE III operations. ; 1 0 1 nf 5 0 - The Experienced User ; 2 4 5 yf 0 0 ~L dBASE III You can operate dBASE III with powerful direct commands. ; 1 0 1 nf 7 0 - The Application Developer ; 2 11 5 yf 2 0 ~L dBASE III Improved dBASE programming language lets you automate repetitive processes and customize your system ; 1 0 1 yf 0 0 dBASE III Packs a Lot of Power - Advanced File Handling ; 2 11 5 yf 2 0 ~L dBASE III Up to 10 data files can be open at once. You can build a database from an unlimited number of files ; 1 0 1 nf 5 0 - Mailing Label Generator ; 2 11 5 yf 2 0 ~L dBASE III You can easily create mailing labels using this built-in utility. ; 1 0 1 nf 7 0 - Large Capacity ; 2 11 5 yf 2 0 ~L dBASE III You can have as many as 128 fields in a single record. A file may have up to a million records. ; 1 0 1 nf 9 0 - New Data Types ; 2 11 5 yf 1 0 ~L dBASE III Dates are stored in the standard format of month, day, year. You can perform date arithmetic and chronological ordering on the DATE field. ; 2 11 5 yf 2 0 ~L dBASE III The MEMO field can hold up to 4,000 characters, enough for two typewritten pages. A built-in word processor helps you enter text. ; 1 0 1 nf 11 0 - Flexible Indexing ; 2 11 5 yf 1 0 ~L dBASE III dBASE III will maintain up to seven active indexes for each file, automatically updating them to reflect changes you make to the records. ; 2 11 5 yf 0 0 ~L dBASE III To demonstrate the power and ease of using dBASE III, take the example of a stockbroker. You might spend your day juggling lists of clients, prospects, marketing reports, and potential investments. ; 2 11 5 yf 2 0 ~L dBASE III You might need to evaluate investments, generate internal reports, and send out mailings to prospects. ; 2 4 5 yf 0 0 ~L dBASE III After you have determined your information needs, you are ready to load dBASE III. ; 1 0 5 yf 0 0 ........................................................................... : : : The dBASE III : : Assistant : : : : Assist uses menus to bring you the power of dBASE III : : : :.........................................................................: : KEY FUNCTION : :.........................................................................: : ESC Exit from current operation. : : Up Arrow Move to previous menu. : : Down Arrow Move to next menu. : : Left Arrow Move one item to the left. : : Right Arrow Move one item to the right. : : Control-A Go to the first menu. : : Control-F Go to the right-most item. : : Option Letter Executes option (Option letter is the : : first letter of the option word). : :.........................................................................: : : : Press Down -> or RETURN to continue, ESC to exit ASSIST: : : : :.........................................................................: ~K APPEND EDIT LIST DIR DISPLAY DISPLAY DISPLAY DISPLAY STRUCTUR STATUS MEMORY ; 2 11 5 yf 2 0 ~L dBASE III The dBASE III Assistant is the new user interface to guide you with a step - by - step command generator that... ; 2 11 5 yf 2 0 ~L dBASE III * Defines dBASE III funtions * Automates command syntax * Prompts for correct responses ; 1 0 5 yf 0 0 Set Up Environment Use ~ICreate~F Label Creation Report Creation ........................................................................... : Create a database. : :.........................................................................: ........................................................................... : ~ICREATE~F : : : : CREATE is used to produce a new database file. It lets you define the : : structure of database records and optionally, start entering information: : : : Command Format: ~ICREATE ~F : : [FROM ] : : : :.........................................................................: ~ICommand: CREATE ~F File in use: Prev. Menu: Up -> Left/Right: <-/-> Next: Dn -> (or RETURN) Help: HELPKEY ~K APPEND EDIT LIST DIR DISPLAY DISPLAY DISPLAY DISPLAY STRUCTUR STATUS MEMORY ; 2 11 5 yf 1 0 ~L dBASE III Right away, dBASE III is ready to help you create your first file. You don't have to spend hours poring over a user manual. ; 1 0 5 yf 0 0 Bytes remaining: 3926 Fields defined: 8 ...................................................................... : CURSOR: <-- --> : INSERT : DELETE : Up a field: ^E : : Char: <- -> : Char: ^V : Char: ^G : Down a field:^X : : Word: ^A ^F : Field: ^N : Word: ^Y : Exit/Save: ^W : : Pan: ^Z ^B : : Record: ^U : Abort: Esc : :..................:.............:...............:...................: Field Name Type Width Dec Field Name Type Width Dec ------------------------------ ----------------------------- 1 LAST_NAME Char/text 13 2 FIRST_NAME Char/text 7 3 BUY_DATE Date 8 4 AMOUNT Numeric 5 2 5 PHONE Char/text 17 6 INTERESTS Memo 10 7 YTD_BUYS Numeric 8 2 8 ~ICOMMISSION Numeric I6 2 ~F Widths are 1 to 254 for CHARACTER fields and 1 to 19 for NUMERIC fields. ~K APPEND EDIT LIST DIR DISPLAY DISPLAY DISPLAY DISPLAY STRUCTUR STATUS MEMORY ; 2 11 5 yf 1 0 ~L dBASE III The dBASE III Assistant leads you through each field, prompting for name, type, width, and decimal places. ; 1 0 5 yf 0 0 Bytes remaining: 3926 Fields defined: 9 ...................................................................... : CURSOR: <-- --> : INSERT : DELETE : Up a field: ^E : : Char: <- -> : Char: ^V : Char: ^G : Down a field:^X : : Word: ^A ^F : Field: ^N : Word: ^Y : Exit/Save: ^W : : Pan: ^Z ^B : : Record: ^U : Abort: Esc : :..................:.............:...............:...................: Field Name Type Width Dec Field Name Type Width Dec ------------------------------ ----------------------------- 1 LAST_NAME Char/text 13 9 ~IRISK_LEVEL Numeric 20~F 2 FIRST_NAME Char/text 7 3 BUY_DATE Date 8 4 AMOUNT Numeric 5 2 5 PHONE Char/text 17 6 INTERESTS Memo 10 7 YTD_BUYS Numeric 8 2 8 COMMISSION Numeric 6 2 Widths are 1 to 254 for CHARACTER fields and 1 to 19 for NUMERIC fields. ~K APPEND EDIT LIST DIR DISPLAY DISPLAY DISPLAY DISPLAY STRUCTUR STATUS MEMORY ; 2 11 5 yf 1 0 ~L dBASE III It is easy to add fields after you have completed the structure. You decide to add a risk factor, so you'll know who's a gambler and who wanted only blue chip investments. ; 2 4 5 yf 0 0 ~L dBASE III Now that you have created the data structure, you're ready to add the client information. ; 1 0 5 yf 0 0 Record No. 1 ...................................................................... : CURSOR: <-- --> : UP DOWN : DELETE : Insert Mode: ^V : : Char: <- -> : Field: ^E ^X : Char: ^G : Exit: ^W : : Word: ^A ^F : Page: ^R ^C : Word: ^Y : Abort: Esc : : : : Record: ^U : Memo: ^] : :..................:................:.............:..................: LAST_NAME ~IROBERTSON ~F FIRST_NAME ~IGENE ~F BUY_DATE ~I05/12/84~F AMOUNT ~I78.00~F PHONE ~I213-555-2345-x567~F INTERESTS ~Imemo~F YTD_BUYS ~I98450.00~F COMMISSION ~I984.50~F RISK_LEVEL ~I8~F ~K APPEND EDIT LIST DIR DISPLAY DISPLAY DISPLAY DISPLAY STRUCTUR STATUS MEMORY ; 2 11 5 yf 0 0 ~L dBASE III The full screen display of each record makes it easy to enter data. After you complete the last field, the record is automatically stored. A new screen display is brought up so you can enter the next record. ; 2 11 5 yf 2 0 ~L dBASE III After entering data, you might find a few typos. They are easy to fix, through the dBASE III edit mode. ; 1 0 5 yf 0 0 Record No. 7 ...................................................................... : CURSOR: <-- --> : UP DOWN : DELETE : Insert Mode: ^V : : Char: <- -> : Field: ^E ^X : Char: ^G : Exit: ^W : : Word: ^A ^F : Page: ^R ^C : Word: ^Y : Abort: Esc : : : : Record: ^U : Memo: ^] : :..................:................:.............:..................: LAST_NAME ~IHARRISON ~F FIRST_NAME ~IROBERQ~F BUY_DATE ~I07/22/84~F AMOUNT ~I73.00~F PHONE ~I312-555-9876-x432~F INTERESTS ~Imemo~F YTD_BUYS ~I23666.00~F COMMISSION ~I236.66~F RISK_LEVEL ~I2~F ~K APPEND EDIT LIST DIR DISPLAY DISPLAY DISPLAY DISPLAY STRUCTUR STATUS MEMORY ; 2 11 5 yf 1 0 ~L dBASE III Full screen display also helps you edit existing data. You simply place the cursor over the letter and correct the spelling so ROBERQ becomes ROBERT. ; 2 3 5 yf 2 0 ~D 1 ~L dBASE III dBASE III allows you to see records which meet a certain criteria. ; 1 0 5 yf 0 0 Retrieve and Present Information Display Sum Average Count Label Report Position .............................................................................. : Display selected data in current database. : :............................................................................: .............................................................................. : DISPLAY : : DISPLAY shows requested information from the active database file. You : : can specify which records should be shown and what information within the : : records to include. : : : : Command Format: DISPLAY [] [] : : [FOR / WHILE ] [OFF] [TO PRINT] : : : :............................................................................: Command:~IDISPLAY ALL FOR YTD_BUYS > 36000 .AND. RISK_LEVEL > 7~F File in use: Clients.dbf Current record #: 1 Size (records) 462 Prev, Menu: Up -> Left/Right: <-/-> Next: Dn -> (or RETURN) Help: HELPKEY ~K APPEND EDIT LIST DIR DISPLAY DISPLAY DISPLAY DISPLAY STRUCTUR STATUS MEMORY ; 2 14 5 yf 2 0 ~L dBASE III You might ask, "Which clients bought more than $36,000 in the year to date, and have a risk level above 7 ?" ; 2 13 5 yf 1 0 ~L dBASE III This is easier than searching through printed reports. ; 2 14 5 yf 1 0 ~L dBASE III There is little need to sort your records since dBASE III's indexing function saves memory and works faster than physically storing all your records. dBASE III can maintain up to seven active indexes for each file, and automatically update them when you update records. ; 1 0 5 yf 0 0 Organize Database Index Sort Copy Pack .......................................................................... : Enter key expression: ~IGROWTH~F : .......................................................................... Field Name Field Type Width Dec. # NAME Character 10 PRICE Numeric 5 2 GROWTH Numeric 3 0 EARNINGS Numeric 10 2 TYPE Character Command:~IINDEX~F File in use: Stocks.dbf Current record #: 2 Size (records): 452 ~K APPEND EDIT LIST DIR DISPLAY DISPLAY DISPLAY DISPLAY STRUCTUR STATUS MEMORY ; 2 11 5 yf 1 0 ~L dBASE III The dBASE III Assistant makes it easy to construct indexes by displaying the field structure on the screen. You can index your stocks by industry, growth rates, price/earnings ratio, and so on. This makes for faster retrieval. ; 1 0 5 yf 0 0 Append Browse Edit Delete Recall Replace Position ............................................................................ :Select field names. Position using Up/Down ARROW KEYS. Select using RETURN: :..........................................................................: Field Name Field Type Width Dec. # LAST_NAME Character 13 FIRST _NAME Character 7 BUY_DATE Date 8 AMOUNT Numeric 5 2 PHONE Character 17 INTERESTS Memo 10 YTD_BUYS Numeric 8 2 COMMISSION Numeric 6 2 Command:~IREPLACE ALL COMMISSION WITH COMMISSION * 1.1~F File in use: CLIENTS.dbf Current record #: 6 Size (records): 452 ~K APPEND EDIT LIST DIR DISPLAY DISPLAY DISPLAY DISPLAY STRUCTUR STATUS MEMORY ; 2 14 5 yf 1 0 ~L dBASE III dBASE III can automatically modify files. If your commission increases,by 10%, you can automatically update all records at once. ; 2 14 5 yf 1 0 ~L dBASE III As your business grows, many prospects will become clients. dBASE III makes it easy to move the appropriate records from the prospect file to the client file. ; 2 3 5 yf 1 0 ~D 1 ~L dBASE III dBASE III's report generator allows you to structure and format reports in many ways. You can even write a brief routine to automate frequently used reports. ; 1 0 5 yf 0 0 ........................................................................... : CURSOR: <-- --> : UP DOWN : DELETE : Insert Mode: ^V : : Char: <- -> : Field: ^E ^X : Char: ^G : Exit: ^W : : Word: ^A ^F : Page: ^R ^C : Field: ^Y : Abort: Esc : : Pan: ^Z ^B : : Column: ^U : Jump: ^] : :.........................................................................: Group/subtotal on: ~IOIL_SECURITIES ~F ~I ~F ~I ~F Summary report only? (Y/N) ~IN~F Eject after each group/subtotal? (Y/N)~IN~F Group/subtotal heading: ~IOIL PERFORMANCE TOTALS ~F Subgroup/sub-subtotal on: ~IHIGH_GROWTH_OIL_SECURITIES ~F ~I ~F ~I ~F Subgroup/subtotal heading: ~IHIGH GROWTH OIL PERFORMANCE TOTALS ~F ~K APPEND EDIT LIST DIR DISPLAY DISPLAY DISPLAY DISPLAY STRUCTUR STATUS MEMORY ; 2 11 5 yf 0 0 ~L dBASE III The report generator can save you time in calculating subtotals and totals. It can figure your average commission, add up the total hours you devote to each type of stock, and count the numbers of customers you have in each industrial area. ; 1 0 5 yf 0 0 ........................................................................... : CURSOR: <-- --> : UP DOWN : DELETE : Insert Mode: ^V : : Char: <- -> : Field: ^E ^X : Char: ^G : Exit: ^W : : Word: ^A ^F : Page: ^R ^C : Field: ^Y : Abort: Esc : : Pan: ^Z ^B : : Column: ^U : Jump: ^] : :.........................................................................: 1 ~IFIRST_NAME, LAST_NAME ~F 2 ~I ~F Label 3 ~ISTREET_ADDRESS ~F contents: 4 ~I ~F 5 ~ICITY, STATE, ZIP ~F ~K APPEND EDIT LIST DIR DISPLAY DISPLAY DISPLAY DISPLAY STRUCTUR STATUS MEMORY ; 2 11 5 yf 0 0 ~L dBASE III The dBASE III Mailing Label Generator can automatically prepare labels for your mailings. Using data already stored in your files, you can generate labels for a advisory letter to clients. ; 1 0 5 yf 6 0 d BBB A SSS EEE IIIIIIIIIIII d B B A A S E II II II ddd BBB A A SS EE II II II d d B B AAAAA S E II II II d d B B A A S E II II II ddd BBB A A SSS EEE IIIIIIIIIIII ; 2 4 5 yf 0 0 ~L dBASE III As your business needs grow, dBASE III will also grow.