আসুন কম্পিউটার শিখি,ডিজিটাল বাংলাদেশ গড়ে তুলি ।: Notes Of Microsoft Access XP

Notes Of Microsoft Access XP

Created By: Md. Helal Uddin E-mail: Helaluddin321@gmail.com.com

gvB‡_vmdU G‡·m G·wc

Part – 2

mywcÖq cÖwk¶bv_©xMb,

A‡bK A‡bK ï‡f”Qv iBj| BwZc~‡e© Avgiv Database Program Microsoft Access Gi cÖ_g ce© wb‡q Av‡jvPbv

K‡iwQ| cÖ_g c‡e© Avgiv Menu Bar Gi Aaxb¯’ wewfboe †gbyi e¨envi wk‡LwQ| AvkvKwi Database Program Microsoft

Access Gi cÖ_g c‡e© Avcbv‡`i †Kvb mgm¨v bvB| GB Avkv e¨v³ K‡i Database Program Microsoft Access Gi wØZxq

c‡e©i KvR ïi“ Kijvg| A‡b‡KB nqZ cÖkoe Ki‡Z cv‡ib cÖ_g c‡e© Avgiv Menu Bar Gi Aaxb¯’ wewfboe †gbyi KvR †kl K‡iwQ

wØZxq c‡e© wK wkLe? wØZxq c‡e©i gva¨‡g Avgiv Database Window Gi Aaxb¯’ 7wU Database Object Gi wewfboe iKg e¨envi

wkLe| Z‡e cÖ_g ce© m¤ú‡K© my¯úó avibv bv _vK‡j wØZxq c‡e©i A‡bK wKQy m¤ú‡K©B my¯úó avibv cvIqv hv‡ebv| cÖ_g c‡e©i †P‡q

wØZxq ce© GKUz RwUj e‡j g‡b n‡Z cv‡i wKš‘ g‡b ivL‡eb cÖ_g ce© Ges wØZxq ce© GKwU Av‡iKwUi cwic~iK| Avgiv Rvwb bZzb

K‡i GKwU Database Window ‰Zix Kivi ci Avgiv Database Window Gi Aaxb¯’ 7wU Database Object cvB| myZivs

Database Window Gi Aaxb¯’ 7wU Database Object †c‡Z n‡j Av‡M GKwU Database Window ‰Zix Kivi wbqg wkL‡Z

n‡e| Avmyb Avgiv †`wL wbæwjwLZ c×wZ‡Z GKwU m¤ú~b© Database Window ‰Zix Ki‡Z cvwi wKbv|

To insert A Database Window t GKwU WvUv‡eR DB‡Ûv ‰Zix Kiv

Microsoft Aaccess Database n‡jv A‡bK¸‡jv Object Gi mgš^q| A_©vr Microsoft Access Database Gi g‡a¨

Database Table, Database Query, Database Forms, Database Report, Database Pages, Database Macro,

and Database Module BZ¨vw` Object mg~n Aš—f©y³ _v†K| cÖwZwU Object n‡jv Database Gi GK GKwU Ask| GB

Object ¸‡jvi cÖ‡Z¨KwU wK fv‡e ‰Zix Ki‡Z nq Zv we¯—vwiZ Rvb‡Z n‡e| GB Object ¸‡jvi †h Object B ‰Zix Ki‡Z PvB bv

†Kb cª_‡g Database Window Open Ki‡Z n‡e| myZivs wKfv‡e Database Window ‰Zix Ki‡Z n‡e Zv RvbvI

AZ¨vek¨K| Database Window ‰Zix Ki‡Z n‡j Microsoft Access Program G `y‡Uv wfboe wfboe c×wZ‡Z Microsoft

Access Database Window ‰Zix Kiv hvq| †hgb t (i) Scratch c×wZ Abymib K‡i| Ges (ii) Data base Wizard

e¨envi K‡i|

Scratch c×wZ Abymib K‡i Microsoft Access Database Window ‰Zix Kiv t

Scratch c×wZ Abymib K‡i Database Window ‰Zix c~e©K wewfboe cÖKvi Database Object ‰Zix Ki‡Z n‡j cÖ_‡g

File Click, New Click Ki‡j New bv‡g GKwU Dialog Box Avm‡e ZLb

Database Select K‡i

Ok Click Ki‡j File New Database bv‡g GKwU Dialog Box Avm‡e ZLb File Name Box Gi g‡a¨ †h †Kvb GKwU

bvg wj‡L, Create Click Ki‡j H bv‡g GKwU Blank (duvKv) Database Window ‰Zix n‡e|

‰ZixK…Z Blank (duvKv) Database Window Gi g‡a¨ H Database Window Gi Aaxb¯’ 7wU Avjv`v Avjv`v Tab (U¨ve)

AvKv‡i Database Object c`wk©Z n‡e| GB 7wU Avjv`v Avjv`v Tab (U¨ve) AvKv‡i c`wk©Z Database Object Gi

gva¨‡g Avgv‡`i Database Managenent Ki‡Z n‡e| Avmyb Avgiv Scratch c×wZ Abymib K‡i ‰ZixK…Z Database

Window Gi Awab¯’ Database Object Table Gi wewfboe cÖKvi e¨envi wkwL|

wewfboe cÖKvi Table

†h †Kvb GKwU Database Window bZzb K‡i ˆZix Ki‡j A_ev c~‡e© ˆZix Kiv Database Window bZzb K‡i Open Ki‡j

Gi Awab¯’ me©cÖ_g †h Database Object wU c`wk©Z nq †mwUi bvg †Uwej| Database Managenent Gi KvR Ki‡Z n‡j

cÖ_‡g †h KvR Ki‡Z nq Zv n‡jv Data Input Kiv| Kvib Data Input bv Ki‡j Avgiv wK Managenent Kie? Avi GB Data

Input Ki‡Z nq Database Object Table Gi gva¨‡g| Avgiv wbæewb©Z 5 (cuvP) cÖKvi Table (†Uwej) ˆZixi gva¨‡g wfboe wfboe

c×wZ‡Z Data Input Ki‡Z cvwi|

Notes Of Microsoft Access XP Part - 2

Created By: Md. Helal Uddin E-mail: Helaluddin321@gmail.com.com

Avgiv Table (†Uwej) ˆZix Ki‡Z cvwi 5 (cuvP) wU wfboe wfboe c×wZ‡Z †hgb t

1. Datasheet View (WvUvkxU wfD)

2. Design View (wWRvBb wfD)

3. Table Wizard (†Uwej DBRvW©)

4. Import Table (Bg‡cvU© †Uwej)

5. Link Table (wj¼ †Uwej)

c~‡e©i c„óvq ewb©Z GB 5wU c×wZ‡Z †Uwej ˆZix Kivi we¯—vwiZ wbgoeiƒc t

1. Data sheet view (WvUvkxU wfD) t KvR Kivi mgq hw` KLbI Database (WvUv‡eR) †`‡L GiKg g‡b nq Field (wdì) ev

Column (Kjvg) Gi bv‡gi †Zgb †Kvb e¨envi bvB Zvn‡j Database Window ‡Z Ae¯’vbKv‡j

Table Click, New Click Ki‡j New Table Dialog Box Avm‡e ZLb Gi Awab¯’

Datasheet View Click

Ok Click Ki‡j Field 1, Field 2, Field 3.…field 10 Giƒc 10wU Field hy³ GKwU New Database Table Data

Input Kivi Rb¨ cÖ¯‘Z n‡e| GB Ae¯’vq ‰ZixK…Z †Uwe‡ji Field Gi bvg¸‡jv cwieZ©b Kiv hvq Rename Gi gva¨‡g| Z‡e

GKwU welq g‡b ivL‡Z n‡e Datasheet View c×wZ‡Z Table ‰Zix Ki‡j †h KqwU Field Gi cÖ‡qvRb †mB KqwU Field Gi

me©wbæ GKwU Data Input Kivi ci Save Ki‡Z n‡e| †Kvb Data Input Kivi Av‡M Save Ki‡j †Kvb Field Gi bvgB

cvIqv hv‡e bv|

NB t GB KvRwU Avgiv Ab¨ c×wZ‡ZI Ki‡Z cvwi| we¯—vwiZ wk¶‡Ki wbKU †_‡K †R‡b wbb|

2. Design View (wWRvBb wfD) t KvR Kivi mgq hw` KLbI Database (WvUv‡eR) †`‡L GiKg g‡b nq Field (wdì) ev

Column (Kjvg) Gi bvg¸‡jv GKUz Ab¨iKg (wb‡goeewb©Z Q‡Ki gZ) hv Ab¨vb¨ c×wZ‡Z Ly‡R cvIqv hv‡”Q bv ev Kiv m¤¢e n‡”Q

bv| ZLb Database Window ‡Z Ae¯’vbKv‡j

Table Click, New Click Ki‡j New Table Dialog Box Avm‡e ZLb Gi Awab¯’

Design View Click Ki‡j GKwU QK Avm‡e GwU n‡jv Design View (wWRvBb wfD)| ZLb Ni¸‡jv wbæwjwLZ c×wZ

Abymv‡i ˆZix Ki‡Z n‡e| cÖ‡qvR‡b wk¶‡Ki mnvqZvq QKwU ˆZix Ki“b|

Field Name Data Type Description

Sl_No Auto Number Or Press A Serial Number

F_Name Text Or Press T Fast Name

M_Name Text Or Press T Middle Name

L_Name Text Or Press T Last Name

N_Name Text Or Press T Nick Name

B_Data Data/Time Or Press Database Birth Date

Salary Number Or Press N Monthly Salary

Position Text Or Press T Official position

Probation Yes/No Or Press Y Gender

D³ QKwU ‰Zix Kiv †kl n‡q †M‡j m‡½ m‡½ Save Click K‡i Save Name Box Gi g‡a¨ †h †Kvb GKwU bvg wj‡L Ok Click

Ki‡j GKwU Dialog Box Avm‡e| ZLb Yes Click Ki‡Z n‡e| Close Button (x) Click Ki‡Z n‡e| cieZ©x‡Z H bv‡gi

Table wU Open K‡i Avgiv wbqgg‡Zv Database Input Ki‡Z cvwi|

NB t GB KvRwU Avgiv Ab¨ c×wZ‡ZI Ki‡Z cvwi| we¯—vwiZ wk¶‡Ki wbKU †_‡K †R‡b wbb|

3. Table wizard (‡Uwej DBRvW©) t KvR Kivi mgq hw` KLbI Database (WvUv‡eR) †`‡L GiKg g‡b nq Field (wdì) ev

Column (Kjvg) Gi bvg¸‡jv hyw³m½Z Zvn‡j Avgiv Table Wizard (‡Uwej DBRvW©) Gi gva¨‡g †Póv Ki‡Z cvwi| GRb¨

Database Window ‡Z Ae¯’vbKv‡j

Table Click, New Click Ki‡j mv‡_ mv‡_ New Table Dialog Box Avm‡e ZLb Gi Awab¯’

Table Wizard Click, Ok Click Ki‡j Table Wizard Dialog Box Avm‡e| ZLb Sample Table e‡· Click K‡i

Table ¸‡jv Click Ki‡j †h Table click Kiv n‡e H Table Gi Aš—M©Z Computer G Select K…Z Field Name ¸‡jv

†`Lv hvq| evUb Click Kivi gva¨‡g cQ›`gZ Field ¸‡jv Field in my new Table Box G Select Kwi| Zvici hw`

†Kvb Field Gi bvg cwieZ©b Ki‡Z PvB Z‡e H Field Select K‡i Rename Field Click K‡i Rename Field Dialog

Box G cQ›`gZ Field Name wj‡L Ok Click Ki‡Z n‡e| Field Gi Name wbe©vPb †kl n‡j Next Click Ki‡j

Table Wizerd Dialog Box Avm‡e| ZLb Box G Click K‡i Table Gi Rb¨ cQ›`bxq GKwU bvg wj‡L, Next Click,

Next Click K‡i, Enter data directly in to the table Click K‡i Finish Click Ki‡jB Table ‰Zix n‡e ZLb Avgiv

Data Entry Ki‡Z cvwi|

Notes Of Microsoft Access XP Part - 2

Created By: Kamrul Hassan Bappy E-mail: info@khola-janala.com

4. Import Table (‡Uwej Avg`vbxKib) t Database Program Microsoft Access G KvR Ki‡Z wM‡q A‡bK mgq

Spreadsheet Analysis Software (Microsoft Excel) ‡_‡K Data Input Kivi Rb¨ Microsoft Access Program G

_vKve¯’vq Excel ‡_‡K File Input Kiv nq| †mRb¨ cÖ_‡g Excel G wM‡q †h †Kvb bv‡g GKwU File ‰Zix Ki‡Z n‡e| Zvici

Excel Close K‡i MS Access Program G cÖ‡ek K‡i †h Database Window ‡Z Excel G ˆZix Kiv File wU Avb‡Z PvB

†mB Database Window ‡Z Ae¯’vbKv‡j

Table Tab Select K‡i New Click Ki‡j New Table Dialog Box Avm‡e Zvici

Input Table Click, Ok Click Ki‡j Input bv‡g GKwU Dialog Box Avm‡e ZLb

Look in Book Gi g‡a¨ †h Location G Excel Gi File wU Save Kiv Av‡Q †mwU Select K‡i

File of Type Box G Click K‡i Microsoft Excel Select Ki‡Z n‡e ZLb Excel G ˆZix Kiv File ¸‡jv †`Lv hv‡e|

Gevi Excel Gi †h File wU Access Program G Input Ki‡Z PvB †mwU Select K‡i|

Input Click Ki‡jB Input SpreadSheet Wizard Dialog Box Avm‡e Zvici Excel Gi H File Gi Aaxb¯’ †h

Sheet wU Avb‡Z PvB †mwU Select Ki‡Z n‡e (Sheet Select Ki‡j H Aax‡b †h †jLv¸‡jv Av‡Q †mB †jLv¸‡jv †`Lv hv‡e)

Zvici

Next Click K‡i Excel G ˆZixK…Z Sheet Gi cÖ_g Row hw` Column Heading wnmv‡e e¨envi Ki‡Z PvB Zvn‡j

First Row Contains Column Headings G _ wPý w`‡q|

Next Click, in a New Table Click, Next Click K‡i|

Field Name Box G †Kvb bvg wjL‡Z cvwi (H bvgwU cÖ_g Column Gi Column Heading n‡e) Zvici

Next Click, Let Access Add Primary Key Click

Next Click K‡i †h bv‡g Input Ki‡Z PvB †mB bvg wj‡L (GLv‡b †h †Kvb bvg †`Iqv hvq †Kvb bvg bv w`‡j Sheet bv‡g

Save n‡e)

Finish Click, Ok Click Ki‡j Excel G ˆZixK…Z File wU H Database Window ‡Z †`Lv hv‡e Zv Open Ki‡jB

`„k¨gvb n‡e|

NB t GB KvRwU Avgiv Ab¨ c×wZ‡ZI Ki‡Z cvwi| we¯—vwiZ wk¶‡Ki wbKU †_‡K †R‡b wbb|

5. Link Table (m¤úK© ¯’vc‡bi gva¨‡g ‡Uwej Avg`vbxKib) t Database Program Microsoft Access G KvR Ki‡Z

wM‡q A‡bK mgq wfboe wfboe `yBwU Database Window Gi g‡a¨ m¤úK© ¯’vc‡bi gva¨‡g GKwU Database Window †Z Ae¯’vb

K‡i Ab¨ Av‡iKwU Database Window †_‡K Database Table/Object Avg`vbx Kiv hvq| GRb¨ cÖ_‡g †h Database

Window †Z Ab¨ †Kvb Database Window ‡_‡K Table/Object Avg`vbx Ki‡Z PvB †mB Database Window wU Open

K‡i

Table Tab Select K‡i New Click Ki‡j New Table Dialog Box Avm‡e Zvici

Link Table Click, Ok Click Ki‡j Link bv‡g GKwU Dialog Box Avm‡e Ges H Dialog Box Gi g‡a¨ c~‡e© ˆZixK…Z

wewfboe Database Window Gi bvg c`wk©Z n‡e Zvici †h Database Window †_‡K m¤úK© ¯’vc‡bi gva¨‡g ‡Uwej

Avg`vbx Ki‡Z PvB †mB Database Window wU Select K‡i

Link Click Ki‡j H Database Window Gi Aaxb¯’ wewfboe Database Table c`wk©Z n‡e| ZLb †h Database Table

wU Avg`vbx Ki‡Z PvB †mwU Select K‡i

Ok Click Ki‡j Pvwn`vgZ Database Table wU c`wk©Z n‡e|

NB t GB KvRwU Avgiv Ab¨ c×wZ‡ZI Ki‡Z cvwi| we¯—vwiZ wk¶‡Ki wbKU †_‡K †R‡b wbb|

***** -- ***** - ***** - *****

Notes Of Microsoft Access XP Part - 2

Created By: Kamrul Hassan Bappy E-mail: info@khola-janala.com

Wizard e¨envi K‡i Database Design Kiv t

Microsoft Access G AmsL¨ Database Applications ‰Zix Kiv Av‡Q| Gme e¨envi K‡i Avgiv Avgv‡`i cÖ‡qvRb †gUv‡Z

cvwi| Z‡e K_v n‡jv Database ¸‡jv mve©Rbxb nIqvi †cÖw¶‡Z Avcbvi Database hv hv cÖ‡qvRb Zv nqZ ûeû bv †c‡Z cv‡ib|

Z‡e A‡bKvsk cÖ‡qvRb wgU‡e e‡j Avgvi wek¦vm| Wizard e¨envi Kivi myweav n‡jv Lye Aí mg‡q Database wU wWRvBb K‡i

Data Entry Kiv hvq| GRb¨ Table, Forms, Report BZ¨vw` wWRvB‡bi Sv‡gjv †cvnv‡Z nq bv| Bnv ‰Zix Ki‡Z n‡j,

Database Table Gi wWRvBb cQ›` Kivi ci Data Entry Ki‡Z n‡e| Avmyb Avgiv Gevi Aci c„óvq Av‡jvPbvi gva¨‡g G

m¤ú‡K© we¯—vwiZ †R‡b †bB|

File Click

New Click Ki‡j New Dialog Box Avm‡e| Zvici Dc‡ii w`‡K Database Tab Click Ki‡j AmsL¨ Icon c`wk©Z

n‡e| ZLb GB Icon ¸‡jv †_‡K †h †Kvb GKwU Icon wbe©vPb Ki“b hv Avcbvi Database Gi mv‡_ mv`„k¨c~Y© g‡b nq| Icon

wbe©vPb K‡i Ok Click Ki‡j File New Database Window cÖ`wk©Z n‡e| ZLb †h bv‡g Database Table ‰Zix Kie

File Name Box G †mB bvg wj‡L ‡h File Folder G Save Ki‡Z PvB Save in Box G ‡mB File Folder Selete K‡i,

Create Click Ki‡j H bv‡g Database Window & Database Wizard Dialog Box `„k¨gvb n‡e ZLb Database

Wizard Dialog Box Gi

Next Click Ki‡j Database Wizard cÖ`wk©Z n‡e| ZLb Field in the Table Box G cÖ‡qvRbxq Table Field Select

K‡i

Next Click K‡i cQ›` gZ †h †Kvb GKwU Kvjvi (Color) I c¨vUv‡b©i (Patern) wWRvBb wbe©vPb K‡i

Next Click K‡i Report Gi Rb¨ Style wbe©vPb K‡i,

Next Click K‡i Box Gi g‡a¨ Database Title wj‡L

Next Click

Finish Click K‡i K‡qK †m‡KÛ A‡c¶v Ki‡j †`Lv hv‡e GKwU Box G‡m‡Q ZLb

Ok Click Ki‡j My Company Information Dialog Box Avm‡e GB Ae¯’vq wb‡Ri Company Information

Type c~e©K Close Click Ki‡j †`Lv hv‡e cQ›`gZ bZzb Data Base ‰Zix n‡q‡Q|

[ GLv‡b 4/5wU Option ‡`Lv hv‡”Q| cÖ‡Z¨KwUi gva¨‡g Avjv`v Avjv`v KvR m¤úboe Kiv hvq ]

(a) Enter/View Address/Information t GB Option wU Click K‡i B‡”QgZ Data Entry Kiv hvq| Entry ‡kl

n‡j Dc‡ii Wvb †Kv‡b (x) Close Button G click Ki‡Z n‡e|

(b) Preview Report t Entry K„Z Database Address ¸‡jv Print Ki‡j †Kgb †`Lv‡e Zv ch‡© e¶‡bi Rb¨ Bnv e¨envi Kiv

nq|

board bvgwU cwieZ©b Ki‡Z cvwi| GRb¨

Change Switch board Items Click, Edit Click

Switch board name Box G cyivZb bvgwU gy‡Q bZyb GKwU bvg wj‡L Close Click c~bivq Close Click

(d) Exit this Database t Datebase Table Close Kivi Rb¨ GB Option Click Ki‡Z nq| we¯—vwiZ Kvh©c×wZ wk¶‡Ki

wbKU †_‡K †R‡b wbb|

***** -- ***** - ***** - *****

Notes Of Microsoft Access XP Part - 2

Created By: Md. Helal Uddin E-mail: Helaluddin321@gmail.com.com

Query & Filter

Avgiv Av‡MB wk‡LwQ Find e¨envi K‡i wbw`©ó GKwU Record mbv³ Kiv ev †LvRv hvq Ges Record mg~n‡K `ª“Z dgvbymv‡i

mvRv‡bv hvq| GLv‡b Avgiv wkLe wKfv‡e Query e¨envi K‡i mgRvZxq †iKW©mg~‡ni MÖ“c‡K Avjv`v fv‡e cÖ`k©b Ki‡ev Ges

AwfRvZ Dcv‡q †m¸‡jv‡K web¨¯— Ki‡ev|

Microsoft Access G Avgiv QqwU wfboe wfboe Dcv‡q Query ˆZix Ki‡Z cvwi| h_v t

1. Select Queries.

2. Crosstab Queries.

3. Maketable Queries.

4. Update Queries.

5. Append Queries.

6. Delete Queries.

G¸‡jvi we¯—vwiZ Av‡jvPbv wb‡goe ewb©Z nj| cÖ‡qvR‡b wk¶‡Ki mvnvh¨ wbb|

1. Select Queries t

Select Queries Gi gva¨‡g Avgiv Table (†Uwej) Gi Aš—M©Z cQ›`gZ wbw`ó wKQy Column (Kjvg) †K ‡Lv‡R Avjv`v K‡i

†`L‡Z cvwi| GRb¨

†Uwej ˆZix Kiv Av‡Q GiKg ‡h †Kvb GKwU Database Window Open Kwi|

Query Select Kwi|

New Click Ki‡j mv‡_ mv‡_ New Query Dialog Box P‡j Av‡m Zvici Gi Awab¯’

Design View Click.

Ok Click Ki‡jB Query Design View ‡Z P‡j hv‡e Ges Show Table bv‡g GKwU Dialig Box Avm‡e ZLb g‡bi

B‡”QgZ †h Table ‡_‡K Query Ki‡Z PvB ‡mwU Select K‡i Add c~e©K Field Setting K‡i

File Click

Save as Click K‡i Save Name Dialog Box G †h †Kvb GKwU bvg wj‡L

Ok Click Ki‡jB H bv‡g msiw¶Z n‡e cieZ©x‡Z

Close Button (x) Click K‡i Query File wU Open K‡i †`L‡Z cvwi|

NB t GB KvRwU Avgiv Ab¨ c×wZ‡ZI Ki‡Z cvwi| we¯—vwiZ wk¶‡Ki wbKU †_‡K †R‡b wbb|

Wizard e¨envi K‡i Select Queries ‰Zix Kiv

†Uwej ˆZix Kiv Av‡Q GiKg †h †Kvb GKwU Database Window Open Kwi

Queries Select Kwi

New Click

Simple Query Wizard Click

Ok Click Ki‡j Simple Query Wizard Dialig Box Open n‡e| ZLb Table Box G Cilck K‡i Table Select

K‡i Available Fields Box ‡_‡K Button Gi gva¨‡g Field ¸‡jv cQ›`gZ Selected Box G Select Kwi| Zvici

Next Click K‡i †h bv‡g Query ‰Zix Kie †mB bvg wj‡L

Finish Click Ki‡j cQ›`gZ Select K„Z Column (Kjvg) ¸‡jv c`wk©Z n‡e|

Close Button (x) Click K‡i Query File wU Open K‡i †`L‡Z cvwi|

NB t GB KvRwU Avgiv Ab¨ c×wZ‡ZI Ki‡Z cvwi| we¯—vwiZ wk¶‡Ki wbKU †_‡K †R‡b wbb|

Notes Of Microsoft Access XP Part - 2

Created By: Kamrul Hassan Bappy E-mail: info@khola-janala.com

2. Crosstab Queries t

NB: Crosstab Queries Gi gva¨‡g Avgiv Table (†Uwej) Gi Aš—M©Z Column (Kjvg) ¸‡jvi g‡a¨ †h ‡Kvb wZbwU Column

(Kjvg) †K †Uwe‡j †h iKg Av‡Q wVK †m iKg ivL‡Z cvwi Ges H †Uwe‡ji Aš—M©Z Ab¨ GKwU Column (Kjvg) †K cvwU©kvb Ki‡Z

cvwi| Avmyb †`wL G c×wZi gva¨‡g wK iKg Queries (†LvRv) Gi KvR Kiv hvq| GRb¨

cÖ_‡g †Uwej ˆZix Kiv Av‡Q GiKg †h †Kvb GKwU Database Window open Kwi Zvici

Queries Select K‡i

New Click

Crosstab Query Wizard Click K‡i

Ok Click Ki‡j Crosstab Query Wizard Dialog Box Avm‡e ZLb †h Table / File ‡_‡K Query Ki‡Z PvB †mwU

Select Kwi|

Next Click K‡i Available Fields Box ‡_‡K Button Gi gva¨‡g cÖ‡qvRbxq Field ¸‡jv Selected Fields Box G

Copy K‡i Simple Box G cÖ`k©b Kwi| Zvici

Next Click K‡i cQ›`gZ Field Select, Next Click K‡i Functions Select Kwi Zvici

Next Click K‡i †h bv‡g Query ‰Zix Kie †mB bvg wj‡L,

Finish Click K‡i

(x) Close Button Click K‡i Gevi Query File wU Open K‡i †`L‡Z cvwi|

NB t GB KvRwU Avgiv Ab¨ c×wZ‡ZI Ki‡Z cvwi| we¯—vwiZ wk¶‡Ki wbKU †_‡K †R‡b wbb|

3. Make Table Queries t

NB: Make Table Queries Gi gva¨‡g Avgiv GKvwaK Table (†Uwej) Gi Aš—M©Z Column (Kjvg) ¸‡jv‡K †Uwe‡j †h iKg

Av‡Q wVK †m iKg ‡Lv‡R GKwÎZ K‡i cª`k©b Ki‡Z cvwi| Avmyb †`wL G c×wZi gva¨‡g wK iKg Queries (†LvRv) Gi KvR Kiv

hvq| GRb¨

`ywU wfboe wfboe Table Gi g‡a¨ m¤úK© ¯’vc‡bi gva¨‡g Query Ki‡Z n‡e GRb¨ cÖ_‡g GKwU Database Window Open

K‡i `ywU wfboe wfboe Table ‰Zix Kwi (`ywU Table G mgvb Data _vK‡j fvj nq) Gevi

Quary Select Kwi, New Click, Design View Click

Ok Click Ki‡jB Query Design View ‡Z P‡j hv‡e Ges Show Table bv‡g GKwU Dialig Box Avm‡e ZLb †h

Database Table ¸‡jvi g‡a¨ Query Ki‡Z PvB †m¸‡jv Select K‡i G‡K G‡K Add Click Gi gva¨‡g Field List G

¯’vcb Kwi Zvici Close Click K‡i `ywU Table Gi g‡a¨ Relatinship Create Kwi Gevi

Design Gard Box G G¸‡jv cQ›`gZ ¯’vcb Kwi Zvici

File Click, Save as Click K‡i †h bv‡g Query ‰Zix Kie †mB bvg wj‡L

Ok Click c~e©K (x) Close Button Click K‡i Query File wU Open K‡i †`L‡Z cvwi|

NB t GB KvRwU Avgiv Ab¨ c×wZ‡ZI Ki‡Z cvwi| we¯—vwiZ wk¶‡Ki wbKU †_‡K †R‡b wbb|

mywcÖq cÖwk¶bv_©xMb, Avgiv BwZc~‡e© wZbwU c×wZ‡Z Query (‡Kv‡qix) e¨envi K‡i †Uwej †_‡K †LvRv wk‡LwQ| GKwU welq

j¶¨bxq D³ wZbwU c×wZ‡ZB Avgiv †Kv‡qix‡Z msi¶b K‡iwQ Ges cieZ©x‡Z †Kv‡qix †_‡KB Open K‡i †`L‡Z †c‡iwQ| wKš‘

cieZ©x‡Z †h †Kv‡qix¸‡jv Kie †m¸‡jvi KvR Kie †Kv‡qix‡Z Ges Kv‡Ri djvdj cve †Uwej Ae‡R± †_‡K wbw`ó †UwejwU Open

K‡i| Zvn‡j Avmyb Avgiv Ab¨ wZbcÖKvi Query (‡Kv‡qix) wKfv‡e Kiv hvq Zv wkwL|

4. Update Queries t

GB Option Gi mnvqZvq Table ‡_‡K Record Query K‡i cÖwZ¯’vcb Kiv hvq|

cÖ_‡g †h †Kvb GKwU Database Window Open Kwi Zvici

Query Select K‡i New Click, Design View Click

Ok Click Ki‡jB Query Design View ‡Z P‡j hv‡e Ges Show Table bv‡g GKwU Dialig Box Avm‡e ZLb †h

Database Table Update Ki‡Z PvB †mwU Click c~e©K Add K‡i Field Setting K‡i (cÖ‡qvR‡b wk¶‡Ki mvnvh¨ wbb)|

Query Click, Update Query Click K‡i wb‡P Criteria Box Gi g‡a¨ hvnv Update Ki‡Z PvB Zv wj‡L Update to

Box Gi g‡a¨ Update K‡i hvnv emv‡Z PvB Zv wj‡L

Query Click, Run Click, Yes Click, Close Button Click

No Click K‡i Gevi H bv‡gi Database Table Open K‡i †`L‡Z cvwi mKj Field Update n‡q †M‡Q| Z‡e wbw`ó

Field (wd‡ì) †h KqwU bvg Abyiƒc _vK‡e wVK ZZwU Field (wdìB) cÖwZ¯’vwcZ n‡e|

Notes Of Microsoft Access XP Part - 2

Created By: Kamrul Hassan Bappy E-mail: info@khola-janala.com

5. Append Queries t

GB Option Gi mnvqZvq Table ‡_‡K Record Query K‡i ms‡hvRb ev †hvM Kiv hvq|

cª_‡g †h †Kvb GKwU Database Window Open Kwi Zvici Query Tab Select K‡i New Click, Design View

Click, Ok Click Ki‡jB Query Design View ‡Z P‡j hv‡e Ges Show Table bv‡g GKwU Dialog Box Avm‡e ZLb

†h Database Table G Data Append Ki‡Z PvB, †mwU Select K‡i

Add Click, Close Click K‡i Field Setting Kivi ci

Query Click,

Append Query Click K‡i †h Database Table Gi †k‡l Data ‡hvM Kie †mB Table Name wj‡L

Ok Click, Zvici †h ai‡bi Record Append Ki‡Z PvB Zvi Criteria D‡j−L K‡i

Query Click, Run Click, Yes Click K‡i Close Button Click

No Click K‡i Gevi H bv‡gi Database Table Open K‡i †`L‡Z cvwi KgvÛ Abymv‡i mKj Field Append n‡q †M‡Q|

Z‡e wbw`ó Field (wd‡ì) †h KqwU bvg Abyiƒc _vK‡e wVK ZZwU Field (wd‡ìB) ms‡hvRb n‡e|

NB t GB KvRwU Avgiv Ab¨ c×wZ‡ZI Ki‡Z cvwi| we¯—vwiZ wk¶‡Ki wbKU †_‡K †R‡b wbb|

6. Delete Queries t

GB Option Gi mnvqZvq Table ‡_‡K Record Query K‡i ‡gvQv hvq| GRb¨ cÖ_‡g †h †Kvb GKwU Database Window

Open Kwi| Zvici

Query Select K‡i New Click, Design View Click, Ok Click Ki‡jB Query Design View ‡Z P‡j hv‡e Ges

GKwU Dialig Box Avm‡e ZLb †h Database Table G Data Delete Ki‡Z PvB †mwU Select K‡i

Add Click, Close Click K‡i Field Setting K‡i

Query Click, Delete Query Click K‡i mewKQy Setting K‡i

Query Click, Run Click, Yes Click K‡i Close Button Click

No Click K‡i Gevi H bv‡gi Database Table Open K‡i †`L‡Z cvwi KgvÛ Abymv‡i mKj Field Delete n‡q †M‡Q|

Z‡e wbw`ó Field (wd‡ì) †h KqwU bvg Abyiƒc _vKe wVK ZZwU Field (wd‡ì) B gy‡Q hv‡e|

NB t GB KvRwU Avgiv Ab¨ c×wZ‡ZI Ki‡Z cvwi| we¯—vwiZ wk¶‡Ki wbKU †_‡K †R‡b wbb|

Forms

Avgiv †`‡LwQ †Uwe‡j cÖwZwU Record GKB jvB‡b Ges cÖwZwU Field GKB Kjv‡g cÖ`wk©Z nq| G Ae¯’vq GKB mv‡_ A‡bK¸‡jv

Record Screen G cÖ`k©b Kiv m¤¢e n‡jI GKwU Record Gi me¸‡jv Field ‡K cÖ`k©b Kiv m¤¢e bvI n‡Z cv‡i| Avi GRb¨B

cÖ‡qvRb Forms wWRvB‡bi| cy‡iv GKwU Record Gi me¸‡jv Field ‡K mvwR‡q GKB mv‡_ GKwU Screen G cª`k©b Ki‡j

¯^fveZB GwU `„wó b›`b I AvKl©bxq n‡e| d‡g© Qwe ms‡hvM Kiv hvq|

‡Kvb Database Table Open Kivi ci ev Forms Open Kivi ci Uzjev†ii evg †Kv‡b View Tools cª`wk©Z nq G¸‡jv

Menu Bar Gi View Click Ki‡jI cÖ`wk©Z nq| G¸‡jvi gva¨‡g Data wewfboe fv‡e cÖ`k©b Kiv hvq|

Design View t dg©wUi wWRvBb cwieZ©b Ki‡Z PvB‡j GB Option wU e¨envi Ki‡Z nq|

From View t From View AvKv‡i Data ¸‡jv‡K cÖ`k©b Kivi Rb¨ GB Option e¨envi Ki‡Z nq|

Data Sheet View t Database ‡K Table AvK‡i cÖ`k©b Kivi Rb¨ GB Option wU e¨envi Ki‡Z nq|

wewfboe c×wZ Aej¤^b K‡i Forms ev wWRvBb ˆZix Kiv hvq| Avmyb G m¤ú‡K© we¯—vwiZ Av‡jvPbv Kwi|

Auto Form (A‡Uv dg©) Gi mvnv‡h¨ Forms ‰Zix Kiv t

cÖ_g c×wZt

cÖ_‡g †h †Kvb GKwU Database Window Open Kwi Zvici

Table / Query Tab G Click K‡i †h †Kvb GKwU Table / Query Select Kwi| †h Table / Query Gi Data ¸‡jv

Auto Form AvKv‡i †`L‡Z PvB| Zvici

Insert Click, Auto Form Click K‡i A_ev New Object evUb Click K‡i AutoForm Click Ki‡j Auto

Form AvKv‡i cÖ`wk©Z n‡e| ZLb View Menu Gi wZbwU Option Gi mvnv‡h¨ Database wewfboe fv‡e cÖ`k©b Kiv

hvq| cÖ`k©b †k‡l Close Button (x) Click Ki‡j Box Avm‡e ZLb Yes Click Ki‡j Save as Box Avm‡e ZLb

Form wU bv‡g Save Ki‡Z PvB ‡mB bvg wj‡L Ok Click Ki‡j Form Tab G H bv‡g Form ‰Zix n‡e|

Notes Of Microsoft Access XP Part - 2

Created By: Kamrul Hassan Bappy E-mail: info@khola-janala.com

wØZxq c×wZ t

cÖ_‡g †h †Kvb GKwU Database Window Open Kwi Zvici

From Tab Select K‡i New Click Ki‡j New From Dialog Box Avm‡e ZLb

New From Dialog Box G wZbwU Auto Form Option Av‡Q †h †Kvb GKwU Select Kwi| wZbwU‡Z wZb iKg

Auto Form ‰Zix n‡e| wb‡Pi Box G †Kvb Database Table/Query ‡_‡K Auto Form ˆZix Kie †mwU Select

K‡i Ok Click Ki‡j Auto Form ‰Zix n‡e| ZLb View Menu Gi wZbwU Option Gi mvnv‡h¨ Database wewfboe

fv‡e cÖ`k©b Kiv hvq| cÖ`k©b †k‡l

Close Button (x) Click Ki‡j Box Avm‡e ZLb Yes Click Ki‡j Save As Box Avm‡e| ZLb From wU †h bv‡g

Ki‡Z PvB †mB bvg wj‡L Ok Click Ki‡j From Tab G H bv‡g From ‰Zix n‡e| From Tab ‡_‡K H bvgwU Open

K‡i cÖ`k©b Kiv hv‡e|

Wizard e¨envi K‡i From ‰Zix Kiv t

Auto Form ‰Zix Kivi mgq Aek¨B g‡b c‡o‡Q ev †Lqvj K‡i‡Qb †Uwe‡ji me¸‡jv Field B mqswdqfv‡e G‡m hvq| B‡”Q

K‡i wKQy Field ev` †`qv hvq bv hw` wKQy Field ev` w`‡q wbw`ó wKQy Field cÖ`k©b Ki‡Z PvB Z‡e Wizard e¨envi K‡i

Form ‰Zixi gva¨‡g Kiv m¤¢e| GRb¨

cÖ_‡g †h †Kvb GKwU Database Window Open K‡i From Tab Select Kwi Zvici

New Click Ki‡j New From Dialog Box Avm‡e| ZLb

Dc‡ii Box G From Wizard Select Kwi Ges wb‡Pi Box G †Kvb Database Table ‡_‡K From ‰Zix Kie Zv Select

K‡i Ok Click Ki‡jB Form Wizard Dialig Box Avm‡e ZLb Table/Query Box ‡_‡K Table ev Query Select

Change Ki‡Z cvwi| Zvici H Table ev Query Gi Field Name ¸‡jv cÖ`wk©Z n‡e| ZLb Button Gi gva¨‡g

Available Fields Box ‡_‡K cQ›`gZ Field ¸‡jv Selected Fields G Select Kwi|

Next Click. K‡i †h †Kvb GKwU Layout cQ›` Kivi ci Next Click K‡i †h †Kvb Style Select K‡i|

Next Click K‡i Dc‡i Box G †h bv‡g Save Kie ev From ˆZix Kie †mB bvg wj‡L|

Finish Click Ki‡j kZ©g‡Zv Form ˆZix n‡e| Ges Close Button (x) Click Ki‡jB P‡j hv†ÿ| cieZ©x‡Z H Save

Kiv bvg Click K‡i Open Ki‡jB H From cÖ`wk©Z n‡e|

NB t GB KvRwU Avgiv Ab¨ c×wZ‡ZI Ki‡Z cvwi| we¯—vwiZ wk¶‡Ki wbKU †_‡K †R‡b wbb|

Design View e¨envi K‡i Form ‰Zix Kiv t

Form Click

New Click Ki‡j New Form Dialog Box Avm‡e ZLb

Design View Click K‡i †h Table/Query ‡_‡K Form ‰Zix Ki‡Z PvB †mB Table/Query wU Select K‡i

Ok Click Ki‡jB Form Design View ‡Z P‡j hv‡e| ZLb Field List Box wU cÖ`wk©Z n‡e (cÖ`wk©Z bv n‡j View

Menu ‡_‡K Field List Box wU cÖ`wk©Z Ki‡Z n‡e) ZLb Field List Box wU n‡Z Mouse Øviv Field Move K‡i g‡bi

B‡”QgZ Form Design View ‡Z ¯’vcb Kwi| cieZ©x‡Z GB ˆZixK„Z Form wU Design Ki‡Z cvie| Ab¨me Form Gi

g‡ZvB ˆZix Kivi ci Save Gi gva¨‡g msi¶b Ki‡j c‡i cÖ‡qvRbg‡Zv Form Tab ‡_‡K Open Kiv hv‡e|

NB t GB KvRwU Avgiv Ab¨ c×wZ‡ZI Ki‡Z cvwi| we¯—vwiZ wk¶‡Ki wbKU †_‡K †R‡b wbb|

Custom Form wWRvBb t

c~‡e© Avgiv Auto Form Ges Wizard e¨envi K‡i wewfboe iKg From wWRvBb wk‡LwQ| AutoForm Ges Wizard Form

G AwaKvsk KvRB Access Program wb‡R †_‡KB K‡i| d‡j wb‡Ri wbqš¿‡bi g‡a¨ wKQy _v‡K bv| wKš‘ Custom Form

wWRvBb Kiv hvq Ges Dc¯’vcb †k‡l Print Kiv hvq| Custom Form Gi mvnv‡h¨ Form wWRvBb Kivi Rb¨ cÖ_‡g GKwU

Form ˆZix Ki‡Z n‡e| Zvici Form Tab Select K‡i

†h Form Gi Design Ki‡Z PvB †mB Form Name wU Select K‡i

Design Click Ki‡j Design View ‡Z Form wU cª`wk©Z n‡e ZLb Box Gi mv‡_ Tool Box cÖ`wk©Z n‡e| GB Tool

Box Gi Awab¯’ Icon / Tool ¸‡jvi g‡a¨ †KvbwUi gva¨‡g wK KvR Kiv m¤¢e Zv wb‡goe we¯—vwiZ †`Iqv n‡jv| GLv‡b GKwU

welq g‡b ivL‡eb †h †Kvb c×wZ‡Z ˆZix Kiv Form ‡KB g‡bi gZ K‡i Design Kiv hvq| wb‡R wb‡R Design Ki‡Z bv

cvi‡j wk¶‡Ki mnvqZvq mgvavb Ki“b|

Notes Of Microsoft Access XP Part - 2

Created By: Kamrul Hassan Bappy E-mail: info@khola-janala.com

1. Select Object t ‡Kvb wbw`ó Field ‡K Select Kivi Rb¨ GB Tool Gi mvnvh¨ wb‡Z nq| Z‡e GB Tool Gi mnvqZvq

GKwaK Field/Control BZ¨w` Select Kiv hvq| Ges Delete Kiv hvq|

2. Control Wizard t GB Tool Gi mvnv‡h¨ c~‡e©i g‡ZvB Select Kiv hvq Ges cieZ©x‡Z Delete Kiv hvq|

3. Label t GB Tool Gi mvnv‡h¨ Form Gi g‡a¨ New Text mshy³ Kiv hvq, Ges Format Tool Bar Gi mvnv‡h¨ H Text

‡K Design Kiv hvq| cieZ©x‡Z Text Box Select K‡i Delete Key Gi gva¨‡g Delete Kiv hvq|

4. Text Box t d‡g© Text Box mshy³ Kivi Rb¨ GB Tool Gi mvnvh¨ wb‡Z nq| GB Box Gi g‡a¨ †h Field Gi bvg Type

Kiv hv‡e H Field Gi Data ¸‡jv `„k¨gvb n‡e| Print Preview ‡Z †M‡j †`Lv hv‡e| c‡i Text Box cÖ‡qvRb †ev‡a

Select Object Gi gva¨‡g Delete Kiv hvq|

5. Option Group t K‡qKwU Control Gi GKwU Group ‰Zixi Kv‡R e¨eüZ nq|

6/7/8/. Toggle Button/ Option Button/ Check Box t Logical Field G Data Entry ev Kvib wjLvi Rb¨ GB Tool

¸‡jvi mvnvh¨ wb‡Z nq| c‡i D³ Box cÖ‡qvRb †ev‡a Select Object Gi gva¨‡g Select K‡i Delete key Press Gi gva¨

Delete Kiv hvq|

9/10. Combo Box/List Box t mivmwi Data Entry bv K‡i Data cÖ`k©b Kivi Rb¨ GB Tool ¸‡jvi mvnvh¨ wb‡Z nq| GB

Box ¸‡jvi mvnvh¨ wb‡Z nq| GB Box ¸‡jvi mvn‡h¨ Text Box Gi gZ KvR Kiv hvq Ges GKB c×wZ‡Z Delete Kiv hvq|

11. Command Button t hw` †Kvb wbw`©ó Command wcª‡›U cÖwZwU Database G cÖ`k©b Ki‡Z PvB Z‡e GB Tool Click

K‡i Tool Box Gi g‡a¨ wjL‡Z n‡e| c~‡e©i c×wZ Abyhvqx GB Box Delete Kiv hvq|

12. Image t Farm Gi g‡a¨ File ‡_‡__________K †Kvb Qwe mshy³ Kivi Rb¨ e¨eüZ Kiv nq|

13/14. Upbound object Frame/Bound object Frame t Old Object ms‡hvR‡bi R‡b¨ A_©vr Ab¨ †Kvb Packege

‡_‡K ev Clip art ‡_‡K Qwe mshy³ Kivi Rb¨ GB Tool Gi mvnvh¨ wb‡Z nq| Z‡e GB KvR A_©vr Qwe mshy³ Kivi Rb¨

Upbound Object Frame Gi gva¨‡g mnR n‡e|

15. Page Break Subform t Form Gi wbw`©ó †Kvb ¯’v‡b Page Break ‡`Iqvi Rb¨ GB Tool Gi mvnvh¨ wb‡Z nq|

16. Tab Control t Tab Control Tool Gi mvnv‡h¨ Box ‰Zix K‡i Box G (ii) Click Ki‡j GKwU Dialog Box Av‡m|

†mLv‡b Qwe mn A‡bKwKQy Setting Kiv hvq| Box wU Select K‡i Delete Press Gi gva¨‡g Delete Kiv hvq| GB Box G

Select K…Z wKQyB Print Preview ‡Z †`Lv hvq bv|

17. Subform/Supreport t Report Gi †ejvq †Kvb Subform ev Superport ms‡hvRb Kivi Rb¨ e¨eüZ nq|

18. Line t Form Gi g‡a¨ †Kvb Line A_v©r mij †iLv mshy³ Kivi Rb¨ GB Tool Gi mvnvh¨ wb‡Z nq| Bnv Print Preview

‡Z †`Lv hvq Ges Select K‡i Delete Kiv hvq|

19. Rectangle t Form Gi g‡a¨ †Kvb Rectangle A_©vr PZzf~©R mshy³ Kivi Rb¨ GB Tool Gi mvnvh¨ wb‡Z nq| Bnv Prient

Priview ‡Z †`Lv hvq Ges Select K‡i Delete Kiv hvq|

20. Mare Contral t Tool Box Gi g‡a¨ †bB GiKg †Kvb Tool Add Kivi Rb¨ D³ More Control Use Kiv n‡q

_v‡K|

***** - **** - ****

Notes Of Microsoft Access XP Part - 2

Created By: Md. Helal Uddin E-mail: Helaluddin321@gmail.com.com

Text Design

Text ev wjLvq Font, Font Style, Font Color BZ¨vw` cwieZ©b Kiv hvq| G †¶‡Î Avgiv cÖ_g c‡e© wk‡LwQ View Menu Gi

Datasheet View ‡Z Ae¯’vbKv‡j Kiv m¤¢e| wKš‘ Form Gi †ejvq Text Design Ki‡Z

Form Open K‡i hw` Form Gi Font ev Text Design Change Ki‡Z PvB Z‡e Form Open _vKve¯’vq

View Click, Design View Click K‡i Design Mode G hvIqvi ci

Edit Click, Select All Click c~e©K me¸‡jv Field Select K‡i ev wb‡Ri gZ K‡i ‡Kvb Field Select Kivi ci

Formating Tool Bar ‡_‡K B‡”Qg‡Zv Design Ki‡Z cvwi|

N.B. hw` me¸‡jv Field GKB Font Gi bv †`B Z‡e †h Field Gi Change Kie ïay †m&B Field Block/Select Ki‡jB

Pj‡e| ïaygvÎ Block/Select Kiv Field/Column Gi Font Change ev Desing Kiv hv‡e| we¯—vwiZ c×wZ wk¶‡Ki wbKU

†_‡K †R‡b wbb|

Report and mailing Lable

‡Kvb Database Gi DcvË mgy‡ni AvDUcyU n‡”Q Report| †Kvb Table/Query Gi Dci wfwË K‡i Report ‰Zix Kiv nq| e„nr

Database Gi AmsL¨ Record ‡_‡K ïaygvÎ cÖ‡qvRbxq Record mgyn wb‡q Roport ‰Zix K‡i Print w`‡Z cvwi| Report ˆZix

Kivi wewfboe c×wZ wbgoeiƒc t

Auto Report t Auto Form ‰Zixi Kivi gZB Auto Report ‰Zix Kiv hvq| Gi `ywU c×wZ wb‡goe †`Iqv n‡jv t

cÖ_g c×wZ t

cÖ_‡g †h †Kvb GKwU Database Window Open Kwi|

Table Tab G Click K‡i †h †Kvb GKwU Table A_ev Query Tab G Click K‡i †h †Kvb GKwU Query Select Kwi

†h Table/Query Gi Data ¸‡jv Auto Report AvKv‡i †`L‡Z PvB| Zvici

Insert Click, Auto Report Click A_ev New Object Button Click K‡i Auto Report Click Ki‡j Auto

Report AvKv‡i cÖ`wk©Z n‡e| ZLb View Menu Gi wZbwU Option Gi mvnvh¨ Database wewfboe fv‡e cÖ`k©b Kiv

hvq| cÖ`k©b †k‡l Close Button (x) Click Ki‡j Microsoft Access bv‡g GKwU Box Avm‡e ZLb Yes Click

Ki‡j Save as Box Avm‡e| †h bv‡g Report wU Save Ki‡Z PvB †mB bvg wj‡L Ok Click Ki‡j H bv‡g Report wU

Report Tab G Save n‡e| cieZ©x‡Z Report Tab ‡_‡K H bvg Open K‡i ‡`L‡Z cvwi| Report Open Ki‡j

mivmwi Print Preview ‡Z P‡j hvq|

wØZxq c×wZ t

cÖ_‡g †h †Kvb GKwU Database Window Open Kwi Ges Report Tab Select Kwi|

New Click Ki‡j New Report Dialog Box Avm‡e ZLb Dc‡ii Box G Auto Report Gi `yBwU Option †`Lv

hv‡e †h †Kvb GKwU Select Kwi (`ywU‡Z `yB iKg Auto Report ‰Zix n‡e)| Ges wb‡Pi Box G †h Table/Query Gi

Dci wfwË K‡i Auto Report Create Ki‡Z PvB †mwU Select Kwi| Zvici

Ok Click Ki‡jB Auto Report Create n‡e| Z‡e Bnv mivmwi Print Preview ‡Z P‡j hv‡e| ZLb

View Click, Design View Click A_ev Tool Bar ‡_‡K Close Click Ki‡j Design View AvKv‡i cÖ`wk©Z

n‡e| GB Ae¯’vq Form Design Kivi gZ Tool Box Gi mvnv‡h¨ Report Design Ki‡Z cvwi Ges c~bivq Print

Preview ‡Z †`L‡Z cvwi| cÖ`k©b †k‡l Close Button (x) Click Ki‡j Box Avm‡e ZLb Yes Click Ki‡j Save

As Box Avm‡e ZLb Report wU †h bv‡g Save Ki‡Z PvB †mB bvg wj‡L

Ok Click Ki‡j Report Tab G H bv‡g ˆZixK…Z Report wU Save n‡e| cieZ©x‡Z Report Tab †_‡K H bvg

Select K‡i Preview Click Ki‡j Preview AvKv‡i †`Lv hv‡e|

Design Click Ki‡j Design View ‡Z †`Lv hv‡e Ges GB Ae¯’vq Tool Box Gi mvnv‡h¨ Report Design

Change Kiv hvq|

we¯—vwiZ wk¶‡Ki wbKU †_‡K †R‡b wbb|

----------------------------

Notes Of Microsoft Access XP Part - 2

Created By: Kamrul Hassan Bappy E-mail: info@khola-janala.com

Wizard e¨envi K‡i Report ‰Zix Kiv t

Auto Report ‰Zix Kivi †ejvq Aek¨B †Lqvj K‡i‡Qb †Uwe‡ji me¸‡jv Field B ¯^qswdqfv‡e G‡m hvq| wb‡R B‡”Q gZ wKQy

Field ev` †`qv hvq bv| hw` wKQy Field ev` w`‡q cQ›`gZ wbw`©ó wKQy Field cª`k©b Ki‡Z PvB Ges Print Ki‡Z PvB Z‡e

Wizard e¨envi K‡i Repart ‰Zixi gva¨‡g Kiv m¤¢e| GRb¨

cÖ_‡g †h †Kvb GKwU Database Window Open Kwi Zvici Report Tab Select K‡i

New Click Ki‡j New Report Dialouge Box Avm‡e| ZLb Dc‡ii Box G Report Wizard Select Kwi Ges

wb‡Pi Table/Query G †Kvb Database Table/Query ‡_‡K Report ‰Zix Kie Zv Select Kwi|

Ok Click Ki‡jB Report Wizard Dialig Box Avm‡e ZLb Table/Query Box ‡_‡K Select Change Ki‡Z cvwi|

gva¨‡g Available Fields Box ‡_‡K cQ›`gZ Field ¸‡jv Selected Fields Box G Select Kwi, Next Click K‡i

Select K…Z Field Name ¸‡jvi g‡a¨ Grouping Ki‡Z PvB Z‡e †h Field Grouping Kie Button Gi gva¨‡g Select

K‡i Next Click K‡i evKx Field ¸‡jvi Ascending And Descending Select K‡i Next Click K‡i cQ›`gZ

Preview †`‡L Style Select Kwi| Zvici

Next Click K‡i †h bv‡g D³ Report Save Kie Zv wj‡L

Preview Click Kwi‡j Report Preview ‡Z open n‡e

Design Click Kwi‡j Report Design open n‡e|

NB t GB KvRwU Avgiv Ab¨ c×wZ‡ZI Ki‡Z cvwi| we¯—vwiZ wk¶‡Ki wbKU †_‡K †R‡b wbb|

Design View e¨envi K‡i Report ‰Zix Kiv t

Report Click, New Click Ki‡j New Report Dialog Box Avm‡e ZLb

Design View Click K‡i †h Table/Query ‡_‡K Report ‰Zix Ki‡Z PvB †mB Table/Query wU Select K‡i

Gi g‡ZvB ˆZix Kivi ci Save Gi gva¨‡g msi¶b Ki‡j c‡i cÖ‡qvRbg‡Zv Report Tab ‡_‡K Open Kiv hv‡e|

NB t GB KvRwU Avgiv Ab¨ c×wZ‡ZI Ki‡Z cvwi| we¯—vwiZ wk¶‡Ki wbKU †_‡K †R‡b wbb|

Costom Report wWRvBb t

Report G AwaKvsk KvRB Access program wb‡R †_‡KB K‡i| d‡j wb‡Ri wbqš¿‡bi g‡a¨ wKQy _v‡K bv| wKš‘ Custom

Report Gi mnvqZvq wb‡Ri g‡bi B‡”QgZ Report Design Kiv hvq| Ges Dc¯’vcbv †k‡l Print †`Lv †`qv hvq| Custom

Report Gi mvnv‡h¨ Report wWRvBb Kivi Rb¨ cÖ_‡g GKwU Report ˆZix Ki‡Z n‡e| Zvici Report Tab wU Select K‡i

†h Report Gi Design Ki‡Z PvB †mB Report Name wU Select K‡i Design Click Ki‡j Report wU Design View

wk‡LwQ| Custom Report wWRvBb Kivi mgq H GKB c×wZ‡Z Tool Box Gi mvnv‡h¨ KvR Kiv hvq| g‡b bv _vK‡j

c~bivq Custom Form wWRvBb Gi g‡a¨ P‡j hvb Ges †`Lyb wKfv‡e Zv Kiv hvq| Custom Form Design Gi ci Avgiv

Text Desogn Kiv wk‡LwQjvg| GKB c×wZ‡ZB Report Gi g‡a¨I Text Design Kiv hvq| we¯—vwiZ wk¶‡Ki wbKU †_‡K

†R‡b wbb|

Notes Of Microsoft Access XP Part - 2

Created By: Md. Helal Uddin E-mail: Helaluddin321@gmail.com.com

Date & Time Setting Kiv hvq|

Wizard e¨envi K‡i Report ‰Zix Kwi ZLb Grouping Kivi cÖ‡qvRb nq| myZivs Group Header ‡c‡Z n‡j Wizard

e¨envi K‡i Grouping cÖ‡qvMmn GKwU Report ‰Zix K‡i Design View ‡Z P‡j †M‡jB Group Header cvIqv hv‡e|

Time BZ¨vw` Setting Kiv hvq|

Bnv Select K‡i Delete Kivi ci

Insert Click, Data &Time Click K‡i ‡h †Kvb GKwU Date Design Click K‡i

Bnv Select K‡i Delete Kivi ci

Insert Click, Data & Time Click K‡i †h †Kvb GKwU Time Design Click K‡i

N.B t hw` ïay Date Insert Ki‡Z nq Z‡e Include Time Box Gi (_) wPý †Zv‡j Inactive Ki‡Z n‡e Ges hw` ïay

Time Insert Ki‡Z nq Z‡e Include Time Box Active K‡i Include Date Box Gi (_) wPý †Zv‡j Inactive Ki‡Z

n‡e| we¯—vwiZ wk¶‡Ki wbKU †_‡K †R‡b wbb|

Notes Of Microsoft Access XP Part - 2

Created By: Kamrul Hassan Bappy E-mail: info@khola-janala.com

Insert Page Number t c„ôv bv¤^vi ms‡hvRb

Page Number, Page Header/Page Footer Gi g‡a¨ ms‡hvRb Kiv hvq †hLv‡b ms‡hvRb Kie Select K‡i

Print Preview ‡Z Ae¯’vb Kv‡j Avgiv †`L‡Z cvwi| Form G Apply Kiv hvq|

Mailing Label t

‡Kvb Database Table Gi AmsL¨ Field ‡_‡K ïaygvÎ bvg I wVKvbv m¤^wjZ Field `ywU‡K Print Kivi cÖ‡qvRb n‡j

Mailing Label c×wZ Abymib Ki‡Z nq| GRb¨

‡h Table †_‡K bvg I wVKvbv Print Kie †mB Table Gi Database Window wU Open Kwi| Zvici

Report Tab Select K‡i New Button Click Ki‡j New Report Dialog Box Avm‡e| ZLb Dc‡ii Box G Lable

Wizard Select Kwi Ges wb‡Pi Box G †h Table/Query ‡_‡K Lable Kie †mwU Select K‡i

Ok Click Ki‡j Label Wizard Dialog Box Avm‡e| ZLb GB Box Gi mewKQy Setting K‡i

Next Click K‡i cQ›`gZ Font Style Select K‡i Next Click K‡i Button Gi mvnv‡h¨ Field Setting K‡i

Next Click K‡i Field Gi avivevwnKZv Setting K‡i Next Click K‡i Save Kie †mB bvg wj‡L

See the labels as they will look printed Click

Lable Design t

†Z Ae¯’vb Kv‡j Fild Name Select K‡i Formatting Tool Bar Gi mvnv‡h¨ Lebel Design Ki‡Z cvie| Design

Kiv †kl n‡j Save Ki‡Z n‡e| bv cvi‡j wk¶‡Ki mvnvh¨ wbb|

************** - * - ***************

Notes Of Microsoft Access XP Part - 2

Created By: Md. Helal Uddin E-mail: Helaluddin321@gmail.com.com

Macro (g¨v‡_v) t

GKwU Macro (g¨v‡dv) ˆZix Kie| GB Macro (g¨v‡dv) e¨env‡ii Kjv‡KŠkj¸‡jv AvqZ¡ Ki‡Z cvi‡jB e¨enviKvix Zvi wb‡Ri

cÖ‡qvRb I cQ›`gZ g¨v‡dv ˆZix Ki‡Z cvi‡eb| Z‡e Database Management System Software (Microsoft Access)

Gi g‡a¨ KvR Kivi mgq wewfboe ai‡bi Print (wcÖ›U) Kivi cÖ‡qvRb nq| ZvB Avmyb Avgiv wcÖ‡›Ui Dci GKwU Macro (g¨v‡dv)

Kivi Rb¨ Avgiv Macro (g¨v‡dv) ˆZix Kwi|

To Create A Macro (GKwU g¨v‡_v ˆZix Kiv) t

Window Open Kwi Zvici

Table/Object Gi Dci Macro (g¨v‡dv) Ki‡Z PvB Database Window ‡Z wM‡q †mB Table/Object wU Select K‡i

Mouse w`‡q Move K‡i Macro (g¨v‡dv) Window ‡Z Action Field Gi cÖ_g Cell G ¯’vcb Kwi| GB Ae¯’vq

Action Field Gi g‡a¨ Open Table Ges Table Name Box Gi g‡a¨ H Table Gi bvg †`Lv hv‡e| ZLb

Action Field Gi 2nd Cell Gi g‡a¨ Run Command Select Kwi Ges wb‡Pi w`‡K Command Box Gi g‡a¨ Page

Setup Select Kwi| Zvici

Action Field Gi 3rd Cell Gi g‡a¨ Run Command Select Kwi Ges wb‡Pi w`‡K Command Box Gi g‡a¨ Print

Select Kwi| Zvici

Action Field Gi 4th Cell Gi g‡a¨ Run Command Select Kwi Ges wb‡Pi w`‡K Command Box Gi g‡a¨ Page

Setup Select Kwi| Zvici

Action Field Gi 5th Cell Gi g‡a¨ Close Select Kwi Ges wb‡Pi w`‡K Object Type Box Gi g‡a¨ Table (‡h

Object Gi Dci Macro Kiv n‡”Q †mwU) Select Kwi| Ges wb‡Pi w`‡K Object Name Box Gi g‡a¨ Table Name (‡h

Table/Object Gi Dci Macro Kiv n‡”Q †mwUi bvg) Type Kwi| Zvici

File Click, Save Click Ki‡j GKwU Save Box Avm‡e ZLb †h bv‡g Macro (g¨v‡dv) wU msi¶b Ki‡Z PvB †mB bvg

wj‡L Ok Click Ki‡jB Macro (g¨v‡dv) wU H bv‡g msiw¶Z n‡e| ZLb †`Lv hv‡e Avevi Avgiv Database Window †Z

wd‡i G‡mwQ|

‡Z Macro (g¨v‡dv) ‰Zix Kiv Av‡Q †mwU Open Kwi Zvici

Run Click Ki‡jB Run Command Abymv‡i Page Setup Dialog Box Avm‡e ZLb GB Page Setup Dialog Box

Ok Click Ki‡jB Avgiv Avevi Datebase Window ‡Z wd‡i Avme|

Notes Of Microsoft Access XP Part - 2

Created By: Kamrul Hassan Bappy E-mail: info@khola-janala.com

To Edit The Macro (g¨v‡_v ms‡kvab Kiv) t

GLb Avgiv ˆZixK…Z Macro (g¨v‡dv) wU ms‡kvab K‡i ‡`wL Gi gva¨‡g wK wK Kiv m¤¢e

‡h Datebase Window ‡Z Macro (g¨v‡dv) ‰Zix Kiv Av‡Q †mwU Open Kwi Zvici

Macro (g¨v‡dv) Tab Select Kwi Ges †h Macro (g¨v‡dv) wU ms‡kvab Ki‡Z PvB †mwU Select K‡i

Design Click Ki‡jB Macro Design View ‡Z P‡j hv‡e| ZLb g‡bi B‡”QgZ Macro (g¨v‡dv) wU ms‡kvab K‡i

To Delete The Action (G¨vKkb †gvQv) t

GLb Avgiv ˆZixK…Z Macro (g¨v‡dv) wU n‡Z G¨vKkb †gvQv wkLe

‡h Datebase Window ‡Z Macro (g¨v‡dv) ‰Zix Kiv Av‡Q †mwU Open Kwi Zvici

Macro (g¨v‡dv) Tab Select Kwi Ges †h Macro (g¨v‡dv) wU n‡Z G¨vKkb †gvQ‡Z PvB †mwU Select K‡i

Design Click Ki‡jB Macro Design View ‡Z P‡j hv‡e| ZLb g‡bi B‡”QgZ †h G¨vKkbwU †gvQ‡Z PvB †mB e‡·i

wm‡j±i e· Gi g‡a¨ Cursor ‡i‡L, Edit Click, Delete Row Click Or Del Key Press Or Delete Row Tools

Click Ki‡jB wbw`ó G¨vKkbwU †gv‡Q hv‡e|

To Move The Action (G¨vKkb ¯’vbvš—i) t

GLb Avgiv ˆZixK…Z Macro (g¨v‡dv) wU n‡Z G¨vKkb ¯’vbvš—i Kiv wkLe

‡h Datebase Window ‡Z Macro (g¨v‡dv) ‰Zix Kiv Av‡Q †mwU Open Kwi Zvici

Macro (g¨v‡dv) Tab Select Kwi Ges †h Macro (g¨v‡dv) wU n‡Z G¨vKkb ¯’vbvš—i Ki‡Z PvB †mwU Select K‡i

Design Click Ki‡jB Macro Design View ‡Z P‡j hv‡e| ZLb g‡bi B‡”QgZ †h G¨vKkbwU ¯’vbvš—i Ki‡Z PvB †mB

G¨vKk‡bi Row wU Select K‡i Mouse Gi Wvb evUb †P‡c Cut Click K‡i ‡h Row wU‡Z G¨vKkb ¯’vbvš—i Ki‡Z PvB †mB

Row wU Select K‡i Mouse Gi Wvb evUb †P‡c Paste Click Ki‡jB G¨vKkbwU ¯’vbvš—i n‡e| †Kvb bZzb G¨vKkb Create

(ˆZix) Ki‡Z A‡bKmgq G¨vKkb ¯’vbvš—i Ki‡Z nq|

Page Tab (†cR U¨ve) t

Data Access Page ‰Zix Kivi Rb¨ Page Tab (†cR U¨ve) e¨envi Kiv nq| Data Access Page n‡”Q GKwU we‡kl ai‡bi Web

Design View Or Wizard e¨envi K‡i †Kvb Data Access Page ‰Zix Kiv hvq wKsev Av‡Mi †Kvb Data Access Page Gi

Modules Tab (gwWDj U¨ve) t

Modules (gwWDj) n‡”Q Database Program Microsoft Access Gi Programing File. GLv‡b Microsoft Access

Program Gi g‡a¨ Basic Coad G †cÖvMÖvg †jLv nq| Modules (gwWDj) Gi g‡a¨ GK ev GKvwaK wWKjv‡ikbm&, †÷U‡g›U

Ges cÖwmwWDi GK‡Î †Kvb dvB‡j msi¶b Kiv nq| Database Program Microsoft Access Gi g‡a¨ wZb ai‡bi Modules

(gwWDj) i‡q‡Q| †hgb t 1. Form 2. Report 3. Global. ‡Kvb Modules (gwWDj) ˆZix Kiv n‡j Zv Database Gi

Notes Of Microsoft Access XP Part - 2

Created By: Kamrul Hassan Bappy E-mail: info@khola-janala.com

wi‡jkbvj WvUv‡eR e‡j| Database Program Microsoft Access is a Relational Database Management System.

cvwi| Relation (wi‡jkb) A‡bK c×wZ‡Z Kiv hvq| Query Gi KvR Rvbv _vK‡j Avgiv Lye mn‡R Relation (wi‡jkb) Gi

KvR Ki‡Z cvie| wKfv‡e Relation (wi‡jkb) Ki‡Z nq Zv we¯—vwiZ wk¶‡Ki wbKU †_‡K †R‡b wbb|

*******************

Thank you,

Created By: Md. Helal Uddin E-mail: Helaluddin321@gmail.com.com

**********************************************************************

আসুন কম্পিউটার শিখি,ডিজিটাল বাংলাদেশ গড়ে তুলি ।

সোমবার, ২ জানুয়ারী, ২০১২

Notes Of Microsoft Access XP

কোন মন্তব্য নেই:

একটি মন্তব্য পোস্ট করুন