7/22/2019 Makalah Microsoft Access

1/31

i

Kmemcmn Idi @isusud Qdtue Kakaduni

Pulms Eachkphe

@isusud Hcan ?

EACHKRHE 1?

@\I MLQZPIDM (27=6=2==269)PVIDMD@M MKICIM (27=6=2==2:7)

@HZAD RAKFIKFIDL ?

@r. Eatmdl \iyhdh, Z.R`., K.R`.

RVHLVMK ZPQ@I RAD@I@IEMD GIZIEM

GMEQCPMZ EALQVQMD @MD ICKQ RAD@I@IEMD

QDIWAVZIPMZ ZVI\IOMYM

62=:/62=0

7/22/2019 Makalah Microsoft Access

2/31

i

EMPM RADLMDPMV

Ruoi `md syueur paducis pmdomtemd eanm`irmt Mccmn swt., emradm faremt

rmnkmt `md emrudim-Dym, paducis `mpmt kadyusud `md kadyacasmiemd kmemcmn idi

tmdpm m`mdym nmcmdlmd farmrti `mcmk prhsas padlarommddym sanidllm `mpmt

`isacasmiemd tapmt pm`m wmetudym. @mcmk nmc idi paducis kadlmkfic ou`uc

Kijrhshgt Mjjass `mcmk kmtm eucimn ehkputar `mcmk pakfacmomrmd gisiem.

M`mpud tuoumd pakfumtmd kmemcmn idi m`mcmn udtue kakaduni smcmn smtu tulms

sakastar : kmtm eucimn ehkputar `mcmk pakfacmomrmd gisiem.

Padtudym safmlmi kmnecue shsimc paducis ti`me fism kacmeuemd nmc eajic

idi sad`irimd tmdpm fmdtumd farfmlmi pinme. @adlmd itu paducis fmdyme

kadlujmpemd tarikm emsin eapm`m sakum pinme ymdl tacmn kakfmdtu `mcmk

prhsas pakfumtmd kmemcmn idi ymdl ti`me `mpmt `isafutemd smtu parsmtu, sajmrm

enusus paducis idlid kadymkpmiemd tarikm emsin eapm`m?

=) Fmpme @r.Eatmdl \iyhdh, Z.R`.,K.R`. sacmeu `hsad padlmsun kmtm eucimnehkputar `mcmk pakfacmomrmd gisiem5

6) Ea`um hrmdl tum emki ymdl tacmn kakfariemd fmdtumd sartm sadmdtimsmkakfariemd `hm rastudym, fmie sajmrm khric kmupud sajmrm kmtaric `mcmksatimp cmdlemn ea`apmddym5

:) Zacurun smnmfmt-smnmfmt emki tarjidtm eacumrlm fasmr @m`igis 62=6 ymdl sacmcukakfariemd `ueudlmd sartm sakmdlmt ymdl tme eadmc nadti. Cafin cmli, sacmcu

satim fmie `i smmt sadmdl kmupud susmn.

@adlmd salmcm earad`mnmd nmti paducis kadym`mri fmnwm kmemcmn idi

kmsin omun `mri sakpurdm, udtue itu paducis smdlmt kadlnmrmpemd eritie `md smrmd

`mri pmrm pakfmjm ymdl saeirmdym kakfmdlud sartm kadidlemtemd eumcitmskmemcmn idi. Ku`mn-ku`mnmd kmemcmn idi `mpmt farkmdgmmt fmli paducis, pm`m

enususdym `md ukukdym fmli sakum pinme ymdl kakfmjm kmemcmn idi.

Id`armcmym, =7 Hethfar 62=:

Radyusud

7/22/2019 Makalah Microsoft Access

3/31

ii

@MGPMV IZI

Nmcmkmd

EMPM RADLMDPMV ............................................................................ i

@MGPMV IZI .......................................................................................... ii

FMF I

RAD@MNQCQMD

=.= Cmtmr Facmemdl ...................................................................... =

=.6 Vukusmd Kmsmcmn ................................................................. =

=.: Puoumdb .................................................................................. =

FMF II

RAKFMNMZMD

6.= Radladmcmd Kijrhshgt Mjjass 622< ...................................... 6

6.6 Kakucmi Kijrhshgt Mjjass 622< .......................................... 6

6.: Ehkphdad Kijrhshgt Mjjass 622< ....................................... :

6.0 Kadutup Rrhlrmk Kijrhshgt Mjjass 622< ............................ >

6.1 Radlartimd Pmfac, Giac`, `md Vajhr` ..................................... >

6.7 Kakucmi Cakfmr Earom ......................................................... =2

6.< Rakfumtmd Pmfac ................................................................... =2

7/22/2019 Makalah Microsoft Access

4/31

ii

6.> Kakfumt Ghrk ...................................................................... =9

6.9 Kakh`igiemsi Ghrk (Rakfumtmd Nam`ar md Ghhtar) ........... 6=

6.=2 Rakfumtmd Vaphrt ............................................................... 66

6.== Kakh`igiemsi Vaphrt ........................................................... 60

FMF III

RADQPQR

:.= Easikpucmd ............................................................................ 67

@MGPMV RQZPMEM ............................................................................. 6

7/22/2019 Makalah Microsoft Access

5/31

=

FMF I

RAD@MNQCQMD

=.= Cmtmr Facmemdl

Kijrhshgt Mjjass karupmemd prhlrmk mpciemsi `mtmfmsa ymdl `iludmemd

udtue karmdjmdl, kakfumt `md kadlachcm `mtmfmsa sajmrm ku`mn `md japmt. Idi

`iemradmemd hcan eaku`mnmdym `mcmk padlhcmnmd farfmlmi oadis `mtmfmsa sartm

nmsic menir farupm cmphrmd `adlmd tmkpicmd `adlmd `asmid ymdl cafin kadmrie.

@mtmfmsa tar`iri `mri ? Pmfcas, Ghrks, Vaphrts. Kijrhshgt Mjjass 622< karupmemd

smcmn smtu padlhcmnmd @mtmFmsa ymdl jueup jmdllin. Kijrhshgt Mjjassm`mcmn

sumtu prhlrmk mpciemsi fmsis `mtm ehkputar racmsihdmc ymdl `iludmemd udtue

karmdjmdl, kakfumt `md kadlhcmn farfmlmi oadis `mtm `adlmd empmsitms ymdl

fasmr. @mtmfmsam`mcmn eukpucmd tmfac-tmfac ymdl smcidl faracmsi. Mdtmr tmfac

ymdl smtu `adlmd ymdl cmid smcidl faracmsi, sanidllm saridl `isafut fmsis `mtm

racmsihdmc. Vacmsi mdtmr tmfac `inufudlemd hcan sumtu eay, ymitu prikmry eay `md

ghraild eay.

=.6 Vukusmd Kmsmcmn

=. Mpm itu kijrhshgt Mjjass86. Mpm fmlimd-fmmlimd `mri Ks. Mjjass8:. Fmlmikmdm cmdlemn-cmdlemn earom Ks.Mjjass80. Mpm kmdgmmt Ks.Mjjass81. Fmlmikmdm jmrm kadlhprmsiemd Kijrhshgt Mjjass8

=.:Puoumd=. Kadladmc `md kakmnmki Ks.Mjjass.6. Kadlatmnui fmlimd-fmlimd Ks.Mjjass.:. Kadlatmnui cmdlemn-cmdlemn earom Ks.Mjjass.0. Kadlatmnui kmdgmmt Ks.Mjjass.1. Kadlatmnui jmrm kadlhprmsiemd kijrhshgt Mjjass

7/22/2019 Makalah Microsoft Access

6/31

6

FMF II

RAKFMNMZMD

6.=Radladmcmd Kijrhshgt MjjassKijrhshgt Mjjass m`mcmn sumtu prhlrmk /mpciemsi udtue @mtmfmsa kmdmlakadt

ymdl karupmemd fmlimd `mri Kijrhshgt Hggija, `adlmd farfmlmi eaku`mnmd

saparti padlmturmd `mtm, pakfumtmd ghrk, padymridl `mtm, `cc.

Kijrhshgt mjjass (mtmu Kijrhshgt Hggijajjass) m`mcmn safumn prhlrmk

mpciemsi fmsis `mtm ehkputar racmsihdmc `ituouemd udtue emcmdlmd rukmnmd `md

parusmnmmd eajic nidllm kadadlmn. Mpciemsi idi karupmemd mdllhtm `mri fafarmpm

mpciemsi Kijrhshgt Hggija, sacmid tadtudym Kijrhshgt \hr , Kijrhshgt Axjac, `md

Kijrhshgt RhwarRhidt.

Mpciemsi idi kadlludmemd kasid fmsis `mtm Kijrhshgt Oat @mtmfmsa Adlida,

`md oulm kadlludmemd tmkpicmd lrmgis ymdl idtuitig sanidllm kaku`mnemd

padlludm.

Kijrhshgt Mjjass `mpmt kadlludmemd `mtm ymdl `isikpmd `i `mcmk ghrkmt

KijrhshgtMjjass, Kijrhshgt Oat @mtmfmsa Adlida, Kijrhshgt Z]C Zarvar, Hrmjca

@mtmfmsa, mtmu sakum ehdtmidarfmsis `mtm ymdl kad`ueudl stmd`mr H@FJ.

6.6Kakucmi Kijrhshgt Mjjass 6222

Om`i ymdl `ikmesu` `adlmd giac`s m`mcmn mtrifut ymdl `ikiciei hcan sumtu tmfca.

Za`mdlemd Vajh`s m`mcmn isimd `mtm ymdl `ikiciei hcan tmfac.

EAPAVMDLMD ?

Giac` Dmka ? Gudlsidym udtue kakmsuemd dmkm- dmkm giac` `mri sumtu tmfca.

@mtm Pypa ? Oadis tipa `mtm ymdl `ieadmc pm`m Kijrhshgt Mjjass m`mcmn ?

Paxt Zarmdlemimd nurug, mdlem, spmsi `md tmd`m fmjm

Kakh Zarmdlemimd emtm ymdl smdlmt pmdomdl farupm` mtm jmkpurmd

mdtmrm nurug, spmsi `md tmd`m fmjm.

Dukfar @mtm farupm mdlem udtue parnitudlmd kmtakmtiem

@mtm/Pika @mtm Farupm tmdllmc `md wmetu

Jurradjy @mtm farupm dicmi kmtm umdl udtue parnitudlmd kmtakmtie

Muth Dukfar Ficmdlmd mtmu padakhrmd farmturmd sajmrm farurutmd

hthkmtis `md dicmidym ti`me `mpmt `irufmn

Yas/Dh @mtm kmsuemd ymdl farupm padymdlemcmd

HCA Hfoajt @iludmemd udtue aestardmc hfoae kismcdym lmkfmr, sumrm

`sf.

Nyparcide Lmfudlmd mri tae `md dukarij ymdl isikpmd `mcmk fadtue

tae `iludmemd udtue kadyikpmd phidtar ea situs waf

Chheup \izmr` Qdtue kakicin safumn dicmi `mri tmfca cmid mtmu cist fhx mtmu

jhkfh Fhx

Giac`s

7/22/2019 Makalah Microsoft Access

14/31

=2

@asjriptihd ?Eatarmdlmd ymdl memd kakparku`mn `mcmk kakmnmki giac`

dmka.

Rrikmry Eay ? Qdtue kadlnid`mri tarom`idym pakmsuemd mtm ymdl smkm/`hfacmtmu safmlmi giac` id`ax utmkm mtmu giac` eudji padlurutmd `mtm `mri

safumn tmfca.(Lmkfmr Eudji)

6.7Kakucmi Cakfmr Earom

Kakucmi cakfmr earom fmru `mri lattidl stmrta` `ipicin Fcmde @mtmfmsaGica

DmkaJramta

Jramta ? Qdtue Kakfuem oad`acm `heukad

.mjj`f? gica aestadsi Mjjass @mtmfmsa

6.< Rakfumtmd Pmfac

Zatacmn Fuem oad`acm prhlrmk(Jramta) sacmdoutdym eitm kakucmi `adlmd

kakfumt hfoajts Pmfac.

Rm`m kadu Pmf picin Jramta Pmfca @asild

7/22/2019 Makalah Microsoft Access

15/31

==

Zatacmngiac` dmka `md@mtm Pypa sasumi ghrkmt ymdl `iidlidemd `md fariemd

Rrikmry Eay sacmdoutdym `isikpmd(Zmva) kis? `mgtmr emrymwmd HE

m.

Kakfumt/kadjiptmemd tmfac KmstarPmfac Kmstar karupmemd tmfac ymdl parufmnmddym omrmdl `icmeuemd,

`adlmd emtm cmid prhsasidput, ufmn `md nmpus `mtm omrmdl tarom`i pm`m tmfac

kmstar.

@mcmk tmfac kmstar tar`mpmt (Rrikmry Eay)`iludmemd safmlmi eudji ymdl

`iludmemd udtue faracmsi `adlmd tmfac cmid ( tmfac Prmdsmesi ). Ymdl parcu `idlmt

m`mcmn dmkm tmfac `md dmkm giac` ti`me fhcan kadlmd`udl spmsi.

Jhdthn tmfac kmstar ? Fih`mtm Ziswm, @mtm Emrymwmd `md @mtm Luru.

Rm`m phsisi daw tmfca ( wid`hw partmkm satacmn pakfumtmd gica .k`f ),taemd Znhrtjut @asild Wiaw

Memd kudjuc wid`hw Zmva Ms ( ehkputar kakidtm kakmsuemd dmkmtmfac ymdl memd `ifumt )

Kmsuemd dmkm tmfac tfZiswm, eaku`imd taemd HE Zajmrm hthkmtis satimp emci pakfumtmd tmfac kadlludmemd Kijrhshgt

Mjjass 622< memd kudjuc giac` `adlmd dmkm I@ `md typa `mtmdym

MuthDukfar `md stmtusdym safmlmi Rrikmry Eay ( `itmd`mi `adlmd

eudji farwmrdm eudidl `i safacmn eiri dmkm giac` ).

7/22/2019 Makalah Microsoft Access

16/31

=6

Nmpus giac` tarsafut `md kmsuemd giac` `md typa `mtmdym.

Eaku`imd taemd thkfhc Pmfca Wiaw udtue eacumr `mri kadu@asild Wiaw,oiem m`m ehdgirkmsi udtue kadyikpmd `mtm, taemd YAZ

f. Kakfumt/kadjiptmemd tmfac PrmdsmesiPmfac Prmdsmesi karupmemd tmfac ymdl saridl `ipmemi ( m`m prhsas idput, ufmn

`md nmpus `mtm ) sajmrm rutid.

Jhdthn Pmfac Prmdsmesi m`mcmn @mtm Dicmi, @mtm ZRR `md @mtm Mfsadsi

h Paemd kadu Jramta 4 Pmfcah Rm`m phsisi daw tmfca ( wid`hw partmkm satacmn pakfumtmd gica .k`f ),

taemd Znhrtjut @asild Wiaw.

h emradm idi pakfumtmd tmfac trmdsmesi, kmem ti`me m`m Rrikmry Eay.Eaku`imd sikpmd `adlmd dmkm tfDicmi.

h

Kmsuemd giac` saparti lmkfmr `ifmwmn idi ?

7/22/2019 Makalah Microsoft Access

17/31

=:

j. RakfumtmdVacmtihdZnipsVacmtihdsnip karupmemd nufudlmd mdtmrm tmfac ymdl smtu `adlmd tmfac

cmiddym, `mcmk nmc idi tmfac kmstar `adlmd tmfac trmdsmesi. Ealudmmd `mri racmsi idi

`mcmn oiem tarom`i parufmnmd `i tmfac kmstar kmem nmsic parufmnmd tarsafut memd

kakpadlmrui tmfac ymdl faracmsi ( tmfac trmdsmesi ), kismcdym oiem sumtu dis pm`m

tmfac kmstar `i nmpus, kmem sakum `mtm pm`m tmfac

trmdsmesi memd ieut tarnmpus.

h Paemd kadu@mtmfmsa Phhc 4 Vacmtihdsnipsh Kmsuemd/tmkfmnemd sakum tmfac eatiem kudjuc wid`hw Znhw Pmfca,

eaku`imd taemd jchsa.

h Eaku`imd nufudlemd giac` `adlmd stmtus prikmry eay pm`m tmfac kmstarea giac` ymdl farsasumimd pm`m tmfac trmdsmesi U dik -4 dik [. Rm`m hptihd

racmsi picin sakum jnaje ymdl kadudouemd parufmnmd pm`m tmfac kmstar

memd farpadlmrun tarnm`mp tmfac trmdsmesi (jnaje idtalritms `mtm, ufmn `mtm

`md nmpus `mtm ). Eaku`imd taemd Jramta.

h Paemd Znhrtjut smva `md jchsa.

`. Radlisimd @mtmQdtue kakfuem tmfac jueup `adlmd jmrm `hufca jcije mtmu jcije emdmd hpad pm`m

dmkm tmfac.

h @mtm tmfac Kmstar

h @mtm tmfac Prmdsmesi

7/22/2019 Makalah Microsoft Access

18/31

=0

Rarcu `iparnmtiemd fmnwm, `mtm DIZ pm`m tfDicmi nmrus m`m `i tfZiswm, oiem `mtm

ymdl `ikmsuemd facuk m`m `i tfZiswm, kmem idput `mtm memd `ithcme. Nmc idi

tarom`i emradm m`mdym gudlsi idtalritms `mtm `mri racmtihdsnip.

a. Kakfumt ]uary]uary `mpmt kadmkpicemd `mtm `mri smtu tmfac kmupud lmfudlmd `mri fafarmpm

tmfac. Radmkpicmd `mtm oulm `mpmt `imtur `adlmd eritarim / gictar tartadtu, kismcdym

kadmkpicemd `mtm dicmi `adlmd rmdla tartadtu.

m. ]uary @mtm Dicmi Ziswm, ymdl kadjmeup fih`mtm siswm `md dicmi siswmh Paemd / picin kadu Jramta 4 ]uary @asild

h Kmsuemd sakum tmfac ( tmfac ymdl memd `ifumt quarydym )h Kmsuemd giac` ymdl m`m pm`m ehtme tmfac ea takpmt ymdl su`mn

`isa`imemd ( fmlimd fmwmn )

h Qdtue kakmsuemd giac` fism `adlmd jmrm `hufac jcije pm`m dmkm giac`mtmu `adlmd jcije `md `rml `mri ehtme tmfac ea ehtme ymdl su`mn

`isa`imemd

7/22/2019 Makalah Microsoft Access

19/31

=1

Eatarmdlmd ?

Giac` ? farisi dmkm giac` / ehchk

Pmfca ? farisi dmkm tmfac / quary

Zhrt ? kadlmtur oadis padlurutmd `mtm pm`m giac` ymdl farsmdleutmd, sajmrm `asj

mtmu msj

Znhw ? kadlmtur giac` tarsafut `itmkpicemd mtmu ti`me

Jritarim ? kadlmtur gictar, kismc udtue kadmkpicemd dicmi ymdl cafin fasmr `mri

7/22/2019 Makalah Microsoft Access

20/31

=7

h Rm`m giac` ymdl ehshdl, jcije emdmd 4 picin Fuic`

h Isiemd rukus ;4 OkcXDicmi?IRZ+KPE, taemd HE, fari tmd`m snhw,eaku`imd taemdsnhrtjut VQD.

7/22/2019 Makalah Microsoft Access

21/31

=

h Memd kudjuc sjript saparti lmkfmr `ifmwmn idi ?

m. Raridtmn Pmkfmn @mtm / Idsart

Ghrkmt ?IDZAVP IDPH UdmkmXtmfca[U(giac`=,giac`6,,giac`d)[

WMCQAZ(vmcua=,vmcua6,,vmcuad)5

*Jmtmtmd ?

Oiem kadlludmemd dmkm giac`, kmem mdtmrm oukcmn giac` ymdl `ijmdtukemdnmrus

smkm `adlmd oukcmn vmcuadym.

Eacafinmddym m`mcmn eitm `mpmt idput safmlmi `mtm, om`i nmdym fafarmpm

giac`.

Oiem tmdpm kadlludmemd dmkm giac`( satacmn dmkmXtmfac cmdlsudl vmcua ),kmem

oukcmn vmcua ymdl `ikmsuemd nmrus smkm `adlmd oukcmn giac` pm`m tmfac

ymdl farsmdleutmd.

Jhdthn =?

7/22/2019 Makalah Microsoft Access

23/31

=9

IDZAVP IDPH tfsiswm(DIZ,Dmkm) WMCQAZ(2:,JyfarJmt_hda)5

Jhdthn 6?

IDZAVP IDPH tfsiswm WMCQAZ(20,JJ_,@myauncunur

Jicmjmp,Jicmjmp,#21#)5

f. Raridtmn Nmpus @mtm/ @acata

Ghrkmt ?@ACAPA GVHK UdmkmXtmfac[ \NAVA Uehd`isi[5

Jhdthn ?

@ACAPA GVHK tfsiswm \NAVA DIK;265

Mrtidym kadlnmpus `mtm siswm ymdl kakpudymi DIK;26. Oiem memd kadlnmpus

sakum `mtm, `adlmd kadlnicmdlemd \NAVA Uehd`isi[5

j. Raridtmn Qfmn @mtm/ Qp`mta

Ghrkmt ? QR@MPA Udmkm[ ZAP Ugiac`=[;Uvmcua=[,Ugiac`6[;Uvmcua6[ \NAVA

Uehd`isi[

Jhdthn ?

QR@MPA tfsiswm sat Mcmkmt;Raud`auy VP21/29,PakpmtXCmnir;JCR

\NAVA DIK;2:5

Mrtidym memd kadlufmn `mtm `adlmd DIK;2:, `md parufmnmd `icmeuemd pm`m

giac` mcmkmt `md takpmt cmnir. Oiem memd kadlufmn sakum `mtm `adlmd `mtm ymdl

smkm, nicmdlemd fmlimd \NAVA Uehd`isi[

6.> Kakfumt Ghrk

Qdtue kadlnmsicemd tmkpicmd ymdl cafin eukudiemtig, kmem `ifutunemd sumtu

idtargmja ymdl `mpmt kakfmdtu padlludm mtmu hparmthr `mcmk kadomcmdemd sumtuprhlrmk mpciemsi, smcmn smtudym m`mcmn ghrk. Qdtue kakfumt ghrk hthkmtis

jmrmdym smdlmt ku`mn emradm giac` ymdl `iludmemd sakum ymdl m`m pm`m Pmfac

safmlmi sukfar `mtmdym.

7/22/2019 Makalah Microsoft Access

24/31

62

Rm`m kadu Pmf picin Jramta Khra GhrksGhrk \izmr`

Qdtue kakid`mnemd sakum giac` picin 44

Eaku`imd Daxt sacmdoutdym picin Cmyhut ghrk Kismc? JhcukdmrDaxt

Zacmdoutdym picin Ztyca ghrkDaxt `md isiemd titca udtue ghrk kismc ?

@mgtmr emrymwmdGidisn

7/22/2019 Makalah Microsoft Access

25/31

6=

Phkfhc Dmvilmsi pm`m Ghrk \izmr`

Phkfhc 4udtue kakmsuemd giac` `mri ehchk Mvmicmfca Giac`sea`mcmk ehchk Zacajta` Giac`ssmtu parsmtu

Phkfhc 44udtue kakmsuemd giac` `mri ehchk Mvmicmfca Giac`sea`mcmk ehchk Zacajta` Giac`ssajmrm farsmkmmd

Phkfhc 3 udtue kadlakfmciemd giac` `mri ehchk Zacajta` Giac`sea`mcmk ehchk Mvmicmfca Giac`ssmtu parsmtu

Phkfhc 33udtue kadlakfmciemd giac` `mri ehchk Zacajta` Giac`sea`mcmk ehchk Mvmicmfca Giac`ssajmrm farsmkmmd

6.9Kakh`igiemsi Ghrk (Rakfumtmd Nam`ar md` Ghhtar)Rakfumtmd ghrk `adlmd kadlludmemd gmsicitms wizmr` tmkpicmdym eurmdl

sasumi `adlmd ymdl `ieanad`mei. Md`m `mpmt kad`asmidym `md kadlmtur sad`iri

sasumi eaidlidmd. Mtmu `mpmt oulm md`m kadmkfmnemd Nam`ar, ghhtar,ikmla,

kadllmdti wmrdm fmjelrhud`, ghdt. @md udtue kad`asmid ghrk md`m `mpmt

ludmemd smcmn smtu oad`acm tmkpicmd ymitu ? NhkaWiaw?

Ghrk Wiaw ? Qdtue kadlisi `md kacinmt tmkpicmd ghrk ymdl tacmn

`ikh`igiemsi

Cmyhut Wiaw ? Qdtue kakh`igiemsi `md kacmeuemd parufmnmd pm`m

ghrk.

@asild Wiaw ? Kakfariemd tmkpicmd `atmic `mri struetur ghrk. Md`m

`mpmt kacinmt fmlimd Nam`ar, @atmic, `md Ghhtar. Oulm fism

kadmkfmnemd,Cmfac, Lmris , Ikmla, parsali pmdomdl `md

cmiddym.

7/22/2019 Makalah Microsoft Access

26/31

66

Chlh ?karupmemd jhdtrhc ymdl fargudlsi udtue kadmkpudl hfoae

lmkfmr ymdl tarcatme pm`m fmlimd Ghrk Nam`ar.

Mm Cmfac ? gudlsidym nmkpir smkm `adlmd Pitca nmdym smom padakpmtmd

cmfac `mpmt `isakfmrmdl takpmt mram ghrk.

6.=2 Rakfumtmd VaphrtVaphrt `mpmt `imrtiemd `adlmd safumn emtm? cmphrmd. Vaphrt karupmemd smcmn

smtugudlsi pm`m Kijrhshgt Mjjass ymdl farludm udtue kakfmdtu eitm kakfumt

cmphrmdkadladmi `mtm`mtm ymdl m`m `mcmk `mtmfmsa eitm. Zafmlmi jhdthn, eitm

`mpmtkadlludmemd raphrt udtue kakfumt cmphrmd trmdsmesi pm`m safumn theh

(pakfacimd`md padoumcmd), cmphrmd `mtm palmwmi safumn parusmnmmd, cmphrmd

sthje `md stmtusfmrmdl pm`m sumtu lu`mdl, `md cmidcmid.Vaphrt mtmu cmphrmd

karupmemd fadtue hcmnmd `mtm ymdl `i`asmid udtue `ijatme ea ka`im jatme mtmu

pridtar. Mjjass kaku`mnemd paearommd pakfumtmd cmphrmd emradm kadya`imemd

gmsicitms Vaghrt \izmr` ymdl kmkpu iludmemd udtue karmdjmdl farfmlmi fadtue

Vaphrt. Md`m `mpmt kadmkpicemd sakum giac` `md rajhr` `mri safumn tmfca, ghrk

ymdl tacmn `iisi sartm kakh`igiemsi cmphrmd pm`m oad`acm Cmyhut `md @asild

Wiaw.

Vaphrt \izmr` `iludmemd sukfar `mtm `mri tmfca `md ghrk ymdl tacmn `ifumt.

Cmdlemn earomdym ecie JramtaVaphrt \izmr` sanidllm memd tmkpic ehtme

`imchl raphrt wizmr`partmkm.Ludmemd thkfhc dmvilmsi ymdl m`m udtue

kakid`mnemd phsisi dmkm giac` `mri ehchkMvmicmfca Giac`sea ehchk Zacajta`

Giac`s(jmrmdym saparti pakfumtmd Ghrk).Ecie Daxtudtue kacmdouemd prhsas.

Md`m `ikidtm udtue kadadtuemd dmkm giac` tartadtu ymdl `mpmt `iludmemd

safmlmi eudji padlachkphemd udtue nmsic raphrt ymdl `iidlidemd.

7/22/2019 Makalah Microsoft Access

27/31

6:

Ecie Daxt udtue kacmdoutemd Rrhsas. Rm`m ehtme idi md`m `ikidtm udtue

kadadtuemd dmkm giac` ymdl `mpmt `iludmemd safmlmi eudji padlurutmd udtue

kmsidlkmsidl lrhup udtue raphrt. Rhcm padlurutmd sajmrm Msjad`idl(kadmie)

`md @asjad`idl(kadurud)

Ecie Daxt udtue kakicin phcm mtmu fadtue tmkpicmd raphrt pm`m fmlimd cmyhut

`adlmd farfmlmi picinmd Rhrtrmit (nmcmkmd eartms talme) `md Cmd`sjmpa (eartms

kad`mtmr)

Rm`m ehtme wizmr` tadtuemd smcmn smtu dmkm styca udtue raphrt, Ecie thkfhc Daxt.

7/22/2019 Makalah Microsoft Access

28/31

60

Zacmdoutdym md`m `ikidtm kakfariemd dmkm titca udtue raphrt. Zajmrm `agmuct

dmkm raphrt memd `ismkmemd `adlmd dmkm tmfca mtmu ghrk safmlmi sukfar `mtm

pakfumtmd raphrt.Md`m `mpmt kadllmdti dmkm raphrt ymdl cafin ehkudiemtig `md

ku`mn udtue `iidlmt.Zatacmn itu Ecie Gidisn udtue kadlmeniri pakfumtmd raphrt

`md cmphrmd ymdl tacmn tarfadtue pm`m lmkfmr `ifmwmn idi?

Rarjhfmmd ymdl fmru smom eitm cmeuemd m`mcmn kakfumt raphrts `ikmdm Kijrhshgt

Mjjass sajmrm hthkmtis kad-ladarmta raphrt `aki eaku`mnmd `md eadymkmdmd

pakmemidym. Isi `mri raphrts tarsafut m`mcmn sakum giac` ymdl tar`mpmt pm`m tmfca

Akpchyaas. Oiem eitm ti`me pums `adlmd tmkpicmd raphrt ymdl smdlmt sa`arnmdm

tarsafut, eitm `mpmt kacmeuemd fafarmpm mesi ymdl `mpmt kakparjmdtie `md

kakparid`mn cmphrmd eitm.

6.== Kakh`igiemsi VaphrtKakh`igiemsi raphrt smkm `adlmd kakh`igiemsi Ghrk ymitu ?pm`m struetur

Vaphrt(Nam`ar, @atmic, Ghhtar) `adlmd jmrm NhkaWiaw?

Vaphrt Wiaw ? Fargudlsi udtue kacinmt tmkpicmd raphrt ymdl tacmn `iisi`md `ikh`igiemsi.

7/22/2019 Makalah Microsoft Access

29/31

61

Rridt Rraviaw? Fargudlsi udtue kacinmt fmtms padjatmemd `heukad Cmyhut Wiaw ? Qdtue kacmeuemd parufmnmd pm`m Vaphrt @asild Wiaw ?Qdtue kakh`igiemsi Vaphrt(Nam`ar, Ghhtar, wmrdm, ikmla

`md cmidym.

Radlisimd (idput `mtm) `md parufmnmd `mtm nmdym `mpmt `icmeuemd pm`m Ghrk ymdl

tacmn `ifumt.

7/22/2019 Makalah Microsoft Access

30/31

67

FMF III

RADQPQR

=.=EasikpucmdKijrhshgt Mjjass m`mcmn sumtu prhlrmk mpciemsi fmsis `mtm ehkputar

racmsihdmc ymdl `iludmemd udtue karmdjmdl, kakfumt `md kadlhcmn farfmlmi

oadis `mtm `adlmd empmsitms ymdl fasmr.

Kijrhshgt Mjjass smdlmt kakfmdtu eitm `mcmk padlhcmnmd `mtm fmie `ifi`mdl fisdis kmupud pad`i`iemd. Eitm fism kadlachkpheemd, kadlurutemd sartm

kadlhcmn sumtu `mtm tadtmdl pakmsuemd eaumdlmd sartm `mtm emrymwmd sumtu

parusmnmmd, mtmu eitm `mpmt kakfumt sumtu `mgtmr kmnmsiswm pm`m sumtu

parlurumd tidlli, ymdl farisi i`adtitms kmnmsiswm `md dicmi mem`akiedym.

M`mpud fmlimd-fmlimd Kijrhshgt Mjjass, imcmn Pmfac, ]uary, Ghrk, Vaphrt,

Kmjrh, `md Zwitjnfhmr`.

7/22/2019 Makalah Microsoft Access

31/31

@MGPMV RQZPMEM

nttp?//afhhefrhwsaa.dat/kmdgmmt-ks-whr`-axjac-`md-mjjass-`mcmk-`udim-

pad`i`iemd-p`g-`: