Notes Of Microsoft Access XP
Created By: Md. E-mail: Helaluddin321@gmail.com.com
gvB‡_vmdU G‡·m G·wc
P art – 2
my wcÖ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. 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|
(c) Change Switch board items t GB Option
wU Click
K‡i Box Gi Title
Bar G wjwLZ Main Switch
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. 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|
A uto 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|
W izard 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|
D esign 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|
C ustom 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. 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
W izard 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|
ZLb †h Table/Query
Select Kie Zvi Field Name ¸‡jv Available Fields Box G
cÖ`wk©Z n‡e| ZLb Button Gi
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
Finish Click Ki‡j Report wU H bv‡g Save n‡e cieZ©x‡Z Report Tab Select K‡i H
bv‡g Select K‡i
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|
D esign 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
Ok Click Ki‡jB Report 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 Report
Design View ‡Z ¯’vcb Kwi| cieZ©x‡Z GB ˆZixK„Z Report wU Design Ki‡Z cvie|
Ab¨me Report
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|
C ostom Report wWRvBb t
c~‡e© Avgiv Auto
Report Ges Wizard
e¨envi K‡i wewfboe iKg Report
Desing wk‡LwQ| Auto Report Ges Wizard
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
†Z cÖ`wk©Z n‡e| ZLb Report
Box Gi mv‡_ Tool Box cÖ`wk©Z
n‡e|
c~‡e© Avgiv hLb Custom
Form wWRvBb wk‡LwQ ZLb Tool Box Gi
wewfboe Option Gi mvnv‡h¨ wKfv‡e KvR Ki‡Z nq Zv
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. E-mail:
Helaluddin321@gmail.com.com
P art of Report t wi‡cv‡U©i wewfboe Ask
[ GKwU c~bv©½ Report G 6wU †mKkb _v‡K| G¸‡jv m¤ú‡K© wb‡goe Av‡jvPbv Kiv nj ]
1. Report Header t GLvb
hv wKQy wjLv n‡e ïaygvÎ cÖ_g c„óvi kxl©‡`‡k cÖ`wk©Z n‡e| Report m¤ú‡K© †Kvb
Z_¨ ev UvB‡Uj
A_©vr hv ïay cÖ_g c„óvi kxl©‡`‡k Print Kiv cÖ‡qvRb
ZvB Report Header G Setting
Ki‡Z n‡e|
2. Page Header t
GLv‡b hv wKQy wjLv n‡e Zv cÖ‡Z¨K c„óvi kxl©‡`‡k cÖ`wk©Z n‡e| GLv‡b †Kvb †nwWs, Page Number ,
Date & Time Setting Kiv hvq|
3. Group Header t GB
†mKkb me mgq cÖ‡qvRb nq bv Ges memgq cÖ`wk©Z nq bv| hw` †Kvb Fild Gi Dci Groping
wba©vib Kiv _v‡K Z‡e cÖ‡Z¨K Group Gi kx‡l© †Kvb
wKQy wjLvi cÖ‡qvRb n‡j GB Section
G Setting
Ki‡Z n‡e| Avgiv hLb
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|
4. Detail t Database Table/Query Gi Data ¸‡jv GLv‡b
cÖ`wk©Z nq| GB †mKk‡b Database Field
Name Gi ¯’vbvš—i
Ki‡j Print
Preview †Z cwieZ©b Avm‡e Ges †mB Abymv‡i Print n‡e|
5. Page Footer t
GLv‡b hv wKQy wjLv n‡e Zv cÖ‡Z¨K c„óvi wbgoecÖv‡š— cÖ`wk©Z n‡e| GLv‡b Page Number †nwWs Date &
Time BZ¨vw` Setting Kiv hvq|
6. Report Footer t
GLv‡b hv Setting Kiv n‡e Zv me©‡kl c„óvi me©wbgoe cÖv‡š— cÖ`wk©Z n‡e|
†Kvb Report Design Kivi mgq Gi
me©‡kl hv wKQy cÖ‡qvRb Zv GLv‡b †mwUs Ki‡Z n‡e|
I nsert Date t ZvwiL ms‡hvRb ev cwieZ©b Kiv
Report Gi Page Footer G Bnv memgq
cÖ`wk©Z nq| hw` Bnv Change Ki‡Z PvB Z‡e Design
View ‡Z Ae¯’vb Kv‡j
Bnv Select
K‡i Delete
Kivi ci
Insert Click, Data &Time Click K‡i ‡h †Kvb GKwU Date
Design Click K‡i
Ok Click [
cieZ©x‡Z Avgiv Print Preview †Z †`L‡Z cvwi ]
g‡b ivL‡eb t Form
& Report G g‡bi B‡”QgZ ms‡hvRb ev cwieZ©b
Kiv hvq| cÖ‡qvR‡b wk¶‡Ki mvnvh¨ wbb|
I nsert Time t mgq ms‡hvRb ev cwieZ©b Kiv
Report Gi PageFooter G Bnv
memgq cÖ`wk©Z nq| hw` Bnv Change
Ki‡Z PvB Z‡e Design
View †Z Ae¯’vb Kv‡j
Bnv Select
K‡i Delete
Kivi ci
Insert Click, Data & Time Click K‡i †h †Kvb GKwU Time
Design Click K‡i
Ok Click [
cieZ©x‡Z Avgiv Print Preview †Z †`L‡Z cvwi ]
g‡b ivL‡eb t Form
& Report G g‡bi B‡”QgZ ms‡hvRb ev cwieZ©b
Kiv hvq| cÖ‡qvR‡b wk¶‡Ki mvnvh¨ wbb|
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
I nsert 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
Insert Click, Page Number Click K‡i Page
Number wU Report
Design Gi †Kvb w`‡K wKfv‡e cÖ`k©b Kie Ges
Print w`e Zv Select Kwi| Zvici Ok click Ki‡j Page Number Setting gZ Report Design cÖ`wk©Z
n‡e| hvnv
Print Preview ‡Z
Ae¯’vb Kv‡j Avgiv †`L‡Z cvwi| Form G Apply
Kiv hvq|
M ailing 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
Finish Click Ki‡j Select gZ Lable ‰Zix n‡e|
cieZx©‡Z Save K„Z bvg Open K‡i †`L‡Z cvie|
L able Design t
c~‡e© Avgiv Form Ges Report
Design Kiv wk‡LwQ c~‡e©i gZB †h Lable Gi Design Kie †mwU Select K‡i Design
Click Ki‡j Lable Design View †Z
cÖ`wk©Z n‡e| GLv‡b c~‡e©i gZ Tool
Box Gi mvnvh¨ wb‡Z cvie| Design View
†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. E-mail:
Helaluddin321@gmail.com.com
M acro (g¨v‡_v) t
W hat is Macro? (g¨v‡_v wK?) t g¨v‡dv n‡”Q †Kvb Kvh© m¤úv`‡bi Rb¨ KwZcq
KgvÛ hv msi¶b Kiv nq Ges cieZ©x‡Z
cwiPvjbv Kiv nq| ‡h mKj KgvÛ mPivPi cÖ‡qvM Ki‡Z nq Zv
Øviv Macro (g¨v‡dv) †cÖvMÖvg ˆZix K‡i wb‡j cieZ©x‡Z wbwg‡lB
m¤úv`b Kiv hvq| Ges GKB KvR evievi Kivi Sv‡gjv †_‡K
†invB cvIqv hvq| GKB mv‡_ A‡bK mgq euvPv‡bv hvq| A_©vr GKwU
gvÎ KgvÛ e¨envi K‡i A‡bK¸‡jv cÖwdqvi GKwU wmwiR‡K c~bt
c~bt wbe©v‡ni c×wZB Macro (g¨v‡dv) bv‡g cwiwPZ| Gevi Avgiv
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)
ˆZix K‡i Macro
(g¨v‡dv) m¤ú‡K© AeMZ nB| Òg‡b Ki“bÓ Avcbv‡K wewfboe
D‡Ï‡k¨ Mailing Label Print Ki‡Z n‡e| GRb¨
Avcbv‡K evievi Print
Setup cwieZ©b K‡i wbw`ó †j‡e‡ji Rb¨ Setup wba©vib Ki‡Z
nq| Ges Mailing Label Print n‡q
†M‡j c~bivq Default
Setup wba©vib Ki‡Z nq| GB KvRwU Avcbv‡K
cÖvqB Ki‡Z nq| Gevi Avmyb GB KvR¸‡jv Lye ZvovZvwo
Kivi Rb¨ Avgiv Macro
(g¨v‡dv) ˆZix Kwi|
To Create A Macro (GKwU g¨v‡_v ˆZix Kiv) t
cÖ_‡g †h Database
Window Gi Aš—M©Z Object/Tab ‡_‡K Macro (g¨v‡dv) ˆZix
Ki‡Z PvB †mB Database
Window Open Kwi Zvici
Macro (g¨v‡dv) Tab Select K‡i New Button Click Ki‡j Macro (g¨v‡dv) Window wU c`wk©Z
n‡e| Gevi †h
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 2 nd 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 3 rd 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 4 th 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 5 th 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|
To Run The Macro (g¨v‡_v Kvh©Ki Kiv) t
GLb Avgiv ˆZixK…Z Macro
(g¨v‡dv) wU Kvh©Ki K‡i ‡`wL Gi gva¨‡g wK wK Kiv m¤¢e
GRb¨ cÖ_‡g ‡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 Kvh©Ki Ki‡Z PvB †mwU Select K‡i
Run Click Ki‡jB Run Command Abymv‡i
Page Setup Dialog Box Avm‡e ZLb GB Page
Setup Dialog Box
†_‡K Page
Setup, Margin, Printer Setup BZ¨vw` g‡bi
B‡”QgZ wba©vib K‡i
Ok Click Ki‡jB Print Dialog Box Avm‡e
ZLb Print Option wba©vib K‡i Ok
Click Ki‡jB Macro (g¨v‡dv) wUi
Print (wcÖ›U) ïi“
n‡e cieZ©x‡Z Print (wcÖ›U) †kl nIqvi ci Run
Command Abymv‡i c~bivq Page Setup Dialog
Box Avm‡e ZLb Ges
wWdë †mwUs cÖ`wk©Z n‡e| ZLb hw` Ab¨iKg Page
Setup K‡i Avevi Print (wcÖ›U) Ki‡Z
PvB Z‡e
H wbqgg‡Zv Ki‡Z cvwi| bZzev cÖ‡qvRbxq cwieZ©b ev
wba©vi‡bi c‡i
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
Save Kwi Ges
cieZ©x‡Z Open K‡i ‡`wL ms‡kvwaZ Macro
(g¨v‡dv) wU Open n‡e|
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
Page (I‡qe †cR)| Internet (B›Uvi‡bU)
†_‡K cÖvß †WUv cÖ`k©b ev KvR Kivi Rb¨ Data
Access Page e¨envi Kiv nq| Internet
(B›Uvi‡bU) Gi g‡a¨ Microsoft
Access Or SQL Server Gi g‡a¨ msiw¶Z ‡WUv wb‡q
KvR Kiv ev †WUv cÖ`k©b Kivi Rb¨ Data
Access Page e¨envi
Kiv nq| GQvovI Ab¨ †h †Kvb †mvm© †_‡K cÖvß †WUv wb‡qI Data Access Page ˆZix
Kiv hvq| Data
Access Page wb‡q
KvR Ki‡Z PvB‡j Kw¤úDUv‡i Aek¨B Internet
Explorer 5.0 ev ZrDaŸ© †Kvb fvm©b Bbój Kiv _vK‡Z
n‡e|
Database Window ‡_‡K Page wbe©vPb Ki‡j Data Access Page ‰Zix
Kivi Rb¨ wZbwU Option cÖ`wk©Z nq| G¸‡jv wb‡q
Design View Or Wizard e¨envi
K‡i †Kvb Data Access Page ‰Zix Kiv hvq wKsev Av‡Mi †Kvb Data Access Page Gi
cÖ‡qvRbxq cwieZ©b mvab Kiv hvq|
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
Modules (gwWDj)
U¨v‡ei AvIZvq cÖ`wk©Z nq|
Notes Of Microsoft Access XP Part - 2
Created By: Kamrul Hassan Bappy E-mail: info@khola-janala.com
Relationship (m¤úK© ¯’vcb) t
Relation (wi‡jkb)
k‡ãi evsjv A_© n‡”Q m¤úK©| †h WvUv‡eR e¨e¯’vq GK ev GKvwaK †Uwe‡ji g‡a¨ m¤úK©
cÖwZôv Kiv hvq Zv‡K
wi‡jkbvj WvUv‡eR e‡j| Database
Program Microsoft Access is a Relational Database Management System.
Gi mvnv‡h¨ Avgiv GK ev GKvwaK †Uwe‡ji g‡a¨ m¤úK© ¯’vcb
Ki‡Z cvwi| Ges cieZ©x‡Z Query
Gi mvnv‡h¨ Zv Ly‡u R †`L‡Z
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. E-mail:
Helaluddin321@gmail.com.com
**********************************************************************
