Page 38 - Math_Genius_1 2
P. 38

cSdxzkmaM best
                           (Background Image)
                                                cSdxzkmaM best lfEefyr djuk (Inserting background image)

                      ,e,l ,Dlsl esa ç'u (Queries in MS Access)
                  iz'u ,e,l ,Dlsl] 2010 }kjk çnku dh tkus okyh lcls egRoiw.kZ fo'ks"krk gS] ftlosQ n~okjk vkidks ,slh tkudkjh

                  izkIr gks ldrh gS] ftls vki lh/s Vscy dks ns•dj ugha izkIr dj ldrs gSaA fdlh iz'u dk mi;ksx djosQ vki fof'k"V
                  •kst 'krZsa nsdj MsVkcsl esa ,d ;k vf/d VscYl ls MsVk •kst ;k ladfyr dj ldrs gSa rkfd vki lVhd MsVk ns•
                  losaQ] tks vki pkgrs gSaA fiQj vki vius MsVkcsl ls MsVk dh leh{kk dj ldrs gSa] tksM+ ldrs gSa] cny ldrs gSa ;k
                  gVk ldrs gSaA
                  ,Dlsl vkidks iz'u cukus ;k fuekZ.k djus vkSj mls MsVkcsl esa lgstus dh vuqefr nsrk gS rkfd vki bls dbZ ckj
                  pyk losaQA LVªDpMZ Dosjh ySaXost (,lD;w,y) fjys'kuy MsVkcsl vkSj MsVk eSfuiqys'ku osQ fy, ,d oaQI;wVj Hkk"kk gS]

                  ftldk mi;ksx MsVk Mkyus] viMsV djus vkSj la'kksf/r djus osQ fy, fd;k tkrk gSA

                  ç'uksa osQ çdkj (Types of Queries)
                  ,e,l ,Dlsl esa fofHkUu çdkj osQ ç'u gSa%
                      iz'u dk p;u djsa (Select Query)% ;g ,d ;k vf/d VscYl ls MsVk iquçkZIr djrk gSA ;g MsVk'khV esa fjdkWMZ

                       dks lewg MsVk osQ fy, izn£'kr djrk gS vkSj ;ksx] x.kuk] vkSlr bR;kfn dh x.kuk djus osQ fy, izn£'kr djrk gSA
                      iSjkehVj iz'u (Parameter Query)% ;g ,d çdkj dk pqfuank iz'u gS] tks pyus ls igys vkidks buiqV osQ
                       fy, laosQr nsrk gSA iz'u rc buiqV dks ØkbVsfj;k osQ :i esa mi;ksx djrs gSa] tks ifj.kke dks fu;af=kr djrs gSaA
                      fØ;kRed ç'u (Action Query)% ;g ,d u;k Vscy cukrk gS ;k blesa ls MsVk tksM+dj] gVkdj] v|ru vkSj

                       tksM+dj vkiosQ MsVk dks cny nsrk gSA
                      ØkWlLVSc iz'u (Crosstab Query)% ;g ,d ,slk iz'u gS] tks ,d iafDr 'kh"kZdksa vkSj dkWye 'kh"kZdksa dk mi;ksx
                       djrk gS rkfd vki ,d gh ckj esa nks Jsf.k;ksa osQ lanHkZ esa viuk MsVk ns• losaQA


                  laca/ LFkkfir djuk (Setting up Relationship)
                                                          +
                                                                                     +
                  laca/ ,sls fyad gksrs gSa] tks ,d Vscy esa ,d IkQhYM dks nwljh Vscy esa mlh IkQhYM ls lac¼ djrs gSaA ,d laca/ nksuksa
                                          +
                                                                                          +
                  VscYl esa leku uke okys IkQhYM dk feyku djosQ dk;Z djrk gSA esy •kus okys IkQhYM ,d Vscy dh çkFkfed dh
                  gSa] tks fdlh Vscy esa çR;sd fjdkWMZ dks fof'k"V :i ls igpkurh gSaA iQkWjsu dh ,d Vscy esa ,d dkWye gS] tks nwljs
                  Vscy dh çkFkfed dh ls esy •kuk pkfg,




                     36  Play (Ver. 1.0)-VIII
   33   34   35   36   37   38   39   40   41   42   43