gvwëwgwWqv †Uªwbs GKv‡Wgx , wSbvB`n
mvwU©wd‡KU Bb Kw¤úDUvi Awdm A¨vwcø‡Kkb
44 K¬vk
‡Kv‡qwi t
‡Kv‡qwi k‡ãi
A_© n‡jv evQvB| ZvB †WUv‡eR †Uwej †_‡K cQ›`bxq †WUv¸‡jv Luy‡R †ei Kivi c×wZ‡K
†Kv‡qwi e‡j| †Kv‡qwii KvR n‡jv †Uwe‡ji †WUv¸‡jv wb‡q| ZvB †Kv‡qwi Kivi Av‡M
†Uwe‡j †WUv Gw›Uª K‡i wb‡Z n‡e| ‡Uwej ˆZwi bv K‡i †Kv‡qwi Kiv hv‡e bv| †Uwe‡ji
Dci wfwË K‡i †Kv‡qwi ˆZwi Kiv n‡q _v‡K|
‡Kv‡qwii
myweav t
: GK ev GKvwaK †Uwe‡j msiw¶Z wecyj msL¨K †WUv †_‡K †h
†Kvb †WUv‡K AwZ `ª“Z I mn‡R †ei Kiv hvq|
: mvP©K…Z †WUv¸‡jv‡K my›`i Dc¯’vcbvi gva¨‡g wcÖ›U †`qv
hvq|
‡Kv‡qwii
cÖKvi‡f` t
gvB‡µvmdU&
†WUv‡e‡R wewfbœ ai‡bi †Kv‡qwi i‡q‡Q| h_v-
1. Select
Queries 2. Crosstab Queries 3. Action Queries ( Make Queries, Update Queries, Append Queries, Delete Queries) 4. SQL Queries
Select Queries t Kw¤úDUv‡ii
wm‡j± †Kv‡qwii e¨envi me‡P‡q †ewk e¨eüZ n‡q _v‡K| GB †Kv‡qwii gva¨‡g †Kvb
†Uwe‡ji †WUv mn‡R evQvB K‡i Zv †mf K‡i ivLv hvq| ZvQvovI GK ev GKvwaK †Uwej
†_‡K †WUv¸‡jv‡K wb‡q mn‡R KvR Kiv hvq|
wm‡j±
‡Kv‡qwi ˆZwi Kiv
1. Information ‡Uwe‡ji †iKW©¸wj †_‡K Job Title, Department, Salary wdì¸wj cÖ`k©‡bi Rb¨ TSC bv‡g GKwU ‡Kv‡qwi †Uwej ˆZwi Ki‡Z-
: 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 bv‡g GKwU WvqvjM eK&ª Avm‡e|
: Show Table WvqvjM eK&ª †_‡K Information ‡Uwej wm‡j± K‡i Add evU‡b wK¬K
Ki‡Z n‡e|
: Close evU‡b wK¬K Ki‡Z n‡e| †UwejwU †Kv‡qwi DB‡Ûv‡Z †`Lv
hv‡e|
: Select Query DB‡Ûv‡Z Information ‡Uwe‡ji Job
Title, Department, Salary wdì
Gi Dci Wej wK¬K K‡i Field ‡iv †Z ¯’vcb
Ki‡Z n‡e|
: ‡Kv‡qwi †UwejwU TSC bv‡g
†mf Ki‡Z n‡e|
cieZx©‡Z
TSC ‡Kv‡qwi †UwejwU I‡cb Ki‡Z n‡j
: Navigation evUb †_‡K All Access object wm‡j± Ki‡j Query cÖ`wk©Z n‡e|
: TSC Gi Dci gvD‡mi Wvej wK¬K Ki‡j Zvn‡j ïay Dc‡iv³ 3wU
wd‡ìi †iKW©¸‡jv †`Lv hv‡e|
2. Information ‡Uwe‡ji †_‡K hv‡`i wWcvU©‡g›U Computer Zv‡`i ZvwjKv cÖ`k©‡bi Rb¨ TSC-1 bv‡g GKwU †Kv‡qwi †Uwej ˆZwi Ki‡Z n‡j-
: 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 bv‡g GKwU WvqvjM eK&ª Avm‡e|
: Show Table WvqvjM eK&ª †_‡K Information ‡Uwej wm‡j± K‡i Add evU‡b wK¬K
Ki‡Z n‡e|
: Close evU‡b wK¬K Ki‡Z n‡e| †UwejwU †Kv‡qwi DB‡Ûv‡Z †`Lv
hv‡e|
: Select Query DB‡Ûv‡Z Information ‡Uwe‡ji mKj wdì Gi Dci Wej wK¬K K‡i wd츇jv Field ‡iv †Z ¯’vcb Ki‡Z n‡e|
: Criteria Row Gi Department Kjv‡g Computer wjL‡Z n‡e|
: ‡Kv‡qwi †UwejwU TSC-1 bv‡g †mf K‡i DB‡Ûv †_‡K †ei n‡Z n‡e|
cieZx©‡Z
TSC-1 ‡Kv‡qwi †UwejwU I‡cb Ki‡Z n‡j
: Query Gi Aaxb TSC-1 Gi Dci gvD‡mi Wvej wK¬K Ki‡j Computer Department Gi †iKW©¸‡jv †`Lv hv‡e|
3. Information ‡Uwe‡ji †_‡K hv‡`i †eZb 5500 UvKv Ges 12000 UvKvi
g‡a¨ Zv‡`i ZvwjKv cÖ`k©‡bi Rb¨ TSC-2 bv‡g GKwU
†Kv‡qwi †Uwej ˆZwi Ki‡Z n‡j-
: 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 bv‡g GKwU WvqvjM eK&ª Avm‡e|
: Show Table WvqvjM eK&ª †_‡K Information ‡Uwej wm‡j± K‡i Add evU‡b wK¬K
Ki‡Z n‡e|
: Close evU‡b wK¬K Ki‡Z n‡e| †UwejwU †Kv‡qwi DB‡Ûv‡Z †`Lv
hv‡e|
: Select Query DB‡Ûv‡Z Information ‡Uwe‡ji mKj wdì Gi Dci Wej wK¬K K‡i wd츇jv Field ‡iv †Z ¯’vcb Ki‡Z n‡e|
: Criteria Row Gi Salary Kjv‡g >=5500 and <=12000 A_ev Between 5500 and 12000 wjL‡Z n‡e|
: ‡Kv‡qwi †UwejwU TSC-2 bv‡g †mf K‡i DB‡Ûv †_‡K †ei n‡Z n‡e|
cieZx©‡Z
TSC-2 ‡Kv‡qwi †UwejwU I‡cb Ki‡Z n‡j
: Query Gi Aaxb TSC-2 Gi Dci gvD‡mi Wvej wK¬K Ki‡j Zvn‡j 5500 UvKv Ges 12000 UvKvi g‡a¨ hviv
†eZb cvq Zv‡`i ZvwjKv †ei n‡e|
wet `ªt
†Uwe‡ji Join
Date ‡ei Kivi †¶‡Î Criteria Row Gi Join Date Kjv‡g Between #7/6/77# and
#9/2/80# wjL‡Z n‡e|
4. Information ‡Uwe‡ji †_‡K hv‡`i wWcvU©‡g›U Computer Ges Training Zv‡`i ZvwjKv
cÖ`k©‡bi Rb¨ TSC-3
bv‡g GKwU †Kv‡qwi †Uwej ˆZwi Ki‡Z
n‡j-
: 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 bv‡g GKwU WvqvjM eK&ª Avm‡e|
: Show Table WvqvjM eK&ª †_‡K Information ‡Uwej wm‡j± K‡i Add evU‡b wK¬K
Ki‡Z n‡e|
: Close evU‡b wK¬K Ki‡Z n‡e| †UwejwU †Kv‡qwi DB‡Ûv‡Z †`Lv
hv‡e|
: Select Query DB‡Ûv‡Z Information ‡Uwe‡ji mKj wdì Gi Dci Wej wK¬K K‡i wd츇jv Field ‡iv †Z ¯’vcb Ki‡Z n‡e|
: Criteria Row Gi Department Kjv‡g Computer or Training wjL‡Z n‡e|
: ‡Kv‡qwi †UwejwU TSC-3 bv‡g †mf K‡i DB‡Ûv †_‡K †ei n‡Z n‡e|
cieZx©‡Z
TSC-3 ‡Kv‡qwi †UwejwU I‡cb Ki‡Z n‡j
: Query Gi Aaxb TSC-2 Gi Dci gvD‡mi Wvej wK¬K Ki‡j hv‡`i wWcvU©‡g›U Kw¤úDUvi Ges †UªBwbs Zv‡`i
ZvwjKv †ei n‡e|
TTF—TrueType Font
TTL—Transistor-Transistor
Logic
UPS—Uninterruptible
Power Supply
URI—Uniform
Resource Identifier
URL—Uniform
Resource Locator
USB—Universal
Serial Bus
UTF—Unicode Transformation
Format
UTP—Unshielded
Twisted Pair
VB—Visual
Basic
VBA—Visual
Basic for Applications
No comments:
Post a Comment