Basic HTML Version

|  | Table of Contents |  | View Full Version

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 |