Access - menene wannan? Create a database a cikin Microsoft Access

Duk wani mai amfani da kwamfuta tsarin dangane da Windows ya sani cewa a cikin wani misali ofishin suite daga Microsoft wani version ya hada da wani musamman Access edita. Wannan shi ne abin da a shirin ne don aiki tare da shi a yanzu kuma za a dauke. Babu shakka, za a ba kawai da farko abubuwa kamar wani bayanin da cikakken duk fasali na aikace-aikace zai dauki fiye da daya shafi.

Mene ne Access?

Menene wannan shirin? Access - cikakken-featured tsarin for aiki tare da bayanai daga kowane irin dangane da zumunci model da ikon da kuzari musanya data tare da wasu aikace-aikace ko internet wallafe. Yana bayar da aikace-aikace bayanai sarrafa aiki da kai kayan aikin da wani irin, wanda aka wakilta, a wani ginannun form.

Bugu da kari, Access - wannan shi ne wani kunshin, wanda ya hada da goyon baya ga ActiveX controls, wanda muhimmanci kara da damar da shirin cikin sharuddan abin da shi za a iya amfani da su kawai a cikin alluna ko rubutu da aka gyara, amma kuma kafofin watsa labarai da kuma a kan Internet shafukan. Kafa a aikace-aikace na connection tsakanin database (DB) damar m tracking na canje-canje a cikin wani daga cikinsu tare da atomatik gyara na sigogi a cikin sauran.

Babban kwatance a cikin yin amfani da aikace-aikace

Unsurprisingly, Microsoft Access, a mafi yawan lokuta ake amfani da su da cikakken sanya aiki da kai kan aiwatar da bincike na wasu matakai a lissafin kudi, kasuwanci da kuma t. Q. Saboda duniya tsarin, da shirin zai iya kawar da zargin da ake kira data redundancy a lokacin da ake bukata don canja wani daya siga ba ta shigar da sabon, kuma a cikin karbuwa daga cikin tsofaffin, kuma dõmin canje-canje zai bayyana a duk hade database.

Alal misali, a cikin sha'anin tare da Access ajiye hanya na kaya, abokan ciniki da kuma ayyukan da a cikinsa suna da hannu. Daya siyar canji banki details. Isar da shi a database canza su kamar yadda atomatik gyara zai shafi sauran database. Data musayar za a yi, da kuma ba a gabatar da sabon tare da data kasance mãsu girmansu. Kuma wannan canji zai shafi wannan shafi ayyukan. Wannan shi ne, a wata hanya, mai amfani sami wani cikakken aiki da kai.

Haka ya shafi, misali, kaya iko. Lokacin da wani rukuni na dukiya sayar ta hanyar da ya dace rabo daga cikin sha'anin, da headings suna ta atomatik rubuta kashe a kayayyaki-tushen bayanai, wanda shi ne samuwa a kan request. Amma shi ne mafi sauki misalai. A gaskiya ma, cikin aikace-aikace na da nisa fiye da damar.

A tsarin da Microsoft Access

Amma saukaka, shi ne cimma godiya ga ainihin abubuwan, wanda taka muhimmiyar rawa a cikin bincike da kuma aiki na database data. Daga cikin babban abubuwa ne da wadannan:

• tebur - da kashi cewa Stores asali bayanai a wani takamaiman format (Tazarar, rubutu, graphics, da dai sauransu ...).
• request - a matsakaici na musayar related abubuwa, da sauran bayanai, ko na ɓangare na uku shirye-shirye;
• fom - biyayya da bayanai ko data a mai amfani-friendly form.
• Rahoton - nuna sarrafa sakamakon.
• Macro - executable kashi cewa ba su yi wasu ayyuka a taron na wani taron, ka ƙirƙiri wani tambaya, rahoton tsara;
• module - Kayayyakin Basic harshen siffofin to muhimmanci bunkasa ikon da shirin ta hanyar kafa hanyoyin da yin amfani da mahara ayyuka.

Sadarwa tare da wasu aikace-aikace da kuma na waje databases

Kamar yadda ya bayyana, Access - shi ne mai shirin cewa ba ka damar ba kawai amfani da nasu shigar daga mai amfani, amma kuma a haɗa su da juna. The yiwuwar aikace-aikace irin wannan cewa bayanai za a iya shigo da daga wasu aikace-aikace (FoxPro, Paradox, Excel, Word, da dai sauransu). Don rage wuya da wadannan hanyoyin, ba za ka iya shigo, kuma aboki, ba kawai da wadannan shirye-shirye, amma kuma tare da kafofin a wani cibiyar sadarwa yanayi, ko a kan Internet.

The sosai guda bonding tsari ne da za'ayi a kan tushen da buƙatun da irin aikin a matsayin SQL database (Access goyon bayan su, kuma).

Samar da wani database a kan tushen da shaci

A Access tebur ne babban kashi. A bayyanar, wannan bangaren ya yi kama da wani Excel, amma Samun damar ne yawa fadi, da kuma yadda za a yi aiki tare da wadannan abubuwa suna da nasu rarrabe fasali.

Duk da haka, don ƙirƙirar da kansa database a farawa iya zama quite sauki. Bayan bayyanar da barka da taga samar da mai amfani da zaɓi na shaci kan wanda nan gaba tsarin da database a matsayin wani tebur za a halitta. Wannan ake kira misali na Backstage. Ga za ka iya samun da saka guraben da kalmomin, wanda suna da amfani ga takamaiman ayyuka, ko je zuwa bincika a kan hukuma hanya na Microsoft, idan jerin babu wani daga cikinsu ba ya sadu da mai amfani da bukatun (ko da yake wannan ne mai wuya).

Da zarar ka zaɓi samfuri kana so ka ajiye a matsayin fayil, saka da wuri da kuma sunan, da kuma aikace-aikace ta atomatik samar da ya dace tebur tsarin.

A database daga karce

Idan mai amfani ba ya zo sai ya so ya yi a kan nasu database, ka ƙirƙiri wani sabon fayil a dace menu, zabi wani komai a database. A nan shi ne ya cancanci a duba wasu gazawa. Alal misali, da tebur database ba ya goyon bayan online wallafe, kuma yanar gizo databases ba su yi daidai da wasu gabata fasali.

Halicci wani na farko tebur, za ka iya ci gaba da tare da gabatarwar data. Lura cewa data za a iya shiga kawai a cikin m ginshikan da layuka. Har ila yau, ba su ƙara komai Kwayoyin tsakanin su bisa ga irin yadda aka yi a Excel. Bugu da kari, mafi muhimmanci yanayin ne cewa kowane shafi kamata dauke daya kawai type, wato, idan asali format shafi yin amfani da kwanan wata da lokaci bayanai da lissafin dangane da exponent shiga a cikin shafi ba za a gane. Saboda haka cewa yana yiwuwa ya shirya tebur kana bukatar shi ne a cikin wannan hangen zaman gaba. Domin sauƙi na amfani ba za ka iya amfani da musamman zane yanayin.

A nuances na data shigo da nuni zuwa ga wasu kafofin

A kan shigo da data ne zai yiwu a shirin ba musamman iyakance. Babban yanayin ne kawai da cewa shigo data kamata a rushe ta irin tebur (a Excel maƙunsar ko Word). Idan shigo da aka yi, misali, a wani rubutu embodiment na "Notepad" iya ƙirƙirar da irin wannan tsarin amfani da shafin key (Tab).

Za ka iya amfani da SharePoint lists da kuma mahada data for sauki aiki. Don yin wannan, yi amfani da wani musamman umuruinsa zuwa ga waje data tab, located a cikin rukuni na shigo da dauri. Yana offers shirye-sanya mafita (Excel, Word, da sauransu. D.). Lokacin da ka zaɓi za su ne kawai saka da wuri da ake so fayil, inda ka ajiye a cikin halin yanzu database, da kuma tabbatar da selection.

ƙarshe

Irin wannan Access aikace-aikace. A shirin ne sosai rare daga mai fadi da kewayon masu amfani, kamar yadda ta developers sun yi kokari kamar yadda zai yiwu mu hada a shi da yiwuwar wasu software na da irin wannan. Kuma wannan shi ne abin yi da aikace-aikace sosai m saita da kuma sanya aiki da kai da aikace-aikace na mafi ayyuka. Ya zauna a ƙara da cewa Access - wannan shi ne mai iko sosai ga kayan aiki da bayanan da aiki, ko da yake akwai aka dauke kawai da farko bayani game da aikace-aikace.