APPENDIX C: SAMPLE APPLICATIONS



          CHECK REGISTER

               The  Check  Register  involves  three  databases,  the  most
          important of which  is  CHECKREG,  which  stores  the  individual
          checks.


          Database: CHECKREG

          Field Name    Type    Length    Input Restriction
          ----------    ----    ------    -----------------
          CHECK_NO      Char       4      Mask: @!
            * the check number or code
          DATE_PAID     Date       8      none
            * the date the check was paid
          PAYEE_NAME    Char      25      List: PAYEES->PAYEE_NAME
            * the payee (links to PAYEES database)
          AMOUNT_PD     Num       10      Mask: ###,###.##
            * the amount of the payment
          CLEARED       Log        1      Mask: Y
            * whether or not the check has cleared
          EXP_TYPE      Char      15      List: TYPES->EXP_TYPE
            * the expense category


          Database: PAYEES

          Field Name    Type    Length    Input Restriction
          ----------    ----    ------    -----------------
          PAYEE_NAME    Char      25      none
            * the party to whom checks are written
          TAX_ID        Char      11      Mask: @!
            * the payee's federal tax identification number


          Database: TYPES

          Field Name    Type    Length    Input Restriction
          ----------    ----    ------    -----------------
          EXP_TYPE      Char      15      none
            * the expense category









                                        -C1-






          Reports Associated with the Check Register (continued)

          Report Spec   Description
          -----------   -----------
          OUTSTAND      A list of checks which haven't cleared
          PAID_TO1      Checks listed by PAYEE_NAME
          PAID_TO2      Summary of amounts paid to each payee
          CK_TYPE1      Checks listed by EXP_TYPE
          CK_TYPE2      Summary of amounts paid for each expense
                          category


          APPOINTMENT CALENDAR

               The appointment calendar involves two databases, CALENDAR
          and LISTS.  LISTS is used only as an input restriction list.

          Database: CALENDAR

          Field Name    Type    Length    Input Restriction
          ----------    ----    ------    -----------------
          DATE          Date       8      none
            * the date of the event for this record
          TIME          Char       5      Mask: ##:##
            * the time of the event
          AM_PM         Char       1      Mask: !
            * whether the time is a.m. or p.m.
          EVENT         Char      30      none
            * a brief description of the event
          LOCATION      Char      30      none
            * the location for the event
          EVENT_TYPE    Char       8      List: LISTS->EVENT_TYPE
            * the event category (e.g., business, personal, etc.)


          Database: LISTS

          Field Name    Type    Length    Input Restriction
          ----------    ----    ------    -----------------
          EVENT_TYPE    Char       8      none
            * category of events (used by CALENDAR)
          RELATNSHIP    Char       8      none
            * category of relationship (used by ROLODEX)


          Reports Associated with the Appointment Calendar

          Report Spec   Description
          -----------   -----------
          DAILY         A daily event calendar
          MONTHLY       A monthly calendar of upcoming events



                                        -C2-






          ROLODEX

               The Rolodex, or personal telephone/address files, involves
          two files, ROLODEX and LISTS.  LISTS is also used by CALENDAR.


          Database: ROLODEX

          Field Name    Type    Length    Input Restriction
          ----------    ----    ------    -----------------
          FIRST_NAME    Char      15      none
            * the individual's first and middle names
          LAST_NAME     Char      15      none
            * the individual's last name
          COMPANY       Char      20      none
            * the individual's employer, if applicable
          ADDRESS       Char      25      none
            * the street address
          CITY          Char      15      none
            * the city
          STATE         Char       2      Mask: @!
            * the state, as a two-letter code
          ZIP_CODE      Char       5      Mask: #####
            * the basic five-digit zip code
          ZIP_PLUS4     Char       4      Mask: ####
            * the additional 4 digits of the zip code
          HOME_PHONE    Char      12      Mask: ###/###-####
            * the individual's home phone number
          WORK_PHONE    Char      12      Mask: ###/###-####
            * the individual's work phone number
          RELATNSHIP    Char       8      List: LISTS->RELATNSHIP
            * relationship to the individual (i.e., personal, etc.)


          Database: LISTS

          Field Name    Type    Length    Input Restriction
          ----------    ----    ------    -----------------
          RELATNSHIP    Char       8      none
            * category of relationship (used by ROLODEX)
          EVENT_TYPE    Char       8      none
            * category of events (used by CALENDAR)


          Reports Associated with the Rolodex

          Report Spec   Description
          -----------   -----------
          DIRECTRY      An alphabetized telephone directory
          MLABELS       Mailing labels for people on your ROLODEX




                                        -C3-