*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.