Icho chimwe chezvirongwa zvishoma zvinozivikanwa muMicrosoft 365 office suite, zvisinei nekubatanidzwa kubva muna 1992 shanduro. Muchinyorwa chino tinotsanangura Chii chinonzi Microsoft Access uye ndechei?.
Iyo yazvino vhezheni ye Microsoft Access, izvo zvatichataura nezvazvo pano, yakabudiswa muna Gumiguru 5, 2021 kuti ishandiswe mukati Windows 10 uye Windows 11. Izvi zvinotora pakati pe44 MB uye 60 MB pane hard drive, zvichienderana nesarudzo yekuisa yakasarudzwa.
Chii chinonzi Microsoft Access?
Microsoft iri a Dhatabhesi manejimendi system inosanganisirwa muMicrosoft Office suite yemaapplication (ikozvino Microsoft 365). Icho chishandiso chine chinangwa chekubatsira vashandisi kugadzira uye kubata dhatabhesi nechinangwa chekuchengetedza, kuronga uye kuongorora ruzivo.
Chikonzero nei ichi chishandiso chiri kushoma kushandiswa zvakanyanya nekuda kwekusaziva kukosha kwayo kwechokwadi. Vazhinji vashandisi vanotenda zvisirizvo kuti chero chinhu chakaitwa neAccess chinogona kuitwa neAccess. Excel
Kunyangwe chiri chokwadi kuti mapurogiramu ese ane mapoinzi akafanana, Excel inonyanya kukodzera kubata nhamba yedata uye kuita masvomhu pane iyo data. Access, kune chikamu chayo, inowedzera hukuru hukuru hwehunyanzvi uye inosanganisira chaiwo mabasa ekugadzirisa akasiyana marudzi e data. Mukuwedzera, inokubvumira kuti udzivise data iyo vashandisi vanopinda mumunda wega wega, pamwe nekubatanidza data yakabatana mumatafura akawanda.
Dhatabhesi dzakachengetwa neMicrosoft Access dzinoratidza faira rekuwedzera ".accdb". Kunyangwe izvi zviri izvo zvakajairika uye zvakare zvazvino, zvinokwanisika kuwana mamwe ekuwedzera (".mdbe" o ".mde"), iyo inoenderana neshanduro dzisati dzasvika 2007. Pane dzimwe nguva, kuvhura rudzi urwu rwekuwedzera, mushandisi anofanira kutanga ashandisa chishandiso chekushandura kuti chishandure ku «.accdb».
Zvinhu zvatingaite neAccess
Ungashandisa sei Access kubata dhatabhesi? Pazasi, tinotsanangura mamwe emabasa akajairika atinogona kuita nechokushandisa ichi.
Gadzira dhatabhesi
PaKupinda skrini yekumba, tinya "Faira" uye mune yesarudzo koramu kuruboshwe, sarudza "Itsva." Pakati pemasarudzo akasiyana anoratidzwa pachiratidziri, isu tinofanirwa kusarudza iyo yakanzi se "Blank Desktop Database".
Iyi ichangobva kugadzirwa dhatabhesi inogona kupihwa zita sedanho rekutanga kuwana iyo template nyowani uye wotanga kuishandisa.
Gadzira tafura
Kuti uwedzere tafura yedata kune dhatabhesi yatakagadzira, zvinodikanwa kuti uende kune ribhoni rekushandisa uye tinya pane tab. "Tafura". Minda yakawanda sezvatinoda inogona kuwedzerwa kune iyi tafura itsva. Kuti uite izvi unofanirwa kudzvanya kurudyi uye sarudza sarudzo "Tinya kuti uwedzere".
Chikamu chebhokisi checombo chinoshandiswa kunyora marudzi akasiyana-siyana e data anogona kugoverwa kumunda (mu Access inosungirwa kupa rudzi rwe data kumunda wega wega).
Wedzera data patafura
Kune nzira dzakawanda dzekuwedzera data kune tafura yeAccess: kushandisa fomu, kuipinza kubva kunze kwefaira, uchishandisa SQL, kana kuisa data zvakananga (kureva, nemaoko). Sarudzo yakajairika ndeye import nemafaira ".csv". Aya ndomaitiro aunozviita iwe:
- Paribhoni rezviridzwa, tinya pa "Data rekunze".
- Ipapo tinobaya pamusoro "Rugwaro faira".
- Zvadaro tinosarudza iyo faira yefaira uye tafura yekuenda.
- Tisati taenderera nekutumira, tinokwanisa kuongorora zvese zvefaira (kushandiswa kwenguva kana koma se delimiters, inoda kusiya mamwe minda.
- Pakupedzisira, tinodzvanya bhatani "Pedzisa" kumhanya kupinza.
Kubva pano, pane zviito zvakawanda zvatinogona kuita mukushandisa nematafura akasiyana atakaunza. Somuenzaniso, zvinobvira gadzira hukama pakati pematafura kubvunza data kubva kumatafura akasiyana. Iwe unogona zvakare kugadzira a tafura yekutarisa, iyo ine data inoratidzwa neimwe tafura, kana kutogadzira mibvunzo yakaoma pamatafura akawanda ane marudzi akasiyana e data.
Zvimwe zviito zvinogoneka ndezvi gadzira ma backups, gadzira dhatabhesi rinogoneka (izvo vashandisi vekunze havagone kugadzirisa) kugadzira macro to automate yakaoma mabasa kana Export data to Excel, pakati peimwe mikana yakawanda.
Kuita zvese izvi zviito, Microsoft Access inosanganisira inobatsira asistente iyo pasina mubvunzo inobatsira zvikuru kune avo vanoshandisa iyi application kekutanga.
Mhedziso
Microsoft Access isarudzo inokurudzirwa zvakanyanya kumabhizinesi madiki uye epakati-saizi anoda chishandiso chiri nyore uye chiri nyore kushandisa data management. Yakanakira mabasa akadai se ginventory management kana kuongorora chirongwa. Pazviitiko zvese izvi, zvakakosha kudzidza mashandisiro ayo.
Mharidzo inyanzvi mune tekinoroji uye internet nyaya ine anopfuura makore gumi echiitiko mune akasiyana dhijitari media. Ndakashanda semupepeti uye mugadziri wezvemukati we e-commerce, kutaurirana, online kushambadzira uye kushambadzira makambani. Ndanyorawo pane zvehupfumi, mari uye mamwe masekete mawebhusaiti. Basa rangu ndirowo shungu dzangu. Zvino, kuburikidza nezvinyorwa zvangu mu Tecnobits, Ndinoedza kuongorora nhau dzose nemikana mitsva iyo nyika yetekinoroji inotipa zuva rega rega kuvandudza hupenyu hwedu.