MS_Access Tutorial

Notes Of Microsoft Access XP  

gvB‡µvmdU G‡·m G·wc

Part      –   2

mywcÖq cÖwk¶bv_©xMb,

Part - 2

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¯’  wewfbœ †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Ökœ Ki‡Z cv‡ib cÖ_g c‡e© Avgiv Menu Bar Gi Aaxb¯’ wewfbœ †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 wewfbœ 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

. 
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  wfbœ  wfbœ 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 wewfbœ 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 wewfbœ cÖKvi e¨envi wkwL|  

wewfbœ 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 wfbœ wfbœ

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

Notes Of Microsoft Access XP

Avgiv Table (†Uwej) ˆZix Ki‡Z cvwi 5 (cuvP) wU wfbœ wfbœ 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 wbgœiƒc t

Part - 2

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‡gœewb©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|

Sl_No

F_Name

M_Name

L_Name

N_Name

B_Data

Salary

Field Name

Data Type

Auto Number Or Press A

Text Or Press T

Text Or Press T

Text Or Press T

Text Or Press T

Data/Time Or Press Database

Number Or Press N

Serial Number

Fast Name

Middle Name

Last Name

Nick Name

Birth Date

Monthly Salary

Description

Position

Probation

Text Or Press T

Yes/No Or Press Y

Official position

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

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 wfbœ wfbœ `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

wewfbœ  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¯’ wewfbœ 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  

Wizard e¨envi K‡i Database Design Kiv t

Part - 2

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¤úbœ 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  

Query & Filter

Part - 2

Avgiv  Av‡MB  wk‡LwQ  Find  e¨envi  K‡i  wbw`©ó  GKwU  Record  mbv³  Kiv  ev  †LvRv  hvq  Ges  Record  mg~n‡K  `ª“Z  µgvbymv‡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 wfbœ wfbœ 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‡gœ 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|