Thursday, August 23, 2018

Class-47(Report)


gvwëwgwWqv †Uªwbs GKv‡Wgx, wSbvB`n
mvwU©wd‡KU Bb Kw¤úDUvi Awdm A¨vwc­­‡Kkb
47 K¬vk
Report wK Ges Gi myweav t
wi‡cvU© Gi KvR n‡jv Pvwn`v gZ Z‡_¨i myweb¨¯Í cÖwZ‡e`b Dc¯’vcb Kiv GK K_vq WvUv‡e‡Ri DcvËmg~‡ni AvDUcyU n‡jv wi‡cvU© Ges wi‡cvU© Gi gva¨‡g B”Qvbyhvqx wj‡L my›`i Dc¯’vcbvq †iKW© mg~‡ni wcÖ›U †bqv nq|

Auto Report ‰Zwi
Auto Form Gi g‡Zv Auto Report Gi gva¨‡gI Lye mn‡R wi‡cvU© ˆZwi Kiv hvq|
: Service bvgK †WUv‡eRwU I‡cb K‡i Reports U¨v‡e wK¬K Ki‡Z n‡e|
: New evU‡b wK¬K Ki‡Z n‡e|
: Auto Report:Tabular wm‡j± Ki‡Z n‡e|
: K‡¤^veK&ª †_‡K cÖ‡qvRbxq Table ev Query wm‡j± (Information) Ki‡Z n‡e|
: Ok evU‡b wK¬K Ki‡jB wi‡cvU©wU w¯‹‡bi Print Preview ‡`Lv hv‡e|
: Report wU Save Kivi Rb¨ File ‡_‡K Save G wK¬K Ki‡Z n‡e|
: Report Name ‡UK&ªe‡· †h †Kvb bvg wj‡L Ok wK¬K Ki‡Z n‡e|
: Zvici DB‡ÛvwU †K¬vR Ki‡Z n‡e|

cieZx©‡Z wi‡cvU©wU I‡cb Ki‡Z PvB‡j
: Reports U¨ve wK¬K Ki‡Z n‡e|
: Information wm‡j± K‡i Preview evUb wK¬K Ki‡Z n‡e|

wi‡cvU©wU‡K Edit Kivi wbqg
A‡Uv wi‡cvU© ˆZwi Kivi ci Dnv wcÖwfD w¯Œ‡b GK mv‡_ †`Lv m¤¢e bvI n‡Z cv‡i| †m †¶‡Î wd츇jv †QvU/eo K‡i mvRv‡bv cÖ‡qvRb n‡Z cv‡i| ZvQvovI wi‡cv‡U©i Dc‡i †nwWs wn‡m‡e wKQy †jLvi cÖ‡qvRb n‡Z cv‡i| ZvB wi‡cvU©wU GwWU Kivi AwZ cÖ‡qvRb|
: wi‡cvU©wU wm‡j± K‡i Design wK¬K Ki‡Z n‡e|
: wWRvBb wfD Gi K‡qKwU †mKkb i‡q‡Q| GB †mKkb¸‡jv me‡P‡q †ekx GwWU Kiv cÖ‡qvRb Page Header Ges Detail ‡mKkb| ‡mKkb¸‡jvi g‡a¨ wd츇jv Gw`K Iw`K miv‡bv Ges †QvU/eo Kiv hvq|
: wd츇jv wm‡j± K‡i Ctrl+G¨v‡iv Kx †P‡c wd츇jv miv‡bv †h‡Z cv‡i| ZvQvovI wm‡j± Kivi ci nvZ wPý Avmvi ci WªvM K‡i wd츇jv miv‡bv hvq| wd츇jv †QvU/eo Ki‡Z n‡j wm‡j± K‡i gvSLv‡bi Kvj RvqMvq 1 GB wPý Avm‡j WªvM K‡i wdì †QvU/eo Kiv hvq|

Information bvgK †UwejwUi Report Title, Salary Gi Sub Total, Grand Total ‡ei Kiv
: Service bvgK †WUv‡eR wU Open K‡i Reports U¨v‡e wK¬K Ki‡Z n‡e|
: New evU‡b wK¬K Ki‡Z n‡e|
: Auto Report : Tabular wm‡j± Ki‡Z n‡e|
: K‡¤^veK&ª †_‡K cÖ‡qvRbxq Table/Query wm‡j± (†hgb Information) Ki‡Z n‡e|
: Ok evU‡b wK¬K Ki‡jB wi‡cvU©wU w¯Œ‡bi Print Preview ‡`Lv hv‡e|
: View Menu n‡Z Design View wK¬K Ki‡jB wi‡cvU©wUi Edit Screen P‡j Avm‡e|
: Report Header/Footer bv _vK‡j View Menu n‡Z Report Header/Footer wK¬K Ki‡Z n‡e|
: K‡›Uªvj¸‡jv †P‡c a‡i B”Qvbyhvqx miv‡q Ges †QvU/eo K‡i mvRv‡Z n‡e|

wi‡cvU© UvB‡Uj wjL‡Z n‡j
: hw` UvB‡Uj bv _v‡K Zvn‡j Toolbox n‡Z Label evUb wK¬K K‡i Report Header ‡mKk‡b WªvM K‡i B”Qvbyhvqx UvB‡Uj (†hgb- Employee Information) wjL‡Z n‡e|

Sort Ges Group Abyhvqx Salary Gi Sub Total ‡ei Ki‡Z n‡j
: View Menu n‡Z Sorting and Grouping wK¬K Ki‡Z n‡e|
: Field/Expression n‡Z †UwejwUi wdì wm‡j± Ki‡Z n‡e (†hgb Job Title) hv MÖ“c AvKv‡i wcÖwfD‡Z †`Lv hv‡e Ges Dnv mU© Kivi Rb¨ Ascending or Descending wbe©vPb Ki‡Z n‡e|
: Group Footer ‡m‡j wK¬K K‡i Wªc WvDb eK&ª n‡Z Yes wbe©vPb Ki‡Z n‡e Ges c‡i DB‡ÛvwU eÜ Ki‡Z n‡e|
: Information ‡Uwe‡ji wi‡cvU©wU‡Z Job Title Footer ‡mKkb e„w× cv‡e|
: Toolbox n‡Z Text Box evUb wK¬K K‡i Job Title Footer ‡mKk‡b WªvM Ki‡Z n‡e Ges Unbound Ask Salary wdì eivei ivLyb|
: Text AskwUi Dci wK¬K K‡i Sub Total wjL‡Z n‡e|
: Unbound As‡k =Sum([Salary]) UvBc Ki‡Z n‡e|

Salary Gi me©‡gvU †UvUvj (Grand Total) ‡ei Kivi Rb¨
: Toolbox n‡Z Text Box evUb wK¬K K‡i Report Footer ‡mKk‡b WªvM Ki‡Z n‡e Ges Unbound Ask Salary wdì eivei ivLyb|
: Text AskwUi Dci wK¬K K‡i Grand Total wjL‡Z n‡e|
: Unbound As‡k =Sum([Salary]) UvBc Ki‡Z n‡e|

Information bvgK †UwejwUi H_Rent, Medical Ges Total wd‡ìi †nwWs ms‡hvRb Ges Dnvi Calculation ‡ei Kiv
: Information bvgK †UwejwU‡K c~‡e©i b¨vq Auto Report ‰Zwi Ki‡Z n‡e|
: View Menu n‡Z Design View wK¬K K‡i wi‡cvU©wUi Edit Screen G Avm‡Z n‡e|

H_Rent, Medical Ges Total wd‡ìi †nWvi wnmv‡e ivLvi Rb¨
: Toolbox n‡Z Label evUb wK¬K K‡i Page Header ‡mKk‡b WªvM K‡i wZbwU UvB‡Uj (†hgb-H_Rent, Medical, Total) ‰Zwi Ki‡Z n‡e Ges my›`ifv‡e Salary wd‡ìi Wvb cv‡k mvRv‡Z n‡e|

H_Rent ‡ei Kivi Rb¨
: Toolbox n‡Z Text box evUb wK¬K K‡i Detail ‡mKk‡b WªvM Ki‡Z n‡e Ges Unbound Ask H_Rent wdì eivei ivL‡Z n‡e|
: Text As‡ki †jLv gy‡Q †dj‡Z n‡e|
: Unbound As‡k =([Salary])*50/100 UvBc Ki‡Z n‡e|

Medical fvZv †ei Kivi Rb¨
: Toolbox n‡Z Text box evUb wK¬K K‡i Detail ‡mKk‡b WªvM Ki‡Z n‡e Ges Unbound Ask Medical wdì eivei ivL‡Z n‡e|
: Text As‡ki †jLv gy‡Q †dj‡Z n‡e|
: Unbound As‡k = 700 UvBc Ki‡Z n‡e|

Total ‡ei Kivi wbqg
: Toolbox n‡Z Text box evUb wK¬K K‡i Detail ‡mKk‡b WªvM Ki‡Z n‡e Ges Unbound Ask Total wdì eivei ivL‡Z n‡e|
: Text As‡ki †jLv gy‡Q †dj‡Z n‡e|
: Unbound As‡k = ([Salary])+700+([Salary])*50/100 UvBc Ki‡Z n‡e|

GLb wcÖ›U wcÖwfD †`L‡j †Uwe‡ji wd‡ì D‡j­wLZ Salary Gi 50% House Rent, 700 UvKv K‡i †gwW‡Kj Ges Salary, Medical, House Rent Gi †gvU †hvMdj †`Lv‡e hv Information ‡Uwe‡j GB wd츇jv †bB| GBiƒc AwZwi³ KvR K‡i wcÖ›U AvDU Kiv hv‡e|






UPS-Uninterrupted Power Supply (IPS - Instant Power Supply) 
BIOS- Basic Input & Output System+
OS- Operating System
RAM- Random Access Memory
ROM- Read Only Memory
PSU- Power Supply Unit
AGP- Accelerated Graphics Port
CMOS- Complementary Metal Oxide Semiconductor
CAD- Computer Aided Design  
FTP- File Transfer Protocol

===============================================
(১) 2008 সালের - জানুয়ারী জুনের ফাইনাল পরীক্ষার প্রশ্ন 50 টি পড়তে হবে। 




No comments:

Post a Comment