Winisis Step By Step 122d73

c ! ‘ "#

$ $% & '( )" * ' & # + ' ,-#)-## #) ## # , ' , ) ' .!" / ' 0) " ! ,1223$4566763 c

V V

c

Database Design, and Information Storage and Retrieval

j

c

Lesson 2 will answer t e following questions: Scope V at are t e four components of a VinISIS database A How do you define t e Field Definition Table (FDT) of your database A How do you create t e Vork S eets (FMT), Field Select Table (FST) and t e Display Formats (PFT) of your database A How do you modify t e FDT, FMT, FST and PFT A How do you create additional FMTs and PFTs A Finally, ow do you create & modify a library database using VinISIS A

c

j

By t e end of t e lesson you will be able to: A

Identify t e four components of a VinISIS database A Define t e FDT of your database A Create FMT, FST and PFT A Edit and modify FDT, FMT, FST and PFT A Create additional FMTs & PFTs A Create and modify a library database c

A To

create a database using VinISIS t e following components ave to be defined: Field Definition Table (FDT) Data entry works eet(s) (FMT) Display format(s) (PFT) Field Selection Table(s) (FST) c

en you open t e VinISIS program you will get t is window.

AV

c

AT

en eit er click on DATABASE on t e menu bar and t en on NEV or A Click on

c

AT

en you will get t is dialog box

A

Type t e name you wis to give your database and click OK c

AT

en you will get t e field definition table w ere you can define your fields c

8 A

T e FDT consists of six parameters for you to define t e structure of t e records in your database TYPE: 3 different types

a

REP: to define w et er t e field is repeatable or not

(Alp anumeric, Alp abetic, Numeric) can be selected by clicking on t e arrow ere

PATTERN/SUBFIELDS: to define sub fields or pattern

c

H A Once

you define all t ese parameters click on ADD

FDT wit seven fields c

H 8 A Once

you define t e FDT click on t e green ARROV at t e rig t and bottom

c

AT

H

en you will get t is dialog box A By clicking on t e buttons in t e middle you can add t e fields to t e works eet

c

H A

Help messages and t e default values can be included by clicking on

A Once

FMT is created click on t e green (forward) arrow at t e bottom

c

H AT

en you will get t is message A VinISIS system will assist you to create t e display format if you click on YES c

H AT

e system allows you to select one of t e five formats s own in t e figure AOnce you select a format t e system automatically creates it and you can move to t e next stage in t e same way as you moved from FMT to PFT c

H

A

T en you are given t e option to use t e Dictionary Assistant w ic will assists you in creating t e FST. Click on YES as s own in t e figure

T is message will be displayed w en you move from PFT

c

H A At

t is point you ave to select t e fields by clicking on t e c eckbox beside t e field name# c

H A Once

you select t e fields you can select t e tec nique for eac field by clicking on t e down arrow at t e Tec nique box

c

H

en you finis creating t e FST and move forward you will get t is dialog box

AV

AT en click on t e

TERMINATE button c

H AT

en you will get t is message and click YES

A 9



(& c

H ! AT

en you will get t is dialog box w ere you can select t e database you created and open it

c

a ë





ë

c

H " # # $! Ô

In your new database click on EDIT in t e menu bar. T en you will get t is menu of w ic t e four lines at t e bottom will allow you to edit t e FDT, FMT,PFT and FST.

Ô

By clicking on t e relevant line, t e related component will open, e.g. clicking on Field Definition Table will open t e FDT c



c