salapasagnþrcati ilc 1 page - - wordpress.com¾rcati ilc 1page - -perpare by : ly.krim chrea ilc...

salaPasaGnþrCati ILC Page - 1 -

Perpare by : LY.KRIM CHREA ILC SCHOOL (017)_855 576

What Microsoft Access ......................................................................................................................... 2

What Database ....................................................................................................................................... 3

Table ...................................................................................................................................................... 4

Data Type ............................................................................................................................................... 5

Field Properties ...................................................................................................................................... 6

Get External ........................................................................................................................................... 7

Relationships .......................................................................................................................................... 8

Query ..................................................................................................................................................... 9

Form ....................................................................................................................................................... 10

Tool Box ................................................................................................................................................ 11

Formula .................................................................................................................................................. 12

Report .................................................................................................................................................... 13

Macro ..................................................................................................................................................... 14

Chart ...................................................................................................................................................... 15

Exercise .................................................................................................................................................. 16



esckþIepþIm³ etIGIVeTACakmµviFI Microsoft Access 2003

kmµviFI Access CakmµviFImYyEdlEdleRbIsMrab;rkSaTukTinñn½y RKb;RKgTinñn½y EsVgrkTinñn½y Rsg;Tinñn½y

CaedIm ehIyvakmµviFImYysßitkñúgCMBUk Relational Database Edlkt;RtarkSaTuknigpþl;mkvijya:grh½snUvTinñn½y

ehIyeKniymeRbIeTAelIkargarsMxan;dUcteTA³

-RKb;RKgsßitiCatYelx b¤CabBa¢Iraynam)anrab;Esn lannak; edaykt;RtabBa¢ÚlTinñn½yTaMgenaHeTArkSaTukkñúg kMuBüÚT½r

ehIyGacRsavRCavrkeQµaH b¤Bt’manBImnusSmñak;edayRKab;EtvaybBa¢ÚlnUvGtþelx b¤eQµaHmnusSenaH.

-RKb;RKgkartandannUvskmµPaB lT§plsikSarbs;sisS tMerobeQµaHtamlMdab;tYGkSrlMdab;BinÞú cMNat;fñak; kargar

TaMgenHelakGñkminRBYy)armÖeLIy Ms-Access nwgeFIVCUnedayRKan;Etpþl;Bt’maneGayvab:ueNÑaH.

-kt;RtanigRsavRCavnUvCIvRbvtþimnusSRKb;rUb ehIyGacbBa¢ÚlrUbfa b¤søak;sñamepSg²eTAkñúg Computer tamry³ma:suIn

Scanner nigGaceFIVkarBRgIk b¤bRgÜmrUbPaBTaMgenaHpþl;kargayRsYlkñúgkarRtYtBinitü.

-eFIVRkabsþIBIkMeNInnigtMhay énRbCara®sþb¤RkabbepSg²EdlbgðajkargarGIVmYy.

-eFIVtaragebovtSr_ TUTat;R)ak;ema:géntMlBlkmµ

-cMeBaHkargarCMnYj ehIyeFIvkarkt;TuknUvkar Order TMnijrbs;GtifiCndUcCa RbePT TMnij cMnYn tMél QñÜldwkCBa¢Ün.

-KNenyü>>>>>>nigkargarmYycMnYneTot.

]TahrN¾ ebIelakGñkCaGñkRKb;RKgBt’manmanrbs;sisS nisitS elakGñkKYrEtykkmµviFI Access edIm,IeRbI R)as;

eRBaHcaCYyGñkeGaygayRsYlkñúgkardkRsg;Bt’man KNnaBinÞú rkniTÞis cMNat;fñak; eFIVkat sBaØabR½t nigEpñk

TIpSarEfmeTotpg.

Access GacCYysMrYldl;kargarCaeRcIneTotdUcCa

- kargarEpñksþúkTMnij

- kargarRKb;RKgesovePAenAbNÑal½y

- kargarKNenyü nigRKb;RKgelIbBa¢ICaeRcIneTot.



How to start Microsoft Access

Start Programs Microsoft Office Microsoft Access



CMBUkTI1 DATABASE

How to know about Access

Fill New Blank Database ecjpÞaMgmYysresreQµa³enAkEnøg File name Create

Title Bar

Menu Bar

Standard Bar



rYcecjpÞaMg Database

+ Create Table Datasheet View

- New Datasheet View OK ecjpÞaMgmYy rYcsresrTinñn½ydUcxageRkam



cMNaMcucelIBakü View ecjpÞaMgmYyrYcsresreQµaHTinñn½yEdlRtUv Save rYccuc OK ecjpÞaMg No

+ Create Design View

- New Design View OK ecjpÞaMgmYy rYcsresrTinñn½ydUcxageRkam

cucelI Save ecjpÞaMgmYyrYcsresreQµaHTinñn½yEdlRtUv Save rYccuc OK ecjpÞaMg No



cucelIBakü View ecjTinñn½ydUcxageRkam

+ Create Design View

- New Table Wizard OK



rYcecjTinñn½ydUcxageRkam

cUrb¥ÚnbegáIt Table mYyehIy Save dak;eQµaH Table Employees



karsikSaEsVgyl;GMBI DATA TYPE

- Text GkSr> GkSrlayelx 255 tY

- Memo GkSr> GkSrlayelx )aneRcInCag Text 65535 tY

- Number vayCaelx GacKNna)an

- Date/Time kalbriecætéf¶ExqñaM

- Currency manrUbiyb½NÑ duløar erol )at $ R B

- Auto Number elxerogedaysV½yRbvitþi

- Yes/No Bit rWminBit

-OLE Object dak;rUbPaB rUbft

Lookup Wizard kMNt; Field EdlGackMNt;eRCIserIs



sikSaGMBI Format

Of Text KWkarkMNt;BN’GkSrtam Column nig TMrg; GkSrtUc GkSrFM

sBaØasMKal; rebobeRbI

@ sMrab;dak;BN’GkSr @[Red] , @[Yellow] , @[Blue]

> sMrab;kMNt;eGayGkSr eTACaGkSrFM Thy THY, Sok SOK

< sMrab;kMNt;eGayGkSr eTACaGkSrtUc Thy thy , SOK sok

Of Number KWGackMNt;TMrg;CaelxepSg²dUcCa

Of Date / Time



+ GackMNt;vayedayxøÜnÉgdUcCa

sBaØasMKal; eRbIsMrab;

:

/

-

D

dd

ddd

dddd éf¶CaGkSr (Monday – Sunday)

M

mm

mmm

mmmm

yy

yyyy

H

hh

N

nn

S

ss

+ How to use Get External Date

Import

- New Import Table Select Database Click Import Select Table or Query

rYceyIgcg;cuc Table Query or Form NaEdleyIgcg;)an. cMNaMeyIgcucelIÉksarNaEdleyIgcg;)anrYccuc Import



cUrbegáIt Table Customer

cUrbegáIt Table Book



cUrbegáIt Table Sale

cUrbegáIt Table Tax for Rental

karsikSaBI Relationships

karcg; Relationship KWCakareFIVeGaymanTMnak;TMngrvag Table 1 & Table 1 eTot rWcg;vaCa Table 1 eTA

Table eRcIneTot. ehIykarP¢ab; Table eTA)anlu³RtaEt Table ena³man

- Field Name (Ca ID dUcKña)

- man Primary Key

- man Data Type dUcKña

]TahrN_

+ How to use set Primary Key

karkMNt; Primary Key eTAelI Field NamYyenaH Field enaHminGacbBa¢ÚlTinñ½ysÞÜneLIy.

- rebobcucelI karGnuvtþn¾



- karGnuvtþn’

Tool Relationship ecjpÞaMgmYyrYccuc Add Select File Name

EdleyIgcg;)anrYccucelIBakü Create



- karlub Relationship cuc Right Click elIEx Relationship Delete Yes

cUrbegáIt Table Student’s



cUrbegáIt Table Study List



- cUrcg Relationship

cUrbegáIt Table Teacher List



cUrbegáIt Table Salary for Teacher

- cUrcg Relationship



Queries mantYnaTI RbmUlpþúMTinñn½y EsVgrk dkRsg; nigeFIVkarKNnaCaedIm. ehIyvamanTMnakTMng;CamYy

Table EdleyIgbegáItBImunmk.

]TahrN_³ eyIgcg;yk Table 2 mkKNna

eyIgcucelIBakü Query Create query Design View



Query for Sale

cucelI Query > Add 4Table KW Customer, Book, Sale, Tax for Rental rYccab;Taj Fill cUlkñúg Query nigKNna Amount, Sale, Tax, Total .



Query Total Quantity of Sale

cucelI Query > Add Table Sale rYcTaj Fill Book ID, nigKNna Quantity

cucyk Table Book & Query Total of Sale rYcKNna



Query Total Cost of Goods Sold

cucyk Table Book & Query Total Quantity of Sale



Query Total Point

- cUrKNna Result eday Avg of Points >=5 Pass

Avg of Points >=5 Fail

- cUrKNna Mention eday Avg of Points =10 “Excellent”,>=9”Very Good”, >=8”Good”,>=7”Fair”, >=6”AFair”, >=5”Medum”, <5”Weak”.



Query Total Point by Cross Tab

edIm,IKNna Gross Tab GñkRtUvTajTinñn½ymkdak;eGayGs;sinenAtam Row nImYy². rYccuc nigeRCIserIsyk Sum Rtg; Point TaMgBIrbnÞab;mkcuc

Query Query Cross Tab rYceRCIserIsRtg; Gross yk Row Heading TaMgGs;elIkElgEt Subject Ca Column nig Point mYyCa Value



Form KWeRbIsMrab;bgðajTinñn½yEdl)anBI Table or Query edaymanlkçN³gayRsYlemIlEfmTaMgGacEk

lMG)anbEnßmeTotdUcCa GacvayGkSrExµr)an bB¢ÚalTinñn½y EkERb lub nigGacKNna)an rYmpSMTaMgkar dak;bB¢Úal rUbPaB

rWrUbfteTotpg.

+ Create Form by Design View

- Form Design View OK

karsikSaGMBI Tool Box

- rebobeRbI Label sMrab;sresrGkSrenAelI Form/Report -

- rebobeRbI Text Box sMrab;sresrrUbmnþedIm,IKNnark

tMélepSg²enAelI Form/Report

-rebobeRbI Option Group sMrab;dak;lkçxNÐ Toggle Button, Check Box CaRkum

edIm,IcuceRCIserIs

-rebobeRbI Toggle Button CalkçxN§ÐEdleRbIenAkñúg Option Group manragmUl

sMrab;cuceRCIserIs

-rebobeRbI Option Box CalkçxNÐEdleRbI Option Group manragmUl sMrab;cuceRCIserIs

- rebobeRbI Check Box CalkçxNÐEdleRbI Option Group manragmUl nigbYnRCugsMrab;cuceRCIserIs

- rebobeRbI Combo Box CaRbGb;mYyEdlman sMrab;cuceRCIserIs

- rebobeRbI List Box CaRbGb;mYyEdlman GUseLIgcuHedIm,IcuceRCIserIs



cUrKNna Form dUcxageRkam³

cucelI Text Box Properties Control Source Build rYcvayrUbmnþdUcxageRkam³

cUreronbenáIt Tab Control eGay Form Student & Study edayxøÜnÉg.



cUrbegáIt Main Form & Sub Form rYcKNnapg

- cucelI Form Customer yk Design

- cucelI Sub Form KUseRkam Form Footer Next rhUtcb;

- rYcKNna Sum Quantity edaycucelI Text Box KUskñúg Form rbs; Form Sale Right Click

Properties Control Source Build vay Sum([Quantity)

cMNaM

- Main Form PaKeRcInCarag Columns

- Sub Form PaBeRcInCarag Tabular, Data Sheer



cUrbegáIt Main Form 1 & sub Form 2 edayxøÜnÉg

- Main Form (Customer)

- Sub Form (Sale & Rental)

cUrbegáIt Main Form 1 & sub Form 2 edayxøÜnÉg nigsrubTinñn½ynisSit

- begáIt Form 2 sinehIyeFIVvaCarag Design



karbegáIt Form CaPasaExµr



- Report eRbIkñúgkarRtYtBinitü (View) nige)aHBumÖBt’manTTYl)anBItarag b¤ Queries

- eFVI Group Records KNna bUksrub mFümPaK sresrrUbmnþKNnakñúgeBlEtmYy.

- Report GaceFIVGIVdUc Form EdrEtvaxusBI Form Rtg;minGacbBa¢ÚlTinñn½y)anKWvaTTYlTinñn½yBIeKsMrab;e)aH

Bum>>>>>.

- eyIgGacbegáItr)aykarN’)antam Wizard and Without Wizard dUc Form Edr.

+ eyIgcucelI Report New ecjpÞaMmYydUcxageRkamrYceRCIserIsGIVEdreyIgcg;)an.

- ]TahrN’

rYceRCIserIs Table Form Queries NamYyEdleyIgcg;)an OK



cMNaM eKGaceRbIrUbmnþedIm,IKNnaenAelI Report )anEdr. ehIykñúgkarsresrrUbmnþKNnaeyIgminRtUvsreesrkñúg tMbn;

Page Header or Page Footer eLIyeRBaHkñúgtMbn;enHeKeRbIsMrab;dak;elxTMB½r b¤kalbriecäT.eKGacsresrrUbmnþ

)ankñúgtMbn; (Section) Detail, Report Header/Footer, Group Header/Footer.



]TahrN_

salapasagnþrcati ilc 1 page - - wordpress.com¾rcati ilc 1page - -perpare by : ly.krim chrea ilc...

Documents