Class-45 (Query Table)

gvwëwgwWqv †Uªwbs GKv‡Wgx , wSbvB`n

mvwU©wd‡KU Bb Kw¤úDUvi Awdm A¨vwcø­‡Kkb

45 K¬vk

Make Query Table ‰Zwi t

GB †Kv‡qwii myweav n‡jv GK ev GKvwaK †Uwe‡ji wdì wb‡q GKwU †Uwej ˆZwi Kiv hvq| Service ‡WUv‡e‡Ri wi‡jkb hy³ (Information, Employee) `yBwU †Uwe‡ji Name, Address, Job Title, District, Salary wd츇jv wb‡q Make Table Query ‰Zwi Kivi Rb¨

: Service ‡WUv‡eRwU I‡cb K‡i Gi Create wieb Gi Other IqvK©MÖæ‡ci Aaxb Query design wK¬K Ki‡Z n‡e|

: Show Table WvqvjM eK&ª n‡Z Table `ywU wm‡j± K‡i Add evUb wK¬K Ki‡Z n‡e|

: Close evUb wK¬K Ki‡Z n‡e|

: Select Query DB‡Ûv‡Z Employee Ges Information ‡Uwej n‡Z cQ‡›`i wdì G Wvej wK¬K K‡i wdì †iv‡Z ¯’vcb Ki‡Z n‡e|

: Desig U¨v‡ei Aaxb Query Type IqvK©MÖæ‡ci Aaxb Make Table evU‡b wK¬K Ki‡Z n‡e|

: Table Name Gi ¯’v‡b bZzb †Uwe‡ji bvg w`‡q ‡hgb : Mt-1 w`‡q Ok wK¬K Ki‡Z n‡e|

: Save evU‡b wK¬K Ki‡Z n‡e|

: ‡h †Kvb bvg ‡hgb : Make table-1 UvBc Ki‡Z n‡e hv Make ‡Kv‡qixi bvg wn‡m‡e _vK‡e|

: Ok evU‡b wK¬K Ki‡Z n‡e|

: Make Table Query DB‡Ûv eÜ Ki‡Z n‡e|

: Query wU ivb Kivi Rb¨ †Kv‡qwiwU wm‡j± K‡i Open wK¬K Ki‡Z n‡e|

Update Query t

‡Kvb †Uwe‡ji wbe©vwPZ †iKW©mg~‡ni wbw`©ó wd‡ìi gvb‡K cwieZ©b Kivi Kv‡R G †Kv‡qwi e¨envi Kiv nq| Avc‡WU †Kv‡qwii gva¨‡g †Uwe‡ji †hvM, we‡qvM, Mo, †iRvë BZ¨vw` †ei Kiv hvq| wb‡gœi Student ‡Uwe‡ji Total, Average, Result wdì wZbwU Avc‡WU †Kv‡qwii gva¨‡g c‚iY Ki‡Z n‡j-

wb‡gœi b¨vq GKwU Student ‡Uwej ˆZwi Kiæb|

Roll	Number
Name	Text
Bang	Number
Eng	Number
Math	Number
Total	Number
Average	Number
Result	Text

Dc‡iv³ Student ‡Uwe‡j 5wU †WUv Gw›Uª Kiæb|

: Service ‡WUv‡eRwU I‡cb K‡i Gi Create wieb Gi Other IqvK©MÖæ‡ci Aaxb Query design wK¬K Ki‡Z n‡e|

: Show Table WvqvjM eK&ª n‡Z Table : Student wm‡j± K‡i Add evUb wK¬K Ki‡Z n‡e|

: Close evUb wK¬K Ki‡Z n‡e|

: Desig U¨v‡ei Aaxb Query Type IqvK©MÖæ‡ci Aaxb Update evU‡b wK¬K Ki‡Z n‡e|

: Student Table Gi Total, Average, Result Wej wK¬K K‡i wdì †iv‡Z ¯’vcb Ki‡Z n‡e|

: Update To ‡iv‡Z Total ‡ei Kivi Rb¨ Total Column G [Bang]+[Eng]+[Math] UvBc Ki‡Z n‡e|

: Update To ‡iv‡Z Average ‡ei Kivi Rb¨ Average Column G ([total])/3 UvBc Ki‡Z n‡e|

: Update To ‡iv‡Z Result ‡ei Kivi Rb¨ Result Column G iif([Average]>=80, "A+", iif([Average]>=70, "A", iif([Average]>=60,"A-",iif([Average]> 50, "B", "C"))) wj‡L G›Uvi Pvc‡Z n‡e|

: Save K‡i (†hgb t Exam) Update Query DB‡Ûv †_‡K †ei n‡Z n‡e|

: Query wU ivb Kivi Rb¨ Exam wm‡j± K‡i Open wK¬K Ki‡Z n‡e|

: Yes Click > Yes Click Ki‡Z n‡e|

: Table U¨ve wK¬K Ki‡Z n‡e|

: Student ‡Uwej wm‡j± K‡i Open wK¬K Ki‡j †UwejwUi †UvUvj, Gfv‡iR I †iRvë Avc‡WU n‡q‡Q Zv †`Lv hv‡e|

Delete Query t

GKwU †WUv‡e‡Ri dvBj †_‡K wbw`©ó wKQy Z_¨ gy‡Q †`qvi Rb¨ GB †Kv‡qwi e¨envi Kiv nq| awi Information ‡Uwe‡ji Computer wWcvU©‡g›U cÖ‡qvRb ‡bB| GRb¨ Computer wWcvU©‡g›U‡K Delete Query Gi gva¨‡g gy‡Q w`‡Z n‡j t

: Service ‡WUv‡eRwU I‡cb K‡i Gi Create wieb Gi Other IqvK©MÖæ‡ci Aaxb Query design wK¬K Ki‡Z n‡e|

: Show Table WvqvjM eK&ª n‡Z Table : Information wm‡j± K‡i Add evUb wK¬K Ki‡Z n‡e|

: Close evU‡b wK¬K Ki‡Z n‡e|

: Desig U¨v‡ei Aaxb Query Type IqvK©MÖæ‡ci Aaxb Delete wK¬K Ki‡Z n‡e|

: Information ‡Uwe‡ji mKj wd‡ì Wvej wK¬K K‡i wdì †iv‡Z ¯’vcb Ki‡Z n‡e|

: Criteria Row Gi Department Kjv‡g Computer UvBc Ki‡Z n‡e|

: ‡Kvb bvg w`‡q (†hgb t Delete) Save evU‡b wK¬K K‡i DB‡Ûv †_‡K †ei n‡Z n‡e|

: Table U¨v‡e wK¬K K‡i Information ‡Uwej I‡cb Ki‡j Kw¤úDUvi wWcvU©‡g›U †`Lv hv‡e bv|

VBS—Visual Basic Script

VPN—Virtual Private Network

VPU—Visual Processing Unit

WAN—Wide Area Network

WAP—Wireless Access Point /Wireless Application Protocol

Wi-Fi—Wireless Fidelity

WLAN—Wireless Local Area Network

WMA—Windows Media Audio

WMV—Windows Media Video

WPAN—Wireless Personal Area Network