M M  AÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»I J  º HºI  º HºI J  º ,Welcome! You are about to be introduced to 8 CORNERSTONE, HºI J O  º <the sophisticated database system for Snon-programmers HºI J  º 6(or for programmers who don't need extra work). B HºI  º  + Hº I J  º Cornerstone is from INFOCOM '!, a leader in the micro- Hº I  º <computer software field. Infocom pioneered a new genre Hº I J  º of software, interactive ficption ,, which has been widely Hº I J  º 6acclaimed for its technical excellence and creativity. B º I J  º +Most importantly, Infocom has focused upon 7eliminating HºI J  º  *the barriers between people and computers.6 ºI J  Aº ºI  º   <With Corneerstone, Infocom has now applied the same HºI J  º   <expertise to business productivity software. HºI  ºHºI J  ºHºI J  AÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼI J M M c ÿÿÿÿÿ ?  ?  ?    This disk is not "Cornerstone. Instead, it presents?     a  simulation %of Cornerstone, demonstrating how one>   1person solved his information management problems =   -using Cornerstone. It alsot offers background 9  4information on a wide variety of Cornerstone topics. @ ? ?    %In general, you'll need to press the 1  =to?     5move to the next screen. If at any point you wish toA    0leave this demonstration, just press the Escape <A    rkey.8  ?  ?  ? ÿÿÿÿÿM M  AÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍuÍÍÍÍÍÍÍÍÍ»I  Aº ºI  º ' Choose what you'd like to see next:2 ºI  Aº ºI  5º =  HºI  º ? 1) What's a Relational Database? HºI m Aº º I  º 92) Using Cornerstone with Other Software. Hº I  Aº º I  º  3)  5Types of Cornerstone Applications. Hº I  º  8 B Hº I   º  4) 5Technical Specifications. HºI  Aº ºI  º ,5) Cornerstone Demonstration. ; ºI  º  . 8 ºI  º ? HºI  Tº ? Enter a Number, HºI  º or press Escape( to exit.6 ºI  AÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼI M M ÿÿÿÿÿ  0 r  ?    8There are many applications for databases. For example,D    6they can be used for accounting, personnel, inventory    5management, sales tracking, order entry, or property A B  !management. The list is endless. - ? ? a  9Exercise your imagination with us now, and pretend you're E  8Bob Jones, financial consultant. We'll show you how Bob D    used Cornerstone #for a typical database application,@ E    5without having to be a computer expert or programmer.A G  ?    4(This demonstration of Cornerstone takes about 20-25@    iminutes to complete.)!'  = F  ? ÿÿÿÿÿ ?  ?  ?  ?    1It used to be tnhat you could get away with having=   9information scattered all over the place - file cabinets, E  9note pads, calendars, Rolodex (TM). But as your business E  %has grown, success has had its price. 1 ? ?    5Keeping organized -- finding the information you needA   when i2you need it -- is getting more and more difficult.C  ?  ?  ?  ?  ? ÿÿÿÿÿ ?  ? n  ?    *What you need is one coherent system that:6  ? ?  * Tracks  meetings " #and & ' appointments 3 ?  * 2gKeeps a history of all client contacts, so you can E  *look back over everything you've discussed =   ?   * Replaces your current Rolodex0  ?   * -Records the hours that you're billing to each@   client/  ?   ? ÿÿÿÿÿ ?  ?  ?  ?    6And today's the day to create this system. You boughtB  !CornerstonCe and went through the -Beginner's Guide  (subtitled 10 Easy Lessons &). And they were easy. =   )Now it's time to put Cornerstone to work. 5 ? ?    !Today you plan to build your new -Client Tracking    database.3 o  ?  ?  ?  ?  ? ÿÿÿÿÿ ?  ?    2If databases arre new to you, you may want to start>     2with the first few sections. These sections offer>     1background information on databases and potential=   uses of Cornerstone. ( ?  5If you are familiar with databases (or are anxious to A  5see Cornerstone at work), you may want to go directly A p %to the simulated Cornerstone session. 1  ?    4However, feel free to go through the sections in any@    'order you choose. Pressing the Escape 3 9key willA    5give you the option of returning to the menu (review)A    (frame, where you can select any section.4  ? o  ? ÿÿÿÿÿ ?  ?  ?  ?    :It's Saturday. The sun is shining, fresh smells of springF  7are in the air. Across the road, the golf course hasr a C  /steady stream of people slicing into the woods. ;  ? < E  8You're stuck in your office where the windows don't even D    7open. Your desk is inundated with papers. Things haveC    finally gotten out of control.*  ? a  ?  ?  ?  ? ÿÿÿÿÿ  File name:   Description:ÿÿÿÿÿ DEFINE-NEW-ATTRIBUTE3 ÿÿÿÿÿM M t M Select a command from the menu. Use arrow keys or type the command.    D VIEW DEFINE CUSTOMIZE DELETE UTILITIES M NEW-RECORD EXIT ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ  Cornerstone V5.1 2ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄM M i M Copyright 1984 Infocom Inc. All rights reserved. M M Press the key (F1) for an explanation of the choices listed in the M menu and a listing of the function keys. M M o M M M M M M n M MÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄM File: Previous mode: Files viewed: ÿÿÿÿÿ* ,That's incorrect. Try again.I ÿÿÿÿÿM M Enter values into the form. M M M EDIT Attribute name STRING OVS M  Attribute name:= M Description: M Type: S ÿÿÿÿÿM DEFINE-NEW-ATTRIBUTE M Use the SHORT or LONG form for defining the attribute?   SHORT-FORM? LONG-FORM M ÿÿÿÿÿ LONG-FORMÿÿÿÿÿ ) Press the 3 >.? ÿÿÿÿÿ)#ÉÍpÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»)º , In this case 9 @remindsG º)º , you that 5DEFINE <is the commandJ º)º ,for defining your new databaseJ º)º ,(not too surprisingly).C ENowH º)º ,you're ready to start.B  º)#ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿ( SHORT-FORM + LONG-FORM4 ÿÿÿÿÿMÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄe File:  COMPANIES Previous mode: 0Define6 Files viewed: ÿÿÿÿÿ COMPANIESÿÿÿÿÿ / ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»/º 3Notice that CornerstoneJ º/º 3knows which file you'reJ º/º 3 using, and >puts it in theL º/º 3HELP messages whereverI º/º 3 appropriate.? º/ ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿ3 COMPANIESÿÿÿÿÿM EDIT Display dollar sign? c BOOLEAN OVS ÿÿÿÿÿ  It's also easy to learn!)At any point you can=    press the   key and get an explanation, in>   /plain English, of your current position and all>   the available options.%  5    Press the  !key %(F1) *when you're ready.< ÿÿÿÿÿ ) t )   The long form starts off looking9  "like the short form, and you enter;  the same basic information.4  ) ) ÿÿÿÿÿ Use scientific notation?:  Minimum number value: ÿÿÿÿÿ Attribute name:= ÿÿÿÿÿ 3ÉÍÍÍÍÍÍÍÍrÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» 3º º º The DEFINE-NEW-ATTRIBUTE ,command gives you = ºº #a choice of a short or a long form.6  ºº ,Since the SHORT-FORM is already highlighted,? ºº  all you have to do is press the 3 ;key.? º3º º3º º º u  Press the ' /key.3 º3ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿ   Description: @ ÿÿÿÿÿMÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ File:  COMPANIES Previous mode: 0Initial7 Files viewed: ÿÿÿÿÿ( DEFINE-NEW-ATTRIBUTE LONG-FORM [ok] M m M M ÿÿÿÿÿM DEFINE-NEW-ATTRIBUTE SHORT-FORM [ok] M M M M M M M M M M T M M M M M M r M M ÿÿÿÿÿ  Press the  +key./ ÿÿÿÿÿ* , Press the 6 Dkey.H ÿÿÿÿÿ* ,As you type, CornerstoneD * ,narrows the menu to onlyD * ,those commands starting withH *a ,"-D.".0 *! ÿÿÿÿÿM EDIT Display negative numbers using parent BOOLEAN OVS ÿÿÿÿÿ   D DEFINE DELETE M ÿÿÿÿÿ, Minimum number value: 0.00  Maximum number value: ÿÿÿÿÿM EDIT Maximum number value i NUMBER OVS ÿÿÿÿÿ EFINE [ok]ÿÿÿÿÿ   Description: ' ÿÿÿÿÿM M Enter values into the form. M EDIT Attribute name STRING OVS ÿÿÿÿÿ  File name:  ÿÿÿÿÿ DEFINE-NEW-ATTRIBUTE3 ÿÿÿÿÿMn (There are no ATTRIBUTES in the current FILE.) ÿÿÿÿÿM EDIT Type ENUMERATED OVS M M Attribute name: Standard_Billing_Rate M Description: This is the standard hourly billing rate for the company.  Type: G ÿÿÿÿÿMiÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ- File: Previous mode: 0Define6 Files viewed: ÿÿÿÿÿM EDIT Description STRING OVS ÿÿÿÿÿM M File name: COMPANIES   Description: @ n M M ÿÿÿÿÿ(   File name: ( Description: ÿÿÿÿÿM M M Enter values ignto the form. M M M EDIT File name STRING OVS ÿÿÿÿÿ DEFINE-NEW-FILEÿÿÿÿÿ- File: Previous mode: 0Initial7 Files viewed: ÿÿÿÿÿ( DEFINE-NEW-ATTRIBUTE LONG-FORM M  Press to execute the command. (You may press to erase it.)M ÿÿÿÿÿMYou must enter one of the following types: M M STRING for textual information, including digits you won't be M using in calculations, such as zip codes and phone M C numbers. M NUMBER for number values that have a decimal part, such as a M dollar amount. M INTEGER for whole number values, such as a count of items. M ENUMERATED for a value restricted to a pre-defined list of values M (which you specify). M DATE for a calenodar date, such as 10/9/59. M TIME for a time of day, such as 5:17 pm. M BOOLEAN for one of the values "Yes" or "No". M DERIVED to derive the value from other information (attributes) M in the COMPANIES file or a related file. M SUBRECORD to define a subfile of the COMPANIES file. (You M cannot create a subrecord withrin a subrecord.) ÿÿÿÿÿ  Display commas?: No  Display dollar sign?: No ÿÿÿÿÿ + + + + + + + + ÿÿÿÿÿ 7 p  7  7  7  7  7  7  7 ÿÿÿÿÿMYou are in Initial mode. Initial moode is the starting mode of the system. MFrom Initial mode you can enter the other modes of Cornerstone. M (For the location of the Cornerstone command keys, and a listing of the Mcontrol keys, press again.) M MVIEW lets you view the records in a file. MNEW-RECORD lets you create one or more records in rthe file. MDEFINE lets you create new files and attributes, or change existing M ones. MCUSTOMIZE lets you customize various aspects of the system. MDELETE lets you delete formats, selection criteria, and print devicesMUTILITIES lets you use the Cornerstone utilities. MEXIT lets you exit from Cornerstone. a M M ÿÿÿÿÿM EDIT Number of post-decimal digits INTEGER OVS ÿÿÿÿÿ, Maximum number value: 100.00  Maximum number of values: 1 ÿÿÿÿÿM EDIT Minimum number value NUMBER OVS ÿÿÿÿÿM EDIT Use scientific notation? t ENUMERATED OVS ÿÿÿÿÿ* Display zero for numbers less than one?:  Use scientific notation?: When necessary ÿÿÿÿÿM EDIT Maximum number of values INTEGER OVS ÿÿÿÿÿM M Attribute name: Standard_Billing_Rate M Description: This is the standard hourly billing rate for the company. M Type: NUMBER i  Default display width: 6 12 M Number of post-decimal digits: 2 M Display commas?: No M Display dollar sign?: No M Display negative numbers using parentheses?: No M Display zero for numbers less than oone?: Yes (e.g., 0.123) M Use scientific notation?: When necessary M Minimum number value: M Maximum number value: M Maximum number of values: 1 M Unique values?: No ÿÿÿÿÿ. Display negative numbers using parentheses?: n (Display zero for numbers less than one?:, Yes ÿÿÿÿÿM EDIT Default display width INTEGER OVS ÿÿÿÿÿM  Attribute name:= M Description: M Type: ÿÿÿÿÿ& That's all i t takes to define a new; & file! ; % :  Now you're ready to define the 7 9  individual attributes (items of7  information) in the , COMPANIES 6file.; ÿÿÿÿÿ  ÿÿÿÿÿ DEFINE  DELETEÿÿÿÿÿM M S M Select a command from the menu. Use arrow keys or type the command.    D DEFINE-NEW-FILE REDEFINE-FILE DELETE-FILE M PRINT ALL-DONE M DEFINE (Top level) M (There are no FILES in your database.) ÿÿÿÿÿM EDIT Display zero for numbers lessp than one BOOLEAN OVS ÿÿÿÿÿ  STRING   6for textual information, including digits you won't be N  2using in calculations, such as zip codes and phone J  numbers. 0 ÿÿÿÿÿ  Company_name@ STRING M eM ÿÿÿÿÿDEFINE  <lets you create new files and attributes, or change existingN  ones. )#ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»L ÿÿÿÿÿ STRINGÿÿÿÿÿ That's incorrect. Try again.6 ÿÿÿÿÿ. Display dollar sign?: Yes  ,Display negative numbers using parentheses?:0 ÿÿÿÿÿ4 c 4 Attribute name: Company_Name 4 Description: This is the name of the organization.  Type: . ÿÿÿÿÿM EDIT Description STRING OVS ÿÿÿÿÿMÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ File:  COMPANIES Previous mode: 0Define6 Files viewed: ÿÿÿÿÿ* ,You cant enter a command withH * ,the arrow keys, or by typingH * ,enough (in either upper orF * ,lower case) to make it clearH * ,what you want.: ÿÿÿÿÿ *! *! *  5Type ";D<".>  *! *! ÿÿÿÿÿ*! *! r * 0 Press the : Bkey.F *! *! ÿÿÿÿÿ   D VIEW DEFINE CUSTOMIZE DELETE UTILITIES    NEW-RECORD EXIT9 ÿÿÿÿÿ    =VIEW DEFINE CUSTOMIZE DELETE UTILITIES M NEW-RECORD EXIT u ÿÿÿÿÿ 5   +At the top, Cornerstone shows you a menu of<   -commands. Cornerstone is easy to use because>   /it always shows you everything you can do next.@  5  5 ÿÿÿÿÿ ?ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» º )You've decided thmat you need three files: 7 º ?º º º  * COMPANIES  (organization-level information) =  º º  * PEOPLE  (replacing your current rolodex): º º * CLIENT HISTORY "!(notes about each client contact)C º ?º º º "Here you'll define the first file.0 º ?º º ?º º ?ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿM EDIT Type ENUMERATED OVS ÿÿÿÿÿL Select a command from the menu. Use arrow keys or type the command.    C DEFINE-NEW-ATTRIBUTE REDEFINE-ATTRIBUTE L DELETE-ATTRIBUTE DEFINE-RELATTIONSHIP REMOVE-RELATIONSHIP ... ÿÿÿÿÿ " - Press the 7 ?key.C ÿÿÿÿÿ +ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»+º ºº &At certain points Cornerstone presents= ºº %you with a simple form to fill out or< ºº $edit. In this case you just enter a; ºº #name for the file and a description: ºº of what it's for.( r º+ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿ Whatever description -you 1put in7  appears in the 'HELP , messages,5   !assisting you (or anyone else) in9  using your database. . No other 9   database !provides this level of7  support.  ÿÿÿÿÿM EDIT Display commas? BOOLEAN OVS a ÿÿÿÿÿ 7ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» 7º º 7º º º +When you start Cornerstone, here's how your< º º screen appears. # º 7º º 7º º 7ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿiÿÿ " Number of post-decimal digits: 2  Display commas?:  No ÿÿÿÿÿM M Attribute name: Standard_Billing_Rate M Description: This is the standard hourly billing rate for the company. M Type: NUMBER M Default display width: 12  n Number of post-decimal digits: ". 2 M Display commas?: No M Display dollar sign?: No M Display negative numbers using parentheses?: No M Display zero for numbers less than one?: Yes (e.g., 0.123) M Use scientific notation?: When necessary M Minimum niumber value: M Maximum number value: M Maximum number of values: 1 M Unique values?: No ÿÿÿÿÿM EDIT Description STRING OVS M M Attribute name: Standarnd_Billing_Rate   Description: @ ÿÿÿÿÿM M DEFINE-NEW-ATTRIBUTE M Use the SHORT or LONG form for defining the attribute?   SHORT-FORM? LONG-FORM M g M DEFINE (File level) FILE: COMPANIES ÿÿÿÿÿ +ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»+º ºº !This form is quite similar to the8 ºº !file definition form. First, you8 ºº enter the attribute name and3  ºº  description.# º+º º+ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿM Attribute name: Company_Name   Description: @ ÿÿÿÿÿ #The last line of the form specifies:  $the type of data for this attribute.;   To find out more about what this7  means, you can press ,2.3  ) C ) ÿÿÿÿÿM M M ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ  Cornerstone V5.1 2ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄM M o M M M M M M r M M M M M M p M ÿÿÿÿÿM M DEFINE-NEW-FILE [ok] M M M o M DEFINE (Top level) M M M M M M r M M M M M M a M M M ÿÿÿÿÿM EDIT Default display width INTEGER OVS ÿÿÿÿÿ   Press the  ' (key., ÿÿÿÿÿM DEFINE (File level) FILE: COMPANtIES ÿÿÿÿÿ0 3HELP shows you thatF 0 3STRING :is the appropriateL 0 3data type for CompanyH 0 3Name.8 0 ÿÿÿÿÿ +ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» º To enter STRING, just type ST. 5 7Once ; ºº $you've entered enough to distinguish; ºº your selection, 'Cornerstone will do: ºº  the reist. "(You don't have to be a9 ºº programmer or a typist!)/ º+º º+º º+ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿ ) )  That's all it takes.-  You've defined a new attribute!8 ) ) o ) ÿÿÿÿÿ )  Now you're ready to use the 4long8  form to define a Standard Billing9   Rate attribute for each company.8 )  !We'll enter this command for you.9 ) ÿÿÿÿÿ ,"ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» ,º n 1Once you've entered the H º ,º 1data type, new items E H º,º 1specific to that typeF,G º,º 1appear in the form.D  º,º 1These allow you to setG º,º 1many of Cornerstone'sF º,º 1sophisticated features.H º,"º º,"ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿ - .For example, in this case G - . you might: 8 - 0*1 3say "8Yes;" to displayingJ -  6 a dollar signC  - 0*1 3set a minimum rateE -  6of 9$0/hour@  - 0*1 3set a maximum rateE -  6of 9 $100/hour C (for now)L ÿÿÿÿÿ /ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» /º 0 I º /º 1Short or long form - you J º/º 1can change these sSettings L º/º 1at any time. No otherG º/º 1database gives you this I º/º 1flexibility! J º/º0 A  º/ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿM M Attribute name: Company_name M Description: This is the name of the organization.  Type: G p M M M M M M e M M M M M ÿÿÿÿÿM c M M M M M M t M M M M M M Mr ÿÿÿÿÿ  Press the & -key 1(F1)5.6 ÿÿÿÿÿ 3ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» º ,Every record in a file has room for the same ? º º .pieces of information, just like a pre-printed A ºº (paper form. These pieces of information; ºº (called  attributes%) constitute the record.= ºº )To udefine the first attribute, select the< ºº DEFINE-NEW-ATTRIBUTE (command.0 º3º º3º º3ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿ ÿÿÿÿÿ Attribute name:= ÿÿÿÿÿ    º Type in !ST# , then press 07.8 ÿÿÿÿÿMmÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ File:  CLIENT_HISTORY Previous mode: .Update4 Files viewed: N1O ÿÿÿÿÿKEW-RECORD M Which file do you want to create records for?  CLIENT_HISTORY-# COMPANIES M PEOPLE ÿÿÿÿÿB CLIENT_HISTORY [ok] M M M ÿÿÿÿÿKEW-RECORD M Which file do you want to create records for? T   D CLIENT_HISTORY COMPANIES M PEOPLE ÿÿÿÿÿM M  HÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»  º ; Dr E JºK  º A Hopefully, you've gotten a flavor of what's involved JºK  º A in building a Cornerstone database. Bob went on and Jº  º A defined his other files and attributes in the same fashion. JºK  º A JºK  º A The key points about defining your Cornerstone databaase: Jº K  º A Jº K  º  *   It's EASY!  *You just answer simple questions Jº  º A in a form. Jº K  º A Jº K  º  *, If you're ever noit sure what to do, press >D. JºK  º A (Of course, that's true anywhere in Cornerstone.) JºK  º A JºK  º * You can add, delete, or change2 files and Jº  º  attributes " at any time-. JºK  º An JºK  º A JºK  CÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼK    2 3 7 8 M ÿÿÿÿÿ 'ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍiÍÍÍÍÍÍÍ» º  To add a new client record, just 9 º º choose NEW-RECORD +from the menu, 9 ºº "then choose the file, in this case; ºº CLIENT-HISTORY'.( º'º º'º º'ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿ > I  > Last month you talked with a potential client, n I  > I  * Easy Charters, and added them to your 5 COMPANIES> D I  > I  :file. You also added their owner, Hernando Martinez, I > I  to your PEOPLE  +file. I > g I > I  > Today you received their signed contract in the I  > I  . mail, and you're ready to add them to your9  D I  " -   CLIENT_HISTORY file.#'  ?  ? ÿÿÿÿÿM M M Enter values for the record. M M C M EDIT Co. Name STRING OVS M  Co. Name: D M Current Status: M Source of Lead: M o M HISTORY M ------- M NOTES DATE M ----- ---- M o M r M Billing Rate: Billable Hours: Charges: M M Date to Call: M ÿÿÿÿÿ ?  ?  ? p  ? Time passes. It's late May and the lilacs are  ? ? in bloom. You've finished defining your new ? ? database, and you've entered data for all your ? ? existing clients.  ?o    >  ?  ?  ?  ?  ? ÿÿÿÿÿM r M M Enter values for the record. M M M EDIT Co. Name STRING OVS M a  Co. Name: D M Current Status: M Source of Lead: M M HISTORY M ------- t M NOTES DATE M ---- ---- M o M M Billing Rate: Billable Hours: Charges: M i M Date to Call: M ÿÿÿÿÿMÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄM File: Previous mode: Files viewed: ÿÿÿÿÿM M M Seolect a command from the menu. Use arrow keys or type the command.    D VIEW DEFINE CUSTOMIZE DELETE UTILITIES M NEW-RECORD EXIT ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ  Cornerstone V5.1 2ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄM M M n M M M M M M M M M M M M S ÿÿÿÿÿ  Press the ( 3.4 ÿÿÿÿÿ / / / / / / / / p / / / ÿÿÿÿÿ1ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»º -Here Cornerstone provides you with a form for= ºº  data entry. You !can design the form (as in; ºº -this case), or Cornerstone will automatically= ºº +supply one. The first field is for Company; ºº ,Namee, and we'll enter Easy Charters for you.< º1º º1ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿ /ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» º Oops! Misspelled * Easy Charters 7, 8 9but <  º º %Cornerstone caught it and gives us an = >error C º º message at the top. + º/º ºº 'You designed the dcatabase so that only ? ºº companies entered in the 1 COMPANIES ;file? @canC ºº ,be clients. That way you can't accidentallyDºº enter 2 different spellings. 6 CornerstoneA ºº )checks consistency among different files.A º/ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿ  ?   Press "E"., t  ? ÿÿÿÿÿ -  #But Cornerstone not only warns you, < =it ?  "will actually show you the allowed ;   values. Press the ,  6key, and>  $Cornerstone displays all the company=  names from the (other .(COMPANIES) file!? - r - - ÿÿÿÿÿ Try it. Press the -  7key ;(F5)?.@ ÿÿÿÿÿ AÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» Aº º º 7Here you can see the correct spelling of Easy Charters.F º Aº º AÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍuÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿ ?   That's incorrect.( * Try it again.7  ? ÿÿÿÿÿ   Like the  key, Cornerstone's /  9key is @context-   specific. If you enter just an "-E. " and press : C,D    =Cornerstone shows only commpanies whose name starts with "E". ÿÿÿÿÿMCo. Name: Easy Charters , 111 Federal Street /Current Status:> M Boston, MA 02110 Source of Lead: M M HISTORY M ------- M NOTES DATE ÿÿÿÿÿM M M M M T M M M ÿÿÿÿÿM The value does not MATCH any allowed value. Press OPTIONS. ÿÿÿÿÿM M r M Enter values for the record. M M M EDIT Co. Name STRING OVS M M M a M M M M ÿÿÿÿÿMYou are entering a text STRING. MThe value is constriained to match one of the following values. (The following Mis a list of legal values based on what you've typed so far, before the Mcurrent cursor position.) M ALLIED ACCOUNTING ASSO EASY CHARTERS FAMILY NURSING CENTERS M FLOWER POWER KILOBITE SANDWICH SHOP MASSACHUSETTS METAL PR M RELEVANT TECHNOLOGY PR ROBERT BARNUM & ASSOCI S. P. I. INC. M n  Co. Name: D Eazy Charters M Current Status: M Source of Lead: M M HISTORY M ------- i M NOTES DATE ÿÿÿÿÿ   9Since Easy Charters is the only company whose name startsE    with "E ", press the   ( key. Cornerstone does the rest.   Press the & .key.2 ÿÿÿÿÿ  EASY CHARTERSÿÿÿÿÿM M n M M M M M M g M M M M M M M ÿÿÿÿÿ  º $Type "*N+".- ÿÿÿÿÿ That's incorrect. Try again.8 ÿÿÿÿÿ  NEW-RECORD? M ÿÿÿÿÿ %   Cornerstone now gives you a menuC 9  !of all the file names. To choose:  CLIENT-HISTORY',( %   Press the & 4key.8 ÿÿÿÿÿ % %   Press the ( 0key.4 % % % ÿÿÿÿÿMYouo are entering a text STRING. M MThe value you enter in this field must match one of the following values M(based on what you've typed so far, before the cursor position). M EASY CHARTERS M M r M ÿÿÿÿÿ  !Now press the / (F5) >key.B ÿÿÿÿÿ  ÿÿÿÿÿM EDIT Current Status ENUMERATED OVS ÿÿÿÿÿ/Current Status:/Source of Lead:ÿÿÿÿÿ ? ?e: Easy Charters ? p111 Federal Street Current Status: Active Acc ? Boston, MA 02110 Source of Lead: June Foray ? Price & Smÿÿÿÿÿ = =  9We'll fill in the next two pieces of information for you. F = = o = ÿÿÿÿÿ   8With other databases you must define field widths. Once  ,defined, they're very difficult to change. 9 Cornerstone D  gives you total flexibility. +For example, you can change F  :from 5 to 9 digit zip codes, or enter extraordinarily long G  :names (such as the firm of Smith, Jones, Klein, Beeblebrox G  and Babblefish).r + ÿÿÿÿÿ ?ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» º  :Cornerstone not only completes the name, but it also pullsG º º #in the address from the other file. 0 º ?º º º 0You only enter Easy Charter's name once, in the = COMPANIES F º º -file. If they move, you change it there and : the address E ºa º -is automatically updated in every other file! : º ?ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿM 111 Federal Street Current Status: Active Account , Boston, MA 02110 /Source of Lead:> June Foray at ? PriM M HItSTORY M ------- ÿÿÿÿÿM EDIT Source of Lead STRING OVS ÿÿÿÿÿ ?ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» º 8Each time you contact your client, you can add a note. E º º 7This way all the information about your clients will be D º º in one place. / i º ?ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿ   .When there wasn't enough room on one line for ; Source of  Lead ,, Cornerstone simply inserted an extra line. =  =  Cornerstone uses variable-length fields 4. You never have E  2to decide in advance how long any entry will be -- ?   &Cornerstone makes room as you needo it. 3 ÿÿÿÿÿM EDIT 1st Contact_People.Notes(1) STRING OVS M M MCo. Name: Easy Charters M 111 Federal Street Current Status: Active Account M Boston, MA 02110 Source of Lead: Jnune Foray at M Price & Smithson M M HISTORY M ------- M NOTES DATE M ----- ----   o ; A M M Billing Rate: Billable Hours: Charges: M ÿÿÿÿÿ, 111 Federal Street /Current Status:> M Boston, MA 02110 Source of Lead: S M M HISTORY M ------- M NOTES DATE ÿÿÿÿÿMCo. Name: Easy Charters M 111 Federal Street Current Status: Active Account  p CÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» L  º 3Cornerstone also fills in the standard billing rate C  º L  º 4for the company. When you enter the number of hours D º L  º +worked, Cornerstone calculates the charges. ; º L  Cº º L  NOTES º e Type 4 and then press .9 ºL  ----- CÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼL M o Preliminary meeting with Hernando Martinez. He is 5/16/85 M interested in better utilizing the float between his M customers' payments and his outflows. We talked about M various investment possibilities. Call him next Wednesday. M c  Billing Rate: $45.00 Billable Hours:-# Charges: ÿÿÿÿÿM M MCo. Name: Easy Charters M 111 Federal Street Current Status: Active Account M Boston, MAt 02110 Source of Lead: June Foray at M Price & Smithson M M HISTORY M ------- M NOTES DATE M ----- r ----  o ; A M M Billing Rate: Billable Hours: Charges: M ÿÿÿÿÿ2Billable Hours: 4.00 Charges: $ 180.00 ÿÿÿÿÿ ?ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» uº  :After you've entered everything about this client contact,G º º 6Cornerstone makes room for the next note. Cornerstone C º º uses multi-valued fields %. & You don't have to decide in C º º 8advance how many notes (or anything else) there will be. E º ?ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿ ? ?e: Easy Charters m ? 111 Federal Street Current Status: Active Acc ? Boston, MA 02110 Source of Lead: June Foray ? Price & Smÿÿÿÿÿ ?ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» º 1Notes like this can be up to two pages long. But >  º º 5Cornerstone stores your information efficiently. It B º º "never uses more space than you do. / º ?ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿ 5/22/85ÿÿÿÿÿM EDIT 1st Contact_History.Billable Hours NUMBER OVS ÿÿÿÿÿM M M HISTORY M ------- T M NOTES DATE M ----- ---- M o Preliminary meeting with Hernando Martinez. He is 5/16/85 M interested in better utilizing the float between his M customers' payments and his outflows. We talked about M various investment possibilities. Call him next Wednesday. rM M Billing Rate: 45.00 Billable Hours: 4.00 Charges: $ 180.00 M   Date to Call:? M- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -ÿÿÿÿÿM EDIT Date to Call DATE OVS ÿÿÿÿÿaM M M M HISTORY M ------- M NOTES DATE M ----- i ---- M o Preliminary meeting with Hernando Martinez. He is 5/16/85 M interested in better utilizing the float between his M customers' payments and his outflows. We talked about M various investment possibilities. Call him next Wednesday. M M Billing Rate: $45.00 Billabnle Hours: 4.00 Charges: $ 180.00 M  o ; A ÿÿÿÿÿM EDIT 2nd Contact_History.Notes(1) STRING OVS ÿÿÿÿÿ? o Preliminary meeting with Hernando Martinez. He is B 5/16/85J M interested in better utilizing the float between his M customers' paymentsi and his outflows. We talked about M various investment possibilities. Call him next Wednesday. ÿÿÿÿÿM M M Do you want to create another record?  YES F NO M n ÿÿÿÿÿ) YES ,NOÿÿÿÿÿM M NO [ok] M M M g M M M M M M M M M M M M M C M M ÿÿÿÿÿM EDIT 1st Contact_History.Date DATE OVS ÿÿÿÿÿ That's incorrect.* , Try again.6 ÿÿÿÿÿMCo. Name: Easy Charters M 111 Federal Street Curorent Status: Active Account M Boston, MA 02110 Source of Lead: June Foray at M Price & Smithson M M HISTORY M ------- M NOTES DrATE M ----- ---- M o Preliminary meeting with Hernando Martinez. He is 5/16/85 M interested in better utilizing the float between his M customers' payments and his outflows. We talked about M various investment possibilities. Call him next Wednesday. M  p  Billing Rate:; 45.00 Billable Hours: Charges: ÿÿÿÿÿ  9You don't have to type in the date. You defined the file F  9so that Cornerstone automatically enters the current date F  (but you can always change it). , ÿÿÿÿÿM EDIT 1st Contact_History.Billing Rate NUMBER OVS ÿÿÿÿÿ ?ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» º  7Last, put in the Dateo to Call. Cornerstone understandsD º º 4terms like "next Wednesday," "last Monday," or "this A º º 3Sunday," and turns them into the appropriate dates. @  º ?ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿ   +For example, you can add a 2nd (or 3rd, or 830th< ) note, asF  5necessary. With other databases you'd have to define B Ca D  2nd (or 3rd, or 30th !) field, and waste storarge. <  = ÿÿÿÿÿ Billing Rate: $45.00 Billable Hours:ÿÿÿÿÿ; ; ; Billing Rate: Billable Hours: Charges: ÿÿÿÿÿ; ; ÿÿÿÿÿ; a ÿÿÿÿÿM M M Select a command from the menu. Use arrow keys or type the command.    D VIEW DEFINE CUSTOMIZE DELETE UTILITIES M NEW-RECORD EXIT ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ  Cornerstone V5.t1 2ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄM M M M M M i M M M M M M oM M M MÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄM File: Previous mode: Files viewed: ÿÿÿÿÿMPlease select the file you wish to view. You may select any file appearing Min the mennu. The menu lists all the files in your database. M MCLIENT_HISTORY This file is used to record on-going client contacts. MCOMPANIES This file contains basic information about actual and M potential client organizations, including name, address, M telephone number, and standard billing rate. MContact_History M This subrecord is used for recording the on-going contacts M with the client/customer organization. This includes room forM extensive notes, as well as the date of contact. MContact_People This subrecord contains information about individual people M within the client organization. The person's name must be in M the PEOPLE file. S MPEOPLE This file contains name, addresses, telephone numbers, and M other information about individuals. It can be used for both M personal and professional purposes. ÿÿÿÿÿ-!ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»-º /Cornerstone integrates theI º -º / information ;you've entered I, J K º -º /with what it knows about its K º -º /own workings and your pcurrent L º -º /position, to produce a E Ftruly K º -º /context-specific message. H º-!ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿM Select an ATTRIBUTE.    D Birthday Birthday_Month M Company_Name Country First_Name M Full_Name Home_City Home_CSZ M Heome_Phone Home_State Home_Street_Address M Home_zip_code Job_Title Last_Name M Notes References Work_Associates M Work_CSZ Work_Phone Work_Street_Address M  L Home State: MA  L Home Zip Codce: 02167  L Home CSZ: Brookline, MA 02167  L Home Phone: 617-232-8488  L Birthday: AUGUST 6  L Company Name: Easy Charters  L Work Street Address: 111 Federal Street  L Wtork CSZ: Boston, MA 02110  L Notes: Lived in Chicago before moving into this job in Jan. 84.  L Die-hard Chicago Cubs fan, and very competitive. ÿÿÿÿÿ PEOPLE C M ÿÿÿÿÿ . 2 Press the < Dkey. H ÿÿÿÿÿ  r That's incorrect.* , Try again.6 ÿÿÿÿÿM M Select a command from the menu. Use arrow keys or type the command.    D UPDATE SELECT VIEW COLUMN DETAILED M USE SAVE REPORT SORT PRINT ALL-DONE ÿÿÿÿÿ .!ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» .º 0Here the menu shows all the K º.º 0utypes of information in theK º.º 0PEOPLE 7file. In this caseJ º.º 0you might select A Full NameJ,K º.º 0 Company Name<, andAB Work PhoneL.M º.!ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿM VIEW PEOPLE 317 Records SORTED M Name Home Phone Work Phone M============================================================================= Mm > L Marcia Andrews 617 232-8488 222-2225 > L --------------------------------------------------------------------------- M Christopher Banks 603-275-7665 603-324-8492 M ---------------------------------------------------------------------------M Robert Barnum 212 863-8043 603-554-3000 M ------ ---------------------------------------------------------------------M Ken Becker 617 444-4284 886-5693 M 617 444-4119 M ---------------------------------------------------------------------------M Carol Bell 617-229-0925 203-292-0172 M ---------------------------------------------------------------------------M Marilyn Brown T203 863-5629 203-275-1000 MÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ File:  PEOPLE  Previous Mode: 0Initial7 Files viewed: N1O ÿÿÿÿÿM M ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»  º  =Cornerstone has many powerful data entry features, including:H º M r º º   º * Data validation.!) Cornerstone can check for minimum, Jº  º & maximum, unique, or mandatory values.9 º M º º   º * Variable-length fields.( Cornerstone opens up extraD  º  º  space as you need ita. )' º  º - A º   º *   key. & Cornerstone will always show you all E  º  º  your available options. +% º  º  ." º   º * Automatic completion.&  Cornerstone completesi commandsF  º   º ' and data entries wherever possible.7 º M º º   º * Relational capabilities.) Cornerstone automaticallyD  º  º 0 compares or inserts values from multiple files.C  º M º º   º *  nCalculation.% Cornerstone can perform arithmetic,B º  º /financial, string, date, and time calculations.C  º M ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ M ÿÿÿÿÿ  ( Press the 2 =.>  ÿÿÿÿÿKIEW PEOPLE [ok] Mi Entering View Mode ... Please wait M M M VIEW PEOPLE 317 Records SORTED M M M n M M M M M M g M M M M M M ÿÿÿÿÿ   ----- º  The PEOPLE +file holds much more information about eachC  Ken B º  :person than appears here. If you want to check everythingG   º  :about a particular person, say Marcia Andrews, you can useG  ----- º  the  DETAILED command."&  Carol >º  ----- Cº Type " D!".#% ÿÿÿÿÿ / / / / 1 With the :COLUMN Acommand H / 1you can choose which items K / 1 to display. < / / 7Type "=C>".@ / / o / ÿÿÿÿÿ  That's incorrect. Try again.: ÿÿÿÿÿM Select a command from the menu. Use arrow keys or type the command.  DETAILEDA M ÿÿÿÿÿ/ / 1Now press the ? J.K ÿÿÿÿÿM r M M Select a command from the menu. Use arrow keys or type the command.    D UPDATE SELECT VIEW COLUMN DETAILED M USE SAVE REPORT SORT PRINT ALL-DONE M VIEW PEOPLE 317 Records SORTED >L First Name: Marcia p  L Last Name: Andrews  L Full Name: Marcia Andrews  L Home Street Address: 13 Eliot Crescent  L Home City: Brookline  L Home State: MA  L Home Zip Codeo: 02167  L Home CSZ: Brookline, MA 02167  L Home Phone: 617-232-8488  L Birthday: AUGUST 6  L Company Name: Easy Charters  L Work Street Address: 111 Federal Street  L Worrk CSZ: Boston, MA 02110  L Notes: Lived in Chicago before moving into this job in Jan. 84.  L Die-hard Chicago Cubs fan, and very competitive. ÿÿÿÿÿKETAILED ALL-ATTRIBUTES [ok] M M M a M VIEW PEOPLE 317 Records SORTED M M M M M t M M M M M M i M M M M ÿÿÿÿÿ A  A  A o  A  A Time passes. Your information that was once  A A scattered around has now been consolidated A A and organized with Cornerstone. A n A  A Now it's time to show Cornerstone at work;  A  A giving you the exact information you want,  A  A displayed the way you want to see it.  A  A  A ÿÿÿÿÿ8pany_Name M Select an ATTRIBUTE or press ENTER to execute the command.    D Birthday Birthday_Month M Country First_Name Home_City ... ÿÿÿÿÿ8 S M Select an ATTRIBUTE or press ENTER to execute the command.   Company_Name= M ÿÿÿÿÿ: M Select an ATTRIBUTE or press ENTER to execute the command.    D Company_Name Copuntry M ÿÿÿÿÿ Cll_Name M Select an ATTRIBUTE or press ENTER to execute the command.    D Birthday Birthday_Month M Company_Name Country First_Name ... ÿÿÿÿÿ F fu e M Select an ATTRIBUTE.   Full_Name@ M ÿÿÿÿÿ D M Select an ATTRIBUTE.    D First_Name Full_Name c M M VIEW PEOPLE 317 Records SORTED >L First Name: Marcia  L Last Name: Andrews  L Full Name: Marcia Andrews  L Home Street Address: 13 Eliot Crescent t  L Home City: Brookline  L Home State: MA  L Home Zip Code: 02167  L Home CSZ: Brookline, MA 02167  L Home Phone: 617-232-8488  L Birthday: AUGUST 6 r  L Company Name: Easy Charters  L Work Street Address: 111 Federal Street  L Work CSZ: Boston, MA 02110  L Notes: Lived in Chicago before moving into this job in Jan. 84.  L Die-hard Chicago Cubs fan, and very competitive. ÿÿÿÿÿ OLUMN M u M M ÿÿÿÿÿ   COLUMN C M ÿÿÿÿÿMÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄM File: m Previous mode: Files viewed: ÿÿÿÿÿ/ / / 1One important database G / 1function is preparing ad I / 1hoc reports. With C  / 1Cornerstone there's Eno K / 1limit 7to the number ofG / 1reports you can create.H / / / ÿÿÿÿÿ VIEW E M ÿÿÿÿÿ IEW M Which file do you want to VIEW?    D CLIENT_HISTORY COMPANIES M Contact_History Contact_People PEOPLE ÿÿÿÿÿ / T  (Let's use some previously saved formats.; /  $To use a report format, just select 7USE ;  from the menu.!  ) :   Press the #  0key.4  ÿÿÿÿÿ /  "If you want a printed copy of this7  r  report, just select )PRINT /from the menu.=  $Any report can be printed just as it9  appears on the screen.+ / / ÿÿÿÿÿ#- M Select an ATTRIBUTE or press ENTER to execute the command.    D Work_Associates Work_CaSZ M Work_Phone Work_Street_address ÿÿÿÿÿ   Work_Phoneÿÿÿÿÿ /  )If you create a report you'll want to use<  &again, you can save it for future use.9 /  Up to 255 different report formats 6can be<  saved !for each file. : i/ ÿÿÿÿÿ!/ work_Phone [ok] M M M M VIEW PEOPLE 317 Records SORTED M n M M M M M M M i M M M M M M n M ÿÿÿÿÿ!/ work_Phone M Select an ATTRIBUTE or press ENTER to execute the command.    D Anniversary Anniversary_Month M Birthday Birthday_Month Country ... ÿÿÿÿÿ   7Here you see a menu of your files. If you've forggottenD    2the use of any file (or someone else is using your?     database), pressing ! (shows you the descriptionA    you "entered when the file was defined.3    Press the %  (F1) 1key.5 ÿÿÿÿÿM M M Select a command from the menu. Use arrow keys or type the command.    D UPDATE SELECT VIEW COLUMN DETAILED M USE SAVE REPORT SORT PRINT ALL-DONE M VIEW PEOPLE 317 Records SORTED M Full name Company Name Work Phone M ----------------------------------------------------------------------- > CL Marcia Andrews Easy Charters 222-2225 M Christopher Banks KiloBITE Sandwich 603-324-8492 M Shoppes, Inc. M Robert Barnum Robert Barnum & 603-554-3000 M Associates M Ken Becker TIP Construction Co. 886-5693 M Carol Bell o Zonka Trucking Co. 203-292-0172 M Marilyn Brown SAC Press 203-275-1000 M Mitchell Capone Alpha Accounting Assoc. 603-942-0101 M David Green Massachusettes Metal 395-1774 M Products M Dan Horner Robert Barnum & 603-554-3000 M Associaters ÿÿÿÿÿ. . . 1First, let's look at the I . 1PEOPLE 8file. = . . ÿÿÿÿÿ 1ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» º +That's all it takes to create a new report! > º1º ºº +Where there wasn't enough room forp KiloBITE> ºº ,Sandwich Shoppes' name, Cornerstone inserted? ºº an extra line. #You never have to worry: ºº )about lengths - Cornerstone makes room as< ºº needed.' º1ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿ /That's incorrect. Try again. L ÿÿÿÿÿ  & Press the 0 8key.<  ÿÿÿÿÿPEOPLE  :This filoe contains name, addresses, telephone numbers, andL  =other information about individuals. It can be used for bothO  #personal and professional purposes.5 ÿÿÿÿÿ/ / / 1For example, before leaving L / 1on vacation you might want K / 1to prepare a report for H / 1your assistant listing G / r1everyone with whom you doJ / 1 business.: / / / ÿÿÿÿÿ IEW M M M ÿÿÿÿÿ  . 6Type " <P =". ?a ÿÿÿÿÿ.!ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ».º 1With 6DETAILED> ? you see everyL º .º 1item in your file, displayed M º .º 1 one per line. > º .!º º .º 1Cornerstone presents the I º .º 1records one after another, K º.º 1as if on a scroll. And youL º.º 1can move through this scrollM º.º 1a 3line7, 9page=, ?screenE, torI º.º 1record7 8at a time, in eitherL º.º 1 direction.; º.!ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿ ?ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» º You're looking at !some% &of the information from theA º º PEOPLE ,file (specifically names and phone numbers).B º ?º º º 2Since this is whait you use most often, you made itA º º the initial display #(of course Cornerstone lets youB º º !change this display at any time).0 º ?ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿ/ 4That's incorrect.E  /  8 Try again.B  ÿÿÿÿÿ  ?ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» ?º o º º 1To look at the information in a file, just selectA º º VIEW and then the file name., º ?º º º Type "V"., º ?ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿM seLECT BY-FORM M Press to exnecute the command. (You may press to erase it.)M M ÿÿÿÿÿ BY-FORMÿÿÿÿÿM seLECT M Choose a means for SELECTing new records or press to re-select.    D BY-FORM ALL FLAGGED UNFLAG GED M ÿÿÿÿÿ   USE  ÿÿÿÿÿM USE M Do you want to use a FORMAT or SELECTION CRITERIA?    D FORMAT SELECTION-CRITERIA M ÿÿÿÿÿ S FORMATÿÿÿÿÿM USE FORMAT M Select a FORMAT.    D business_mail_labels employment M full_info home_mailing_labels PREVIOUS-VIEW ... ÿÿÿÿÿ business_mail_labelsÿÿÿÿÿM USE FORMAT business_mail_labels pM Press to execute the command. (You may press to erase it.)M M ÿÿÿÿÿM M USE FORMAT business_mail_labels [ok] M M e M M VIEW PEOPLE 317 Records SORTED M M M M c M M M M M M t M M M M M ÿÿÿÿÿM r M M Select a command from the menu. Use arrow keys or type the command.    D UPDATE SELECT VIEW COLUMN DETAILED M USE SAVE REPORT SORT PRINT ALL-DONE M VIEW PEOPLE 317 Records SORTED >L Marcia Andrews u  L V.P. of Finance  L Easy Charters  L 111 Federal Street  L Boston, MA 02110 > L M Christopher Banks m M Vice-President M KiloBITE Sandwich Shoppes, Inc. M 111 Beacon Street M Wickford, RI 02852 M M Robert Barnum  M Senior Partner M Robert Barnum & Associates ÿÿÿÿÿ FORMATÿÿÿÿÿM USE M Do you want to use a FORMAT or SELECTION CRITERIA?    D FORMAT SELECTION-CRITERIA M T ÿÿÿÿÿ   USE  ÿÿÿÿÿM Select a command from the menu. Use arrow keys or type the command.  SELECT C M ÿÿÿÿÿ1 /  &Cornerstone displays a list of all ther;  !saved formats. Each one offers a6   different way of looking at the4   information in your file.. /  "Type "(F)".+ ÿÿÿÿÿ 0ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» 0º º 0º 3To get the records E º 0º 3you want, just move F º 0º 3to the appropriate E º0º a 3field and enter theF º0º 3proper values.A º0º º0ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿM @ull_info [ok] M M M i M VIEW PEOPLE 317 Records SORTED M M M M M n M M M M M M M i M M M ÿÿÿÿÿ[ok]ÿÿÿÿÿ , , .To do this, you would C , .choose 5SELECT;. CornerstoneI , .presents you with a list ofIn , .all the items in the file,H , .and you just enter theD , .value(s) you want to match., ÿÿÿÿÿM M M Select a command from the menu. Use arrow keys or type the command.    D UPDATE SELECT VIEW COLUMN DETAILED Mg USE SAVE REPORT SORT PRINT ALL-DONE M VIEW CLIENT_HISTORY 40 Records SUBTOTALED M >L Allied Accounting Assoc. 1/16/85 280.00  L Allied Accounting Assoc. 1/24/85 200.00  L Allied Accounting Assoc. 2/05/85 0.00  L Allied Accounting Assoc. 2/12/85 400.00  L ----------  L $ 880.00 >L M Easy Charters 5/16/85 67.50 M ---------- M C $ 67.50 M M Flower Power 4/26/84 100.00 M Flower Power 5/08/84 200.00 M Flower Power 6/02/84 0.00 ÿÿÿÿÿ /    Press the ' 2o.3  / / / / / ÿÿÿÿÿ EDIT Home City(1)  Home Street Address:   Home City:ÿÿÿÿÿ EDIT Home State(2)   Home State:   ct   Home zip code:  Home CSZ: r  Home Phone:  Birthday:  Company Name:  Work Street Address:  Work CSZ: ÿÿÿÿÿ  That's incorrect. Try again.8 ÿÿÿÿÿ  DONE [ok]M M M ÿÿÿÿÿ 1 1p 4Here we'll enter D 1 4CT and RI, and B 1 4Cornerstone willD 1 4 do the rest.@ 1 ÿÿÿÿÿM Name Home Phone Work Phone M============================================================================= M > L Marcia Andrews 617 232-8488 222-2225 o > L---------------------------------------------------------------------------- M Christopher Banks 603-275-7665 603-324-8492 M-----------------------------------------------------------------------------M Robert Barnum 212-863-8043 603-554-3000 M-----------------------------------------------------------------------------M Ken Becker 617 444-4284 886-5693 M r 617 444-4119 M-----------------------------------------------------------------------------M Carol Bell 617-229-0925 203-292-0172 M-----------------------------------------------------------------------------M Marilyn Brown 203 863-5629 203-275-1000 ÿÿÿÿÿ + ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» + º º +º .For example, beforea A Byour F º+º .business trip to>  º+º .Connecticut and RhodeC º+º .Island, you would want theH º+º .phone numbers of everyoneG º+º .you know there.= º+ º º+ ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿM M M Setlect a command from the menu. Use arrow keys or type the command.    D UPDATE SELECT VIEW COLUMN DETAILED M USE SAVE REPORT SORT PRINT ALL-DONE M VIEW CLIENT_HISTORY 40 Records SORTED M HISTORY M ------- > L Mon, i 5/06/85 Called Dan to make appointment. Not in. Left message.  L M Thu, 5/09/85 Called again to make appointment. In meeting. Left a M message. M M Mon, 5/13/85 Returned Dan's returned call. Not in. Left message. M o M Tue, 5/14/85 Called Dan again. In meeting. Left message. M M Sat, 5/18/85 Spoke with Rob over tennis. Mentioned problem reaching M Dan. He assured me I'll get to see him. M M Mon, 5/20/85 Received call from Dann. Made appointment for 5/24/85. ÿÿÿÿÿ   Press the ' /key.3  ÿÿÿÿÿ/   Press the # 1key.5  ÿÿÿÿÿM M M Select a command from the menu. Use arrow keys or type the command.    D UPDATE SELECT VIEW COLUMN DETAILED M USE SAVE REPORT SORT PRINT ALL-DONE M VIEW PEOPLE 44 Records SORTED M Name Home Phone Work Phone M============================================================================= M > L Christopher BaSnks 401-275-7665 401-324-8492 > L---------------------------------------------------------------------------- M Marilyn Brown 203 863-5629 203-275-1000 M-----------------------------------------------------------------------------M Liz Cirius 203 994-9929 203-541-5000 M-----------------------------------------------------------------------------M Fred Glover 401p-882-3618 401-233-3512 M-----------------------------------------------------------------------------M Karen Malik 203-437-4512 203-336-3660 M-----------------------------------------------------------------------------M John V. Neumann 203-366-0688 203-269-5255 M-----------------------------------------------------------------------------ÿÿÿÿÿM e M M Select a command from the menu. Press to initiate the selection.  EDIT E USE SAVE DELETE DETAILED FORMAT M CALCULATE AND-FORM OR-FORM NEGATE PRINT M SELECT BY-FORM M c M First Name: M Last Name: M Full Name: M Home Street Address: M Home City: M Home State: ct t M ri M Home zip code: M Home CSZ: M Home Phone: M Birthday: M Company Name: M Work Strreet Address: M Work CSZ: ÿÿÿÿÿM M USE FORMAT full_info [ok] M M M u M VIEW CLIENT_HISTORY 40 Records SORTED M M M M M m M M M M M M M M M M ÿÿÿÿÿM USE FORMAT full_info M Press to execute the command. (You may press to erase itT.)M M ÿÿÿÿÿ  full_info@ M ÿÿÿÿÿ7ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»º This format shows all the , DETAILED 5 information@ ºº *in a morre attractive layout, with personal<  ºº 1information on the left, and business informationC ºº  on the right.& º7ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿ )!ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» )!º º)º -This format can be usedD º)º -to print mailing labels.E º)!º º)!ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿMa M Select a command from the menu. Use arrow keys or type the command.    D UPDATE SELECT VIEW COLUMN DETAILED M USE SAVE REPORT SORT PRINT ALL-DONE ÿÿÿÿÿ EDIT Home State(1)   Home City:   Home State:ÿÿÿÿÿM USE FORMAT f M Select a FORMATi.   full_info@ M ÿÿÿÿÿ>L Marcia Andrews Easy Charters  L 13 Eliot Crescent V.P. of Finance  L Brookline, MA 02146 111 Federal Street  Ln USA Boston, MA 02110  L Home Phone: 617 232-8488 Work Phone: 222-2225  L  L Birthday: AUGUST 6 Work Associates: James Brown  L Anthony Little  L i  L Notes: Lived in Chicago before moving into this job in Jan 84.  L Die-hard Chicago Cubs fan, and very competitive. >L ---------------------------------------------------------------------------M Christopher Banks KiloBITE Sandwich Shoppes, Inc. M 64 Meadow Brook Road Vice-President M Providence RI 02243 111 Beacon Street ÿÿÿnÿÿ EDIT Home Street Address(1)   Full Name:  Home Street Address:ÿÿÿÿÿM USE FORMAT M Select a FORMAT.    D charges full_info M PREVIOUS_UPDATE PREVIOUS_VIEW select ... ÿÿÿÿÿM g M M Enter selection criteria. M M M EDIT First Name(1) STRING OVS M   First Name:A M Last Name: M Full Name: M Home Street Address: M Home City: M Home State: M Home zip code: C M Home CSZ: M Home Phone: M Birthday: M Company Name: M Work Street Address: M Work CSZ: o M Notes: ÿÿÿÿÿM M M ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» M º º   º With Cornerstone you can:') r º M º º M º º  º * Display information in an . unlimited7 number> º  º of report formats. )' º M º º  º p*   Create  new reports in seconds. 2 º M º º  º *  Save  )hundreds of report formats for each file. B º M º º  º * Select "records meeting specific criteria.= º M º o º M º º M º º M º º M º º M ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ M r M ÿÿÿÿÿ "* " %Earlier we added data to the A  " %%Client_History file. Here we'll showJ " % you a few ways to use that file.E "* " %#One use is to summarize billings toH " %each client or to all clients.C  "* a "* ÿÿÿÿÿ   USE  ÿÿÿÿÿM USE FORMAT M Select a FORMAT.    D business_mail_labels employment M full_info home_mailing_labels PREVIOUS-VIEW ... ÿÿÿÿÿM USE t M Do you want to use a FORMAT or SELECTION CRITERIA?    D FORMAT SELECTION-CRITERIA M ÿÿÿÿÿ FORMATÿÿÿÿÿM USE M Do you want to use a FORMAT or SELECTION CRITERIA? i    D FORMAT SELECTION-CRITERIA M ÿÿÿÿÿM M M Select a command from the menu. Use arrow keys or type the command.    D UPDATE SELECT VIEW COLUMN DETAILoED M USE SAVE REPORT SORT PRINT ALL-DONE M VIEW CLIENT_HISTORY 40 Records SORTED >L Flower Power Call: Saturday, 5/4/85  L Evan Schlessinger 664-8993 Owner > L -------------------------------------------------------------------------- M SAC Press Call: Wednesday, 5/8/85 n M Marilyn Brown 203-275-1000 Senior Sales Manager M -------------------------------------------------------------------------- M Zonka Trucking Co. Call: Wednesday, 5/15/85 M Carol Bell 203-292-0172 Owner M -------------------------------------------------------------------------- M KiloBITE Sandwich Shoppes, Inc. Call: Thursday, 5/23/85 M Christoph er Banks 603-324-8492 Vice-President M -------------------------------------------------------------------------- M Robert Barnum & Associates Call: Friday, 5/31/85 M Robert Barnum 603-554-3000 Senior Partner M Dan Horner Senior Analyst ÿÿÿÿÿM M USE FORMAT tickler [ok] S M M M M VIEW CLIENT_HISTORY 40 Records SUBTOTALED M M p M M M M M M e M M M M M M Mc ÿÿÿÿÿM USE FORMAT tickler M Press to execute the command. (You may press to erase it.)M M ÿÿÿÿÿM USE FORMAT t M Select at FORMAT.  ticklerB M ÿÿÿÿÿM USE FORMAT M Select a FORMAT.    D charges full_info M r PREVIOUS_UPDATE PREVIOUS_VIEW select ... ÿÿÿÿÿ FORMATÿÿÿÿÿ !,ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» !º $You can specify: 4 º !º $* % ' exact matches 4 5 (such as CT) A  º!º $*% 'ranges- .(1/1/85 - 6/30/85)@  º!º $*% ' wildcards0 1(any name starting with B)K º!º $*% ' negations0u 1 (NOT Boston)= º!º $*% ' logical OR1 2(Boston OR Cambridge)G º!º $*% ' logical AND2 3(Boston AND ActiveE º!!º BAccount)J º!º $*% 'or any . combination9 :of theseB  º!,ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿ   USE  ÿÿÿÿÿ EDIT Full Name(1)   Last Name:   Full Name:ÿÿÿÿÿ/m    Press the ' 2.3  ÿÿÿÿÿ =  =  =  = We hope that this demonstration gave you some  = = idea of how Cornerstone works, and how you might = = use it. Of course, we were only able to show = = a small fraction of what it can do. As you work  =  = with Cornerstone, you'll discover its power and  =  = broad range of capabilitieTs.  =  =  = ÿÿÿÿÿ )Cornerstone comes with a free-form report;   .generator, which is as easy to use as the rest@  of Cornerstone.! #Now we'll show you a few;   other report formats.' r ÿÿÿÿÿM Select a command from the menu. Use arrow keys or type the command.    D SELECT SAVE SORT M ÿÿÿÿÿ )!ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» )!º º )º -Another important use of E º )º -databases is selecting C º)º -records meeting specifiedF º)º - criteria.a6 º)!º º)º -With Cornerstone theA  º)º -information you want is atG º)º -your fingertips.=  º)!ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿ 1ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ» º ,Another use is as a "tickler," reminding you A ºº (of whom to call, and when. Each day you= ºº &can select those clients who should be; ºº  cointacted.$ º1º ºº &You may also want to review the entire; ºº #contact history of certain clients.8  º1ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿ -ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»º %Cornerstone can summarize information6 ºº in the following ways:' ºº * sum *n* -minimum4 ºº * average ** -maximum4 ºº * standard deviation' ** -count2  ºº * net present value& ** -variance5 º-ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÿÿÿÿÿ EDIT Last Name(1)   First Name:   Last Name:ÿÿÿÿÿM M i   FÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»  º   8 Jº   ºSpecifications/Limits#%H Jº   º0--------------------- > H Jº E ºnH Jº   º *( 8,000,000 characters per file. 9H Jº   º *  120 files per database. * H Jº   º *  *4,000 characters per record, expandable by =  H Jº   º . subrecords. <  H Jº   º *  /Each record can cgontain hundreds of subrecords. B H Jº   º < Each subrecord may contain up to 4,000 characters. Jº   º *160 fields per record.)H Jº   º  *2 Each field may have multiple values (up to 255).CH Jº   º*Any/all fields can be indexed.1H Jº   º* "255 saved report formats per file.5H Jº E º H Jº E º H Jº E ºH Jº M ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ M C M ÿÿÿÿÿM M   FÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»  º   8 Jº E ºoH Jº   º-Cornerstone is a powerful relational database< H Jº E ºH Jº   º)management system for personal computers.8H Jº E º H Jº E º H Jrº   º -Now that we've given you the computer-jargon <  H Jº E º H Jº   º 1explanation, this section describes what that @ H Jº E º H Jº   º really means. '!H Jº E ºpH Jº E ºH Jº E º H Jº E º H Jº E ºH Jº M ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍoÍÍÍÍÍÍÍÍÍÍͼ M M ÿÿÿÿÿ ?  ?  ? A database management system is a program for  ?   storing,  organizing,$ %rand ) reporting2 3large quantities ? ? of information. You decide on the type(s) of ? ? information to be managed. ?  ?  ? For example, a personnel system is basaed upon a database,  ?  ? as is an order entry system, a time-billing system, or  ?  ? an airline reservation system.  ? ÿÿÿÿÿ ?  ?  ? tTypically, a good database management system can:  ?   * Display -information in a variety of ways ?   *  Order 0 (sort) information however you want ?   *  Select / data meeting speicified criteria ?   *  Summarize, data  ?   *  Calculate, new data from existing data  ?   * Print /complex reports  ? o  ? ÿÿÿÿÿ ?  ?  ? Cornerstone excels at all these tasks. In addition,  ?  ? Cornerstone can: ? n ?  *  Combine  -information from many files in one report ?  *  Store  /very large quantities of data, including text  ?   * Display information in an / unlimited8 9 number of  ? report formats  ?   * Change .and grow as your needs change  ?  ? ÿÿÿÿÿ ?  ? A database is often compared to a filing cabinSet.  ?  ? Filing Cabinet(s) = Database  ? ? File Folders, e.g. = File ? Accounts Payable ? ? Forms, e.g. = Record ? Acme Mutuapl account  ?  ? Fields, e.g. = Field or Attribute  ? Address  ?  ? Entry, e.g. = Value  ? 77 Elm Street  ? e ÿÿÿÿÿ ?       With a  relational! "(database, information from one file  ?  ? can be combined with or checked against information  ? ? in other files. ? c ? - As a result, you enter information only 8once < = for it ?  ? to be used by many files. Any changes to one file  ?  ? are reflected in all relevant files.  ?  ? t  ? The next screen shows an example.  ? ÿÿÿÿÿ ?  ?  ?  ?  ? r ?   Customers  Payables & , Receivables 7 >Orders D   ---------  -------- & , ----------- 7 >------ D ? ? Acme Mutual Acme Mutual Acme Mutual Acme Mutual  ? 77 Elm St. 77 Elm St. 77 Elm St. 77 Elm St. u ?  ?  ?  ?  ?  ? ÿÿÿÿÿ  ÿÿÿÿÿ 1 Main St.ÿÿÿÿÿ*1 Main St. 1 Main St. 1 Main St.ÿÿÿÿÿ ? m So why use Cornerstone instead of a filing cabinet? ÿÿÿÿÿ  With paper-based systems:'#   -------------------------'#   * 7You need separate files for different purposes,   with lots of # repetition- .of information.  ?  *  Information becomes ' i nconsistent 3 4among files. ?  *  Information must be 'organized on the basis of one D   field /, e.g. Customer Name. Try finding all   4your clients from Buffalo, for example.  ?   * %Preparing reports takes considerable 8time anTd effortG.  ?   * 7Once information has been entered, you are committed  ? to that organizational scheme.  ?   * Information is frequently -misfiled5. ÿÿÿÿÿ  With Cornerstone:+   -------------------r------'#  ?   * You enter most information- .once2, and then get to  ? look at it any way you want. ?  *  Information is "automatically updated 7 8in all 4 relevant files. ?  a ?  *  Information can be &sorted or selected 8 9on the  ? basis of any field.  ?   * Complex reports are prepared in minutes:, including  ? subtotals, totals, and calculations.  ? i   * You can  reorganize% &$your database at any point.  ? ÿÿÿÿÿ* ÿÿÿÿÿM M   FÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»  n º   8 Jº E ºH Jº   º-Cornerstone can work in conjunction with a < H Jº E ºH Jº   º2wide variety of other software programs, includingAH Jº E ºi H Jº   º 5word processors, spreadsheets, and graphics programs. D H Jº   º - <  H Jº E º H Jº   º 1You can use each program for what it does best, @ H Jº E º nH Jº   º /without having to re-enter your data each time.> H Jº E ºH Jº E ºH Jº E º H Jº E º H Jº gE ºH Jº M ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ M M ÿÿÿÿÿ ?  ? If you already have data in another database, or in any  ? of the following program s, you can transfer this  ? information directly into Cornerstone.  ? ? Cornerstone can use (import) data from:  *  7PFS: File and Report  * 9 dBase II  * 9 Lotus 1-2-3 or Symphony  * 9 the DIF fCile format (used by many spreadsheets and  ? graphics programs)   *9 the MailMerge file format (used by many mailing list  ? programs)   *9 the SDF file format (used by many minicomputers  ? and mainframes)   *9 the ASCII file format (used by a variety of computers  ? and online oinformation services) ÿÿÿÿÿ ?  ?  ? You may want to share information on a continuing or  ?  ? periodic basis with another program. ? ? For example, you can: r ?  * 5include a Cornerstone report in a larger ? word-processing document.  ?   * 5analyze Cornerstone data with a spreadsheet or  ? graphics program.  ?  ?p  ?  ? ÿÿÿÿÿ ?  ?  ?  ? Cornerstone can directly send (export) files to:  ? o  * 4 Lotus 1-2-3 or Symphony ?  * 4 programs using the DIF file format ?  * 4 programs using the SDF file format  ?    *4 prograrms using the MailMerge file format  ?   *4 most word-processing programs (ASCII format)  ?  ?  ? ÿÿÿÿÿM M a M ÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»  º ? Jº  º ? You can use Cornerstone to handle almost any type of Jº   º ;information management need. This flexibility may actuallyHº   º ;make it harder to picture how you would use it, so here areHº   t º <a few real examples of what other people are doing. Iº  º ? Jº   º *  7At Infocom, our entire personnel, inventory management, Iº   º 9 customer support, and sales tracking systems are G º   º . built with Cornerstone. <º  º ? i Jº   º*3A loan officer at a bank monitors all the paperworkE º   º 7 associated with different types of loans. E º   º / >º   º *5A consultant keeps Accounts Payable and Receivable inG º  º -Cornerstone, and uses report formats to printBoº  ºinvoices and checks.)'º  º ? Jº M ÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼ M M ÿÿÿÿÿ   > n  ?   *: A company president uses Cornerstone to look at sales  ? by product and by customer.  ?  *  0A manufacturing company uses Cornerstone for job B ? costing; calculating materials, labor needs, and ? costs for various production runs. ?  * : A physician uses Cornerstone for patient records.  ? Another physician uses Cornerstone for survey  ? analysis.  ?   *: Cornerstone was even used to monitor and analyze its  ? own testing.  ? S  ? ÿÿÿÿÿ ?  ?  ?  ?  ? We can't tell you how you'd use it. But remember, ? p ? Cornerstone has been designed to grow and change ? ? as your needs do. ?  ?  ?  ?  ? e  ?  ?  ? ÿÿÿÿÿ ?   <Data Types   <----------  ? c   * 7Strings: Up to 255 characters per value ? (expandable using multiple values) ?  *  3Numbers: 15 decimal digits of precision per field. F  4Can be displayed with commas and dollar signs. ?   * t7Dates: Over 100 different display formats.  ? Full date arithmetic.  ?   * 7Time: Over 10 different display formats.  ? Full time arithmetic...  ?  ? (more) ÿÿÿÿÿ ? r   More Data Types-   ----------------  ?   * 7Boolean: Yes/No or True/False. ?  *  7Enumerated: User-restricted set of choices, such as 7 u [red, white, blue]. Up to 255 choices, each B  4choice up to 255 characters long, yet efficiently ? stored by Cornerstone as a 1 character code.  ?   * 7Derived: Calculated from other fields in the same  ? or related files.  ?   *m 7Subrecords: Set of fields grouped as a unit within  ? a file. In effect, a file within a file.  ? ÿÿÿÿÿ  -   Features 4    =--------  ?   * 9Powerful context-specific help. Explains available ? commands, error messages, even allowable data values. ?  *  9Menu-driven command structure. Enter commands by > typing (with automatic completion) or with arrow-keys. I ? Menus can be hidden for sophisticated users.  ?   *;T Interactive report writer. Allows different formats  ? for viewing, data entry, and selection.  ?  ?  ?  ? (more) ÿÿÿÿÿ  #'   What Comes in the Box $&r   ---------------------#'  ?   * 7Beginner's Guide with 10 lessons. 5 on-disk lessons ? and 5 print-based lessons using a sample database.  *  7Owner's Handbook. Written in plain English with ? numerous examples from the sample database.  *  aQuick Reference Card. ("  *  ,"Read This First" brochure with installation ?    instructions.#% H   * 7Pre-designed Client Tracking System database (similar  ? to the database in this demonstration disk).   * 7Customer Support Plan.   * 7Keyboard template. i   * 8 "Don't Panic" button.  ? ÿÿÿÿÿ  !)  > System Requirements I   <-------------------   *9 IBM PC, PC XT, PC AT;  ? TANDY 100n0, 1200HD, or 2000;   7AT&T 6300, COMPAQ, or 100% compatible computer.  *  7Minimum 256K of memory (512K recommended).  *  72 floppy disk drives or 1 floppy and hard disk.  *  7Monochrome or color monitor.  *  7IBM PC-DOS 2.0, 2.1, 3.0 or compatible operating   system.- i  ?   *9 Recommended retail price: $495.00  ?  ? This computer-based training has been developed using  ? THE EDUCATOR (TM), a product of Spectrum Training  ? Corporation, Salem, Massachusetts. ÿÿÿÿÿ  !) n   More Features /    =-------------  ?   * 9Thorough data checking. Minimum and maximum values, ? unique values, mandatory fields, and cross-file ? checking. ?  g *  ,Complex selection criteria can be saved for =   repeated use. *  ?   * 9Powerful subtotaling, totaling and calculating  ? capabilities.  ?  ?  ?  ? ÿÿÿÿÿ subtotaling, totaling and calculating  ? capabilities.  ?  ?   ?   * 9Powerful subtotaling, totaling and calculating  ? capabilities.  ?  ?  ?  ? o ÿÿÿÿÿ  9Powerful subtotaling, totaling and calculating  ? capabilities.  ?  ?  ?  ? o  * 8Complex selection criteria can be saved for I ? repeated use.  ?   *; Powerful subtotaling, totaling and calculating  ? capabilities.  ?  ? p  ?  ? ÿÿÿÿÿ   *; Powerful subtotaling, totaling and calculating  ? capabilities.  ?  ? p *; Powerful subtotaling, totaling and calculating  ? capabilities.  ?  ?  ?  ? ÿÿÿÿÿ o