                                        oration                                                                                                                                                         ng C                                                                                                                                                                                                                                                                                                                                                                                 TM                                                                                                                                                                                                                                                                                                                       B E G I N N E R ' S   G U I D E   D I S K E T T E   2                                                                                                                                                                       Lesson 7  --  Creating Reports   Lesson 9  --  Defining Files and AttributesPress 7 or 9 to view the corresponding lesson.               Press R to display the Review Frame for lessons 7 and 9.Press X to exit to the operating system.                                           One of the most versatile features of Cornerstone is the ability to use View mode to create reports. In this lesson, you'll see how to develop a Cornerstone report including headers, formatted record display, totals, and subtotals.                                                                       Beginner's Guide Diskette 2 Review Frame  ͻ                                                                                                                                                                                                       Lesson 7  --  Creating Reports                                                                                                Lesson 9  --  Defining Files and Attributes                                                                                                                                          Press 7 or 9 to review the corresponding lesson.                                                                              Press X to exit to the operating system.                                                                                    ͼ                                                                                                                                                                                                                                                                                   Ŀ                                       7    Lesson 7                                                                                        Ŀ                                                          9    Lesson 9                                                                                    Ŀ   B e g i n n e r ' s   G u i d e                 R    Diskette 2                                               Review Frame                                          Ŀ         D i s k e t t e   2               X    Exit to                                                       Operating System                                                      M E N U                                                                                                       Press 7, 9, R, or X                                                  ͻ                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             ͼ                                                                                                                                                                                                                                                                                                                                                                                                                   Ŀ                                                                                                                                                                                                                                                                                                                                                                                   L e s s o n   7                                                                                                                                                                               C r e a t i n g   R e p o r t s                                                                                                                                                                                                                                                                                                                                                                                                                                                                     Press <SPACE> to Continue                                                                                                                                                                                                                                                                                                                                                                                                                       Ŀ                                                                                                                                                                                                                                                                                                                                                                                   L e s s o n   9                                                                                                                                                                            D e f i n i n g   A t t r i b u t e s                                                                                                                                                                                                                                                                                                                                                                                                                                                                  Press <SPACE> to Continue                                                               So far in the Beginner's Guide, you've worked with the sample database supplied with Cornerstone.  In this lesson, you'll see how to define your own files and attributes in Cornerstone.               You've worked with the Customer file and the Order file in the sample database.  Of course, when you used the Order file, you were also using information from the Part file, such as Part Number, Description, and Price.                                                                                  Let's assume however, that the Part file is not currently part of the database and that you want todefine this file.                                                                                                                                                                  _                                                                            Select a command from the menu.  Use arrow keys or type the command.                   VIEW        DEFINE      CUSTOMIZE   DELETE      UTILITIES        NEW-RECORD  EXIT                                                          Cornerstone V1.0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     File:                      Previous mode:                   Files viewed:                                ͻ                                                                                                                                                                                                                                                                                        ͼ                                                                                              To begin, enter View mode for the Order file.Press the <ARROW-RIGHT> key to highlight VIEW.                     VIEW                                                                                    Press <SPACE> to select VIEW.                                                                        VIEW _                                                                       Which file do you want to VIEW?                                                                    CUSTOMER                LINE_ITEMS                   ORDER                   PART                                                                                                                                         Press the <ARROW-DOWN> key to highlight ORDER.                                                           ORDER                                                                                          Press <SPACE> to select ORDER.                                                                       VIEW ORDER _                                                                 Press ENTER to execute the command.  (You may press CANCEL to erase it.)                                                                                                                                                                                                                                                          Press <ENTER> to execute the command.                                                                                                                                             VIEW ORDER [ok]                                                              Entering View Mode ... Please wait.                                                                                                                                                                                                    VIEW ORDER                     34 Records                       NOT SORTED    ORDER  NAME                             DISCOUNT  TERMS   TOT-AFTER-DISC     -------------------------------------------------------------------------  >     1  Newton Auto Rentals               0.200    COD         $224.80            2  Lange's Motorworld                0.100    NET60        $36.00            3  Watertown Car center              0.300    COD          $56.00            4  Medford Motor Service             0.000    COD         $377.00            5  Roman Olds Dealers                0.050    NET30       $246.05            6  Hal's Foreign Auto Repair         0.200    NET90        $96.80            7  Hal's Foreign Auto Repair         0.200    NET60       $111.20            8  Concord Bus Line                  0.080    COD         $400.20            9  T MOtors                          0.020    NET60       $544.80           10  Hanover Service Station           0.100    NET90       $415.80           11  Bunker Hill Garage                0.050    NET90       $394.25           12  Bunker Hill Garage                0.050    NET30       $537.70           13  Cambridge Commons Cab Co.         0.150    NET90       $114.75       File: ORDER                 Previous mode: Initial          Files viewed: 1                                                                                                            _                                                                            Select a command from the menu.  Use arrow keys or type the command.                   UPDATE      SELECT      VIEW        COLUMN      DETAILED         USE         SAVE        REPORT      SORT        PRINT       ALL-DONE      VIEW ORDER                     34 Records                       NOT SORTED    ORDER  NAME                             DISCOUNT  TERMS   TOT-AFTER-DISC     -------------------------------------------------------------------------  >     1  Newton Auto Rentals               0.200    COD         $224.80            2  Lange's Motorworld                0.100    NET60        $36.00            3  Watertown Car center              0.300    COD          $56.00            4  Medford Motor Service             0.000    COD         $377.00            5  Roman Olds Dealers                0.050    NET30       $246.05            6  Hal's Foreign Auto Repair         0.200    NET90        $96.80            7  Hal's Foreign Auto Repair         0.200    NET60       $111.20            8  Concord Bus Line                  0.080    COD         $400.20            9  T MOtors                          0.020    NET60       $544.80           10  Hanover Service Station           0.100    NET90       $415.80           11  Bunker Hill Garage                0.050    NET90       $394.25           12  Bunker Hill Garage                0.050    NET30       $537.70           13  Cambridge Commons Cab Co.         0.150    NET90       $114.75       File: ORDER                 Previous mode: Initial          Files viewed: 1                              ͻ                                                                                                                                                                                                                                                                                                                                                                                       ͼ                                                             The display now shows the records in the Order file.The display includes the Order Number, Customer Name, Discount, Terms, and Total After Discount.                                                    Suppose that you want to print a report in this format, including final totals.                     The totals should include the sum of the Total AfterDiscount attribute for all orders and a count of thetotal number of orders placed by all customers.                                                 To create a report in Cornerstone, you select the REPORT choice in the View mode menu.Type R to highlight REPORT.                                                                                        R_                                                                              REPORT                                                                                                                                                                                                                     Press <SPACE> to select REPORT.                                                                      REPORT _                                                                     Which reporting operation do you want to perform?                                      SUBTOTAL    TOTAL       FORMAT      CALCULATE   HIDE             SHOW                                                                                                                                                                                                                                               _                                                                            Select a command from the menu.  Use arrow keys or type the command.                   UPDATE      SELECT      VIEW        COLUMN      DETAILED         USE         SAVE        REPORT      SORT        PRINT       ALL-DONE      VIEW ORDER                     34 Records                      SUBTOTALED *   ORDER  NAME                             DISCOUNT  TERMS   TOT-AFTER-DISC     -------------------------------------------------------------------------       31  Tosh's Service Center             0.200    NET60       $608.00        Subtotals for Tosh's Service Center                                                                                                      $1,942.40        COUNT:        2                                                                                                                                               3  Watertown Car Center              0.300    COD          $56.00        Subtotals for Watertown Car Center                                                                                                          $56.00        COUNT:        1                                                                                                                                         > ---------------------------------------------------------------------                                                                   $28,956.40      > COUNT:       34                                                             File: ORDER                 Previous mode: Initial          Files viewed: 1                              Press <LAST> (End) to move the record cursor to the last report element.                            Press the <ARROW-RIGHT> key to highlight SUBTOTAL.                                                  Now type T to highlight TOTAL.                                                                      The menu window now shows the operations Cornerstonecan perform on the attributes in the records.  Pressthe <OPTIONS> key (F5) to see them all.                                                             MINIMUM                 MAXIMUM                 FIRST                        LAST                    COUNT                   VARIANCE                     STANDARD-DEVIATION      NET-PRESENT-VALUE                                                                                                                                                                                                         One operation you want is the total number of ordersfor all customers.  You specify this with the COUNT choice.                                                                                         Type C to highlight COUNT.                                                                           REPORT TOTAL C_                                                              COUNT                                                                                                                                                                                                                                                                                                                             Press <SPACE> to select COUNT.                                                                       REPORT TOTAL COUNT _                                                      Select an AGGREGATE function or press ENTER to execute the command.                                SUM                     AVERAGE                      MINIMUM                 MAXIMUM                 FIRST ...                 VIEW ORDER                     34 Records                       NOT SORTED    ORDER  NAME                             DISCOUNT  TERMS   TOT-AFTER-DISC     --------------------------------------------------------------------------                                                                 Cornerstone allows you to add additional operations to the total using the same command line.       You also want to total the Total After Discount attribute, so press the <ARROW-RIGHT> key to highlight SUM.                                                                                                                     SUM                                                                         Press <SPACE> to select SUM.                                                                         REPORT TOTAL COUNT SUM _                                                  Select an ATTRIBUTE.                                                                               DISCOUNT                NUMBER_OF_LINES              ORDER_NO                TOTAL_AFTER_DISCOUNT    TOTAL_BEFORE_DISCOUNT ...                                                                                               Cornerstone now displays a list of attributes that can be totaled.  Notice that you can total attributes in the file even though they are not included in the display format.                           Press the <ARROW-DOWN> key followed by the <ARROW-RIGHT> key to select TOTAL_AFTER_DISCOUNT.                ORDER_NO                                                                                    Press <SPACE> to select the choice.                                                                 ORDER_NO                TOTAL_AFTER_DISCOUNT    T                                                    REPORT TOTAL COUNT SUM TOTAL_AFTER_DISCOUNT _                             Select an AGGREGATE function or press ENTER to execute the command.                                SUM                     AVERAGE                      MINIMUM                 MAXIMUM                 FIRST ...                                                                                                               You've now specified all of the information needed.Press <ENTER> to execute the command.             REPORT TOTAL COUNT SUM TOTAL_AFTER_DISCOUNT [ok]                                                                                                                                                                                                                                                                                                                                                                _                                                                            Select an ATTRIBUTE to group the subtotals by.                                                     AREA_CODE               CITY                         DISCOUNT                EXT                     NAME ...                                                                                                             Cornerstone displays a new prompt asking you to specify the attribute to group the subtotals by.    Type N to highlight NAME.                                                                            N_                                                                              NAME                                                                                                                                                                                                                       Press <SPACE> to select NAME.                                                                        NAME _                                                                       Press ENTER to execute the command.  (You may press CANCEL to erase it.)                                                                                                                                                                                                                                                          Press <ENTER> to execute the command.                                                                                                                                             The report is not appropriately sorted.  Do you want to sort it?                                   YES                     NO                                                                                            Cornerstone recognizes that the report is not in thecorrect sequence to provide the subtotals by customer name, so Cornerstone asks if you want to sort the file.                                       Press the <ARROW-RIGHT> key to highlight YES.                                                                               YES                                                                         Press <SPACE> to select YES.                                                                         YES                                                                          In what ORDER do you want to SORT?                                              ASCENDING                            DESCENDING                                                                                               Cornerstone next asks if you want the records sortedin ascending or descending sequence.  Ascending is the default choice.Press <SPACE> to select ASCENDING.                                             YES ASCENDING _                                                              Press ENTER to execute the command.  (You may press CANCEL to erase it.)                                                                                                                                                                                                                                                          Press <ENTER> to execute the command.                                                                YES ASCENDING [ok]                                                           Sorting ... Please wait.                                                                                                                                                                                                                                                                                                                                                                                        _                                                                            Select a command from the menu.  Use arrow keys or type the command.                   UPDATE      SELECT      VIEW        COLUMN      DETAILED         USE         SAVE        REPORT      SORT        PRINT       ALL-DONE      VIEW ORDER                     34 Records                      SUBTOTALED *   ORDER  NAME                             DISCOUNT  TERMS   TOT-AFTER-DISC     -------------------------------------------------------------------------  >    35  Arlington Auto Parts              0.050    NET30       $140.79        Subtotals for Arlington Auto Parts                                                                                                         $140.79        COUNT:        1                                                                                                                                              11  Bunker Hill Garage                0.050    NET90       $394.25           12  Bunker Hill Garage                0.050    NET30       $537.70           24  Bunker Hill Garage                0.050    NET30     $2,660.00           28  Bunker Hill Garage                0.050    NET90       $916.75        Subtotals for Bunker Hill Garage                                                                                                         $4,508.70        COUNT:        4                                                                                                                                          File: ORDER                 Previous mode: Initial          Files viewed: 1                                                                                                            YES ASCENDING [ok]                                                           Sorting ... Please wait.                                                                                                                                                                                                               VIEW ORDER                     34 Records                       NOT SORTED    ORDER  NAME                             DISCOUNT  TERMS   TOT-AFTER-DISC     -------------------------------------------------------------------------  >    35  Arlington Auto Parts              0.050    NET30       $140.79        Subtotals for Arlington Auto Parts                                                                                                         $140.79        COUNT:        1                                                                                                                                              11  Bunker Hill Garage                0.050    NET90       $394.25           12  Bunker Hill Garage                0.050    NET30       $537.70           24  Bunker Hill Garage                0.050    NET30     $2,660.00           28  Bunker Hill Garage                0.050    NET90       $916.75        Subtotals for Bunker Hill Garage                                                                                                         $4,508.70        COUNT:        4                                                                                                                                          File: ORDER                 Previous mode: Initial          Files viewed: 1                              ͻ                                                                                                                                                                                                   ͼ             Cornerstone now displays your report.  The first record displayedis for Arlington Auto Parts.  The records are sorted in alphabetical sequence.                                                         Press <NEXT> (Tab) to move the record cursor to the next report element.                              >     >                                                                                           This is the subtotals for the firstgroup of records.  It includes the customer Name, the subtotal for Total After Discount and the numberof orders for the customer (COUNT).                            Press <NEXT> again.                                                                                         >                                                                                           The record cursor is now on the first of the four orders from Bunker Hill Garage.                           >     >                                                                                     Following the fourth order is the subtotal record for Bunker Hill Garage.                           The last element of the report is the final totals.                                                 Next, let's add subtotals to the report.                                                            Type R to highlight REPORT.                                                                          REPORT SUBTOTAL _                                                            Select an AGGREGATE function or press ENTER to re-compute subtotals.                               SUM                     AVERAGE                      MINIMUM                 MAXIMUM                 FIRST ...                                                                                                            Press <SPACE> to select the choice.                                                                  REPORT _                                                                     Which reporting operation do you want to perform?                                      SUBTOTAL    TOTAL       FORMAT      CALCULATE   HIDE             SHOW                                                                                                                                                                  REPORT T_                                                                       TOTAL                                                                                                                                                                                                                                  SUBTOTAL                                                                                 REPORT TOTAL _                                                               Select an AGGREGATE function or press ENTER to re-compute totals.                                  SUM                     AVERAGE                      MINIMUM                 MAXIMUM                 FIRST ...                                                                                                            Press <SPACE> to select the choice.                                                                 Type C to highlight the choice COUNT.                                                               Press <SPACE> to select SUBTOTAL.                                                                    REPORT SUBTOTAL C_                                                           Select an AGGREGATE function or press ENTER to re-compute totals.               COUNT                                                                                                                                                                                                                                             Press <SPACE> to select the choice.                                                                  REPORT SUBTOTAL COUNT _                                                    Select an AGGREGATE function or press ENTER to execute the command.                                SUM                     AVERAGE                      MINIMUM                 MAXIMUM                 FIRST ...                                                                                                              Press the <ARROW-RIGHT> key to highlight SUM.                                                                               SUM                                                                         Press <SPACE> to select the choice.                                                                  REPORT SUBTOTAL COUNT SUM _                                                  Select an ATTRIBUTE.                                                                               DISCOUNT                NUMBER_OF_LINES              ORDER_NO                TOTAL_AFTER_DISCOUNT    TOTAL_BEFORE_DISCOUNT ...                                                                                            Press the <ARROW-DOWN> key followed by the <ARROW-RIGHT> key to select TOTAL_AFTER_DISCOUNT.                ORDER_NO                                                                                    ORDER_NO                TOTAL_AFTER_DISCOUNT    T                                                   Press <SPACE> to select the choice.                                                                  REPORT SUBTOTAL COUNT SUM TOTAL_AFTER_DISCOUNT _                             Select an AGGREGATE function or press ENTER to execute the command.                                SUM                     AVERAGE                      MINIMUM                 MAXIMUM                 FIRST ...                                                                                                            Press <ENTER> to execute the command.                                                                                                                                             _                                                                            Select a command from the menu.  Use arrow keys or type the command.                   UPDATE      SELECT      VIEW        COLUMN      DETAILED         USE         SAVE        REPORT      SORT        PRINT       ALL-DONE      VIEW ORDER                     34 Records                      NOT SORTED *   ORDER  NAME                             DISCOUNT  TERMS   TOT-AFTER-DISC     -------------------------------------------------------------------------       25  Lexington Auto Service            0.100    COD         $801.90           26  Hanover Service Station           0.100    COD         $216.00           27  Bunker Hill Garage                0.050    NET90       $916.75           28  Concord Bus Line                  0.080    NET30     $1,506.96           29  Roman Olds Dealers                0.050    COD       $1,339.50           30  Tosh's Service Center             0.200    NET60       $608.00           31  Tosh's Service Center             0.200    NET90         $0.00           32  Cambridge Commons Cab Co.         0.150    COD         $136.00           33  Lexington Auto Service            0.100    COD         $432.00           34  Arlington Auto Parts              0.050    NET30       $140.79      > ---------------------------------------------------------------------                                                                   $28,956.40      > COUNT:       34                                                             File: ORDER                 Previous mode: Initial          Files viewed: 1                               REPORT TOTAL COUNT SUM TOTAL_AFTER_DISCOUNT [ok]                                                                                                                                                                                                                                                                                                                                                                                                                                             REPORT TOTAL COUNT SUM TOTAL_AFTER_DISCOUNT [ok]                                                                                                                                                                                                                                                                    VIEW ORDER                     34 Records                      SUBTOTALED *   ORDER  NAME                             DISCOUNT  TERMS   TOT-AFTER-DISC     -------------------------------------------------------------------------       25  Lexington Auto Service            0.100    COD         $801.90           26  Hanover Service Station           0.100    COD         $216.00           27  Bunker Hill Garage                0.050    NET90       $916.75           28  Concord Bus Line                  0.080    NET30     $1,506.96           29  Roman Olds Dealers                0.050    COD       $1,339.50           30  Tosh's Service Center             0.200    NET60       $608.00           31  Tosh's Service Center             0.200    NET90         $0.00           32  Cambridge Commons Cab Co.         0.150    COD         $136.00           33  Lexington Auto Service            0.100    COD         $432.00           34  Arlington Auto Parts              0.050    NET30       $140.79      > ---------------------------------------------------------------------                                                                   $28,956.40      > COUNT:       34                                                             File: ORDER                 Previous mode: Initial          Files viewed: 1                              When the report is displayed, you see the final totals at the end of the report.  Omnifex currently has 34 orders for a total of $28,956.40.                                                                                                                                          _                                                                            Select a command from the menu.  Use arrow keys or type the command.                   UPDATE      SELECT      VIEW        COLUMN      DETAILED         USE         SAVE        REPORT      SORT        PRINT       ALL-DONE      VIEW ORDER                     34 Records                      NOT SORTED *   ORDER  NAME                             DISCOUNT  TERMS   TOT-AFTER-DISC     -------------------------------------------------------------------------       25  Lexington Auto Service            0.100    COD         $801.90           26  Hanover Service Station           0.100    COD         $216.00           27  Bunker Hill Garage                0.050    NET90       $916.75           28  Concord Bus Line                  0.080    NET30     $1,506.96           29  Roman Olds Dealers                0.050    COD       $1,339.50           30  Tosh's Service Center             0.200    NET60       $608.00           31  Tosh's Service Center             0.200    NET90         $0.00           32  Cambridge Commons Cab Co.         0.150    COD         $136.00           33  Lexington Auto Service            0.100    COD         $432.00           34  Arlington Auto Parts              0.050    NET30       $140.79      > ---------------------------------------------------------------------                                                                   $28,956.40      > COUNT:       34                                                             File: ORDER                 Previous mode: Initial          Files viewed: 1                              The report format is now complete with totals and subtotals.  Let's save the format for later use.  Press the <ARROW-DOWN> key followed by the <ARROW-RIGHT> key to highlight SAVE.                          USE                                                                                            USE         SAVE                                                                                    Press <SPACE> to select the choice.                                                                  SAVE _                                                                       Save the FORMAT or SELECTION CRITERIA?                                                             FORMAT                  SELECTION-CRITERIA                                                                                                                                                                                Press the <ARROW-RIGHT> key to highlight FORMAT.                                                                            FORMAT                                                                      Press <SPACE> to select the choice.                                                                  SAVE FORMAT _                                                                Enter a NAME for the format.                                                                                                                                                                                                  Cornerstone asks you to supply a name for the format.Type ORDER_REPORT and press <ENTER>.                                                                                                               ORDER_REPORT _                                                                                      The name you typed was not ORDER_REPORT.  We corrected the name for you.  Press <ENTER> to save the format.                                                                                            Cornerstone has now saved the report format so that you can recall it at any time.                    Lesson 7 Review Frame  ͻ                                                          In Lesson 7, you've seen how to add subtotals and       totals to a report and how to save a report format.     To review any of the major topics covered in the        lesson, select the appropriate topic from the list      below.                                                                                                              1) Adding Totals to a Report                            2) Adding Subtotals to a Report                         3) Saving a Report Format                               4) Lesson Summary                                                                                           Select one ( 1 to 4 )                                                                                         ͼ                                                                        ͻ                                                                        C O R N E R S T O N E                                                                                      L e s s o n   7   S u m m a r y                                                                      Ķ                                                          As you've seen in this lesson, you can format a         report in Cornerstone's View mode that includes         totals and subtotals.                                                                                           In Lesson 8, you'll learn to improve your reports       even more.  You'll learn how to customize header and    field name information and how to move fields around    on the report.                                                                                                 Please continue with Lesson 8 in the Beginner's Guide.                                                         ͼ                                                                                                                      _                                                                            Select a command from the menu.  Use arrow keys or type the command.                   VIEW        DEFINE      CUSTOMIZE   DELETE      UTILITIES        NEW-RECORD  EXIT                                                          Cornerstone V1.0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     File:                       Previous mode:                  Files viewed:                                ͻ                                                                                                                                                                                                                                                                                        ͼ                                                                                              To define a file, start in Initial mode and enter Define mode.    Press the <ARROW-RIGHT> key twice to highlight DEFINE.                                                                                            VIEW                                                                                    VIEW        DEFINE                                                                                  Press <SPACE> to select DEFINE.                                                                      DEFINE _                                                                     Press ENTER to execute the command.  (You may press CANCEL to erase it.)                                                                                                                                                                                                                                                          Press <ENTER> to execute the command.                                                                                                                                             _                                                                            Select a command from the menu.  Use arrow keys or type the command.                         DEFINE-NEW-FILE   REDEFINE-FILE     DELETE-FILE            PRINT             ALL-DONE                                                DEFINE (Top level)                                                                                                                                        CUSTOMER                The customer information file.                       ORDER                   The order file.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  File:                       Previous mode: Initial          Files viewed:                                                                                                              DEFINE [ok]                                                                                                                                                                                                                                                                                                         DEFINE (Top level)                                                                                                                                        CUSTOMER                The customer information file.                       ORDER                   The order file.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  File:                       Previous mode: Initial          Files viewed:                                ͻ                                                                                                                                                                                                                                                                                                                                                                                       ͼ                                                             As the top status line indicates, you are now in Define mode.  The status line also indicates that you are at the Top level of Define mode.                                                             Define mode differs from other Cornerstone modes in that it consists of three levels.  You are now at the Top level.  Later, you will descend to the File level to create the Part file.                The third level is the Subfile level.  You'll learn more about the Subfile level in Lesson 10.      To define the Part file, you use the DEFINE-NEW-FILEcommand.  Press the <ARROW-RIGHT> key to highlight DEFINE-NEW-FILE.                                                                                                   DEFINE-NEW-FILE                                                                   Press <SPACE> to select the choice.                                                                  DEFINE-NEW-FILE _                                                            Press ENTER to execute the command.  (You may press CANCEL to erase it.)                                                                                                                                                                                                                                                          Press <ENTER> to execute the command.                                                                                                                                             DEFINE-NEW-FILE [ok]                                                                                                                                                                                                                                                                                                EDIT   Name                                              STRING       OVS                                                                                 Name: _                                                                      Description:                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             File:                       Previous mode: Define           Files viewed:                                                                                                                                                                                           Enter values into the form.                                                                                                                                                                                                            EDIT   Name                                              STRING       OVS                                                                                 Name: _                                                                      Description:                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             File:                       Previous mode: Define           Files viewed:                                Cornerstone enters Edit mode and asks you to name the file and describe its purpose.  Type PART in thename field and press <ENTER>.                                                                                                                                                                         You didn't enter the name of the file correctly.  Would you like to try again (Y or N)?                                                                                                                Edit   Description                  Name: PART        Description: _                                You want to describe the file as succinctly and as accurately as possible.  Press <SPACE> and we'll enter a description of the Parts file.                                                              The part information file._                                                                         Press <ENTER> to complete the description.                                                                                                                                        _                                                                            Select a command from the menu.  Use arrow keys or type the command.                               DEFINE-NEW-ATTRIBUTE    REDEFINE-ATTRIBUTE           DELETE-ATTRIBUTE        DEFINE-RELATIONSHIP     REMOVE-RELATIONSHIP ...   DEFINE (File level)                    FILE: PART                            (There are no ATTRIBUTES in the current FILE.)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     File: PART                  Previous mode: Initial          Files viewed:                                Once you enter the name and description of the file,Cornerstone goes to the File level of Define mode asindicated in the top status line.  The name of the file being defined is also shown in the status line.                                                                                             You're now ready to define the attributes of the Part file.  The data area contains a message indicating that the Part file currently has no attributes.                                                You're going to define three attributes for the Partfile:  Part Number  Description  Price       To define an attribute, press the <ARROW-RIGHT> key to highlight DEFINE-NEW-ATTRIBUTE.                                      DEFINE-NEW-ATTRIBUTE                                                        Press <SPACE> to select the choice.                                                                  DEFINE-NEW-ATTRIBUTE _                                                       Use the SHORT or LONG form for defining the attribute?                          SHORT-FORM                           LONG-FORM                                                                                                                                                                                                    Cornerstone now asks whether you want to use the SHORT-FORM or the LONG-FORM for defining the attribute.  Press <SPACE> to select the SHORT-FORM which is the default choice.                           Press <SPACE> to select the choice.                                                                  A_                                                                              ALL-DONE                                                                                                                                                                                                                    DEFINE-NEW-ATTRIBUTE SHORT-FORM _                                            Press ENTER to execute the command.  (You may press CANCEL to erase it.)                                                                                                                                                      Press <ENTER> to execute the command.                                                                                                                                             DEFINE-NEW-ATTRIBUTE SHORT-FORM [ok]                                                                                                                                                                                                                                                                                EDIT   Name                                              STRING       OVS                                                                                 Name:                                                                        Description:                                                                 Type:                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       File: PART                  Previous mode: Define           Files viewed:                                                                                                                                                                                           Enter values into the form.                                                                                                                                                                                                            EDIT   Name                                              STRING       OVS                                                                                 Name: _                                                                      Description:                                                                 Type:                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       File: PART                  Previous mode: Define           Files viewed:                                PART_NUMBER_                                                                                        With the SHORT-FORM, you supply Cornerstone with three items of information about the attribute.  Yougive the attribute a name, an optional description, and identify the type of attribute.             EDIT   Description                                       STRING       OVS                                                                                 Name: PART_NUMBER                                                            Description: The part number uniquely identifies each part in the file._     Type:                                                                                      The first attribute we'll define is the Part Number.Notice that an underscore (_) connects the words in the name.  Cornerstone names cannot contain any spaces.                                         A clear description for each attribute you define will provide good documentation for your database and will make it easier to enhance the database in the future.                                      Finally, you must indicate the type of attribute youare defining.  Press <OPTIONS> (F5) to see the different types of attributes you can define.                                                         EDIT   Type                                              ENUMERATED   OVS                                                                                 Name: PART_NUMBER                                                            Description: The part number uniquely identifies each part in the file.      Type: _                                                                                    You are entering an ENUMERATED value.  Given what you've typed so far (beforethe current cursor position), the following values are allowed.  To see all  the possible values, move the cursor before any text and press OPTIONS again.    STRING                  NUMBER                  INTEGER                      DATE                    TIME                    BOOLEAN                      ENUMERATED              SUBRECORD               DERIVED                                                                                                                                                                             Type: _                                                                            You'll learn more about the different types of attributes in Lesson 10.  For now, define Part Number as a STRING attribute.                                                                             To enter the attribute type, all you have to enter is enough of the value to uniquely identify it.  Type ST and press <ENTER> to give the attribute a type of STRING.                                                                                                                                       Your response was incorrect.  You should have typed ST.  Would you like to try again (Y or N)?      STRING                                                                                                                                                                            _                                                                            Select a command from the menu.  Use arrow keys or type the command.                               DEFINE-NEW-ATTRIBUTE    REDEFINE-ATTRIBUTE           DELETE-ATTRIBUTE        DEFINE-RELATIONSHIP     REMOVE-RELATIONSHIP ...   DEFINE (File level)                    FILE: PART                                                                                                         PART_NUMBER              STRING                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       File: PART                  Previous mode: Initial          Files viewed:                                Cornerstone returns to the File level of Define modeand indicates that Part Number has been defined as aSTRING attribute.                                                                               Press <SPACE> and we'll define the second attribute,Description, for you.                           DESCRIPTION_                                                                                         EDIT   Description                                       STRING       OVS                                                                                 Name: DESCRIPTION                                                            Description: A non-technical description of the part. _                      Type:                                                                                       EDIT   Type                                              ENUMERATED   OVS                                                                                 Name: DESCRIPTION                                                            Description: A non-technical description of the part.                        Type: STRING_                                                                                                                                                            _                                                                            Select a command from the menu.  Use arrow keys or type the command.                               DEFINE-NEW-ATTRIBUTE    REDEFINE-ATTRIBUTE           DELETE-ATTRIBUTE        DEFINE-RELATIONSHIP     REMOVE-RELATIONSHIP ...   DEFINE (File level)                    FILE: PART                                                                                                         PART NUMBER              STRING                                              DESCRIPTION              STRING                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          File: PART                  Previous mode: Initial          Files viewed:                                The last attribute to define is Price.  This attribute will contain a dollar amount, so we'll want to define it with the LONG-FORM.  The LONG-FORMallows more extensive specification of an attribute.  Press the <ARROW-RIGHT> key to highlight DEFINE-NEW-ATTRIBUTE.                                      Press <SPACE> to highlight the choice.                                                              Press the <ARROW-RIGHT> key to highlight LONG-FORM.                                                 SHORT-FORM                           LONG-FORM                                                      Press <SPACE> to select the choice.                                                                  DEFINE-NEW-ATTRIBUTE LONG-FORM _                                             Press ENTER to execute the command.  (You may press CANCEL to erase it.)                                                                                                                                                      Press <ENTER> to execute the command.                                                                                                                                             DEFINE-NEW-ATTRIBUTE LONG-FORM [ok]                                                                                                                                                                                                                                                                                 EDIT   Name                                              STRING       OVS                                                                                 Name:                                                                        Description:                                                                 Type:                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       File: PART                  Previous mode: Define           Files viewed:                                You begin the LONG-FORM by supplying the same three items of information as in the SHORT-FORM.  Type PRICE for the name of this attribute and then press <ENTER>.                                                                                                                                           You did not enter the correct attribute name.  You should have typed PRICE.  Would you like to try again (Y or N)?                                                                                      EDIT   Description                                       STRING       OVS                                                                                 Name: PRICE                                                                  Description:                                                                 Type:                                                                                      Now, enter a short description of the Price attribute, perhaps something like "Unit price of thepart".  Then press <ENTER>.                                                                                                                                                                                  EDIT   Type                                              ENUMERATED   OVS                                                                                 Name: PRICE                                                                  Description:                                                                 Type: _                                                                                    Now type N and press <ENTER> to indicate that Price will be a NUMBER attribute.                                                                                                                         You must enter an N to indicate a NUMBER attribute.Please type N and press <ENTER>.                NUMBER                                                                                              Now that you've seen the definition of an attribute using the LONG-FORM, you see that you could have used the LONG-FORM earlier to define the Part Numberattribute.  You want to specify that each part number must be unique.                                                                              ͻ                                                                                                                                                                                                   ͼ             Cornerstone now displays the rest of the attribute characteristics.  Notice that most of the fields in the form have a default value.                                                                   When you complete the SHORT-FORM, the attribute takes on all of the default values you see here, unlessyou change them later with REDEFINE-ATTRIBUTE.                                                   Let's complete the definition of the Price attribute.                                               The display width should be large enough to display all of the digitsin the field including the decimal point and the dollar sign.                                                                       EDIT   Default display width        Default display width: 7 _                                     Prices will always be less than $999.99, so the default display width should be at least 7 (five digits, a decimal point, and a dollar sign).                                                                                                                                                                                                                      Enter values into the form.                                                                                                                                                                                                            EDIT   Default display width                             INTEGER      OVS                                                                                 Name: PRICE                                                                  Type: NUMBER                                                                 Default display width: 12                                                    Number of post decimal digits: 0                                             Display commas?: No                                                          Display dollar sign?: No                                                     Display negative numbers using parentheses?: No                              Display zero for numbers less than one?: Yes (e.g., 0.123)                   Use exponential notation?: When necessary                                    Minimum number value:                                                        Maximum number value:                                                        Unique values?: No                                                           Indexed: No                                                                  File: PART                  Previous mode: Define           Files viewed:         Since this is a dollar attribute, you want two digits after the decimal point.                       EDIT   Number of post decimal digit Default display width: 7   Number of post decimal digits: 2_   The values are all less than $1000,so you won't need to display commas.                              EDIT   Display dollar sign?         Display commas?: No Display dollar sign?: Yes_                 Let's display the dollar sign.                                                                       EDIT   Minimum number value         Use exponential notation?: Minimum number value: 0_             EDIT   Use Exponential notation?    Display zero for numbers less than one?: Use exponential notation?:                                                                                                 EDIT   Display zero for numbers les Display negative numbers using parentheses?: Display zero for numbers less than one?:                                                                               EDIT   Display negative numbers usi Display dollar sign?: Yes  Display negative numbers using parentheses?:                                                                                            The Price should always be a positive number, so the minimum acceptable value should be zero.        EDIT   Maximum number value         Minimum number value:                 0.00 Maximum number value: 999.99_                                                                                           No price will be greater than $999.99.Press <PAGE-FORWARD> (PgDn) to display the remaining fields.                                                                                                       EDIT   Maximum number of values     Number of post decimal digits: 2    Display commas?: No                                                          Display dollar sign?: Yes                                                    Display negative numbers using parentheses?: No                              Display zero for numbers less than one?: Yes (e.g., 0.123)                   Use exponential notation?: When necessary                                    Minimum number value:                 0.00                                   Maximum number value:               999.99                                   Maximum number of values: 1                                                  Unique values?: No                                                           Indexed?: No                                                                 Mandatory?: No                                                               Changeable?: Yes                                                             Restrict values to file:                                                     Initial value:                                                                                                                 EDIT   Display commas?              Number of post decimal digits: 2  Display commas?: No           EDIT   Unique values?               Maximum number of values: 1 Unique values?: No                  EDIT   Indexed?                     Unique values?: No          Indexed?:                           EDIT   Mandatory?  Indexed?: Mandatory?: Yes_                                                      The Price should be included for all parts.                                                          EDIT   Changeable? Mandatory?: Yes  Changeable?:                                                   No more attribute characteristics need changing, so press <DONE> (F9)to complete the definition of the attribute.                                                                                                                                                                     _                                                                            Select a command from the menu.  Use arrow keys or type the command.                               DEFINE-NEW-ATTRIBUTE    REDEFINE-ATTRIBUTE           DELETE-ATTRIBUTE        DEFINE-RELATIONSHIP     REMOVE-RELATIONSHIP ...   DEFINE (File level)                    FILE: PART                                                                                                         PART NUMBER              STRING                                              DESCRIPTION              STRING                                              PRICE                    NUMBER                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             File: PART                  Previous mode: Initial          Files viewed:                                Fortunately, Cornerstone makes it very easy to change an attribute definition.  Type R to highlightREDEFINE-ATTRIBUTE.                                                                                  You're now back to the Part level of Define mode.  The file and its attributes are now defined.  Type Ato highlight ALL-DONE.                                                                            R_                                                                              REDEFINE-ATTRIBUTE      REMOVE-RELATIONSHIP                                                                                                                                                                                Press <SPACE> to select the choice.                                                                  REDEFINE-ATTRIBUTE _                                                         Press ENTER to choose the highlighted ATTRIBUTE (or select from the menu.)                         DESCRIPTION             PART_NUMBER                  PRICE                                                                                                                                                                Press the <ARROW-RIGHT> key twice to highlight PART_NUMBER.                                                                 DESCRIPTION                                                                 DESCRIPTION             PART_NUMBER                                                                 Press <SPACE> to select the choice.                                                                  REDEFINE-ATTRIBUTE PART_NUMBER _                                             Press ENTER to execute the command.  (You may press CANCEL to erase it.)                                                                                                                                                                                                                                                          Press <ENTER> to execute the command.                                                                                                                                                                                                                          Enter values into the form.                                                                                                                                                                                                            EDIT   Name                                              STRING       OVS                                                                                 Name: PART_NUMBER                                                            Description: The part number uniquely identifies each part in the file.      Type: STRING                                                                 Default display width: 60                                                    Maximum length 255                                                           Maximum number of values: 1                                                  Unique values?: No                                                           Indexed?: No                                                                 Mandatory?: No                                                               Changeable: Yes                                                              Restrict values to file:                                                     Initial value:                                                                                                                                                                                                                         File: PART                  Previous mode: Define           Files viewed:                                                                                                              REDEFINE-ATTRIBUTE PART_NUMBER [ok]                                                                                                                                                                                                                                                                                 EDIT   Name                                              STRING       OVS                                                                                 Name: PART_NUMBER                                                            Description: The part number uniquely identifies each part in the file.      Type: STRING                                                                 Default display width: 60                                                    Maximum length 255                                                           Maximum number of values: 1                                                  Unique values?: No                                                           Indexed?: No                                                                 Mandatory?: No                                                               Changeable: Yes                                                              Restrict values to file:                                                     Initial value:                                                                                                                                                                                                                         File: PART                  Previous mode: Define           Files viewed:                                Cornerstone displays the LONG-FORM for the attribute definition.      The LONG-FORM for STRING attributeshas fewer fields than it has for NUMBER attributes.                                            EDIT   Default display widthType:Default display width: 12_                                         EDIT   Type       Description:Type:                                                                 EDIT   DescriptionName:Description:                                                                 EDIT   Maximum length       Default display width: 12 Maximum length: 12 _                          The longest Part Number will be 12 characters.                                                      EDIT   Maximum number of valuesDefault display width: 12 Maximum length: 12  Maximum number of values:                                                                                                  EDIT   Unique values           Maximum number of values:Unique values: Yes_                         Setting Unique values to Yes tells Cornerstone not to allow any duplicate Part Numbers in the file.  Lesson 9 Review Frame ͻ                                                                                                                  Lesson 9 has covered defining files and attributes      using Cornerstone.  To review any of the major          topics covered in the lesson, select the appropriate    topic from the list below.                                                                                          1) Defining a File                                      2) Adding an Attribute using the SHORT-FORM             3) Adding an Attribute using the LONG-FORM              4) Redefining an Attribute                              5) Lesson Summary                                                                                           Select one ( 1 to 5 )                                                                                         ͼ              Press <ENTER> to execute the command.                                                               EDIT   IndexedUnique values: Yes  Indexed: No_                                                      EDIT   Mandatory?   Indexed: No     Mandatory?: Yes_                                                Every record in the Part file must have a Part Number defined.                                      EDIT   Changeable?  Mandatory?: Yes Changeable:                                                     There are no more changes to make in the definition, so press <DONE>.                                ALL-DONE _                                                                   Press ENTER to execute the command.  (You may press CANCEL to erase it.)                                                                                                                                                      ͻ                                                                           C O R N E R S T O N E                                                                                          L e s s o n   9   S u m m a r y                                                                         Ķ                                                             In this lesson, you've seen how to use Cornerstone's      Define mode to define a file and its attributes.          Both the SHORT-FORM and LONG-FORM were used to            define the attributes.                                                                                              In Lesson 10, you'll use Define mode to define and        redefine attributes.                                                                                               Please continue with Lesson 10 in the Beginner's Guide.                                                           ͼ                                                                                                                                          _                                                                            Select a command from the menu.  Use arrow keys or type the command.                               DEFINE-NEW-ATTRIBUTE    REDEFINE-ATTRIBUTE           DELETE-ATTRIBUTE        DEFINE-RELATIONSHIP     REMOVE-RELATIONSHIP ...   DEFINE (File level)                    FILE: PART                                                                                                         PART NUMBER              STRING                                              DESCRIPTION              STRING                                              PRICE                    NUMBER                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             File: PART                  Previous mode: Initial          Files viewed:                                                                                                                