home *** CD-ROM | disk | FTP | other *** search
- *5-010
- xÇÇÅ
- rââ┘ Introduction to dBASE III PLUS
- rÑâ∙∙
- rªâ┘
- r¿â╤Session 5
- r▒â┘
- r│â∙∙
- r┤â┘
- r╢â∙Format
- r╝â┘ ö
- râäτ ├─
- röïÅIn this session you create a customized
- röìÅformat for the structure of a database å
- röÅÅfile.
- r└ÅÅ
- rñù┘ Press
- r¡ù∙──┘
- r▒ù┘ to continue or
- r─ù∙F5
- rƗ٠to exit
- q╧ÿÅS,,,,,,
- a7,G,,,,,
- a8,P,,,,&H0D,
- a8,C,M002.T,,,&H003F,
- *5-014
- xÇÇ╨
- r¥îÅ º
- r¥ìÅ When you entered data in the ToDoList
- r¥ÄÅ º
- r¥ÅÅ database file, you used the format ä
- r¥ÉÅ º
- r¥æÅ provided by dBASE III PLUS. ï
- r¥ÆÅ º
- q╧ÿÅP,6,,,,,
- a1,P,,,,,
- *5-020
- r┼æ╕───┘
- u╚É╕ î│┐
- l╟ä╕ û─
- q╧ÿ╕N,,,,,,
- a7,P,,,,,
- *5-030
- rüü╨Record No. ç 1
- rüé╨WHAT
- rüâ╨WHO
- rüä╨PHONE
- rüà╨WHEN
- rüå╨WHERE
- rüç╨ACTIVITY
- rëé╨
- rîé╨
- rìéé Ö
- rªé╨
- rìâé ₧
- rìäé ì
- rìàé ê
- rìåé Ö
- rìçémemo
- q╧ÿéP,4,,,,,
- a1,P,,,,,
- *5-040
- rñòç┌ ¬─┐
- d╧ûç│┘
- l╬ùç ¬─└
- rñûç│
- rÑûÅ Press
- r¡û ──┘
- r▒ûÅ to continue or
- r─ûçF5
- r╞ûÅ to exit
- réò╕ Ä─┐
- dÉû╕│┘
- lÅù╕ Ä─└
- uüû╕│┌
- râû╕F9 to review
- q╧ÿ╨S,,,,,,
- a7,G,,,,,
- a8,P,,,,&H0D,
- a8,C,M002.T,,,&H003F,
- a8,T,5-010,,,&H0043,
- *5-050
- xÇÇÅ
- rââ┘ Format ┼
- râäτ ├─
- röèÅIn this session, you use a new database file
- röîÅto create a customized format.
- râù╕ F9 to review
- rñù┘ Press
- r¡ù∙──┘
- r▒ù┘ to continue or
- r─ù∙F5
- rƗ٠to exit
- q╧ÿÅS,,,,,,
- a7,G,,,,,
- a8,P,,,,&H0D,
- a8,C,M002.T,,,&H003F,
- a8,T,5-010,,,&H0043,
- *5-060
- röèÅThe name of the new file is
- r░èçBusiness
- r╕èÅ. ç
- röîÅIt has been set up by a distributor of gag props
- röÄÅsuch as whoopee cushions, insect ice cubes, and
- röÉÅsquirting carnations. The name of the distributor
- röÆÅis V. F. Vase of Meckenutoc, OK.
- q╧ÿÅS,,,,,,
- a7,G,,,,,
- a8,P,,,,&H0D,
- a8,C,M002.T,,,&H003F,
- a8,T,5-010,,,&H0043,
- *5-062
- xÇÇ╨
- rüé╨ ¬═
- rüâ╨FIELDNAME
- rìâé ₧
- rüà╨FIELDNAME
- rìàé Å
- rüç╨FIELDNAME
- rìçé ì
- rüë╨ ┤─
- rüè╨FIELDNAME
- rìèé ¿
- rüï╨FIELDNAME
- rìïé / /
- rüî╨FIELDNAME
- rìîé à .
- rüì╨FIELDNAME
- rììé?
- r£ÄÅ «
- r£ÅÅ The format you create will look like this.
- r£ÉÅ «
- rºôç ¬
- rüö╕┌ Ä─┐
- rºöÅ Press
- r»ö ──┘
- r│öÅ to continue or
- r╞öçF5
- r╚öÅ to exit
- rüò╕│ F9 to review │
- rºòç ¬
- rüû╕└ Ä─┘
- rüùé É ║<A:>║BUSINESS Å ║Rec: Å ║ å ║ ç
- q╧ÿ╨S,,,,,,
- a7,G,,,,,
- a8,P,,,,&H0D,
- a8,C,M002.T,,,&H003F,
- a8,T,5-010,,,&H0043,
- *5-064
- xÇÇÅ
- rââ┘ Format ┼
- râäτ ├─
- ræëÅCustomized formats are useful for making different
- ræïÅpresentations of the information in a database file.
- rüùÅ
- râù╕ F9 to review
- rñù┘ Press
- r¡ù∙──┘
- r▒ù┘ to continue or
- r─ù∙F5
- rƗ٠to exit
- q╧ÿÅS,,,,,,
- a7,G,,,,,
- a8,P,,,,&H0D,
- a8,C,M002.T,,,&H003F,
- a8,T,5-010,,,&H0043,
- *5-066
- ræëÅLike the paper forms used in offices, customized
- ræïÅformats have many uses: ₧
- ræìÅ ä
- ròìç∙
- rûìÅ inventory sheet for the reordering of
- rÿÄÅpopular products
- ròÉç∙
- rûÉÅ support material for a monthly sales report
- ròÆç∙
- rûÆÅ fact sheet, or employee application
- q╧ÿÅS,,,,,,
- a7,G,,,,,
- a8,P,,,,&H0D,
- a8,C,M002.T,,,&H003F,
- a8,T,5-010,,,&H0043,
- *5-067
- råçç┌ ö─┬ å─┐
- råêç│INVOICE
- r¢êç│ Date
- róêç│
- råëç╞ ö═╧ å═╡ ç
- r¬ëÅYou can use dBASE III PLUS to å
- råèç│Customer name
- róèç│
- råïç│and address É │ ç
- r¬ïÅcreate a customized invoice.
- råîç├ ¢─┤
- råìç│
- rêìçItems ordered ï_
- róìç│ ç
- r¬ìÅ Ö
- råÄç│
- rùÄç ï │ ç
- r¬ÄÅIn it, you include only that à
- råÅç│
- rêÅçItems sent
- rûÅç ï_
- róÅç│
- råÉç│
- ròÉç ì │ ç
- r¬ÉÅinformation which applies to
- råæç│
- rêæçCost
- rûæç ï_
- róæç│
- råÆç│
- ròÆç ì │
- rñÆç å
- r¬ÆÅthat particular invoice.
- råôç│
- rêôçAmount due
- rûôç ï_
- róôç│
- råöç└ ¢─┘
- q╧ÿÅS,,,,,,
- a7,G,,,,,
- a8,P,,,,&H0D,
- a8,C,M002.T,,,&H003F,
- a8,T,5-010,,,&H0043,
- *5-068
- råçÅ á
- råêÅ ï
- r¢êÅ ê
- råëÅ ï You can design a format to present the information
- r┼ëÅ
- råèÅ Ä
- róèÅ
- råïÅ ï in your database file for your specific needs. ç
- råîÅ ¥
- råìÅ ╕
- råÄÅ ï
- rÿÄÅ æ
- r¬ÄÅ £
- råÅÅ î
- rûÅÅ ì
- råÉÅ ï
- ròÉÅ «
- r─ÉÅ
- råæÅ ï
- ròæÅ «
- råÆÅ ï
- ròÆÅ »
- råôÅ î
- rûôÅ ì
- råöÅ ¥
- q╧ÿÅS,,,,,,
- a7,G,,,,,
- a8,P,,,,&H0D,
- a8,C,M002.T,,,&H003F,
- a8,T,5-010,,,&H0043,
- *5-070
- ræëÅThe format you are about to design for the Business
- ræïÅdatabase file, is a form which will be used by the
- ræìÅMarketing Department.
- ræÉÅIt will provide Marketing with the information
- ræÆÅnecessary to compile lists of the biggest buyers
- ræöÅof gag props.
- q╧ÿÅS,,,,,,
- a7,G,,,,,
- a8,P,,,,&H0D,
- a8,C,M002.T,,,&H003F,
- a8,T,5-010,,,&H0043,
- *5-072
- ròëÅBusiness database file contains more information ç
- ræïÅabout each customer
- rÑïÅthan Marketing needs to know.
- ræìÅ ò
- ræÄÅFor example, the address of the customer is irrelevant
- ræÉÅto this application. Therefore, you will not include
- ræÆÅthe address in the new form. ò
- ræöÅ ì
- q╧ÿÅS,,,,,,
- a7,G,,,,,
- a8,P,,,,&H0D,
- a8,C,M002.T,,,&H003F,
- a8,T,5-010,,,&H0043,
- *5-074
- ræëÅThe format you create is stored in a new file, å
- ræïÅseparate from the Business database file. Just like
- ræìÅwhen you created ToDoSort from ToDoList, dBASE III PLUS
- ræÄÅ ╢
- ræÅÅwill ask you for a new file name. The name of the new
- ræÉÅ ╢
- rææÅformat file is
- ráæçMarket
- rªæÅ. á
- ræÆÅ ╢
- q╧ÿÅS,,,,,,
- a7,G,,,,,
- a8,P,,,,&H0D,
- a8,C,M002.T,,,&H003F,
- a8,T,5-010,,,&H0043,
- *5-078
- xÇÇ╨
- rüä╨A>
- rùäÅ ñ
- rùàÅ To begin creating the new format,
- rùåÅ ñ
- rùçÅ type
- rč dbase
- rñçÅ ù
- rùêÅ ñ
- rùëÅ æ then press
- r┤ë ──┘
- r╕ëÅ
- rùèÅ ñ
- qâä╨K,,10A/I,,,, è
- a7,G,,,,,
- a8,C,M502.T,,,dbase à ,
- a8,C,M502.T,,,dBASE à ,
- a8,C,M502.T,,,DBASE à ,
- a8,C,M502.T,,,dBase à ,
- a8,C,M502.T,,,Dbase à ,
- a8,C,M502.T,,,dbase à ,
- a8,C,M502.T,,,dBASE à ,
- a8,C,M502.T,,,DBASE à ,
- a8,C,M502.T,,,d