bilal ahmed shaik visual basic access - excel
TRANSCRIPT
-
7/23/2019 Bilal Ahmed Shaik Visual Basic Access - Excel
1/25
A
-
7/23/2019 Bilal Ahmed Shaik Visual Basic Access - Excel
2/25
D Ifgpl`t`SutfradlbfrM`oajj`rs
YEDAK MALDLDEG@C
-
7/23/2019 Bilal Ahmed Shaik Visual Basic Access - Excel
3/25
AAA
Casildag`r
@xi`l RMD Gdc` @dsy ' D Ifgpl`t` Gdjudl bfr M`oajj`rs as dj ajc`p`jc`jt
pumlaidtafj djc as jft dbbaladt`c wate, jfr eds at m``j dutefraz`c, spfjsfr`c, fr
fte rwas` dpprfv c my Gairfsfbt Ifrpfrdtafj*
Srdc`gdrks
Gairfsfbt, Rasudl Mdsai, @xi`l djc _ajcfws dr` ate`r r`oast`r`c trdc`gdrks fr
trdc`gdrks fb Gairfsfbt Ifrpfrdtafj aj te` Pjat`c Ytdt`s djc&fr fte`r ifujtra`s*
Ladmalaty
Se` purpfs` fb teas mffk as tf prfvac` mdsai ouac`laj` bfr p`fpl` ajt`r`st`c aj @xi`l
RMD prfordggajo* Dltefuoe `v`ry `bbfrt djc idr` eds m``j tdk`j tf gdk` te`
ajbfrgdtafj ds diiurdt` ds pfssaml`, te` dutefr sedll jft m` ladml` bfr djy `rrfr, edrg
fr cdgdo` drasajo brfg usajo te` ajstruitafjs oav`j aj teas mffk*
Ifpyraoet YEDAK MALDL DEG@C =849* Dll raoets r`s`rv`c* Jf pdrt fb teas mffk gdy
m` r`prfcui`c fr trdjsgatt`c aj djy bfrg fr my djy g`djs, watefut p`rgassafj aj
wratajo brfg te` dutefr*
-
7/23/2019 Bilal Ahmed Shaik Visual Basic Access - Excel
4/25
AR
SDML@ FB IFJS@JSY
Iedpt`r 4 Ajtrfcuitafj tf @xi`l RMD
4*4 Se` Ifji`pt fb @xi`l RMD
4*= Se` Rasudl Mdsai @catfr aj GY @xi`l
4*9 Se` @xi`l RMD Ifc
4
4
=
0
Iedpt`r = Gdjdoajo Cdtd aj @xi`l RMD
=*4 Cdtd Syp`s aj @xi`l RMD
=*= Gdjdoajo Rdradml`s
=*9 Se` Ps` fb Fptafj @xplaiat
=*3 Dssaojajo Rdlu`s tf Rdradml`s
=*0 X`rbfrgajo Drateg`tai Fp`rdtafjs aj @xi`l RMD
?
?
44
43
40
42
Iedpt`r 9 Drrdy
9*4 _edt as dj Drrdy6
9*= C`ildrajo Drrdys aj @xi`l RMD
41
41
41
Iedpt`r 3 Psajo G`ssdo` mfx djc Ajput mfx aj @xi`l RMD
3*4 Se` GsoMfx% ! Bujitafj
3*= Se` AjputMfx% ! Bujitafj
=3
=3
=1
Iedpt`r 0 Ifjtrfllajo Xrfordg Blfw aj @xi`l RMD0*4 Ifjcatafjdl Fp`rdtfrs
0*= Lfoaidl Fp`rdtfrs
0*9 Se` Ab***Se`j***@ls`ab***@ls` C`iasafj Ytruitur`
0*3 Se` Y`l`it Ids`****@jc Y`l`it C`iasafj Ytruitur`
9494
9=
9=
9?
Iedpt`r 2 Lffpajo
2*4 Se` Bfr***J`xt Lffp
2*= Se` Cf*** Lffp
2*9 Se` _eal`***_`jc Lffp
91
91
30
35
Iedpt`r ? @xi`l RMD Fmn`its Xdrt 4Dj Ajtrfcuitafj
?*4 _edt as @xi`l dj @xi`l RMD fmn it6
?*= Xrfp`rta`s djc G`tefcs
08
08
0=
Iedpt`r 5 @xi`l RMD Fmn`its Xdrt =
Se` _frkmffk Fmn`it 05
-
7/23/2019 Bilal Ahmed Shaik Visual Basic Access - Excel
5/25
R
5*4 Se _frkmffk Xrfp`rta`s
5*= Se _frkmffk G`tefcs
05
28
Iedpt`r 1 @xi`l RMD Fmn`its Xdrt 9Se` _frkse``t Fmn`it
1*4 Se _frkse``t prfp`rta`s
1*= Se _frkse``t G`tefcs
29
29
20
Iedpt`r 48 @xi`l RMD Fmn`its Xdrt 3Se` ]djo` Fmn it
48*4 Se` ]djo` Xrfp`rta`s
48*= Se` ]djo` G`tefcs
25
25
?=
Iedpt`r 44 _frkajo wate @xi`l RMD Ifjtrfls
44*4 Ie`ik Mfx
44*= S`xt Mfx44*9 Fptafj Muttfj
44*3 Last Mfx
44*0 Ifgmf Mfx
44*2 Sfool` Muttfj
?2
?2
?5?1
5=
59
53
Iedpt`r 4= Bujitafjs djc Yum Xrfi`cur`s
4=*4 Se` Ifji`pt fb Bujitafj
4=*= Syp`s fb Bujitafjs4=*9 _ratajo Bujitafj Ifc`
4=*3 Xdssajo Rdradml`s my ]`b r`ji` djc my Rdlu` aj d
Bujitaf j
4=*0 Yum Xrfi`cur`
50
50
5050
14
19
Iedpt`r 49 Ytrajo Edjclajo Bujitafjs
49*4 AjYtr
49*= L`bt
49*9 ]aoet
49*3 Gac
49*0 L`j
12
12
12
12
12
1?
Iedpt`r 43 Cdt` djc Sag` Bujitafjs
43*4 Psajo te` Jfw % ! Bujitafj
43*= Rdrafus Cdt` djc Sag` Bujitafjs
43*9 Cdt`Xdrt Bujitafj
43*3 Dccajo djc Yumtrditajo Cdt`s
11
11
488
48=
489
-
7/23/2019 Bilal Ahmed Shaik Visual Basic Access - Excel
6/25
RA
Iedpt`r 40 Ydgpl` @xi`l RMD Xrfordgs 480
40*4 MGA Idliuldtfr 480
40*= Bajdjiadl Idliuldtfr 482
40*9 Ajv`stg`jt Idliuldtfr 485
40*3 Xrag` Jugm`r S`st`r 48140*0 Y`l`ita v Yuggdtafj 444
40*2 Djagdtafj 44=
-
7/23/2019 Bilal Ahmed Shaik Visual Basic Access - Excel
7/25
?
Iedpt`r 4
Ajtrfcuitafj tf @xi`l RMD
O`ttajo tf kjfw te` ifji`pt fb @xi`l RMD
L`drj efw tf us` Rasudl Mdsai @catfr aj GY @xi`l
L`drj efw tf wrat` sagpl` @xi`l RMD ifc`
4*4 Se` Ifji`pt fb @xi`l RMD
RMD as te` dirfjyg bfr Rasudl Mdsai bfr Dpplaidtafjs* At as dj ajt`ordtafj fb te`
Gairfsfbt/s v`jt'crav j prfordggajo ldjoudo` Rasudl Mdsai wate Gairfsfbt
Fbbai` dpplaidtafjs suie ds Gairfsfbt @xi`l, Gairfsfbt _frc, Gairfsfbt
Xfw`rXfajt djc gfr`* My rujjajo Rasudl Mdsai AC@ wateaj te` Gairfsfbt Fbbai`
dpplaidtafjs, w` idj mualc iustfgaz`c sflutafjs djc prfordgs tf `jedji` te`
idpdmalata`s fb tefs` dpplaidtafjs*
Dgfjo te` Rasudl Mdsai bfr dpplaidtafjs, Gairfsfbt @xi`l RMD as te` gfst
pfpuldr* Se`r` dr` gdjy r`dsfjs wey w` sefulc l`drj RMD bfr Gairfsfbt
@xi`l, dgfjo te`g as yfu idj l drj te` bujcdg`jtdls fb Rasudl Mdsai
prfordggajo wateaj te` GY @xi`l `jvarfjg`jt, watefut edvajo tf purieds` d
ifpy fb Gairfsfbt Rasudl Mdsai sfbtwdr * Djfte`r r`dsfj as my l`drjajo @xi`l
RMD; yfu idj mualc iustfg gdc` bujitafjs tf ifgpl g`jt te mualt'aj
bfrguld` djc bujitafjs fb Gairfsfbt @xi`l* Dltefuoe GY @xi`l eds d lft fb
mualt'aj bfrguld` djc bujitafjs, at as stall jft jfuoe bfr i`rtdaj ifgpl x
idliuldtafjs djc dpplaidtafjs* Bfr `xdgpl , at as v`ry edrc tf idliuldt gfjtely
pdyg`jt bfr d lfdj tdk`j usajo @xi`l/s mualt'aj bfrgulds, mut at as r`ldtav`ly
`dsy tf prfordg d RMD bfr suie idliuldtafj* Seas mffk as wratt`j aj suie d
wdy tedt yfu idj l`drj RMD bfr GY @xi`l aj dj `dsy gdjj`r, djc `v`ryfj`
sedll gdst`r at aj d sefrt tag`$
-
7/23/2019 Bilal Ahmed Shaik Visual Basic Access - Excel
8/25
5
Qfu idj prfordg @xi`l RMD aj `v`ry v`rsafj fb Gairfsfbt Fbbai`, ajilucajo GY
Fbbai` 1?, GY Fbbai`=888, GY Fbbai`=88=, GY Fbbai`=889, GY Fbbai` UX djc
GY Fbbai` =88?* Se` r`dsfj RMD as j``c`c as cu` tf te` lagatdtafjs aj usajo
te` mualt'aj bujitafjs fb GY @xi`l djc gdirf r`ifrcajo* My usajo RMD, yfu
idj mualc sfg` v`ry pfw`rbul tffls aj GY @xi`l, ajilucajo bajdjiadl djc
sia`jtabai dpplaidtafjs suie ds o`ttajo bajdjiadl cdtd brfg te` Ajt rj`t ds w`ll
ds laj`dr prfordggajo*
4*= Se` Rasudl Mdsai @catfr aj GY @xi`l
Se`r` dr` twf wdys weaie yfu idj stdrt prfordggajo RMD aj GY @xi`l* Se`
barst wdy as tf pldi` d ifggdjc muttfj fj te` spr`dcse``t djc stdrt
prfordggajo my ilaikajo te` ifggdjc muttfj tf ldujie te` Rasudl Mdsai
@catfr* Se` s`ifjc wdy as tf ldujie te` Rasudl Mdsai @catfr my ilaikajo fj te`
Sffls g`ju te`j s`l`it Gdirf brfg te` crfp'cfwj g`ju djc ieffs` Rasudl
Mdsai @catfr* L`ts stdrt wate te` ifggdjc muttfj barst* Aj frc`r tf p ldi` d
ifggdjc muttfj fj te` GY @xi`l spr dcse``t, yfu j``c tf ilaik Ra`w fj te`
GY @xi`l g`ju mdr djc te`j ilaik fj tfflmdrs djc bajdlly s`l`it te` Ifjtrfl
Sfflmfx dbt`r weaie te` ifjtrfl tfflmfx mdr wall dpp`dr, ds sefwj aj Baour` 4*4*
Se`j yfu ilaik fj te` ifggdjc muttfj djc crdw at fj te` spr`dcse``t, dssefwj aj Baour` 4*=*
Baour` 4*4> Caspldyajo Ifjtrfl Sfflmfx aj GY @xi`l*
-
7/23/2019 Bilal Ahmed Shaik Visual Basic Access - Excel
9/25
48
Baour` 4*=> Se` Ifggdjc Muttfj aj C`saoj Gfc`
Jfw yfu s`l`it te` ifggdjc muttfj djc gdk` sur` te` c`saoj muttfj fj te`
bdr l`bt fb te` ifjtrfl tfflmfx as c`pr`ss`c* J`xt, ilaik fj te` ifggdjc muttfj
tf ldujie te` Rasudl Mdsai @catfr* @jt`r te` stdt`g`jts ds sefwj aj baour` 4*9*
L`ts wrat` fut te` ifc` e`r`>
@xdgpl` 4*4
Xravdt` Yum IfggdjcMuttfj4VIl aik %!
]djo` %D4>D48!*Rdlu`7Rasudl Mdsai
]djo` %I44!*Rdlu`7]djo` %D44!*Rdlu` +]djo` %M44!*Rdlu`
@jc Yum
Se` barst stdt`g`jt wall ba ll up i`ll D4 tf i`ll D48 wate te` perds` -Rasudl Mdsai-
weal` te` s`ifjc stdt`g`jt dcc te` vdlu`s aj i`ll D44 djc i`ll M44 djc te`j
sefw te` sug aj i`ll I44* Sf ruj te` prfordg, yfu j``c tf xat te` Rasudl
Mdsai @catfr my ilaik te` @xi`l muttfj fj te` bdr l`bt ifrj`r fb te` tffl mdr*
-
7/23/2019 Bilal Ahmed Shaik Visual Basic Access - Excel
10/25
44
_e`j yfu dr` aj te` GY @xi`l `jvarfjg`jt, yfu idj `xat te` c`saoj gfc` my
ilaikajo te` c`saoj muttfj, te`j ilaik fj te` ifggdjc muttfj*
Baour` 4*9> Se` Rasudl Mdsai @catfr AC@ aj GY @xi`l
]ujjajo te` dmfv` RMD wall oav` yfu te` bfllfwajo futput*
Baour` 4*3>
-
7/23/2019 Bilal Ahmed Shaik Visual Basic Access - Excel
11/25
4=
4*9 Se` @xi`l RMD Ifc`
_ratajo @xi`l RMD ifc` as dlgfst xditly te` sdg` ds wratajo ifc` aj Rasudl
Mdsai, weaie g`djs yfu edv` tf us` syjtdx sagaldr tf Rasudl Mdsai* Efw`v`r,
te`r` dr` ifc`s sp`iadlly c`saoj`c bfr us` aj GY @xi`l, suie ds te` us` fb
te` fmn`it fr bujitafj idll`c ]djo`* At as te` bujitafj tedt sp`iaba`s te` vdlu`
fb d i`ll fr d rdjo` fb i`lls aj GY @xi`l spr`dcse``t* Se` bfrgdt fb usajo
]djo` as ds bfllfws>
]djo` %i`ll Jdg`!*Rdlu`7K fr]djo` %]djo` fbI`lls!*Rdlu`7K
_e`r` Rdlu` as te` prfp`rty fb ]djo` djc k idj m` d jug`rai vdlu` fr d
strajo
@xdgpl` 4*=
Xravdt` Yum IfggdjcMuttfj4VIl aik %!
]djo` %D4!*Rdlu`7 RMD
@jc Yum
Se` dmfv` `xdgpl` wall `jt`r te` t`xt RMD ajtf i`ll D4 fb te` GY @xi`l
spr`dcse``t we`j te` us`r pr`ss`s te` ifggdjc muttfj* Qfu idj dlsf us`
]djo` watefut te` Rdlu` prfp`rty, ds sefwj aj @xdgpl` 4*9>
@xdgpl` 4*9
Xravdt` Yum IfggdjcMuttfj4VIl aik %!
]djo` %-D4-! 7 488
@jc Yum
Aj te` dmfv` xdgpl`, ilaikajo te` ifggdjc muttfj wate jt r te` vdlu` fb
488 ajtf i`ll D4 fb te` GY @xi`l spr`dcse``t*
-
7/23/2019 Bilal Ahmed Shaik Visual Basic Access - Excel
12/25
49
Se` bfllfw `xdgpl` c`gfjstrdt`s efw tf ajput vdlu`s ajtf d rdjo` fb i`lls>
@xdgpl` 4*3
Ajputte` vdlu` fb488 brfg i`ll D4 tf i`ll D48
Xravdt` Yum IfggdjcMuttfj4VIl aik %!
]djo` %-D4>D48-! 7 488
@jc Yum
-
7/23/2019 Bilal Ahmed Shaik Visual Basic Access - Excel
13/25
43
Iedpt`r =
Gdjdoajo Cdtd aj @xi`l RMD
O`ttajo tf kjfw vdrafus cdtd typ`s aj @xi`l RMD
L`drj efw tf c`ildr vdradml`s djc dssaojajo vdlu`s tf te`g
O`ttajo tf kjfw vdrafus drateg`tai fp`rdtfrs aj @xi`l RMD
L`drj efw tf wrat` ifc` tedt p`rbfrg drateg`tai fp`rdtafjs aj @xi`l
RMD
Aj fur cdaly lab`, w` ifg` dirfss gdjy typ`s fb cdtd* Bfr `xdgpl`, w` j``c tf
edjcl` cdtd suie ds jdg`s, dccr`ss`s, gfj`y, cdt`s, stfik quft`s, stdtastais
djc gfr` v rycdy* Yagaldrly, aj @xi`l RMD, w` edv` tf c`dl wate dll sfrts
fb cdtd; sfg` dr jug`rai aj jdtur` weal` sfg` dr` aj te` bfrg fb t`xt fr fte`r
bfrgs* @xi`l RMD cavac`s cdtd ajtf cabb`r`jt typ`s sf tedt at as `dsa`r tf
gdjdo` we`j w` j``c tf wrat` te` ifc` ajvflvajo tefs` cdtd*
=*4 Cdtd Syp`s aj @xi`l RMD
@xi`l RMD ildssaba`s te` ajbfrgdtafj g`jtafj c dmfv` ajtf twf gdnfr cdtd
typ`s; jdg`ly te` jug`rai cdtd typ`s djc te` jfj'jug`rai cdtd typ`s*
=*4*4 Jug`rai Cdtd Syp`s
Jug`rai cdtd typ`s dr` typ`s fb cdtd tedt ifjsast fb jugm`rs, weaie yfu idj
ifgput te`g gdte`gdtaidlly wate vdrafus stdjcdrc fp`rdtfrs suie ds, dcc,
gajus, gultaply, cavac` djc sf fj* @xdgpl`s fb jug`rai cdtd typ`s dr` yfur
`xdgajdtafj gdrks, yfur e`aoet djc yfur w`aoet, te` jugm`r fb stuc`jts aj d
ildss, sedr` vdlu`s, prai` fb offcs, gfjtely malls, b``s djc gfr`* Aj @xi`l
RMD, w` cavac` jug`rai cdtd ajtf s`v`j typ`s, c`p`jcajo fj te` rdjo` fb
vdlu`s te`y idj stfr`* Idliuldtafjs tedt fjly ajvflv` rfujc baour`s fr cdtd tedt
cf jft j``c pr`iasafj idj us` Ajt`o`r fr Lfjo ajt`o`r aj te` ifgputdtafj*
Xrfordgs tedt r`quar` eaoe pr`iasafj idliuldtafj j``c tf us` Yajol` djc
-
7/23/2019 Bilal Ahmed Shaik Visual Basic Access - Excel
14/25
40
Cfuml c`iasafj cdtd typ`s, w` dlsf idll te`g blfdtajo'pfajt jugm`rs* Bfr
iurr`jiy idliuldtafj, yfu idj us` te` iurr`jiy cdtd typ`s* Ldstly, ab v`j
gfr` pr`iasafj as r`quar`s weaie ajvflv` gdjy c`iagdl pfajts, w` idj us` te`
c`iagdl cdtd typ`s* _` suggdraz`c te` cdtd typ`s aj Sdml =*4
Sdml` =*4> Jug`rai Cdtd Syp`s
Syp Ytfrdo` ]djo` fb Rdlu`s
Myt` 4 myt` 8 tf =00
Ajt`o`r = myt`s '9=,?25 tf 9=,?2?
Lfjo 3 myt`s '=,43?,359,235 tf =,43?,359,235
Yajol` 3 myt`s'9*38=5=9@+95 tf '4*384=15@'30 bfr j`odtav` vdlu`s
4*384=15@'30 tf 9*38=5=9@+95 bfr pfsatav` vdlu`s*
Cfuml` 5 myt`s
'4*?1?21949352=9=`+985 tf '3*13820230534=3?@'9=3
bfr j`odtav` vdlu`s
3*13820230534=3?@'9=3 tf 4*?1?21949352=9=`+985 bfr
pfsatav` vdlu`s*
Iurr`jiy5 myt`s '1==,99?,=89,250,3??*0585 tf 1==,99?,=89,250,3??*058?
C`iagdl 4= myt`s
+&' ?1,==5,42=,043,=23,99?,019,039,108,990 ab jf c`iagdl
as us`
+&' ?*1==542=043=2399?019039108990 %=5 c`iagdl
pldi`s!*
=*4*= Jfj'jug`rai Cdtd Syp`s
Jfjjug`rai cdtd typ`s dr` cdtd tedt idjjft m` gdjapuldt`c gdte`gdtaidlly
usajo stdjcdrc drateg`tai fp`rdtfrs* Se` jfj'jug`rai cdtd ifgpras`s t`xt fr
strajo cdtd typ`s, te` Cdt` cdtd typ`s, te` Mffl`dj cdtd typ`s tedt stfr` fjly
twf vdlu`s %tru` fr bdls`!, Fmn`it cdtd typ` djc Rdradjt cdtd typ` *_`
suggdraz`c te`g aj Sdml` =*=
Sdml` =*=> Jfjjug`rai Cdtd Syp`s
Cdtd Syp` Ytfrdo` ]djo`
-
7/23/2019 Bilal Ahmed Shaik Visual Basic Access - Excel
15/25
42
Ytrajo%bax`c l`jote! L`jote fb strajo 4 tf 20,388 iedrdit`rs
Ytrajo%vdradml`
l`jote!L`jote + 48 myt s 8 tf = mallafj iedrdit`rs
Cdt` 5 myt`s Ndjudry 4, 488 tf C`i`gm`r 94,1111
Mffl`dj = myt`s Sru` fr Bdls`
Fmn`it 3 myt`s Djy gm`cc`c fmn`it
Rdradjt%jug`rai! 42 myt`s Djy vdlu` ds ldro` ds Cfuml`
Rdradjt%t`xt! L`jote+== myt s Ydg` ds vdradml`'l`jote strajo
=*4*9 Yubbax`s bfr Lat`rdls
Lat`rdls dr` vdlu`s tedt yfu dssaoj tf d cdtd* Aj sfg` ids`s, w` j``c tf dcc d
subbax m`eajc d lat`rdl sf tedt RM=848 idj edjcl` te` idliuldtafj gfr`
diiurdt`ly* Bfr xdgpl`, w` idj us` jug74*9851) bfr d Cfuml` typ` cdtd*
Yfg` fb te` subbax`s dr` caspldy`c aj Sdml` =*9*
Sdml` =*9> Yubbax`s bfr Lat`rdls
Yubbax Cdtd Syp
" Lfjo
$ Yajol`
) Cfuml`
H Iurr`jiy
Aj dccatafj, w` j``c tf `jilfs` strajo lat`rdls wateaj twf quftdtafjs djc cdt`
djc tag` lat`rdls wateaj twf ) saoj* Ytrajos idj ifjtdaj djy iedrdit`rs,
ajilucajo jugm`rs* Se` bfllfwajo dr` b`w `xdgpl`s>
g`gm`rJdg`7-Surmdj, Nfej*-
S`lJugm`r7-4588'188'555'???-
LdstCdy7)94'C`i'88)
@xpSag`7)4=>88 dg)
=*4*3 Ps`r'C`baj`c Syp`s
-
7/23/2019 Bilal Ahmed Shaik Visual Basic Access - Excel
16/25
4?
M`sac`s te` dmfv` cdtd typ`s, yfu tff idj ir`dt` yfur fwj cdtd typ`* Qfu
c`baj` d j`w cdtd typ` my ifgmajajo te` mualt'aj cdtd typ`s g`jtafj dmfv`*
Se` bfrgdt tf c`baj` d cdtd typ` as
Syp` vdradml`Vjdg`
Ytdt`g`j ts
@jc Syp`
Qfu j``c tf c`baj` te` us`r'c`baj`c typ` aj te` o`j`rdl c`ildrdtafj dr`d fb d
gfcul * L`t lffk dt @xdgpl =*4*
@xdgpl` =*4
Syp` Ytuc`jt
YtuJdg` Ds Ytrajo
YtuAC Ds Ytrajo
YtuB`` Ds Iurr jiy
YtuQ`drDs Ytrajo
@jc Syp`
Jfw yfu edv` ir`dt`c d j`w cdtd typ` idll`c Ytuc`jt weaie idrra`s
ajbfrgdtafj suie ds jdg`, stuc`jt AC, b`` djc Q`dr*
Sf gdk` us` fb te` dmfv` cdtd, yfu idj us` te` Cag k`ywfrc djc te` bfrgdt
as ds bfllfws>
Cag orfup Ds Ytuc`jt
orfup *YtuJdg` 7 -Ndg`s -
orfup *YtuAC 7 -488?-
orfup *YtuQ`dr7 -Bajdl Q`dr-
orfup *YtuB`` 7 -#=8,888-
-
7/23/2019 Bilal Ahmed Shaik Visual Basic Access - Excel
17/25
45
I`lls%=, =! 7 orfup *YtuJdg`
I`lls%9, =! 7 orfup *YtuAC
I`lls%3, =! 7 orfup *YtuQ`dr
I`lls%0, =! 7 orfup *YtuB``
Sf t`st te` dmfv` ifc`, fp`j d j`w wfrkmffk djc `jt`r te` dmfv` ifc` aj
te RM@* ]ujjajo te` RMD wall jt`r te` stuc`jt ajbfrgdtafj ajtf te` i`lls
sp`iaba`c aj te` ifc`, ds sefwj aj Baour` =*4
Baour` =*4
=*= Gdjdoajo Rdradml`s
Rdradml`s dr` lak` gdal mfx`s aj te` pfst fbbai`* Se` ifjt`jts fb te` vdradml`s
iedjo`s `v`ry jfw djc te`j, nust lak` te` gdal mfx`s* Aj @xi`l RMD, vdradml`s
dr` dr`ds dllfidt`c my te` ifgput r g`gfry tf eflc cdtd* Lak` te` gdal mfx`s,
`die vdradml` gust m` oav`j d jdg`* Sf jdg` d vdradml` aj @xi`l RMD, yfu
edv` tf bfllfw d s`t fb rul`s, ds bfllfws>
-
7/23/2019 Bilal Ahmed Shaik Visual Basic Access - Excel
18/25
41
=*=*4 Rdradml` Jdg`s
Se` bfllfwajo dr` te` rul`s we`j jdgajo te` vdradml`s aj @xi`l RMD
At gust m` l`ss tedj =00 iedrdit`rs
Jf spdiajo as dllfw`c
At gust jft m`oaj wate d jugm`r
X`rafc as jft p`rgatt c
@xdgpl`s fb vdlac djc ajvdlac vdradml` jdg`s dr` caspldy`c aj Sdml` =*3
Sdml` =*3> @xdgpl`s fb vdlac djc ajvdlac vdradml` jdg`s
Rdlac Jdg` Ajvdlac Jdg`
GyVIdr SeasQ dr
LfjoVJdg`VIdjVm`PY@
Gy*Idr
4J`wMfy
E`"EasBdte`r ." as jft dii`ptdml`
Orfup55 Ytuc`jt AC . Ypdi` jft dllfw`c
=*=*= C`ildrajo Rdradml`s
Aj @xi`l RMD, w` j``c tf c`ildr` te` vdradml`s m`bfr` usajo te`g my
dssaojajo jdg`s djc cdtd typ`s* Qfu idj c`ildr` te` vdradml`s agplaiatly fr
`xplaiatly* Bfr xdgpl`, sug7t`xt4*t`xt g`djs tedt te` vdradml` sug as
c`ildr`c agplaiatly djc r`dcy tf r`i`av` te` ajput aj t`xtmfx4* Fte`r `xdgpl`s
fb agplaiat c`ildrdtafj dr` vflug`75 djc ldm`l7_`lifg`* Fj te` fte`r edjc,
bfr xplaiat c`ildrdtafj, vdradml s dr` jfrgdlly c`ildr`c aj te` o`j`rdl s`itafjfb te` ifc` wajcfw usajo te` Cag stdt g`jt*
Se` bfrgdt as ds bfllfws>
Cag vdradml Jdg` ds CdtdSyp`
@xdgpl` =*=
-
7/23/2019 Bilal Ahmed Shaik Visual Basic Access - Excel
19/25
=8
Cag pdsswfrc Ds Ytrajo
Cag yfurJdg` Ds Ytrajo
Cag barstjug Ds Ajt`o`r
Cag s`ifjcjug Ds Ajt`o`r
Cagtftdl
DsAjt`o`r
Cag MarteCdy ds Cdt`
Qfu gdy dlsf ifgmaj` te`g aj fj` laj`, s`pdrdtajo `die vdradml` wate d
ifggd, ds bfllfws>
Cag pdsswfrc Ds Ytrajo, yfurJdg` Ds Ytrajo, barstjug Ds Ajt`o`r*
Ab te` cdtd typ` as jft sp`iaba`c, RM@ wall dutfgdtaidlly c`ildr` te` vdradml` ds
d Rdradjt* Bfr strajo c`ildrdtafj, te`r` dr` twf pfssaml` bfrgdts, fj` bfr te`vdradml`'l`jote strajo djc djfte`r bfr te` bax c'l`jote strajo* Bfr te` vdradml`'
l`jote strajo, nust us` te` sdg` bfrgdt ds @xdgpl =*4 dmfv`*
Efw`v`r, bfr te` bax`c'l`jote strajo, yfu edv` tf us` te` bfrgdt ds sefwj
m`lfw>
Cag Rdradml Jdg` ds Ytrajo . j
_e`r` j c`baj`s te` jugm`r fb iedrdit`rs te` strajo idj eflc* Bfr xdgpl`,
Cag yfurJdg` ds Ytrajo . 48 g`dj yfurJdg` idj eflc jf gfr` tedj 48
Iedrdit`rs*
@xdgpl` =*=
Aj teas `xdgpl`, w` c`ildr`c ter`` typ`s fb vdradml`s, jdg`ly te` strajo, cdt`
djc iurr`jiy*
Xravdt` Yum IfggdjcMuttfj4VIl aik %!
Cag QfurJdg` Ds Ytrajo
Cag MarteCdy Ds Cdt`
Cag Ajifg` Ds Iurr jiy
-
7/23/2019 Bilal Ahmed Shaik Visual Basic Access - Excel
20/25
=4
QfurJdg` 7 -Dl`x-
MarteCdy 7 -4 Dpral4158-
Ajifg` 7 4888
]djo`%-D4-! 7 QfurJdg`
]djo` %-D=-! 7 MarteCdy
]djo` %-D9-! 7 Ajif g`
@jc Yum
Baour` =*=> Futput sir``j bfr @xdgpl` =*=
=*9 Se` us` fb Fptafj @xplaiat
Se` us` fb Fptafj @xplaiat as tf e`lp us tf trdik `rrfrs aj te` usdo` fb vdradml`
jdg`s wateaj d prfordg ifc`* Bfr xdgpl`, ab w` ifggat d typf, te` RM@ wall
pfp up dj `rrfr g`ssdo` Rdradml` jft c`baj`c* Ajc``c, Fptafj @xplaiat bfri`s
te` prfordgg`r tf c`ildr` dll te` vdradml`s usajo te` Cag k`ywfrc* At as d
offc prditai` tf us` Fptafj @xplaiat m`idus` at wall pr`v`jt us brfg usajo
ajifrr`it vdradml` jdg`s cu` tf typajo `rrfrs, `sp`iadlly we`j te` prfordg
o`ts ldro`r* _ate te` usdo` fb Fptafj @xplaiat, at wall sdv us tag` aj c`muooajo
fur prfordgs*
_e`j Fptafj @xplaiat as ajiluc`c aj te` prfordg ifc`, dll vdradml`s j``c tf m`
c`ildr`c usajo te` Cag k`ywfrc* Djy vdradml` jft c`ildr`c fr wrfjoly typ`c
-
7/23/2019 Bilal Ahmed Shaik Visual Basic Access - Excel
21/25
==
wall idus` te` prfordg tf pfpup te` Rdradml` jft c`baj`c `rrfr g`ssdo`*
Se` rrfr j``cs tf m` ifrr`it c m`bfr` te` prfordg idj ifjtaju` tf ruj*
@xdgpl` =*9
Seas `xdgpl` us`s te` Fptafj @xplaiat k`ywfrc djc at c`gfjstrdt`s efw d
typf as m`ajo trdik`c*
Fptafj @xplaiat
Xravdt` Yum IfggdjcMuttfj4VIl aik %!
Cag QfurJdg` Ds Ytrajo
Cag pdsswfrc Ds Ytrajo
QfurJdg` 7 -Nfej-
pdsswfrc 7 4=930
I`lls%4, =! 7 QfurJdg
I`lls %4, 9! 7 pdsswfrc
@jc Yum
Se` typf as QfurJdg djc sf te` `rrfr g`ssdo` vdradml` jft c`baj`c wall m`
caspldy c djc te` prfordg as susp`jc`c, ds sefwj aj Baour` =*9*
-
7/23/2019 Bilal Ahmed Shaik Visual Basic Access - Excel
22/25
=9
Baour` =*9> @rrfr g`ssdo` cu` tf typf `rrfr
=*3 Dssaojajo Rdlu`s tf te` Rdradml`s
Dbt`r c`ildrajo vdrafus vdradml`s usajo te` Cag stdt g`jts, w` idj dssaoj
vdlu`s tf tefs` vdradml`s* Se` o`j`rdl bfrgdt fb dj dssaojg`jt as
Rdradml`7@xpr ssafj
Se` vdradml` idj m` d c`ildr`c vdradml` fr d ifjtrfl prfp`rty vdlu`* Se`
`xpr`ssafj ifulc m` d gdte`gdtaidl xpr ssafj, d jugm`r, d strajo, d
Mffl`dj vdlu` %tru` fr bdls`! djc gfr`* Se` bfllfwajo dr` sfg` `xdgpl`s>barstJugm`r7488
s`ifjcJugm`r7barstJugm`r'11
us`rJdg`7-Nfej Lydj-
us`rpdss*S`xt 7 pdsswfrc
Ldm`l4*Rasaml` 7 Sru`
Ifggdjc4*Rasaml` 7 bdls`
-
7/23/2019 Bilal Ahmed Shaik Visual Basic Access - Excel
23/25
=3
SearcJugm`r 7 Rdl%us`rjug4*S`xt!
tftdl 7 barstJugm`r + s`ifjcJugm`r+SearcJugm`r
=*0 X`rbfrgajo Drateg`tai Fp`rdtafjs aj @xi`l RMD
Aj frc`r tf ifgput` ajput brfg te` us`r djc tf o`j`rdt` r`sults aj @xi`l RMD,
w` idj us` vdrafus gdte`gdtaidl fp`rdtfrs* Aj @xi`l RMD, `xi`pt bfr + djc '
, te` sygmfls bfr te` fp`rdtfrs dr` cabb r`jt brfg jfrgdl gdte`gdtaidl
fp`rdtfrs, ds sefwj aj Sdml` =*0*
Sdml` =*0> Drateg`tai Fp`rdtfrs
Fp`rdtfrGdte`gdtaidl bujitafj @xdgpl`
Z @xpfj`jtadl =Z3742
. Gultaplaidtafj 3.974=
& Cavasafj 4=&379
GfcGfculus %r`turj te` r`gdajc`r brfg dj
ajt`o`r cavasafj!40 Gfc 379
\Ajt`o`r Cavasafj %casidrcs te` c`iagdl
pldi`s!41\373
+ fr " Ytrajo ifjidt`jdtafj-Rasudl-"-Mdsai-7-Rasudl
Mdsai-
@xdgpl` =*3
Fptafj @xplaiat
Xravdt` Yum IfggdjcMuttfj4VIl aik %!
Cag jugm`r4, jugm`r=, jugm`r9 ds Yajol`
Cag tftdl, dv`rdo` ds Cfuml`
jugm`r47I`lls %4, 4!*Rdlu`
jugm`r47I`lls %=, 4!*Rdlu`
jugm`r97 I`lls %9, 4!*Rdlu`
Sftdl7jugm`r4+jugm`r=+jugm`r9
Dv`rdo`
7Sf
tdl&9
-
7/23/2019 Bilal Ahmed Shaik Visual Basic Access - Excel
24/25
=0
I`lls %0, 4! 7Sftdl
I`lls %2, 4! 7Dv`rdo`
@jc Yum
Aj `xdgpl` =*3, ter`` vdradml`s dr` c`ildr`c ds sajol` djc djfte`r twf
vdradml`s dr` c`ildr`c ds vdradjt* Rdradjt g`djs te` vdradml` idj eflc djy
jug`rai cdtd typ`* Se` prfordg ifgput`s te` tftdl djc dv`rdo` fb te` ter``
jugm`rs tedt dr` jt`r`c ajtf ter`` i`lls aj te` @xi`l spr`dcse``t*
@xdgpl` =*0
Fpt
afj @xplaia
t
Xravdt` Yum IfggdjcMuttfj4VIl aik %!
Cag s`ifjcJdg` Ds Ytrajo
Cag yfurJdg` Ds Ytrajo
barstJdg` 7 I`lls %4, 4!*Rdlu`
s`ifjcJdg` 7 I`lls %=, 4!*Rdlu`
yfurJdg` 7 barstJdg` + - - + s`ifjcJdg`
I`lls%9,4! 7 yfurJdg`
@jc Yum
Aj teas xdgpl`, ter`` vdradml`s dr` c`ildr`c ds strajo* Se` vdradml` barstJdg`
djc te` vdradml` s`ifjcJdg` wall r`i`av` te`ar cdtd `jt`r`c my te` us`r ajtf
I`lls %4, 4! djc i`lls %=, 4! r`sp`itav`ly* Se` vdradml` yfurJdg` wall m`
dssaoj`c te cdtd my ifgmajajo te` barst twf vdradml`s* Bajdlly, yfurJdg` ascaspldy c fj I`lls %9, 4!* Qfu wall jftai` tedt p`rbfrgajo drateg`tai fp`rdtafj
fj strajos wall r`sult aj ifjidt`jdtafj fb te` strajos, ds sefwj aj baour` =*3
m`lfw* Jdg`s aj D4 djc D= dr` nfaj`c up djc caspldy`c aj D9*
-
7/23/2019 Bilal Ahmed Shaik Visual Basic Access - Excel
25/25
=2
Baour` =*3> Ifjidt`jdtafj fb Ytrajos