Page 35 - Math_Genius_1 2

4 ,e,l ,Dlsl esa ç'u] iQkWeZ

vkSj fjiksVZ

(Queries, Forms and Reports in

MS Access)

vkidk y{;

fuEu osQ fo"k; esa tkuuk %
,e,l ,Dlsl esa iQkWeZ ,e,l ,Dlsl esa ç'u

,e,l ,Dlsl esa fjiksVZ

vkius lh•k gS fd oSQls ,e,e ,Dlsl dk mi;ksx Vscy cukus vkSj MsVkcsl esa fjdkWMZ cuk, j•us osQ fy, fd;k
tkrk gSA eku yhft, fd ,d Vscy esa dbZ dkWye gSa] rks vkidks lHkh fjdkWMZ ls ,d fo'ks"k MsVk dh ryk'k esa cgqr
vf/d le; nsuk iM+ ldrk gSA lkFk gh] fdlh fjdkWMZ osQ ckjs esa lHkh tkudkjh dh ges'kk vko';drk ugha gksrh gSA

bl leL;k dks gy djus osQ fy,] ,e,e ,Dlsl esa iQkWeZ] Dosjh vkSj fjiksVZ tSlh oqQN vkSj lqfo/k,¡ gSaA ;s lqfo/k,¡
vko';d tkudkjh dks 'kkWVZfyLV djus esa enn djrh gSaA ;g nks ;k nks ls vf/d VscYl dks tksM+us vkSj lHkh p;fur
VscYl ls lesfdr tkudkjh izn£'kr djus esa Hkh enn djrh gSaA

,e,l ,Dlsl esa QkWeZ (Forms in MS Access)
mi;ksxdrkZ osQ vuqowQy rjhosQ ls VscYl ls MsVk tksM+us] laikfnr djus vkSj izn£'kr djus osQ fy, iQkWeZ dk mi;ksx fd;k
+
tkrk gSA iQkWeZ cukrs le;] vki izn£'kr dh tkus okyh IkQhYM vkSj vki mUgsa oSQls izn£'kr djuk pkgrs gSa] pqu ldrs
gSaA iQkWeZ cukdj] vki vius MsVkcsl dks mu yksxksa osQ fy, vf/d mi;ksxdrkZ osQ vuqowQy cuk ldrs gSa tks fjdkWMZ
laikfnr djrs gSa vkSj n”kZ djrs gSaA
rhu eq[; n`';] ftuesa ,d iQkWeZ izn£'kr fd;k tk ldrk gS%
iQkWeZ n`'; dk mi;ksx MsVk n”kZ djus] laikfnr djus vkSj ns•us osQ fy, fd;k tkrk gSA
fM”kkbu n`'; dk mi;ksx vkiosQ iQkWeZ osQ fMtkbu dks lek;ksftr djus osQ fy, fd;k tkrk
gSA ;g vkidks fdlh iQkWeZ dh lajpuk tSls gsMj] fooj.k vkSj iqQVuksV vuqHkkxksa osQ ckjs esa
vf/d foLr`r n`'; nsrk gSA
ysvkmV n`'; dk mi;ksx fdlh iQkWeZ osQ fofHkUu fu;a=k.kksa osQ Lo:i vkSj vkdkj dks cnyus
osQ fy, fd;k tkrk gSA
çi=k osQ fodYi ns•sa
oaQI;wVj (Views options
of a Form)

Kku fM”kkbu n`'; ls iQkWeZ n`'; esa tkus osQ fy, 'kkWVZdV oqaQth F5 gSA

,e,l ,Dlsl esa ç'u] iQkWeZ vkSj fjiksVZ 33