PHARMACY_MANAGEMENT_PROJECT_Ahmad_Ibitoy.docx

PHARMACY MANAGEMENT SYSTEM BY IBITOYE AHMAD ADEWALE ADEWALE REG EG.. NO NO: 0828 082830 3006 06

SUBMITTED TO THE DEPARTMENT OF COMPUTER SCIENCE FACULTY OF SCIENCE UNIVERSITY OF ABUJA FCT-ABUJA NIGERIA

 IN PARTIAL FULFILMENT FOR THE RE!UIREMENTS OF THE AWARD OF BACHELOR OF SCIENCE DEGREE "B.SC# IN COMPUTER SCIENCE

APRIL 20$3

CERTIFICATION

1

This is to certify that this research work was carried out by IBITOYE AHMAD ADEW ADEWA ALE with with regi regist stra rati tion on nub nuber er !"#" !"#"$! $!!% !% of the De&a De&art rt ent ent of  'OM()TE* +'IE,'E under the su&er-ision of M*+ O.B. I+HOLA.

 /////////////////////

///////////////////// 

M*+ O.B I+HOLA

DATE DATE

0(*O1E'T +)(E*2I+O*3

 /////////////////////

///////////////////// 

D*. M.B. M.B . HAMMAW HAM MAWA A

DATE

0HEAD O4 DE(A*TME,T3 DE(A*TME,T3

 ///////////////////// 

 ///////////////////// 

E5TE*,AL +)(E*2I+O*

DATE

2

AC%NOWLEDGMENT

My &rofound &rofound gratitude gratitude to A6ighty A6ighty A66ah A66ah for the know6edge7 wisdo and understanding that he bestowed on e to carry out this &ro8ect.

I a&&reciate y su&er-isor Mrs O.B. Isho6a for the su&er-ision and su&&ort that she ga-e7 which he6&ed the &rogression and soothness of the &ro8ect. The co9o&eration is uch indeed a&&reciated.

My gratefu6 thanks a6so go to the Entire 'o&uter science de&artent of the )ni-ersity of Abu8a7 the H.O.D Dr. M.B Haawa and a66 6ecturers who &re&ared e fro the base of co&uter science.

I wi66 a6so 6ike to a&&reciate y friends: I 6o-e you a66.

+&ecia6 thanks a6so to y &arents: A6ha8i +.A Ibitoye7 Ha8iya A.B. Ibito Ibitoye ye and and Ha8i Ha 8iya ya Aisha isha Ibito Ibitoye ye who who enco en coura urage ged d su&& su&&ort orted ed and an d he6&ed e financia66y7 &rayerfu66y and ora66y throughout this &ro8ect. May the A6ighty A66ah b6ess you a66 and kee& you a66 to en8oy the fruit of your 6abour In shaa A66ah.

3

ABSTRACT

This &ro8ect is insight into the design and i&6eentation of a (haracy Manageent +yste. The &riary ai of is to i&ro-e accuracy and enhance safety and efficiency in the &haraceutica6 store. Today anageent is one of  the ost essentia6 features of a66 for. Manageent &ro-ides so&histication to  &erfor any kind of task in a &articu6ar for. This is &haracy anageent syste: it is used to anage ost &haracy re6ated acti-ities in the &haracy.

4

TABLE OF CONTENT

'O2E* (A;E 'E*TI4I'ATIO, ...................................................................................................... I A'<,OWLED;ME,T............................................................................................ II AB+T*A'T............................................................................................................III TABLE O4 'O,TE,T...........................................................................................................I2 TABLE O4 4I;)*E+.............................................................................................................2I LI+T O4 TABLE+..................................................................................................................2II CHAPTER ONE INTRODUCTION....................................................................................=

=.!

I,T*OD)'TIO,...........................................................................................................=

=.=

BA'<;*O),D O4 THE +T)DY...............................................................................=

=.#

+TATEME,T O4 THE (*OBLEM...............................................................................#

=.$

AIM+ A,D OB1E'TI2E+.............................................................................................#

=.>

+'O(E A,D LIMITATIO,...........................................................................................$

=.?

*E+EA*'H METHODOLO;Y....................................................................................>

=.%

DE4I,ITIO, O4 TE*M+..............................................................................................>

=.@

'HA(TE* LAYO)T.....................................................................................................?

CHAPTER TWO LITERATURE REVIEW.......................................................................%

#.!

I,T*OD)'TIO,...........................................................................................................%

#.=

(HA*MA'Y (*A'TI'E I, THE (A+T......................................................................%

#.#

THE (*E+E,T DAY (HA*MA'Y............................................................................=>

#.$

THE 4)T)*E O4 (HA*MA'Y ....................................................................17

#.>

BE,E4IT+ O4 THE (*O(O+ED +Y+TEM...............................................................#!

CHAPTER THREE

SYSTEM ANALYSIS AND DESIGN............................................#=

$.!

I,T*OD)'TIO,.........................................................................................................#=

$.=

+Y+TEM A,ALY+I+ ................................................................................... 21

$.=.=

A,ALY+I+ O4 E5I+TI,; +Y+TEM.............................................................22

$.#

*E)I*EME,T+ DE4I,ITIO, ...................................................................23

$.#.=

METHOD O4 I,4O*MATIO, ;ATHE*I,; .................................................23

$.$

+Y+TEM DE+I;, ....................................................................................... 24

$.>

+Y+TEM MODELLI,; ...............................................................................25

5

$.?

+Y+TEM 4LOW'HA*T..............................................................................25

$.?

DATABA+E DE+I;, ....................................................................................38

CHAPTER FOUR

SYSTEM IMPLEMENTATION.....................................................>#

>.!

I,T*OD)'TIO,.........................................................................................................>#

>.=

'HOI'E O4 (*O;*AMMI,; LA,;)A;E.................................................42

>.$

+Y+TEM DO')ME,TATIO,....................................................................................>>

>.>

HA*DWA*E *E)I*EME,T..................................................................................>>

>.%

DATABA+E +(E'I4I'ATIO,....................................................................................>?

>.@

MOD)LE DE+'*I(TIO,...........................................................................................>?

>."

+Y+TEM MAI,TE,A,'E.........................................................................................?$

CHAPTER FIVE

CONCLUSION AND RECOMMENDATION.................................??

?.!

+)MMA*Y..................................................................................................................??

?.=

'O,'L)+IO,.............................................................................................................??

?.#

*E''OMME,DATIO,..............................................................................................?% *E4E*E,'E+.............................................................................................................?@ A((E,DI5..?"

6

LIST OF FIGURES 4igure. $.$.=

Waterfa66 Mode6 Of +yste De-e6o&ent Life 'yc6e.#>

4igure $.?.=

+tructure 'hart.#@

4igure $.?.#

+yste f6owchart..#"

4igure $.?.$

Adin f6owchart..#C

4igure $.?.>

+u&er-isor 46owchart...$!

4igure $.?.?

+taff f6owchart..$=

4igure >.=

Hoe&age.....>?

4igure >.#

Adin Login Menu..>%

4igure >.$

+u&er-isor Login..>@

4igure >.>

+taff Login>"

4igure >.?

Adin Menu Modu6e..>C

4igure >.%

Drug *egistration 4or...?!

4igure >.@

+taff registration for..?=

4igure >."

+tore Manager..?#

4igure >.C

+a6es window?$

7

LIST OF TABLES

Tab6e $.=

Adinistrator Login Tab6e.. $"

Tab6e $.#

Drug inforation Tab6e....$C

Tab6e $.$

+u&er-isor Login Tab6e>!

Tab6e $.>

+taff Login Tab6e >!

Tab6e $.?

+taff inforation Tab6e>=

CHAPTER ONE

$.0

INTRODUCTION

(haracy anageent syste is a anageent syste that is designed to i&ro-e accuracy and to enhance safety and efficiency in the &haraceutica6 store. It is a co&uter based syste which he6&s the (haracist to i&ro-e in-entory anageent7 cost7 edica6 safety etc. The syste a66ows the user to enter a anufacturing and e&iry date for a &articu6ar   &roduct or drug during o&ening stock and sa6es transaction. The syste wi66 a6so gi-e re&ort showing the 6ist of &roducts e&iry after a s&ecified date before the &roduct e-entua66y e&ires. It a6so in-o6-es anua6 entry u&on arri-a6 of new batches of drugs and u&on drug o-eent out of the &haracy for a certain &eriod7 e.g. e-ery onth7 the &haracist ay want to generate re&ort for the o-eent of drugs in and out of  the &haracy7 getting inforation about the drugs e.g. e&iry date7 date &urchased7 nuber of drug ty&e 6eft7 6ocation of a drug in the &haracy.

8

At &resent7 anua6 syste is being uti6ied in the &haracy. It reFuires the &haracist to anua66y onitor each drug that is a-ai6ab6e in the &haracy. This usua66y 6eads to istakes as the work6oad of the &haracist increases.

$.$

BAC%GROUND OF THE STUDY

Due to the sie and Fua6ity ser-ice of the &haracy7 the &haracy has a -ery 6arge custoer base. These custoers tend to -isit the &haracy for ser-ices ost6y when they c6ose fro work. At this &eriod7 the nuber of custoers that &atronise the  &haracy is on the increase7 thereby aking the work6oad of the &haracists uch ore tedious. This case akes it difficu6t for the &haracist to attend to custoers in a short &eriod. Meanwhi6e the &haracist has to ensure satisfaction in ser-ices to kee& their  custoers. The factors entioned abo-e7 resu6ts in de6ay of the ser-ices being rendered to the custoers7 thereby s6owing down sa6es and risk 6osing -a6uab6e custoers in the 6ong run.

$.2

STATEMENT OF THE PROBLEM

(haracy anageent has ke&t &a&er record in fi6ing cabinets. Managing a -ery 6arge &haracy with records on &a&ers wi66 be tedious and difficu6t to kee& track of  in-entories with regards to the drugs in the store7 e&iry date7 Fuantity of drugs a-ai6ab6e based on the categories and their functions. The &haracist has to order drugs to re&6enish the a6ready diinishing stock. In addition7 ordering of drugs is being carried out anua66y. +ignificant aount of tie is a66ocated for writing the order as the &haracist needs to go through the stock   ba6ance and ake rough estiate of the aount to order based on 4igures.

2

Drugs are not su&&osed to be used after they ha-e e&ired. This &ro8ect work wi66  &ro&t the &haracist about drugs that are c6ose to e&iry7 &re-enting those drugs fro being so6d and a6so &ro-iding so6ution to the ear6ier stated &rob6es.

$.3

AIMS AND OBJECTIVES

The ai of this &ro8ect is to de-e6o& a software for the effecti-e anageent of a  &haraceutica6 store that wi66 be ab6e to achie-e the fo66owing ob8ecti-esG

$.&

-

Ensuring effecti-e &o6icing by &ro-iding statistics of the drugs in stock. Maintaining correct database by &ro-iding an o&tion to u&date the drugs in

-

stock. I&ro-ing the efficiency of the syste by ensuring effecti-e onitoring of 

-

ser-ices and acti-ities. To &ro-ide o&tia6 drug in-entory anageent by onitoring the drug

-

o-eent in the &haracy. To ensure that there eists a 6e-e6 of restricted access based on functiona6ity

-

and ro6e. To ensure that the syste is user friend6y. To be ab6e to generate re&ort within a s&ecified &eriod of tie.

SCOPE AND LIMITATION

The sco&e of this &ro8ect is 6iited to the acti-ities of a &haraceutica6 store which inc6udes wi66 i&ro-ing hea6th outcoes7 reduce hos&ita6 and 6ong ter care adissions7 enhance access and care in the Estate and surrounding counities and ensuring best use of resources7 the use of a co&uter based anageent syste for  i&ro-ing the efficiency of a &haracy is needed and it is an essentia6 &art of any odern continuous6y e-o6-ing society.

3

The syste wi66 not be ab6e to hand6e drug &rescri&tion7 drug to drug interaction. The syste wi66 not be ab6e to hand6e contraindication and &o6y&haracy in a &rescri&tion: this i&6ies that these ser-ices wi66 be anua66y co&6eted by the &haracist.

$.'

RESEARCH METHODOLOGY

The research ethod used for this &ro8ect work gi-es a descri&tion of how the  &haracy anageent syste for Boniks (haracy and stores7 ;wari&a Estate7 Abu8a wi66 be de-e6o&ed. Therefore the ethod used in the design and co66ections of inforation fro -arious sources are as fo66owsG

-

+tudying the &resent syste in detai6 and the organiationa6 sty6e.
-

syste. A Fua6itati-e for of inter-iew was conducted in the organiation to

-

understand the ode of o&eration of the o6d syste. (riary dataG This source has to do with the tet book contacted for the de-e6o&ent of this &ro8ect.

$.6

DEFINITION OF TERMS S()*+, G Is the co&6e &ur&osefu6 co66ection of interre6ated co&onents that work 

together to take soe ob8ecti-es. D/ 1*+*41: is a situation in which a substance 0usua66y another drug3 affects

the acti-ity of a drug when both are adinistered together. P45(7,( G is the use of u6ti&6e edications by a &atient7 es&ecia66y when too

any fors of edication are used by a &atient7 i.e. when ore drugs are &rescribed than is c6inica66y warranted.

4

C41*1*41G is the condition or factor that ser-es as a reason to withho6d a

certain edica6 treatent.

$.9

CHAPTER LAYOUT

The cha&ter 6ayout of this &ro8ect is out6ined in a seFuentia6 anner starting with 'ha&ter one which consists of the Introduction7 Background of the study7 +tateent of  the &rob6e7 Ais and ob8ecti-es7 +ignificance of study7 *esearch ethodo6ogy7 +co&e7 Liitation7 and Definition of ters. 'ha&ter two consist of introduction7 Literature re-iew of the &ro8ect7 an o-er-iew of   &haracy anageent in the &ast7 at &resent and a6so inc6ude the benefits of   &haracy anageent. 'ha&ter three dea6s with the ana6ysis of the eisting syste under which descri&tion of the current syste wi66 be ana6ysed7 &rob6es of eisting syste7 descri&tion of the  &ro&osed syste and the ad-antages of the &ro&osed syste. 'ha&ter four consists of syste design7 syste i&6eentation and syste docuentation under the syste design7 the syste design wi66 ha-e in&ut and out&ut design. 'ha&ter fi-e wi66 inc6ude suary7 conc6usion and recoendation. It consists of the suary of the &ro8ect re&ort7 recoendation based on the research done on the  &ro8ect and conc6usion.

5

CHAPTER  TWO

LITERATURE REVIEW

2.0

INTRODUCTION

A &haracist is a edica6 &rofessiona6 who dis&enses drugs to &atients according to a  &rescri&tion ordered by a &hysician or other c6inician. (haracists ha-e an in9de&th know6edge of the cheistry of -arious drugs and how they react in huans7 and a6so how drugs interact with each other 0'har6es E. *osenberg7 =C"!3. (haracists ust accurate6y easure and &ackage edicine7 ensuring its dosage and safety to be adinistered &ro&er6y to a &atient. Whi6e the &haracist does not ty&ica66y se6ect or   &rescribe the edication7 the &haracist educates the &atient on how to take the edication and what reactions or &rob6es to be a-oided. As edication e&erts7 &haracists are concerned with safeguarding the &ub6ics hea6th in atters re6ating to edication distribution and use and disease state anageent. (haracists &6ay a -ita6 ro6e in i&ro-ing &atient care through the edicine and inforation they &ro-ide.

2.$

PHARMACY PRACTICE IN THE PAST

This gi-es an o-er-iew of e-ents that ha-e occurred in &haracy &ractice through se-era6 ages both in the &ast and &resent7 and a6so indicates &ossib6e e-ents of the future.

6

2.$.$

T7+ H)*4( 4 P7,(

As 6ong as there ha-e been societies7 there ha-e been s&ecia6ists and &hysicians whose so6e &ur&ose was to &re&are and adinister edicina6 treatents. The ear6iest hea6ers engaged in what is now ca66ed (haracognosy7 which is the study and a&&6ication of   &6ants and herbs for hea6ing. E-idence that ear6y an used &haracognosy to treat i66ness is indis&utab6e7 with archaeo6ogica6 disco-eries attesting to the fact &re9dating e-en the de-e6o&ent of faring or ania6 husbandry. The beginnings of &haracy are ancient. When the first &erson e&ressed 8uice fro a succu6ent 6eaf to a&&6y to a wound7 this art was being &racticed. In the ;reek 6egend7 Asc6e&ius7 the god of the hea6ing art7 de6egated to Hygeia the duty of co&ounding his reedies. +he was his a&othecary or &haracist. The &hysician9&riests of Egy&t were di-ided into two c6assesG those who -isited the sick and those who reained in the te&6e and &re&ared reedies for the &atients 0Hoan7 #!!"3. The &haracy &rofession can be traced back at 6east as far as the +uerian  &o&u6ation7 6i-ing in odern day IraF fro around >!!! B'7 they used edicina6  &6ants such as 6iFuorice7 ustard7 yrrh7 and o&iu. There were se&arate &eo&6e who worked to &re&are edicines7 as a se&arate ro6e fro diagnosis and treatent which was carried out by edics. These &recursors to &haracists a6so cobined their ro6e with that of a &riest. The +uerians wrote the ear6iest sur-i-ing &rescri&tions fro at 6east #@!! B.'.  so near6y ?!!! years ago 0;riggs7 =CCC3. The Ancient Egy&tians had s&ecific &re&arers of edicine7 known as (asto&hor. (haracy was -iewed as a high status branch of edicine7 and again7 6ike the +uerians7 these &haracists were a6so &riests who worked and &ractised in the te&6es 0Anderson7 #!!?3.

7

4ro sur-i-ing &a&yrus scro66s7 notab6y the Ebers (a&yrus which dates fro =?!! B'7 we know that the Egy&tians ade and used infusions7 ointents7 6oenges7 su&&ositories7 6otions7 eneas7 and &i66s. The

Ebers

(a&yrus

inc6udes "@?

 &rescri&tions and @!! drugs. Meanwhi6e7 in 'hina in about the sae era 0#!!! B'37 a an ca66ed +hen ,ung wrote the first nati-e herba67 which contained descri&tions of  $%? &6ant9based drugs 0Anderson7 #!!?3. +ta66s and sho&s se66ing edicina6 goods eisted around =C!! B.'. in the town of  +i&&ara on the Eu&hrates *i-er. Howe-er7 the ear6iest recorded sho& dea6ing with sa6es of edicines in London was o&ened in =$>?. In ancient ;reece and *oe and during the idd6e Ages in Euro&e7 the art of hea6ing recognied a se&aration between the duties of the &hysician and those of the herba6ist7 who su&&6ied the &hysician with the raw ateria6s fro which to ake edicines. The Arabian inf6uence in Euro&e during the "th century had howe-er brought about the &ractice of se&arate duties for the &haracist and &hysician. The trend toward s&ecia6iation was 6ater reinforced by a 6aw enacted by the city counci6 of Bruges in =%"$7 forbidding &hysicians to &re&are edications for their &atients. In Aerica7 Ben8ain 4rank6in took a &i-ota6 ste& in kee&ing the two &rofessions se&arate when he a&&ointed an a&othecary to the (ennsy6-ania Hos&ita6. The de-e6o&ent of the &haraceutica6 industry since Wor6d War II 6ed to the disco-ery and use of new and effecti-e drug substances. It a6so changed the ro6e of the  &haracist. The sco&e for ete&oraneous co&ounding of edicines was uch diinished and with it the need for the ani&u6ati-e ski66s that were &re-ious6y a&&6ied by the &haracist to the &re&aration of &i66s7 &6asters7 and &otions 0*osenberg7 #!!"3.

8

The &haracist continues7 howe-er7 to fu6fi6 the &rescriberJs intentions by &ro-iding ad-ice and inforation: by foru6ating7 storing7 and &ro-iding correct dosage fors: and by assuring the efficacy and Fua6ity of the dis&ensed or su&&6ied edicina6  &roduct. 2.$.2

O/1 1 D+;+54,+1* 4 P7,(

Before the dawn of history ancient an 6earned fro instinct7 fro obser-ation of   birds and beasts. 'oo6 water7 a 6eaf7 dirt7 or ud was his first soothing a&&6ication. By tria67 he 6earned which ser-ed hi best. E-entua66y7 he a&&6ied his know6edge for the  benefit of others 0Mathews7 =C%#3. P7,( 1 1+1* B<(541G Baby6on7 8ewe6 of ancient Meso&otaia7 often

ca66ed the crad6e of ci-i6iation. It &ro-ides the ear6iest known &ractice of the art of the a&othecary. (ractitioners of hea6ing of this era 0about #%!! B.'.3 were &riest7  &haracist and &hysician7 a66 in one. P7,( 1 1+1* C71G 'hinese (haracy stes fro +hen ,ung 0about #!!!

B.'.37 an e&eror who sought out and in-estigated the edicina6 -a6ue of se-era6 hundred herbs. Medicina6 &6ants inc6ude &odo&hy66u7 rhubarb7 ginseng7 straoniu7 cinnaon bark7 e&hedra etc. D() 4 *7+ P() E<+):  K(a&yrus EbersK 0=?!! B.'.3 is the best known and ost

i&ortant &haraceutica6 record. It is a co66ection of "!! &rescri&tions entioning @!! drugs. T7+47)*) - F*7+ 4 B4*1(:  Theo&hrastus 0about $!! B.'.37 was the greatest

ear6y ;reek &hi6oso&hers and natura6 scientists7 is ca66ed the Kfather of botany.K His

9

obser-ations and writings dea6ing with the edica6 Fua6ities and &ecu6iarities of herbs are unusua66y accurate7 e-en in the 6ight of &resent know6edge. T+ S/55* - A1 E5( =T+,>+= D/: Man 6earned ear6y of the

 &restigious ad-antage of tradearks as a eans of identification of source and of  gaining custoers confidence. One of the first thera&eutic agents to bear such a ark  was Terra +igi66ata 0+ea6ed Earth37 a c6ay tab6et originating on the Mediterranean is6and of Lenos before ?!! B.'. 0;eorge A. Bender7 =C%@3 D4)4+) - A S+1*)* L44>) A* D/): (edanios Dioscorides 0first century

A.D.37 contributed ighti6y to such a transition in (haracy. He obser-ed7 recorded and s&read the ece66ent ru6es for co66ection of drugs7 their storage and use. His tets were considered basic science as 6ate as the siteenth century. G5+1 - E?+,+1*+ I1 D/ C4,411/: He &racticed and taught both

(haracy and Medicine in *oe. His &rinci&6es of &reå and co&ounding edicines ru6ed in the Western wor6d for =7?!! years: and his nae sti66 is associated with that c6ass of &haraceutica6s co&ounded by echanica6 eans 9 ga6enica6s. He was the originator of the foru6a for a co6d crea. D,1 A1 C4),) - P7,(@) P*41 S1*): twin shi& of the hea6th

 &rofessions7 (haracy and Medicine7 is &ortrayed by Daian7 the a&othecary7 and 'osas7 the &hysician. M41)* P7,(:  During the idd6e ages renants of the western know6edge of 

 &haracy and edicine were &reser-ed in the onasteries 0fifth to twe6fth centuries3. Manuscri&ts fro any is6ands were trans6ated or co&ied for onastery 6ibraries. The onks gathered herbs and raised the in their own herb gardens. These they &re&ared

10

according to the art of the a&othecary for the benefit of the sick and in8ured. ;ardens such as these sti66 ay be found in onasteries in any countries. T7+ F)* A4*7+( S74): The Arabs se&arated the arts of a&othecary and

 &hysician7 estab6ishing in Bagdad 6ate in the eighth century the first &ri-ate6y owned drug stores. They &reser-ed uch of the ;reco9*oan wisdo de-e6o&ing with the aid of their natura6 resources syru&s7 confections7 conser-es7 disti66ed waters and a6coho6ic 6iFuids. A;+11 - T7+ =P+)1 G5+1=:  Aong the bri66iant contributors to the sciences of 

(haracy and Medicine during the Arabian era was one genius who sees to stand for his tie 9 the (ersian7 Ibn +ina 0about C"!9=!$@ A.D.37 ca66ed A-icenna by the Western wor6d. He was a (haracist7 &oet7 &hysician7 &hi6oso&her and di&6oat. He ga-e contribution to the sciences of &haracy and edicine by his &haraceutica6 teachings. S+*41 4 P7,( A1 M+1+:  In Euro&ean countries7 &ub6ic &haracies

 began to a&&ear in the =@th century. In +ici6y and southern Ita6y7 &haracy was se&arated fro Medicine. T7+ F)* O5 P7,44+: The idea of a &haraco&oeia with officia6 status7

to be fo66owed by a66 a&othecaries7 originated in 46orence. The ,uo-o *ece&tario7 origina66y written in Ita6ian7 was &ub6ished and becae the 6ega6 standard for the city9 state in =>C". T7+ S4+*( 4 A4*7++) 4 L4141: In =%=@7 4rancis Bacon 0&hi6oso&her9

 &o6itician3 fored a se&arate co&any known as the KMaster7 Wardens and +ociety of 

11

the Art and Mystery of the A&othecaries of the 'ity of LondonK. This was the first organiation of &haracists in the Ang6o9+aon wor6d 0Mathews7 =C%#3. S7++5+ - G+*+)* 4 *7+ P7,)*)-C7+,)*):  During his few short years7 'ar6

Wi6he6 +chee6e ga-e to the wor6d disco-eries that ha-e brought its &eo&6e inca6cu6ab6e ad-antages. He ade thousands of e&erients7 disco-ered oygen7 ch6orine7 &russic acid7 tartaric acid7 tungsten7 o6ybdenu7 g6ycerine7 nitro9g6ycerine7 and count6ess other organic co&ounds that enter into todays dai6y 6ife7 industry7 hea6th7 and cofort. T7+ A,+1 P7,+*5 A))4*41: )nder 6eadershi& of its first (resident7

Danie6 B. +ith7 and first +ecretary7 Wi66ia (rocter7 1r.7 the twenty de6egates 6aunched The Aerican (haraceutica6 Association and o&ened ebershi& to KA66  &haracists and druggistsK of good character who subscribed to its 'onstitution and to its 'ode of Ethics. The Association continues to ser-e (haracy today 0Bender7 =C%@3. E4+1 A1 A,+1 P7,( M++*: Euro&ean and Aerican (haracy

grou&s et for the first tie7 at the +econd Internationa6 'ongress of (haracy in (aris7 4rance in ="%@.

2.$.3

S4,+ >+( *+) 1 P7,( 7)*4(

="#!

The a6ka6oid Fuinine was first etracted fro the bark of cinchona trees  by two 4rench cheists7 (ierre 1ose&h (e66etier and 1ose&h Bienae 'a-entou.

="@>

Diaor&hine or Heroin was first synthesised fro or&hine.

12

=""$

4irst edition of The Etra (haraco&oeia &ub6ished7 edited by Wi66ia Martinda6e and Dr Wynn Westcott.

="CC

As&irin7 was 6aunched by the ;eran co&any.

=C=!

+a6-arsan7 the first agic bu66et drug7 effecti-e against sy&hi6is was disco-ered by (au6 Ehr6ich and Dr +ahachiro Hata.

=C=?

Medicine sta& duty was doub6ed as a wartie fundraiser.

=C=@

The 2enerea6 Disease Act &rohibited the ad-ertising of edicines for  2D and se66ing itures containing schedu6ed substances.

It

introduced the conce&t of &rescri&tion on6y edicines. =C##

The Dangerous Drugs Act regu6ated the i&ort and sa6e of &otentia6 drugs of addiction inc6uding the deri-ati-es of o&iu7 cocaine and cannabis so wide6y used in &ro&rietary reedies.

=C#"

(enici66in disco-ered by A6eander 46eing.

=C$"

The 4ood and Drugs Act &rohibited the adu6teration and is6abe66ing of drugs.

=C$C

The 'ancer Act restricted the ad-ertiseent of &roducts c6aiing to treat cancer.

=C>!

)nder the 4inance 0,o. #3 Act &urchase ta was i&osed on a range of  goods inc6uding ost drugs and edicines.

=C>=

The (haracy and Medicines Act re&ea6ed the o6d edicine sta& duty. It forbade the genera6 ad-ertiseent of &roducts c6aiing to treat a nuber of s&ecific i66nesses inc6uding Brights disease7 cataract

13

e&i6e&sy and TB7 or to be effecti-e in &rocuring an abortion. 4or the first tie anufacturers were reFuired to 6ist the acti-e ingredients of   &roducts on their &ackaging. =C>"

The ,ationa6 Hea6th +er-ice ade &rescri&tion edicine a-ai6ab6e to a66. )nti6 the introduction7 in the =C?!s7 and subseFuent hefty increasing of &rescri&tion charges7 &ro&rietary edicines were no 6onger seen as a chea& a6ternati-e to seeing the doctor.

=C%=

Ibu&rofen was f irst s ynthesised b y a tea at t he B oots ( ure D rug 'o&any in Deceber.

=C%>

Introduction of Ad-erse Drug *eaction ye66ow card schee in res&onse to the tha6idoide tragedy of =C%=.

2.2

THE PRESENT DAY PHARMACY

The odern drugstore -aries significant6y fro its ancient counter&arts. Whi6e the  &ro&rietors of &haracies in the far distant &ast were often aking nuerous edica6 decisions 9 diagnosing and treating &atients without the consu6tation of &hysicians 9  &haracists in the odern drugstore are tasked instead with the res&onsibi6ity of  e-a6uating the a&&ro&riateness and anaging the dis&ensation of &haraceutica6s  &rescribed to &atients under a doctors care. Aong the ost i&ortant of &haracist  8obs is assuring that the &atient has not been &rescribed two drugs which wi66 ha-e an ad-erse interaction. An in9de&th study of &haraco6ogy is reFuired to ake such e-a6uations and in a66 states such &ositions are high6y regu6ated and reFuire testing  before the issuance of a &haracists 6icense.

14

4ar fro being 8ust a c6erk behind a counter7 &haracists a6so &6ay a ro6e in disease anageent and e-a6uation of test resu6ts. In hos&ita6s7 &haracists are often in the ro6e of inter&reting cheica6 signatures in co&6e test resu6ts and ad-ising  &hysicians on treatent o&tions as we66 as aking doctors aware of new and &ossib6y ore effecti-e drugs. Many &eo&6e interested in a career as a &haracist ha-e found that in recent ties it is a Fuite re6iab6e &rofession in ties of econoic hardshi&. Earnings for &rofessiona6  &haracists continue to rise whi6e the industry for new and returning workers is Fuite robust. 2.2.$

H4 *4 B+4,+  P7,)* - E*41 1 T11/

The history of &haraceutica6 education has c6ose6y fo66owed that of edica6 education. As the training of the &hysician underwent changes fro the a&&renticeshi& syste to fora6 educationa6 courses7 so did the training of the &haracist. The first co66ege of &haracy was founded in the )nited +tates in ="#= and is now known as the (hi6ade6&hia 'o66ege of (haracy and +cience. Other institutes and co66eges were estab6ished soon after in the )nited +tates7 ;reat Britain7 and continenta6 Euro&e. 'o66eges of &haracy as inde&endent organiations or as schoo6s of uni-ersities now o&erate in ost de-e6o&ed countries of the wor6d. The course of instruction 6eading to a bache6or of science in &haracy etends at 6east fi-e years. The first and freFuent6y the second year of training7 ebracing genera6 education sub8ects7 are often &ro-ided by a schoo6 of arts and sciences. Many institutions a6so offer graduate courses in &haracy and cognate sciences 6eading to the degrees of Master of +cience and doctor of &hi6oso&hy in &haracy7  &haraco6ogy7 or re6ated disci&6ines. These ad-anced courses are intended es&ecia66y

15

for those who are &reå for careers in research7 anufacturing7 or teaching in the fie6d of &haracy. +ince the treatent of the sick with drugs enco&asses a wide fie6d of know6edge in the bio6ogica6 and &hysica6 sciences7 an understanding of these sciences is necessary for adeFuate &haraceutica6 training. The basic fi-e9year curricu6u in the co66eges of &haracy of the )nited +tates7 for ea&6e7 ebraces &hysics7 cheistry7 bio6ogy7  bacterio6ogy7 &hysio6ogy7 &haraco6ogy7 and any other s&ecia6ied courses. As the  &haracist is engaged in a business as we66 as a &rofession7 s&ecia6 training is  &ro-ided in erchandising7 accounting7 co&uter techniFues7 and &haraceutica6  8uris&rudence. (haracists graduating fro co66ege today are reFuired to ha-e a (harD7 or  doctorate of (haracy degree. 'o66ege students can start a four9year &haracy  &rogra after successfu66y co&6eting two years of undergraduate coursework and earning a &assing score on the ('AT 0(haracy co66ege adission test3. 'oursework  in &haracy and &re9&haracy inc6udes cheistry7 &hysics7 bio6ogy7 anatoy7 and  &hysio6ogy. Additiona66y7 (harD students ust co&6ete a series of rotations in a -ariety of  c6inica6 and &haraceutica6 settings. The 6ength and Fuantity of rotations -aries7 but the a-erage (harD &rogra reFuires @9=! rotations7 each of which is >9% weeks in 6ength. If a student knows ear6y in his or her co66ege career that they wou6d 6ike to becoe a  &haracist7 one cou6d graduate with a (harD in about % years. Many co66ege students do not decide unti6 6ater in co66ege or after co66ege to becoe a &haracist: therefore7 any &haracists ha-e co&6eted eight years of co66ege.

16

2.3

THE FUTURE OF PHARMACY Autoation wi66 assist with this7 because anything that strea6ines and autoates the

dis&ensing and distribution &rocess wi66 ob-ious6y free the &haracist to fu6fi66 ore of a c6inica6 ro6e as we667K said 1aes Owen7 B+ (har7 (harD7 director of   &rofessiona6 &ractice for the Aerican (haracists Association 0A(hA3. +i&6y &ut7 &haracists and &haracies of toorrow ust find ways to increase  &rofit argins by reducing the cost of &rescribing7 ebracing techno6ogy7 and focusing ore on &atient counse66ing7 iuniations7 education7 and other natura6 offshoots of their c6inica6 e&ertise. +oe e&erts &redict that the future of &haracy wi66 ebrace the c6inica6 ski66s and care &haracists ha-e a6ways been Fua6ified to de6i-er. Techno6ogica6 o&tions a-ai6ab6e to &haracies today are as nuerous as they are con-enient. As the hea6thcare syste becoes ore digita67 the ost eciting thing is that &haracists wi66 ha-e the &otentia6 to becoe ore connected to &atients and ha-e ore tie for &atient9centred acti-ities.K

2.3.1 Categories of Some of the technologies in the future are:

•

*esources for c6inica6 decision su&&ort. Error &re-ention and Fua6ity assurance. Ad-ances in bar9coding and e-en radio9freFuency identification techno6ogy

•

wi66 he6& &haracists -erify the a&&ro&riate use of edications. Te6ecounications infrastructure. 4or ea&6e7 to be ab6e to send a &atient a

• •

tet essage reinder to take eds or easure b6ood g6ucose 6e-e6s. This wi66

• •

6ead to better se6f9care anageent beha-iours. Autoation and robotics. 'o66aborati-e &ractice connecti-ity7 achie-ed through a cobination of  e6ectronic &rescribing 0e9&rescribing3 and the abi6ity to connect to and echange data with 6abs and &hysician offices.

17

•

De6i-ery ser-ice su&&ort7 using ;(+9dri-en te6ecounications systes for 

•

routing7 tracking7 order status7 dis&atch7 6ocating7 and o-ersight. (haracy sur-ei66ance and security systes7 which wi66 create a greater 6e-e6 of security for &haracies e-en when &haracists are off9site.

(haracies that do not ste& u& to this cha66enge wi66 6ose the abi6ity to hand6e i&ortant drugs7 and this wi66 ean 6oss of soe of their ost -a6uab6e &rescri&tions and &atients. +e-era6 co&anies se66 software and hardware that increase the efficiency of   &haracies by anaging workf6ow. The &haracist wi66 &6ay a significant ro6e in aking contributions to &atient care7 and these contributions wi66 be docuented using techno6ogy and transitted using techno6ogy7 and that care wi66 be recorded in the EH* 0e6ectronic hea6th records3 in the future. (haracists wi66 be integra6 tea ebers as far as the care of &atients is concerned.K I&ro-ed care and reduced errors wi66 be the cornerstones of this re6ationshi& between  &haracists and autoation. 2.3.2

T7+ 7()5 5(4* 4 +1+ 4 *4,44@) 7,+)

+oe e&erts say it de&ends on the indi-idua6 &haracy and the ty&e of autoation  being i&6eented. According to Bi66 ;. 4e6key7 BA7 M+7 &rofessor of hea6thcare inforatics in the de&artent of &haracy care syste at Auburn )ni-ersity in A6abaa &redicted that any &haracies across the country wi66 choose to o-e the &haracist to a ore cons&icuous forward 6ocation in their stores. With the &haracist in front7 howe-er7

18

you can &ut the techno6ogy behind c6osed doors or you can be6ie-e that &atients wi66  be fascinated to see how these robotics work. There wi66 eist a ied rece&tion7 de&ending u&on where the &haracy is and u&on how we66 the &atients recei-e the dis&6ay of a66 these techno6ogies. Mu66er said that dis&ensing achines wi66 ha-e a definite i&act on 6ayout. It has to  be easi6y accessib6e to staff7 but not 6ocated in an area that causes traffic and  bott6enecks. Workf6ow a6so affects the 6ogica6 &6aceent of a dis&ensing achine. If  the achine counts but does not 6abe6 and -ia67 it needs to be 6ocated in the technician area and &ositioned so a66 techs ha-e easy access. If the achine 6abe6s and -ia6s7 and on6y reFuires the fina6 &haracist check7 it needs to be 6ocated between the  &haracists and technicians7 de&ending on who is &utting the &rescri&tion in the bag. Autoation needs to fit into workf6ow7 not 8ust be a &art of it. 'hristo&her

Thosen7

-ice

&resident7 business de-e6o&ent7
Lester 

Incor&oration agreed7 noting that e-en in a situa tion where a chain ay ha-e gone to a centra69fi66 syste7 where7 say #! to $! &er cent of the -o6ue is o-ed off9site7 it sti66 needs to deterine how to best use autoation to address the reaining on9site dis&ensing reFuireents. Which is why7 said Mu66er7 you wou6d not 8ust add a achine into an eisting 6ayout: soe thought and care ust be gi-en to &ro&er6y ref6ow the behind9the9counter s&ace to get the ost fro your in-estent. The botto 6ine is that e-erything needs to o-e toward a ore efficient f6ow.

19

2.&

BENEFITS OF THE PROPOSED SYSTEM

The &ro&osed syste wou6d be designed to he6& ake the rigorous acti-ities carried out in a &haracy uch easier by &ro-iding the statistics of drugs in stock7 onitoring drug o-eent in the &haracy and ensuring effecti-e &o6icing of the acti-ities in the &haracy. The new syste wi66 be designed to &ro-ide the fo66owing benefits in the interest of  the &haracy:

The syste wou6d enhance anageent ser-ices and i&ro-e &roducti-ity. The syste wou6d enhance )ser+yste interface. The syste wou6d be cost effecti-e. The syste wou6d i&ro-e inforation Fua6ity and accessibi6ity.

20

CHAPTER THREE

SYSTEM ANALYSIS AND DESIGN

3.0

INTRODUCTION

+yste is a co66ection of an interre6ated co&onents that works together to achie-e a  &ur&ose. +yste ana6ysis is referred to the systeatic eaination or detai6ed study of  a syste in order to identify &rob6es of the syste7 and using the inforation gathered in the ana6ysis stage to recoend i&ro-eents or so6ution to the syste. +yste design is an abstract re&resentation of a syste co&onent and their  re6ationshi& and which describe the aggregated functiona6ity and &erforance of the syste. +yste design is a6so the o-era66 &6an or b6ue&rint for how to obtain answer to the Fuestion being asked. The design s&ecifies which of the -arious ty&e of a&&roach. 3.$

SYSTEM ANALYSIS

+yste ana6ysis is the study of sets of interacting entities7 inc6uding co&uter systes ana6ysis. This fie6d is c6ose6y re6ated to reFuireents ana6ysis or o&erations research. It is a6so Kan e&6icit fora6 inFuiry carried out to he6& soeone identify a better  course of action and ake a better decision than he ight otherwise ha-e ade. +yste Ana6ysis is a ethodo6ogy that in-o6-es the a&&6ication of systeatic a&&roaches to co66ects facts about an eisting syste with the ai of i&ro-ing it or  re&6acing it with ore efficient syste within the contet of the a-ai6ab6e resources. In other words7 +yste ana6ysis can a6so be -iewed as the &rocess of in-estigating a syste7 identifying &rob6es and using the inforation to recoend i&ro-eents to the syste.

21

3.$.$

ANALYSIS OF EISTING SYSTEM

Before we ana6yse the design of the &ro&osed syste7 we need to carefu66y high6ight the &rob6es of the eisting syste so as to a-oid recurrence. This ana6ysis ser-es as a  &ointer on how to ebark on bui6ding the &ro&osed syste that wi66 he6& the (haracist &ro-ide o&tia6 drug in-entory anageent by onitoring the drug o-eent and state in the &haracy. The &rob6es of the current syste shou6d be out6ined. Be6ow are soe of the &rob6es associated with the eisting syste:

•

+ignificant aount of tie is a66ocated for writing the order as the &haracist needs to go through the stock ba6ance and ake rough estiate for the aount to order based on 4igures.

•

The state of drugs in stock is anua66y checked.

•

Mistake of se66ing e&ired drugs to custoers.

•

Too uch work6oad on e&6oyees

•

4i6ing cabinet in the &haracy with &a&er record.

3.$.2 ANALYSIS OF PROPOSED SYSTEM

4ro the &rob6es 6isted in the eisting syste7 the i&6eentation of the &ro&osed syste sha66 focus on:

•

(haracists ha-ing access to the &ro&osed syste at any tie.

•

Ensuring effecti-e &o6icing by &ro-iding statistics of the drugs in stock.

•

I&ro-ing the efficiency of the syste by ensuring effecti-e onitoring of  ser-ices and acti-ities.

22

3.2

•

;enerating re&ort within a s&ecified &eriod of tie.

•

*educing the e&6oyeesJ work6oad.

RE!UIREMENTS DEFINITION

(re6iinary in-estigation &6ays an i&ortant ro6e in de-e6o&ing a satisfactory reFuireent. ItsJ as a resu6t of thorough in-estigation of how the current or the eisting syste works using the facts gathered at the &re6iinary in-estigation that 6eads to focusing on the &ossibi6ity of re&6acing the eisting syste or i&ro-ing u&on the eisting syste. This task in-o6-es inforation gathering. 3.2.$

METHOD OF INFORMATION GATHERING

'o66ection of fact is the act of getting and gathering inforation fro -arious sources in order to be ab6e to co&ose the &ro8ect. Data used for designing of the syste were gathered through se-era6 eans. Therefore the ethod used in the design and co66ections of inforation fro -arious sources are as fo66owsG

•

'o66ecting and ana6ysing eisting ateria6s on the &ro8ect to&ic7 written by

•

different e&ert. +tudying the &resent syste in detai6 and the organiationa6 sty6e.
•

know the eFui&ent needed7 and the ode of o&eration of the o6d syste. (riary dataG This source has to do with the tet book contacted for the

• •

de-e6o&ent of this &ro8ect.

3.3

SYSTEM DESIGN

+yste design is the &rocess of defining the architecture7 co&onents7 odu6es7 interfaces7 and data for a syste to satisfy s&ecified reFuireents through syste

23

ode6ing. One cou6d see it as the a&&6ication of systes theory to  &roduce de-e6o&ent. The design of this syste wi66 be user friend6y. It sha66 be designed in such a way that e&6oyees wi66 be ab6e to na-igate easi6y through the inforation su&&6ied on the syste. In other words7 syste design consists of design acti-ities that &roduce syste s&ecifications satisfying the functiona6 reFuireents that were de-e6o&ed in the syste ana6ysis &rocess. +yste design s&ecifies how the syste wi66 acco&6ish. +yste design is the structura6 i&6eentation of the syste ana6ysis.

PROJECT PLANNING

RE"UIREMENT GAT#ERING

PROJECT DEVELOPMENT  INTER!ACE IMPLEMENTATI ON AND SYSTEM

MAINTENANC E AND UPGRADING FIG. 3.3.$

WATERFALL MODEL OF SYSTEM DEVELOPMENT LIFE CYCLE

The diagra abo-e is a syste de-e6o&ent 6ife cyc6e that i66ustrates how the design of the &ro8ect is broken down into fi-e different &hases7 which are (ro8ect (6anning7

24

*eFuireent

;athering7

(ro8ect

I&6eentation

and

Interface

Design7

I&6eentation and +yste Testing7 Maintenance and +yste )&grading. The &ro&osed (haracy Manageent +yste for Boniks (haracy and +tores wi66 start with &ro8ect &6anning by deterining the users of the syste7 ais and ob8ecti-es of the &ro8ect. After these7 etensi-e research wi66 be done to deterine how to design an effecti-e syste7 as we66 as to re-iew the current syste. Then7 the design was with an initia6 &rototy&e of the syste7 and then refined it based on their suggestions. (hases of ana6ysis7 design and i&6eentation were &erfored iterati-e6y unti6 users and designers agreed on a fina6 syste s&ecification. At this &oint7 the &ro8ect cou6d o-e to the fina6 i&6eentation &hase. 3.&

SYSTEM MODELLING

During the syste reFuireents and design acti-ity7 systes ay be ode66ed as a s et of co&onents and re6ationshi&s between these co&onents. These are nora66y i66ustrated gra&hica66y in a syste architecture ode6 that gi-es the reader an o-er-iew of the syste organisation. +yste ode66ing he6&s to gi-e ore detai6ed syste s&ecifications which are in for of gra&hica6 re&resentations that can describe  &rob6e to be so6-ed or the syste that is to be de-e6o&ed. Because of the gra&hica6 re&resentations used7 ode6s are often ore understandab6e than detai6ed natura6 6anguage descri&tion of the syste reFuireents. Ea&6es of such ode66ing too6 is a +yste 46owchart. 3.'

SYSTEM FLOWCHART

+yste f6owchart is a ty&e of diagra that re&resents an a6gorith or  &rocess7 showing the ste&s as boes of -arious kinds7 and their order by connecting these with arrows. This diagraatic re&resentation can gi-e a ste&9by9ste& so6ution to a gi-en  &rob6e. (rocess o&erations are re&resented in these boes7 and arrows connecting

25

the re&resent f6ow of contro6. 46owcharts are used in ana6ysing7 designing7 docuenting or anaging a &rocess or &rogra in -arious fie6ds. Different sybo6s are used in the f6owchart to re&resent in&ut7 out&ut7 decision7 connectors and &rocess.

26

3.'.$

STRUCTURE CHART

SELECT MENU

ADMIN LOGIN

SUPERVISOR LOGIN

STAFF LOGIN

SUPERVISOR MENU

ADMIN MENU

ADD DRUG

ADD DRUG

STAFF MENU ADD STAFF

ADD CATEGORY 

GOTO STORE ADD CATEGORY  SELL DRUGS

VIEW DRUGS

GOTO STORE

MANAGE DRUGS VIEW DRUGS

RESTOCK DRUG

DRUG STATE MANAGE DRUGS

VIEW SALES

DRUG STATE

VIEW STAFF VIEW SALES

VIEW STAFF

3.'.2

SYSTEM FLOWCHART

27

DELETE DRUG

 YES

 YES

 YES

28

3 3

3.'.3

ADMIN FLOWCHART

START ADMIN

2

ENTER LOGIN DETAILS

SELECT

VALIDATED

AS ADMIN ADMIN%

ADMIN LOGIN

3

NO

NO

YES ADD DRUG

B

AS NO SUPERVISO

SUPERVIS G OR LOGIN

YES MANAGE DRUGS

NO NO

NO

YES ADD STAFF

YES DRUG STATE

C

STA!! LOGIN

AS STA!!%

NO ADD CATEGORY

YES

D

NO NO

NO

NO

YES VIEW SALES

I

E$IT%

YES GOTO STORE

H

NO

E

YES VIEW STAFF

J

 YES STOP

NO VIEW DRUGS

YES

F

YES

NO LOG OUT

29

2

3 3

3.'.&

SUPERVISOR FLOWCHART

SUPERVISOR 

$

ENTER LOGIN DETAILS

VALIDATED

SUPERVISOR

3

MENU

NO

YES ADD DRUG

YES

NO MANAGE DRUGS

L

P

NO YES ADD CATEGORY

NO

M

YES DRUG STATE

!

NO YES GOTO STORE

NO

VIEW SALES

YES VIEW DRUGS

YES

NO

N

NO

O

YES VIEW STAFF

YES

NO LOG OUT

3.'.'

STAFF LOGIN FLOWCHART

30

R 

S

$

STAFF LOGIN

ENTER LOGIN DETAILS

NO

VALIDATED

YES

ENTER  STORE

31

YES

A

A

DISPLAY STORE

SELL

RESTOC% 

ENTER !UANTITY

ENTER !UANTITY

NO NO DOES !UANTITY EIST

DOES !UANTITY EIST

YES

YES

DISPLAY SOLD

DISPLAY SUCCESS

#

#

32

B

'

ENTER DRUG DETAILS

NO

ENTER STAFF DETAILS

VALIDATED

NO

VALIDATED

YES

YES

DISPLAY SUCCESS

DISPLAY SUCCESS

#

#

33

D

4

DISPLAY DRUGS

DISPLAY CATEGORY

ADD CATEGORY

#

ADD NEW DRUG

DELETE CATEGORY

#

EDIT DRUG INFORMATION

NO

VALIDATED

DISPLAY SUCCESS

YES

# DISPLAY SUCCESS

#

34

;

DISPLAY STORE MANAGER 

CHEC%  STOC% 

RESTOC% 

SELECT DRUG

ENTER  !UANTITY

DELETE

ALL STOC% 

LOW STOC% 

NO

VALIDATED

DISPLAY SUCCESS

EPIRED DRUGS

YES

DISPLAY SUCCESS DISPLAY

DISPLAY

#

DISPLAY

#

35

#

NO

DOES !UANTITY EIST

NO

36

E

GOTO STORE

H

DISPLAY DRUG STATE

SELECT DRUG STATE

#

RESTOC% 

SELL

ENTER  !UANTITY

ENTER  !UANTITY

I

DISPLAY SALES

SELECT VIEW SALES

#

STOP VALIDATED

YES

1

YES

DISPLAY SUCCESS

DISPLAY SUCCESS

#

# DISPLAY STAFF INFORMATION

SELECT VIEW STAFF

37

#

3.'

DATABASE DESIGN

This is a shared co66ection of data that are re6ated or fi6es that are to eet the iediate need of authoried users. These data ay be in for of tet7 nueric7 date or encoded iages. ADMI,I+T*ATO* LO;I, TABLEG

F+5 N,+

F+5 T(+

F+5 L+1/*7

D+)*41

Adin/)sernae

2archar

0=?3

Adin )sernae

(assword

2archar

0=?3

Adin &assword

Tab6e $.=

Adinistrator tab6e

Tab6e $.= abo-e ser-es as a re&ository for adinistrator detai6s7 that wi66 be ab6e to ha-e access to the entire detai6s on the a&&6ication. It is a tab6e that stores the adinistrator 6ogin detai6s.

38

D*); I,4O*MATIO, TABLE

F+5 N,+

F+5 T(+

F+5 L+1/*7

D+)*41

Drug/,ae

2archar

0=?3

Drug ,ae

Drug/ID

2archar

0@3

Drug ,uber in stock  

Manufacturer

2archar

03

Manufacturer  

Batch/,o

2archar

03

Batch ,uber  

(roduction/Date

DateTie

03

(roduction Date

E&iry/Date

DateTie

03

E&iry Date

Dosage

Tet

03

Dosage

*eg/Date

DateTie

03

*egistration Date

uantity

Int

03

uantity

'ost/(rice

Int

03

'ost (rice

Interest/*ate

Int

03

Interest *ate

E&ected/+a6e

Int

03

E&ected +a6e

Tab6e $.# Drug inforation tab6eG This tab6e is naed tb6D*);7 it de&icts the inforation of  the drugs in the &haracy. Tab6e $.# shows the inforation about the drugs in the &haracy and is being Fueried fro the database on the drug registration &age to show a66 the drugs for user to se6ect.

+)(E*2I+O* LO;I, TABLE

F+5 N,+

F+5 T(+

F+5 L+1/*7

D+)*41

)+E*,AME

2archar

0=?3

+u&er-isor usernae

(A++WO*D

2archar

0=?3

+u&er-isor &assword

TABLE $.$ +)(E*2I+O* TABLE

39

Tab6e $.$ abo-e ser-es as a re&ository for su&er-isor detai6s7 which wi66 be ab6e to ha-e access to the reFuired detai6s on the a&&6ication as sti&u6ated by the adinistrator. It is a tab6e that stores the su&er-isor 6ogin detai6s. +TA44 LO;I, TABLE

F+5 N,+

F+5 T(+

F+5 L+1/*7

D+)*41

)+E*,AME

2archar

0=?3

+taff )sernae

(A++WO*D

2archar

0=?3

+taff (assword

TABLE $.> +TA44 LO;I, TABLE Tab6e $.> abo-e ser-es as a re&ository for a staff detai6s7 that wi66 be ab6e to ha-e access to the reFuired detai6s on the a&&6ication as sti&u6ated by the adinistrator. It is a tab6e that stores the staff 6ogin detai6s.

40

+TA44 I,4O*MATIO, TABLE F+5 N,+

F+5 T(+

F+5 L+1/*7

D+)*41

+TA44/,AME

2archar

03

+taff ,ae

*E;,O

Int

0%3

+TA44/+E5

2archar

0%3

+taff +e

 ,ATIO,ALITY

2archar

03

,ationa6ity

+TA44/+TAT)+

2archar

0=?3

+taff +tatus

DOB

Date

03

Date Of Birth

(HO,E/,O

Int

0==3

ADD*E++

2archar

03

'ontact Address

+TATE

2archar

03

+tate

EMAIL

2archar

03

Eai6

)+E*,AME

2archar

03

)sernae

(A++WO*D

2archar

0 =?3

(assword

TABLE $.?

*egistration nuber  

(hone ,uber  

+TA44 I,4O*MATIO, TABLE

Tab6e $.? abo-e consist of inforation of the 6ist and inforation of the e&6oyed staff in the  &haracy .The inforation of staff on the reFuired fie6d can be seen fro the tab6e $.? abo-e.

41

CHAPTER FOUR 

SYSTEM IMPLEMENTATION

&.0

INTRODUCTION

+yste i&6eentation is a stage in syste 6ife cyc6e whereby a new syste is de-e6o&ed7 insta66ed and ade ready for use. It is this stage that a66 detai6s and key  &oint in the reFuireent s&ecification are &ractica6ised. +yste i&6eentation therefore7 is a -ery essentia6 stage in which its success deterines to a great etent the success of the new syste. At this instance7 after a66 is said and done the syste is du6y ready to be i&6eented 0(haracy Manageent +yste3. +yste design is concerned ain6y with the coordination of acti-ities7 8ob &rocedures and eFui&ent uti6iation in order to achie-e organiationa6 ob8ecti-es. It addresses data in&ut and out&ut data7 &rocessing and interface. This stage in-o6-es the design of the new (haracy Manageent +yste a case study of Boniks &haracy ;wari&a Abu8a. &.$

CHOICE OF PROGRAMMING LANGUAGE

'hoosing a &rograing 6anguage de&ends on your 6anguage e&erience and the sco&e of the a&&6ication you are bui6ding. Whi6e sa66 a&&6ications are often created using on6y one 6anguage7 it is not uncoon to de-e6o& 6arge a&&6ications using u6ti&6e 6anguages. The &ro&ose a&&6ication to be bui6t is not a web based a&&6ication that needs internet faci6ities to function but a standa6one a&&6ication.

42

The choice of &rograing 6anguage to use for this &rograe is -isua6 basic. The structure of the Basic &rograing 6anguage is -ery si&6e7 &articu6ar6y as to the eecutab6e code. 2isua6 Basic has any new and i&ro-ed features such as inheritance7 interfaces7 and o-er6oading that ake it a &owerfu6 ob8ect9oriented &rograing 6anguage. It is  &articu6ar6y easy to de-e6o& gra&hica6 user interfaces and to connect the to hand6er  functions &ro-ided by the a&&6ication. 2isua6 Basic fu66y integrates the .,ET 4raework and the coon 6anguage runtie7 which together &ro-ide 6anguage intero&erabi6ity7 garbage co66ection7 enhanced security7 and i&ro-ed -ersioning su&&ort. 2isua6 Basic su&&orts sing6e inheritance and creates Microsoft interediate 6anguage 0M+IL3 as in&ut to nati-e code co&i6ers. &.2

SYSTEM TESTING AND DEBUGGING

Testing is an integra6 &art of software de-e6o&ent &rocesses. This is to ensure that the Fua6ity reFuireent of the a&&6ication is not co&roised by testing and debugging &rogra odu6es before they are integrated7 testing the syste to ensure an effecti-e inter9o&erabi6ity after integration. Debugging has to do with fiing of errors encountered during &rogra eecution. +yste testing dea6s with the rea6 6ife testing of the syste7 to ascertain how far it has gone in carrying out the e&ected task. This was carried out in two &hases.  ,uber one is the source code testing which eaine the 6ogic of the &rogra. +econd6y7 the s&ecification testing which in-o6-es the eaination of the syste as regard to what it shou6d do and how it shou6d be done gi-en s&ecific conditions. This

43

inc6udes in&utting data7 co66ecting its out&ut and coå it with the out&ut of the o6d syste and assessing it to see if it can re&6ace the o6d syste.

&.3

SYSTEM DOCUMENTATION

+yste docuentation is a crucia6 as&ect of i&6eentation &rocess. It describes the working of co&onents and ser-es as a ethod of counication between a&&6ication de-e6o&ers and users. It a6so he6&s future ana6ysis of a&&6ication either by the sae or different syste ana6ysts and de-e6o&ers. To setu& the syste7 there ust be -isua6 basic %.! software insta66ed on the co&uter   before it can work.

&.&

&.'

HARDWARE RE!UIREMENT •

A iniu hard disk s&ace of #! ;igabytes 0;B3

•

*AM sie of =;B

•

(entiu > dua6 &rocessor '()

•

A 2;A co6our onitor 

•

Mouse

•


SOFTWARE RE!UIREMENT

•

Windows o&erating syste such as Windows #!!!7 windows 5(7 Windows 2ista7

•

Windows @. 2isua6 basic %.! software.

44

&.6

DATABASE SPECIFICATION

A database is a sing6e fi6e which consists of structured data and records which are stored in iniu or no du&6ication of data. It is therefore a constructed7 consistent and contro66ed &oo6 of data. A good database ust be coon to a66 users and inde&endent of the &rogras which use it to generate out&ut. Howe-er7 Microsoft Access was used as the database a&&6ication too6 for designing the database anageent syste. The database anageent syste is 6iited on6y to database adinistrator 0Manageent3. Whi6st the syste designer  de-e6o&er   &rograer is res&onsib6e for aintaining and u&grading of the database and the who6e software.

&.9

MODULE DESCRIPTION

+AM(LE O)T()T 4O*M+ HOME (A;E

4igure >.= showing HOME (A;E

45

4igure >.= shows the se6ect 6ogin &age. It is the first interface that a&&ears on the screen when the a&&6ication is being 6oaded. This interface dis&6ays the nae of the a&&6ication and soe other inforation about the software. The &age consist of 6ogins that eist for se-era6 other  6e-e6s in the a&&6ication. They consist of adinistrator7 su&er-isor and staff 6ogin. ADMI, LO;I, ME,)

4igure >.# +howing Adin 6ogin enu 4igure >.# abo-e7 shows the adin 6ogin area of the a&&6ication. After a successfu6 6ogin su&&6ying the correct usernae and &assword7 it o&ens into another &age where the acti-ities of the adin odu6e are fu66y sti&u6ated. The adin contro6s a66 the a8or acti-itis of this a&&6ication. Acti-ities such as Addstaff7 Add Drugs7 'hange )sernae and &assword7 Manage drugs7 2iew sa6es etc can on6y be contro66ed by the adin. 4utherore7the Adin has contro6 o-er the su&er-isor and a66 other user of the a&&6ication.

46

+)(E*2I+O* LO;I,

4igure >.$ +howing +u&er-isor 6ogin 4igure >.$ abo-e shows the su&er-isor 6ogin.The su&er-isor is an e&6oyee that anages the acti-ities of the &haracy. After a successfu 6ogin7 soe of the acti-ities that can be  &erfored by the su&er-isor are Manage drugs7 -iew sa6es7 -iew drugs etc. The su&er-isor has a high 6e-e6 of acces on the a&&6ication ece&t for addition a new staff.

47

+TA44 LO;I,

4igure >.> +howing +taff 6ogin 4igure >.> abo-e shows the staff 6ogin section.The staff is resonsib6e for u&dating the 6ist of drugs in the store.The staff can a6so engage in buying and se66ing of drugs.The staff is

48

reFuired to &ro-ide a -a6id usernae and &assword in other to be ab6e to &erfor its acti-ities.

49

ADMI, MAI, ME,)

4igure >.? +howing Adin Menu Modu6e 4igure >.? abo-e shows the Adin odu6e enue. It 6ist acti-ities that can be &erfored by the adinistrator.the Adinistrator Adinistrator is the &erson res&onsib6e for the u&grade7anageent on the software.the adinistrator is gi-en an un6iited access as to &erforing the o&erations in the &haracy.

50

D*); *E;I+T*ATIO, 4O*M

4igure >.% +howing Drug *egistration 4or 4igure >.% abo-e shows the drug registration for. ,ew drugs brought to the &haracy are registered here. It recei-es the detai6s of new batches batches of drug in the &haracy.

51

+TA44 +TA44 *E;I+T*AT *E; I+T*ATIO, IO, 4O*M 4O *M

4igure >.@ +howing +taff *egistration 4or 4igure >.@ abo-e shows the staff registration for. I&ortant inforation 6ike the contact detai6s is co66ected with this for. A 6ogin detai6 that is7 a usernae and a &assword is assigned to the new staff as we66.

52

+TO*E MA,A;E* 

4igure >." +howing the +tore Manager  4igure >." abo-e shows the store anager. Here drugs can be so6d. The user wi66 be reFuired to se6ect a category of drug to se66. Drugs in the &haracy are categorised based on their function. When the drug needed to be &urchased is se6ected7 the software generates i&ortant inforation about the drug such as dosage7 a-ai6ab6e Fuantity7 se66ing &rice7 e&iry date7 6ocation of the drug in the &haracy etc. A6so the user can se66 drugs7 &rint bi667 check a66 stock7 6ow stock or check the e&ired drugs in stock.

53

+ALE+ WI,DOW

4igure >.C +howing +a6es 4igure >.C shows the 6ist of drugs so6d in the &haracy. There is an o&tion to -iew the sa6es in the &haracy within a s&ecified date.

&.8

SYSTEM MAINTENANCE

Maintenance is a continuous &rocess of aking odifications and u&grading the a&&6ication. This usua66y coences after the a&&6ication has gone into use. There are two different ways by which this a&&6ication can be aintained. They inc6udeG

•

Additi-e or Enhanceent aintenance:  Business &rocesses are dynaic.

As

 business &rocesses change7 a&&6ications that su&&ort these &rocesses ust e-o6-e to ref6ect these changes. Thus7 for this a&&6ication to &erfor o&tia66y and to eet changing user reFuireents7 it ust be odified continuous6y.

54

•

'orrecti-e aintenanceG This is reFuired in the e-ent that an error occurred when the a&&6ication is in use. 'orrections ust be ade to changes disco-ered that can cause a6functioning of the syste.

55

CHAPTER FIVE

CONCLUSION AND RECOMMENDATION

'.0

SUMMARY

(haracy anageent syste is designed to i&ro-e the accuracy7 enhance safety and efficiency in the &haraceutica6 store. It is a co&uter based syste which he6&s the (haracist to i&ro-e in-entory anageent7 cost7 edica6 safety etc. (haracy anageent syste was de-e6o&ed to ensure the security of inforation and re6iabi6ity of (haracy records when accessing and &ro-iding ser-ices to the custoers. The inforation gathered during the data co66ection was &ro&er6y ana6ysed and the resu6ts &ro-ided the basis for the new syste. The syste was tested and found to be functiona6 and the out&uts &roduced by this syste were encouraging. The a&&6ication wi66 hence reduce the 6oss of inforation un6ike the eisting syste and a6so inforation wi66 be &rocessed fast.

'.$

CONCLUSION

Effecti-e Effecti-e i&6eentation i&6eentation of this software software wi66 take care of the basic reFuireents reFuireents of  the &hara &haracy cy anage anageen entt syste syste becaus becausee it is ca&ab6 ca&ab6ee of &ro-id &ro-iding ing easy and effecti-e effecti-e storage of inforation inforation re6ated to acti-ities acti-ities ha&&ening in the sti&u6ated sti&u6ated area. With these7 the ob8ecti-es of the syste design wi66 be achie-ed.

56

In order to a66ow for future e&ansion7 the syste has been designed in such a way that wi66 a66ow &ossib6e odification as it ay dee necessary by the &haracy anageent7 whene-er the idea arises.

'.2

RECCOMMENDATION

Designing this a&&6ication 0(haracy anageent syste3 is not an easy task. It a66 started started fro fro the reFuir reFuiree eent nt gatheri gathering ng and &asses &asses throug through h so any any other other stages stages  before co&6etion. Based on the benefits of this syste and treendous -a6ue it wi66 add to custoer9user  satisfaction7 the be6ow recoendation wi66 be considered:

It is reco reco en ende ded d that that the the new new syst syste e shou shou6d 6d be used used with with the the nece necess ssar ary y s&ecifications of the syste reFuireents and &ro-ision for an uninterru&ted &ower  su&&6y shou6d be ade a-ai6ab6e throughout the hours of o&eration of the &haracy to a-oid &ower outage. There shou6d a6so be basic co&uter know6edge for the users of  the software. It is recoended that the software be i&ro-ed es&ecia66y in areas of accounting as it wi66 be of great i&act to the de-e6o&ent of retai6 &haracy.

57

REFERENCES

Barb Barbar araa ;rig ;riggs gs.. Green Green Pharm Pharmacy acy:: The Histor Historyy and Evolut Evolution ion of Western estern Herbal  Herbal   Medicine, Second Edition. Viin! Viin! "ress, "ress, #$%&'(. P! %)*%+. %)*%+. 'har6es E. *osenberg7 Morris 1. 2oge6. The Thera"eutic evolution: Essays in the social  history of -merican Medicine, Second Edition. niversity of Pennsylvania "ress, #$%+%(.  P! $+/. (eter ; Hoan7 Briony Hudson7 *ayond ' *ow. Po"ular *ow.  Po"ular Medicines: -n illustrated Les6ie ;. Mathews. History Mathews.  History of Pharmacy in 0ritain. Edinbur!h, E1S. 2ivin!stone#$%3'(.  P! '$)*'').  History, 4ourth 4ourth Edition. Trade Trade "a"erbac, Pharmaceutical "ress "ress #'55&(. P!. $'+ . +tuart Anderson. Main! Anderson. Main! Medicines: - 0rief History of Pharmacy and Pharmaceuticals, Si6th Edition. 7essica 7essic a 8in!sley "ublisher, #'559(. P! '$/. 'har6es 'har6es E. *osenb *osenberg erg..  History of Medicine and -llied Sciences, Seventh Edition. niversity of Pennsylvania "ress, #'55)(. P! $%+. ;eorge A. Bender.  Bender.  Great moments in Medicine, Medicine, ambrid!e university "ress #$%3+(. P!  $$&.

58

APPENDI

+O)*'E 'ODE

ADMI, LO;I,

P&'()*+ S, /L'C' O E&&& R+,/+ N+:* ;VALIDATE USERNAME AND PASS ?? T@+ M: ?ENTER USERNAME AND PASS
;COMPARE INPUT T#E T#E !OUND RECORD I= ,+&.T+:* > ADMIN1 T@+ I= ).T+:* > ADMIN2 T@+

;I! IT CORRESPONDSB DISPLAY CON!IRMATION M: ?LOGIN ?? ).T+:* > ?? =&/MAIN.S@ M+.#'+

E:'* S, E I=  E I=  ;I! NOT !OUNDB DISPLAY DENIAL O! ACCESS M: ?YOU ARE NOT AUT#ORIFED?B (C&'*')B ?LOGIN SYSTEM?

59

,+&.T+:* > ?? ).T+:* > ?? E S,

P&'()*+ S, !&/U)C)+ A I*++& =&/S
P&'()*+ S, L)+1C'I+: A I*++&

E S,

P&'()*+ S, )+HP&++HA'' A I*++& ;I! T#E ENTEREY IS PRESSEDB CLIC ON LOGIN I= +HA'' > 13 T@+  

++

 

/L'C'

E I=  ; E S,

P&'()*+ S, ,+&C@)+ O E&&& R+,/+ N+:* ;I! NOT#ING IS TYPEDB EEP I= ,+&.T+:* > ?? T@+   ++

60

E+ ;SEARC# !OR T#E RECORD TYPED IN T#E COMPUTER   AL'.R+&+*.M(+!'&* AL'.R+&+*.!' ?,+&)/+ > ;?  ,+&.T+:*  ?;?B 0B )S+)&@!&)&

I= AL'.R+&+*.EO! T@+

E+

E I=  E I=    ; E S,

P&'()*+ S, ,+&+HP&++HA'' A I*++& ;I! T#E ENTEREY IS PRESSEDB CLIC ON LOGIN I= +HA'' > 13 T@+  

++

 

/L'C'

E I=  ; E S, Di user7 (A++=7 (A++# As 2ariant Di ,)M=7 )A,=7 LOW=7 +,=7 +,# As Integer  Di MADE= As Doub6e

61

Di DATE=7 DATE# As Date

+ub +how/+tate03 *E+ET 'O),TE*+  ,)M=  ! )A,=  ! LOW=  ! +,=  ! +,#  !

DE4)LT 2AL)E+ 6bL)A,#.'a&tion  K99K 6b6LOW.'a&tion  K99K 6b6,O.'a&tion  K99K 6b6AMO),T.'a&tion  K99K

*E4*E+H *E'O*D AdoD*);.*efresh MO2E TO 4I*+T *E'O*D AdoD*);.*ecordset.Mo-e4irst

+TATE TIME*  TiD*);.Enab6ed  4a6se

End +ub

+ub 'hange/(ass03

62

On Error *esue ,et 'OLLE'T THE ,EW (A++WO*D (A++=  In&utBo0K(LEA+E E,TE* THE (A++WO*D YO) WA,TK7 KLO;I, MA,A;E*K3 'OLLE'T 'O,4I*MATIO, O4 (A++WO*D (A++#  In&utBo0K(LEA+E 'O,4I*M THE (A++WO*D YO) WA,TK7 KLO;I, MA,A;E*K3 NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN

'O,4I*M (A++WO*D E,T*Y If (A++=  (A++# Then

T*A,+4E* (A++WO*D E,T*Y TO THE 4IELD 6b6(A++.'a&tion  (A++=

+A2E *E'O*D+ Ado)+E*.*ecordset.+a-e *E4*E+H *E'O*D+ Ado)+E*.*efresh

'LEA* 4IELD+ tt)+E*.Tet  KK tt(A++.Tet  KK

DI+(LAY +)''E++ ME++A;E MsgBo K(A++WO*D 'HA,;E WA+ +)''E++4)LLK7 -bInforation

63

EL+E DI+(LAY ),+)''E++4)L ME++A;E E6se MsgBo K+O**Y7 B)T THE (A++WO*D YO) +)((LIED DOE+ ,OT MAT'H7 A,D A+ +)'H7 THI+ (*O'E++ I+ TE*MI,ATEDK7 -bEc6aation7 K0LO;I, MA,A;E*3K Ado)+E*.*efresh tt)+E*.Tet  KK tt(A++.Tet  KK

End If  NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN End +ub

+ub 'hange/)ser/(ass03 On Error *esue ,et 'OLL'ET THE ,EW )+E*,AME user  In&utBo0K(LEA+E E,TE* THE )+E*,AME YO) WA,TK7 KLO;I, MA,A;E*K3 'OLLE'T THE ,EW (A++WO*D (A++=  In&utBo0K(LEA+E E,TE* THE (A++WO*D YO) WA,TK7 KLO;I, MA,A;E*K3 'OLLE'T 'O,4I*MATIO, O4 (A++WO*D (A++#  In&utBo0K(LEA+E 'O,4I*M THE (A++WO*D YO) WA,TK7 KLO;I, MA,A;E*K3 NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN

'O,4I*M (A++WO*D E,T*Y If (A++=  (A++# Then

64

T*A,+4E* E,T*Y TO THE 4IELD+ 6b6)+E*.'a&tion  user  6b6(A++.'a&tion  (A++=

+A2E *E'O*D+ Ado)+E*.*ecordset.+a-e *E4*E+H *E'O*D+ Ado)+E*.*efresh

'LEA* 4IELD+ tt)+E*.Tet  KK tt(A++.Tet  KK

DI+(LAY +)''E++ ME++A;E MsgBo K)+E*,AME A,D (A++WO*D WE*E 'HA,;ED +)''E++4)LLYK7 -bInforation7 K0LO;I, MA,A;E*3K

EL+E DI+(LAY ),+)''E++4)L ME++A;E E6se MsgBo K+O**Y7 B)T THE (A++WO*D YO) +)((LIED DOE+ ,OT MAT'H7 A,D A+ +)'H7 THI+ (*O'E++ I+ TE*MI,ATEDK7 -bEc6aation7 K0LO;I, MA,A;E*3K Ado)+E*.*efresh tt)+E*.Tet  KK tt(A++.Tet  KK

End If  NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN

65

End +ub

(ri-ate +ub 'LD/'6ick03 On Error *esue ,et +how/+tate

DI+(LAY +TATE fr)+E*.2isib6e  True

tt)+E*.Tet  KK tt(A++.Tet  KK HIDE THE *E+T fr'AT.2isib6e  4a6se 4r+TATE.2isib6e  4a6se frA)THO*.2isib6e  4a6se

'A,'EL )(DATI,; THE DATABA+E Ado'AT#.*ecordset.'ance6)&date Ado)+E*.*ecordset.'ance6)&date NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN End +ub

(ri-ate +ub cdADD/'6ick03 On Error *esue ,et If Len0tt'AT.Tet3 P # Then

66

Ado'AT#.*ecordset.Add,ew Ado'AT#.*ecordset.+a-e Ado'AT#.*efresh Ado'AT.*efresh

Ado'AT#.*ecordset.Add,ew MsgBo KD*); 'ATE;O*Y WA+ E,TE*ED +)''E++4)LLYK7 -bInforation E6se MsgBo K'ATE;O*Y E,TE*ED I+ TOO +HO*TK7 -bEc6aation End If  End +ub

(ri-ate +ub cd'HA,;E/'6ick03 Di A,+ As Integer 

'O,4I*M E,T*Y If tt)+E*.Tet  6b6)+E*.'a&tion And tt(A++.Tet  6b6(A++.'a&tion Then I4 E,T*Y I+ 'O**E'T THE, A,+  MsgBo0KYO)* LO;I, DETAIL+ WE*E 'O**E'T. I4 YO) WA,T TO 'HA,;E YO)* )+E*,AME A,D (A++WO*D (LEA+E +ELE'T YE+. I4 YO) WA,T TO 'HA,;E YO)* (A++WO*D O,LY +ELE'T ,O. I4 YO) WA,T TO 'A,'EL THI+ (*O'E++7 (LEA+E +ELE'T 'A,'ELK7 -buestion Q -bYes,o'ance67 K0LO;I, MA,A;E*3K3

If A,+  -bYes Then 'HA,;E )+E*,AME A,D (A++WO*D 'hange/)ser/(ass Eit +ub NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN

67

E6seIf A,+  -b,o Then 'HA,;E (A++WO*D 'hange/(ass Eit +ub NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN

E6seIf A,+  -b'ance6 Then 'A,'EL Eit +ub

End If  NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN

E6se I4 LO;I, DETAIL+ WA+ ),+)''E++4)LL THE, MsgBo KYO) A*E ,OT A)THO*I+EDK7 -bEc6aation7 K0LO;I, MA,A;E*3K End If  NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN

End +ub

(ri-ate +ub cdDEL/'6ick03 On Error *esue ,et Di A,+ As Integer  DI+(LAY 'O,4I*MATIO, O4 DELETIO,

68

A,+  MsgBo0KA*E YO) +)*E YO) WA,T TO DELETE THI+ DE(A*TME,TRK7 -buestion Q -bYes,o3

If A,+  -bYes Then DELETE *E'O*D Ado'AT.*ecordset.De6ete End If 

End +ub

(ri-ate +ub cd'AT/'6ick03 On Error *esue ,et DI+(LAY 'ATE;O*Y (A,EL HIDE THE *E+T fr)+E*.2isib6e  4a6se frA)THO*.2isib6e  4a6se 4r+TATE.2isib6e  4a6se fr+TA44.2isib6e  4a6se

+HOW 'ATE;O*Y fr'AT.2isib6e  True Ado'AT#.*ecordset.Add,ew tt'AT.Tet  KK NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN End +ub

69

(ri-ate +ub cdD*);/'6ick03 frD*);+.+how frD*);+.Ti,EW.Enab6ed  True

Me.Hide

End +ub

(ri-ate +ub cd(A++/'6ick03 On Error *esue ,et DI+(LAY )+E* (A,EL fr'AT.2isib6e  4a6se frA)THO*.2isib6e  4a6se Ado'AT#.*ecordset.'ance6)&date

fr)+E*.2isib6e  True tt)+E*.Tet  KK tt(A++.Tet  KK NNNNNNNNNNNNNNNNNNNNNNNNN

End +ub

70

(ri-ate +ub cdMD*);/'6ick03 fr+TO*E.+how Me.Hide End +ub

(ri-ate +ub cd+ALE+/'6ick03 fr2+ALE.+how Me.Hide End +ub

(ri-ate +ub cd+TA44/'6ick03 DI+(LAY +TATE fr+TA44.2isib6e  True HIDE THE *E+T 4r+TATE.2isib6e  4a6se fr'AT.2isib6e  4a6se fr)+E*.2isib6e  4a6se frA)THO*.2isib6e  4a6se

End +ub

(ri-ate +ub cd+TATE/'6ick03 On Error *esue ,et +how/+tate

71

'LEA* *E'O*D+ 6stLOW.'6ear  6st)A,.'6ear  6stE5(.'6ear 

DI+(LAY +TATE 4r+TATE.2isib6e  True HIDE THE *E+T fr'AT.2isib6e  4a6se fr)+E*.2isib6e  4a6se frA)THO*.2isib6e  4a6se fr+TA44.2isib6e  4a6se

'A,'EL )(DATI,; THE DATABA+E Ado'AT#.*ecordset.'ance6)&date Ado)+E*.*ecordset.'ance6)&date NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN

+TA*T TIME*  TiD*);.Enab6ed  True End +ub

(ri-ate +ub cd+TO*E/'6ick03 On Error *esue ,et

72

fr+TO*E.+how fr+TO*E.Ti,EW.Enab6ed  True

Me.Hide

End +ub

(ri-ate +ub cd2D*);/'6ick03 frD*);+.+how Me.Hide

End +ub

(ri-ate +ub cd2+TA44/'6ick03 fr2IEW+TA44.+how Me.Hide

End +ub

(ri-ate +ub 4or/Load03 6b6DATE.'a&tion  Date End +ub

(ri-ate +ub 4or/)n6oad0'ance6 As Integer3 On Error *esue ,et Di A,+ As Integer 

73

DI+(LAY 'O,4I*MATIO, O4 DELETIO, A,+  MsgBo0KA*E YO) +)*E YO) WA,T TO )ITRK7 -buestion Q -bYes,o3

If A,+  -bYes Then 'A,'EL )(DATE+ Ado'AT.*ecordset.'ance6)&date Ado'AT#.*ecordset.'ance6)&date Ado)+E*.*ecordset.'ance6)&date

frADMI,Login.+how frADMI,Login.AdoLogin.*efresh

),LOAD ALL 4O*M+ )n6oad frD*);+ )n6oad fr+ALE )n6oad fr+(LA+H )n6oad fr+TA44*eg )n6oad fr+TO*E )n6oad frTe66er  )n6oad fr2+ALE Eit +ub End If 

'ance6  = End +ub

74

(ri-ate +ub Iage=/MouseMo-e0Inde As Integer7 Button As Integer7 +hift As Integer7 5 As +ing6e7 Y As +ing6e3 fr+TA44.2isib6e  4a6se End +ub

(ri-ate +ub 6b6'LO+E$/'6ick03 On Error *esue ,et

HIDE THE 4*AME frA)THO*.2isib6e  4a6se NNNNNNNNNNNNNNNNNNNNNNNNNNNNNN

End +ub

(ri-ate +ub 6b6'LO+E=/'6ick03 On Error *esue ,et 'A,'EL )(DATE+ Ado)+E*.*ecordset.'ance6)&date NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN

HIDE THE 4*AME fr)+E*.2isib6e  4a6se NNNNNNNNNNNNNNNNNNNNNNNNNNNNNN

75

End +ub

(ri-ate +ub 6b6'LO+E#/'6ick03 On Error *esue ,et 'A,'EL )(DATE+ Ado'AT#.*ecordset.'ance6)&date NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN

HIDE THE 4*AME fr'AT.2isib6e  4a6se NNNNNNNNNNNNNNNNNNNNNNNNNNNNNN

End +ub

(ri-ate +ub 6b6'LO+EE>/'6ick03 On Error *esue ,et HIDE (A,EL 4r+TATE.2isib6e  4a6se

End +ub

(ri-ate +ub 6b6+TA44/'6ick03 fr+TA44*eg.+how Me.Hide

76

End +ub

(ri-ate +ub 6b6+TA44/MouseMo-e0Button As Integer7 +hift As Integer7 5 As +ing6e7 Y As +ing6e3 On Error *esue ,et 'HA,;E 'OLO)* O4 LABEL+ 6b6+TA44.Back'o6or  SH!S 6b6+)(.Back'o6or  SH'!4444 NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN End +ub

(ri-ate +ub 6b6+)(/'6ick03 On Error *esue ,et Ado)+E*.*ecord+ource  K+ELE'T N 4*OM TBL+)(E*2I+O*K Ado)+E*.*efresh

I4 E,T*Y I+ 'O**E'T THE, A,+  MsgBo0KYO) A*E ABO)T TO 'HA,;E THE +)(E*2I+O*+ LO;I, DETAIL+. I4 YO) WA,T TO 'HA,;E THE +)(E*2IO*+ )+E*,AME A,D (A++WO*D (LEA+E +ELE'T YE+. I4 YO) WA,T TO 'HA,;E THE +)(E*2IO*+ (A++WO*D O,LY +ELE'T ,O. I4 YO) WA,T TO 'A,'EL THI+ (*O'E++7 (LEA+E +ELE'T 'A,'ELK7 -buestion Q -bYes,o'ance67 K0LO;I, MA,A;E*3K3

If A,+  -bYes Then 'HA,;E )+E*,AME A,D (A++WO*D 'hange/)ser/(ass Eit +ub NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN

77

E6seIf A,+  -b,o Then 'HA,;E (A++WO*D 'hange/(ass Eit +ub NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN

E6seIf A,+  -b'ance6 Then 'A,'EL Eit +ub End If  *E4*E+H *E'O*D+ Ado)+E*.*ecord+ource  K+ELE'T N 4*OM )+E*+K Ado)+E*.*efresh

End +ub

(ri-ate +ub 6b6+)(/MouseMo-e0Button As Integer7 +hift As Integer7 5 As +ing6e7 Y As +ing6e3 On Error *esue ,et 'HA,;E 'OLO)* O4 LABEL+ 6b6+)(.Back'o6or  SH!S 6b6+TA44.Back'o6or  SH'!4444 NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN End +ub

(ri-ate +ub LO/'6ick03

78

)n6oad Me End +ub

(ri-ate +ub ta=/'6ick03 On Error *esue ,et

DI+(LAY A)THO*  frA)THO*.2isib6e  True HIDE THE *E+T fr'AT.2isib6e  4a6se fr)+E*.2isib6e  4a6se 4r+TATE.2isib6e  4a6se fr+TA44.2isib6e  4a6se

'A,'EL )(DATI,; THE DATABA+E Ado'AT#.*ecordset.'ance6)&date Ado)+E*.*ecordset.'ance6)&date NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN

End +ub

(ri-ate +ub TiD*);/Tier03 On Error *esue ,et I4 LOW ;ET ,AME O4 D*); A,D 'O),T THE D*); If 2a606b6.'a&tion3  ? Then ADD TO LI+T +,#  +,# Q =

79

6stLOW.AddIte +,# S K3 K S 6b6D,AME.'a&tion 6st)A,.AddIte 6b6.'a&tion

LOW=  LOW= Q = End If  NNNNNNNNNNNNNNNNNNNNNNNNNNNNNN

I4 E5(I*ED ;ET ,AME O4 D*); A,D 'O),T THE D*); DATE=  6b6DATE.'a&tion DATE#  6b6E5(.'a&tion If DATE#  DATE= Then +,=  +,= Q = ADD TO LI+T 6stE5(.AddIte +,= S K3 K S 6b6E5(.'a&tion S K 9 K S 6b6D,AME.'a&tion End If 

;ET ,)MBE* O4 D*);+  ,)M=  ,)M= Q =

;ET )A,TITY O4 D*);+ )A,=  )A,= Q 2a606b6.'a&tion3

;ET AMO),T +OLD MADE=  MADE= Q 2a606b6MADE.'a&tion3

;O TO ,E5T *E'O*D AdoD*);.*ecordset.Mo-e,et

80

I4 WE *EA'H THE E,D7 +TO( If AdoD*);.*ecordset.EO4 Then AdoD*);.*ecordset.Mo-e(re-ious

TiD*);.Enab6ed  4a6se T*A,+4E* *E'O*D+ 6b6,O.'a&tion  ,)M= 6bL)A,#.'a&tion  )A,= 6b6LOW.'a&tion  Math.*ound000LOW=  ,)M=3 N =!!37 #3 S KUK 6b6AMO),T.'a&tion  MADE= End If  NNNNNNNNNNNNNNNNNNNNNNNNNNNNNN

End +ub

(ri-ate +ub tt)+E*/'hange03 On Error *esue ,et 4I,D )+E*  Ado)+E*.*ecord+ource  K+ELE'T N 4*OM )+E*+ WHE*E )+E*,AMEK S tt)+E*.Tet S K A,D (A++WO*D K S tt(A++.Tet S KK Ado)+E*.*efresh NNNNNNNNNNNNNNNNNNN End +ub

(ri-ate +ub tt(A++/'hange03 On Error *esue ,et

81

4I,D )+E*  Ado)+E*.*ecord+ource  K+ELE'T N 4*OM )+E*+ WHE*E )+E*,AMEK S tt)+E*.Tet S K A,D (A++WO*D K S tt(A++.Tet S KK Ado)+E*.*efresh NNNNNNNNNNNNNNNNNNN End +ub

(ri-ate +ub 2A+/'6ick03 On Error *esue ,et d&t+ALE.*efresh d&t+ALE.+how

End +ub

(ri-ate +ub 2'
End +ub

(ri-ate +ub 2L+/'6ick03 On Error *esue ,et d&tLOW.*efresh d&tLOW.+how

End +ub

82

Di YEA*= As Integer 

+ub LoadDE4)LT03 On Error *esue ,et

;I2E DE4)LT DATE 2AL)E+ ttDOB.Tet  Date ttEM(DATE.Tet  Date NNNNNNNNNNNNNNNNNNNNNNNNNNNNN

DE4)LT +E5 O&tMAL.2a6ue  True

NNNNNNNNNNNNNNNNNNNN

LOAD DE4)LT (I'T)*E tt(I5.Tet  KcGV(*O;*AM 4ILE+V(HAMA'YVIagesVno/iage.8&gK (I5.(icture  Load(icture0tt(I5.Tet3 NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN

DE4)LT 2AL)E+ 4O* 'OMBO BO5 tt+TAT)+.Tet  K+ELE'T +TAT)+PPK

NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN

83

*E4*E+H *E'O*D Ado,)M.*efresh I,'*EME,T ,)MBE*  6b6;E,,O.'a&tion  2a606b6;E,,O.'a&tion3 Q = DE(E,DI,; O, THEE LE,;TH7 +);;E+T ,)MBE*  If Len06b6;E,,O.'a&tion3  = Then tt*E;.Tet  KB(+!!K S 2a606b6;E,,O.'a&tion3 E6seIf Len06b6;E,,O.'a&tion3  # Then tt*E;.Tet  KB(+!K S 2a606b6;E,,O.'a&tion3 E6se tt*E;.Tet  KB(+K S 2a606b6;E,,O.'a&tion3 End If  NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN

End +ub

+ub Load(i03 On Error *esue ,et Load (icture If tt(I5.Tet  KK Then tt(I5.Tet  KcGV(*O;*AM 4ILE+V(HAMA'YVIagesVno/iage.8&gK (I5.(icture  Load(icture0tt(I5.Tet3 E6se (I5.(icture  Load(icture0tt(I5.Tet3 End If  NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN End +ub

84

+ub 2a6idate*ecords03 On Error *esue ,et Di A7 B As Integer  *E+ET 'O),TE*+ A ! B! NNNNNNNNNNNNNNNNNNNNNNNN

'HE'< I4 THI+ *E;,O I+ A2AILABLE If 6b6TY(E.'a&tion  K,K And Len06b6,AME.'a&tion3 P = Then MsgBo KTHI+ +TA44 ID HA+ BEE, TA
'HE'< I4 THI+ )+E*,AME I+ A2AILABLE If 6b6TY(E.'a&tion  K,K And Len06b6)+E*.'a&tion3 P = Then MsgBo KTHI+ )+E*,AME HA+ BEE, TA
2ALIDATE *E'O*D

85

If tt*E;.Tet  KK Or ttEM(DATE.Tet  KK Or tt,AME.Tet  KK Or tt+E5.Tet  KK Or ttDOB.Tet  KK Or tt,ATIO,.Tet  KK Or tt+TATE.Tet  KK Or ttADD.Tet  KK Or tt(HO,E.Tet  KK Or ttEMAIL.Tet  KK Or tt+TAT)+.Tet  K+ELE'T +TAT)+PPK Then MsgBo KALL 4IELD+ M)+T BE 4IELD BE4O* I AM ALLOWED TO +A2E THI+ *E'O*D. THA,< YO)K7 -bEc6aation7 K0+TA44 MA,A;E*3K Eit +ub End If  NNNNNNNNNNNNNNNNNNNNNNNNNNNN

+A2E *E'O*D Ado+TA44.*ecordset.+a-e Ado,)M.*ecordset.+a-e NNNNNNNNNNNNNNNNNNNNNNNNNN

DI+(LAY +)''E++ MsgBo K*E'O*D WA+ +A2ED +)''E++4)LLYK7 -bInforation NNNNNNNNNNNNNNNNNNNNNNNNNNNN

 Di A,+ As Integer   DI+(LAY 'O,4I*MATIO, O4 ,EW *E'O*D A,+  MsgBo0KWO)LD YO) LI
86

If A,+  -bYes Then DELETE *E'O*D Ado+TA44.*ecordset.Add,ew

LOAD DE4)LT 2AL)E+ LoadDE4)LT NNNNNNNNNNNNNNNNNNNNNN

Eit +ub End If 

),HIDEcontro6s *E4*E+H *E'O*D+ Ado+TA44.*efresh NNNNNNNNNNNNNNNNNNNNNNNNNNNN

End +ub

+ub HIDEcontro6s03 ake contro6s in-isib6e cd,E5T.2isib6e  4a6se cd(*E2.2isib6e  4a6se cdLA+T.2isib6e  4a6se cd4I*+T.2isib6e  4a6se cdEDIT.2isib6e  4a6se cd,EW.2isib6e  4a6se cdMenu.2isib6e  4a6se

87

NNNNNNNNNNNNNNNNNNNNNNNNNNNNN

hide search bar  tt+EA*'H.2isib6e  4a6se Labe6=0=$3.2isib6e  4a6se

NNNNNNNNNNNNNNNNNNNNNNNNNNN

ake contro6s -isib6e cd'A,'EL.2isib6e  True cd+A2E.2isib6e  True cd(I5.2isib6e  True D=.2isib6e  True D#.2isib6e  True NNNNNNNNNNNNNNNNNNNNNNNNN

ake contro6s E,ABLED O&tMAL.Enab6ed  True O&t4EM.Enab6ed  True tt*E;.Enab6ed  True tt,AME.Enab6ed  True tt+E5.Enab6ed  True ttDOB.Enab6ed  True tt,ATIO,.Enab6ed  True tt+TATE.Enab6ed  True tt+TAT)+.Enab6ed  True ttADD.Enab6ed  True

88

tt(HO,E.Enab6ed  True ttEM(DATE.Enab6ed  True ttEMAIL.Enab6ed  True ttA;E.Enab6ed  True tt)+E*.Enab6ed  True tt(A++.Enab6ed  True

NNNNNNNNNNNNNNNNNNNNNNNNN

;I2E DE4)LT DATE D=.2a6ue  Date D#.2a6ue  Date YEA*=  D=.Year  NNNNNNNNNNNNNNNNNNNNN

'HA,;E 'A(TIO, Me.'a&tion  K+TA44 *E;I+T*ATIO,K NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN tt*E;.+et4ocus

End +ub

+ub ),HIDEcontro6s03

89

ake contro6s -isib6e cd,E5T.2isib6e  True cd(*E2.2isib6e  True cdLA+T.2isib6e  True cd4I*+T.2isib6e  True cdEDIT.2isib6e  True cd,EW.2isib6e  True cdMenu.2isib6e  True NNNNNNNNNNNNNNNNNNNNNNNNNNN

ake contro6s in-isib6e cd'A,'EL.2isib6e  4a6se cd+A2E.2isib6e  4a6se D=.2isib6e  4a6se D#.2isib6e  4a6se cd(I5.2isib6e  4a6se NNNNNNNNNNNNNNNNNNNNNNNNNNNNNN

unhide search bar  tt+EA*'H.2isib6e  True

Labe6=0=$3.2isib6e  True

NNNNNNNNNNNNNNNNNNNNNNNNNNN

ake contro6s DI+ABLED O&tMAL.Enab6ed  4a6se

90

O&t4EM.Enab6ed  4a6se tt*E;.Enab6ed  4a6se tt,AME.Enab6ed  4a6se tt+E5.Enab6ed  4a6se ttDOB.Enab6ed  4a6se tt,ATIO,.Enab6ed  4a6se tt+TATE.Enab6ed  4a6se tt+TAT)+.Enab6ed  4a6se ttADD.Enab6ed  4a6se tt(HO,E.Enab6ed  4a6se ttEM(DATE.Enab6ed  4a6se ttEMAIL.Enab6ed  4a6se ttA;E.Enab6ed  4a6se tt)+E*.Enab6ed  4a6se tt(A++.Enab6ed  4a6se

NNNNNNNNNNNNNNNNNNNNNNNNN

'HA,;E 'A(TIO, Me.'a&tion  K+TA44 *E'O*D+K NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN End +ub

(ri-ate +ub cdEDIT/'6ick03 On Error *esue ,et

91

HIDEcontro6s TY(E O4 *E'O*D 6b6TY(E.'a&tion  KEK NNNNNNNNNNNNNNNNNNNNNN DI+ABLE *E;,O 4IELD tt*E;.Enab6ed  4a6se NNNNNNNNNNNNNNNNNNNNNNNNNN End +ub

(ri-ate +ub cd'A,'EL/'6ick03 On Error *esue ,et ),HIDEcontro6s 'A,'EL 'HA,;E+ MADE TO *E'O*D+ Ado+TA44.*ecordset.'ance6)&date NNNNNNNNNNNNNNNNNNNNNNNNNNNN End +ub

(ri-ate +ub cdME,)/'6ick03 On Error *esue ,et DI+(LAY ME),) frMAI,.+how 'LO+E THI+ 4O*M )n6oad Me

End +ub

92

(ri-ate +ub cd,EW/'6ick03 On Error *esue ,et HIDEcontro6s ADD ,EW *E'O*D Ado+TA44.*ecordset.Add,ew NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN

LOAD DE4)LT 2AL)E+ LoadDE4)LT NNNNNNNNNNNNNNNNNNNNNN 6b6TY(E.'a&tion  K,K

End +ub

(ri-ate +ub cd,E5T/'6ick03 On Error *esue ,et ;O TO THE ,E5T *E'O*D Ado+TA44.*ecordset.Mo-e,et NNNNNNNNNNNNNNNNNNNNNNNNNNNNN

I4 YO) ;ET THE E,D O4 THE 4ILE If Ado+TA44.*ecordset.EO4 Then ;O TO THE *E'O*D BE4O*E THE BLA,< 0IE THE LA+T *E'O*D3 Ado+TA44.*ecordset.Mo-e(re-ious DI+(LAY A ME++A;E THAT YO) A*E AT THE E,D MsgBo KYO) HA2E *EA'HED THE E,D O4 THI+ *E'O*DK7 -bInforation End If 

93

NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN Load(i End +ub

(ri-ate +ub cd(I5/'6ick03 On Error *esue ,et (*O(I5.+howO&en tt(I5.Tet  (*O(I5.4i6e,ae (I5.(icture  Load(icture0tt(I5.Tet3 End +ub

(ri-ate +ub cd(*E2/'6ick03 On Error *esue ,et ;O TO THE (*E2IO)+ *E'O*D Ado+TA44.*ecordset.Mo-e(re-ious NNNNNNNNNNNNNNNNNNNNNNNNNNNNN

I4 YO) ;ET THE BE;I,,I,; O4 THE 4ILE If Ado+TA44.*ecordset.BO4 Then ;O TO THE *E'O*D BE4O*E THE BLA,< 0I.e THE 4I*+T *E'O*D3 Ado+TA44.*ecordset.Mo-e,et DI+(LAY A ME++A;E THAT YO) A*E AT THE BE;I,,I,; MsgBo KYO) HA2E *EA'HED THE BE;I,,I,; O4 THI+ *E'O*DK7 -bInforation Load(i End If  NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN End +ub

94

(ri-ate +ub cdLA+T/'6ick03 On Error *esue ,et ;O TO THE LA+T *E'O*D Ado+TA44.*ecordset.Mo-eLast NNNNNNNNNNNNNNNNNNNNNNNNNNNNN Load(i End +ub

(ri-ate +ub cd4I*+T/'6ick03 On Error *esue ,et ;O TO THE 4I*+T *E'O*D Ado+TA44.*ecordset.Mo-e4irst NNNNNNNNNNNNNNNNNNNNNNNNNNNNN Load(i End +ub

(ri-ate +ub cd+A2E/'6ick03 On Error *esue ,et 2a6idate*ecords End +ub

(ri-ate +ub D#/'hange03 On Error *esue ,et

95

ttEM(DATE.Tet  D#.2a6ue End +ub

(ri-ate +ub D=/'hange03 On Error *esue ,et ttDOB.Tet  D=.2a6ue ttA;E.Tet  YEA*= 9 2a60D=.Year3 End +ub

(ri-ate +ub 4or/Load03 ),HIDEcontro6s

End +ub

(ri-ate +ub 4or/)n6oad0'ance6 As Integer3 On Error *esue ,et DI+(LAY ME),) frMAI,.+how *E4*E+H *E'O*D+ O, THE ME,) With frMAI, .AdoD*);.*efresh End With NNNNNNNNNNNNNNNN 'LO+E THI+ 4O*M )n6oad Me

End +ub

96

(ri-ate +ub O&t4EM/'6ick03 tt+E5.Tet  K4EMALEK End +ub

(ri-ate +ub O&tMAL/'6ick03 tt+E5.Tet  KMALEK End +ub

(ri-ate +ub Tier=/Tier03 cd,EW/'6ick  Tier=.Enab6ed  4a6se End +ub

(ri-ate +ub tt(HO,E/
97


Bee& End +e6ect

NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN End +ub

(ri-ate +ub tt(I5/'hange03 On Error *esue ,et Load(i End +ub

(ri-ate +ub tt*E;/'hange03 On Error *esue ,et Ado'HE'<.*ecord+ource  K+ELE'T N 4*OM TBL+TA44 WHE*E *E;,OK S tt*E;.Tet S KK Ado'HE'<.*efresh

End +ub

(ri-ate +ub tt*E;/Lost4ocus03 On Error *esue ,et 'HE'< I4 THI+ *E;,O I+ A2AILABLE If 6b6TY(E.'a&tion  K,K And Len06b6,AME.'a&tion3 P = Then MsgBo KTHI+ +TA44 ID HA+ BEE, TA
98

(ri-ate +ub tt+EA*'H/'hange03 On Error *esue ,et Ado+TA44.*ecord+ource  K+ELE'T N 4*OM TBL+TA44 WHE*E *E;,O LI
End +ub

(ri-ate +ub tt+E5/'hange03 On Error *esue ,et +ELE'T +E5 WE, *E'O*D I+ +'*OLLED If tt+E5.Tet  KMALEK Then O&tMAL.2a6ue  True E6se O&t4EM.2a6ue  True NNNNNNNNNNNNNNNNNNNNNNNNNNN End If  End +ub

(ri-ate +ub tt+TAT)+/
'ase -b
99

'ase E6se
Bee& End +e6ect

NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN End +ub

(ri-ate +ub ttTY(E/
'ase -b
Bee& End +e6ect

NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN

End +ub

(ri-ate +ub tt)+E*/'hange03 On Error *esue ,et Ado'HE'<#.*ecord+ource  K+ELE'T N 4*OM TBL+TA44 WHE*E *E;,OK S tt)+E*.Tet S KK Ado'HE'<#.*efresh

100

End +ub

(ri-ate +ub Ti,EW/Tier03 On Error *esue ,et cd,EW/'6ick  Ti,EW.Enab6ed  4a6se End +ub

101

2IEW +ALE+ Di 4),= As 2ariant

(ri-ate +ub cdDEL/'6ick03 On Error *esue ,et Di A,+ As Integer  (*OM(T 4O* *E+(O,+E A,+  MsgBo0KA*E YO) +)*E YO) WA,T TO DELETE THI+ D*); *E'O*DRK7 -buestion Q -bYes,o3 If A,+  -b,o Then Eit +ub End If  DELETE *E'O*D I4 THEY A,+WE* YE+ AdoD*);.*ecordset.De6ete *E4*E+H *E'O*D+ AdoD*);.*efresh AdoD*);.*efresh

End +ub

(ri-ate +ub cd,E5T/'6ick03 On Error *esue ,et ;O TO THE ,E5T *E'O*D AdoD*);.*ecordset.Mo-e,et NNNNNNNNNNNNNNNNNNNNNNNNNNNNN

I4 YO) ;ET THE E,D O4 THE 4ILE

102

If AdoD*);.*ecordset.EO4 Then ;O TO THE *E'O*D BE4O*E THE BLA,< 0IE THE LA+T *E'O*D3 AdoD*);.*ecordset.Mo-e(re-ious DI+(LAY A ME++A;E THAT YO) A*E AT THE E,D MsgBo KYO) HA2E *EA'HED THE E,D O4 THI+ *E'O*DK7 -bInforation End If  NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN

End +ub

(ri-ate +ub cd(*E2/'6ick03 On Error *esue ,et ;O TO THE (*E2IO)+ *E'O*D AdoD*);.*ecordset.Mo-e(re-ious NNNNNNNNNNNNNNNNNNNNNNNNNNNNN

I4 YO) ;ET THE BE;I,,I,; O4 THE 4ILE If AdoD*);.*ecordset.BO4 Then ;O TO THE *E'O*D BE4O*E THE BLA,< 0I.e THE 4I*+T *E'O*D3 AdoD*);.*ecordset.Mo-e,et DI+(LAY A ME++A;E THAT YO) A*E AT THE BE;I,,I,; MsgBo KYO) HA2E *EA'HED THE BE;I,,I,; O4 THI+ *E'O*DK7 -bInforation

End If  NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN End +ub

103

(ri-ate +ub cdLA+T/'6ick03 On Error *esue ,et ;O TO THE LA+T *E'O*D AdoD*);.*ecordset.Mo-eLast NNNNNNNNNNNNNNNNNNNNNNNNNNNNN

End +ub

(ri-ate +ub cd4I*+T/'6ick03 On Error *esue ,et ;O TO THE 4I*+T *E'O*D AdoD*);.*ecordset.Mo-e4irst NNNNNNNNNNNNNNNNNNNNNNNNNNNNN

End +ub

(ri-ate +ub 'dALL/'6ick03 On Error *esue ,et AdoD*);.*ecord+ource  K+ELE'T N 4*OM TBL+ALE O*DE* BY D*);/,AMEK AdoD*);.*efresh

End +ub

(ri-ate +ub 'oand=/'6ick03 On Error *esue ,et

104

AdoD*);.*ecord+ource  K+ELE'T N 4*OM TBL+ALE WHE*E *E;/DATE BETWEE,K S D=.2a6ue S K A,D K S D#.2a6ue S K O*DE* BY D*);/,AMEK AdoD*);.*efresh

End +ub

(ri-ate +ub 4or/Load03 On Error *esue ,et 6b6DATE.'a&tion  Date End +ub

(ri-ate +ub 4or/)n6oad0'ance6 As Integer3 frMAI,.+how With frMAI, .AdoD*);.*efresh .Ado'AT.*efresh

End With End +ub

(ri-ate +ub tt4),/'LI'<03 I4 ALL I+ +ELE'TED7 4I,D ALL *E'O*D+ If tt4),.Tet  KALLPPK Then AdoD*);.*ecord+ource  K+ELE'T N 4*OM TBL+ALE O*DE* BY D*);/,AMEK AdoD*);.*efresh E6se +ELE'T THE +ELE'TED 'ATE;O*Y

105

AdoD*);.*ecord+ource  K+ELE'T N 4*OM TBL+ALE WHE*E D*);/4),'TIO,K S tt4),.Tet S K O*DE* BY D*);/,AMEK AdoD*);.*efresh End If 

End +ub

(ri-ate +ub tt+EA*'H/'hange03 On Error *esue ,et +EA*'H *E'O*D BY +O*TI,; *E'O*D AdoD*);.*ecord+ource  K+ELE'T N 4*OM TBL+ALE WHE*E D*);/,AME LI
(ri-ate +ub Ti4),/Tier03 On Error *esue ,et I4 WE HA2E THE +AME 'ATE;O*Y7 I;,O*E IT A,D ;O TO THE THE ,E5T *E'O*D If 6b64),.'a&tion  4),= Then Ado4),.*ecordset.Mo-e,et NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN E6se EL+E ADD IT TO THE LI+T O4 4),'TIO,+ A,D (*O'EED TO THE ,E5T *E'O*D tt4),.AddIte 6b64),.'a&tion 4),=  6b64),.'a&tion Ado4),.*ecordset.Mo-e,et

106

End If  NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN I4 YO) ;ET TO THE E,D7 +TO( If Ado4),.*ecordset.EO4 Then Ado4),.*ecordset.Mo-e(re-ious Ti4),.Enab6ed  4a6se End If  NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN

End +ub

(ri-ate +ub tt+O*T/'6ick03 Di LOW= As Integer 

On Error *esue ,et I4 ALL I+ +ELE'TED7 ;I2E ALL *E'O*D+ If tt+O*T.Tet  KALLPPK Then AdoD*);.*ecord+ource  Kse6ect N fro TBL+ALE order by drug/naeK AdoD*);.*efresh

I4 IT+ LOW *E'O*D E6seIf tt+O*T.Tet  KLOW +TO'
107

E6seIf tt+O*T.Tet  KE5(I*ED D*);+K Then AdoD*);.*ecord+ource  Kse6ect N fro TBL+ALE where e&iry/dateK S 6b6DATE.'a&tion S K order by drug/naeK AdoD*);.*efresh End If  End +ub

(ri-ate +ub tt4),/
Bee& End +e6ect

NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN End +ub

(ri-ate +ub tt+O*T/
108