Concepts Jikelele database Access

impucuko Modern ikwimfuno ukwenzelwa Ukuphathwa rhoqo nokugcina esininzi data ezahlukeneyo. Kwakhona, kukho imfuneko esweni rhoqo iimpembelelo zotshintsho zabo kwezinye iifayile ulwazi. Eyona ndlela iluncedo kuququzelela zonke ezi nkqubo kwi ngendlela ledatha. Isixhobo ezisebenzisekayo zokusetyenziswa umbutho inokuba esithandwayo inkqubo database Access.

Yintoni a DBMS

data ezahlukeneyo athathwe yaye igcinwe ngendlela tabular. Kudla ukuba neetafile ezimbalwa ziqulathe ulwazi olunxulumene omnye komnye ngandlela ithile. Zizo zonke ezi thebhile ezalanayo kuyinto database.

Ukuze ube nako ukulawula ngokupheleleyo data evela kwiziko ledatha, kufuneka kwakhona enze imibuzo. Ukwenzela ukuba kube lula ukuba ukuzaliswa kokuqala iinkcukacha ezigcinwayo, ngokuqhelekileyo ukusebenzisa iifomu nesilungiselelwe ngokukodwa. Zokusebenzisa inkqubo kufuneka usebenzise Ukongezelela imacros zesikocan kwezinye iimeko. Nokuqokelelwa zolwazi kunye nezinye izixhobo yenza inkqubo ebizwa ngokuba DBMS - yolawulo loseto ledatha. Umzekelo ingaba Foxpro, Oracle, ledatha Microsoft Access.

Eyona engundoqo Imisebenzi DBMS

Access DBMS yenza le misebenzi ibalulekileyo ilandelayo:

- ukuphumeza amanyathelo ayimfuneko data kunye neefomula;

- ekumiseni unxulumano phakathi iitafile kunye iiseti data;

- ukukwazi ukudibanisa izicelo.

Zonke izixhobo, nto leyo efumaneka kwiziko ledatha MS Access arsenal, eyenzelwe ukuba ukukhonza ngokupheleleyo iindlela ezimbini eziphambili kwinkqubo ulwazi. Lo uyilo mbutho kanye ukuguqulwa ngesakhiwo ledatha kunye zazo iinkcukacha eziyimfuneko ezahlukeneyo.

Umahluko omkhulu Database Access

nezinye iindlela zolawulo ezininzi ezisetyenziswa badwelisi benkqubo zokusebenzisa umsebenzi kunye iinkcukacha, ledatha Access lula ukufunda. Ekubeni le platform Russified, kwakunye umgangatho wawo onke interface MS Office, nokuba abasebenzisi ongenamava aliyi kuba waziva ngexesha kweenkqubo zayo zophuhliso.

Kwangaxeshanye, Access iiseti data yolawulo inkqubo epheleleyo nazo zonke iimpawu eziyimfuneko. Yila inkqubo zingasetyenziswa kuphela kwinto enye khompyutha, koko uthungelwano lwasekuhlaleni.

amathuba Access

Le program ivumela ukuba ukwenza izinto original ngohlobo neetafile kunye namasimi kweentlobo ezahlukeneyo, ezifana amanani, itekisi, imizobo, nkqu emasimini ole.

Ngaphezu koko, ulwalamano phakathi iitafile inikezelwe, apho ehla inkxaso uhlaziyo data kunye ayo ukucima xa kuyimfuneko.

Yonke imisebenzi data ezisisiseko ezifana bengena, ukubukela, ukugcina, ukuhlaziya, ukuhlela, ukuhluza, ukufumana iisampulu. Kwakhona Indexing eyenziwa kwiinkalo ezikhethiweyo, uyifakile ingcaciso yolawulo.

Xa kugcwaliswa ukubalwa amasimi zingasetyenziswa usebenzisa ifomula ezahlukeneyo.

Database Access - inkqubo lula noluqondakalayo oko zonke iimpawu ezi zicelo abaziingcali.