The Database muna Excel: kusika features, ivhu uye mazano

Excel riri simba mudziyo kuti anosanganisa kupfuura kubatsira uye dzinoshanda vanoshandisa mabasa. Izvi zvinosanganisira Graphics, matafura, machati, ndizvidavirire kugadzirira Masvomhu, kukarukureta kuti akasiyana-siyana, uye zvichingodaro. Tinodzidza kubva ino, sei kuti pave Database kuna Excel, nei zvichidikanwa, uye chii zano rinogona kutibatsira kufambisa basa rake.

Chii chinonzi Database?

Ichi chaiwo chivako, zvine uye kuunganidza ane ruzivo zvinhu zviri zvinangwa zvakasiyana. Zviri nyore, kutaridza chehurongwa uye vakaisa pamusoro echiShinto mashoko. Vanhu vangani vari kudzidza mukirasi, avo maitiro, misi yokuzvarwa neguhu kadhi - ichi zvose pamwe chete chinhu Database. Zvichidikanwa kwese - iri maindasitiri uye kwesayenzi emakambani, dzidzo uye zvokurapa masangano, Vezvemitemo uye kunyange Eenhede establishments. Zvechokwadi, pamazita madhishi dzavo yokuwana pamwe macalorie, uyewo tsanangudzo ariwo dzigare mairi ine mashoko.

Pano tinonzwisisa. Zvino iwe unofanira kuziva chii Database kuna Excel, uye sei kuti kusika nayo.

Kutanga date yokuchengetera muna Excel

Database akasikwa nesu, richava nyore uye pasina frills. midziyo izvi chete date - asi yainetsa uye vanomiririra hombe mashoko gadziriro ane "Musimboti" yomukati, iyo ine chimwe muzvizhinji kuti mitsetse romutemo rakanyorwa nyanzvi.

basa redu richava imwe tafura, izvo achava zvose zvakafanira mashoko. Tisati kutanga kugadzirisa mubvunzo sei kuti Database kuna Excel, unofanira kudzidza hwokugadzira mazwi kuti anoshandiswa kana kuwadzana naro.

Horizontal mitsetse ari markup jira "Excel" akadana zvinyorwa, uye kutwasuka mbiru - minda. Unogona kuwana kushanda. Vhurai chirongwa uye kuumba workbook idzva. Zvadaro, muzana rokutanga chaizvo mutsetse uchida kunyora mazita munda.

Cell Format Features

Zvinobatsira kudzidza zvakanaka kuuraya zviri musero. Kana yako Excel Database ichange iine chero mari, zviri nani kuratidza muminda zvakakodzera kusanganiswa zvinowanika umo mushure grade pfungwa uchaenda digits maviri. Uye kana paine zvakafanana musi, zvinokosha kusiyanisa nzvimbo ino, uye kuti asimbise rakakodzera Manyorerwo nokuti. Saka, mashoko ako zvose zvichabviswa kupatsanurwa nemazvo uye pasina zvikanganiso. akavhiyiwa zvose zvisina paminda chirongwa zvakaitwa kubudikidza akapoteredza menu "Format Masero."

Zvinokoshawo uye runoenzanirana akaitwa chirongwa ichi. Sheet, riri basa kusaina kudzivisa kuvhiringidzika. Kuti hurongwa kusiyanisa pakati nyore zviri headers uye zvikamu, zvinofanira dzinounzwa kwavari akatsveyamiswa, akasimbisa kana noushingi rugwaro, apo haana kukanganwa kuti kuisa zita kumunda vakaparadzana, kwete vasanganiswa. Zvakakosha kuita kuti kukwanisa kushandisa munowanika AutoForm uye AutoFilter.

Chii AutoForm mu "Excel" uye nei kudiwa?

Gadzira munhu Database kuna Excel - basa kwakaoma uye rakaoma. Kuti tibatsire anoishandisa kuti zviite basa, purogiramu ine kupa, zvinonzi zvaitika ichizadza masero zvakafanorongwa mashoko. Somuenzaniso, mbiru upamhi, mutsara urefu, Schriftgröße, Fonts mhando, ruvara munda, etc. - .. All mune rimwe watinya anogona kukuitira AutoForm, kana iwe kugadzira zvakanaka. Yakakodzera, handizvo here?

Kugadzira ari "chivharo" Database

Mukuwedzera, usakanganwa pamusoro asunga Mutsara wokutanga. In Excel 2007, zvinokwanisika kuti sezvinotevera: kuenda Tab "View", ipapo sarudza "Ndinoda Panes" uye tinya ari akapoteredza Muterere pamusoro "Isa musoro mutsetse." Izvi zvaida kuti kugadzirisa "chivharo" basa. Sezvo Excel Database inogona kunyatsonanga guru bhuku, kana scrolling uye pasi acharasikirwa huru mashoko - mazita minda, chiri zvakavaomera kuti user.

Kamwe pamusoro mutsetse wakaiswa, tinotaura mitsetse matatu okutanga munguva yemberi Database uye kuwedzera muchitokisi miganhu.

Kuenderera basa racho

Kuramba, unofanira kubuda mashoko zvinokosha, izvo zvichaita ane Database muna Excel. Example zvinonzi pasi apa.

Ngatitii tinoda kuumba Database Mari kubva vabereki kuchikoro Fund. Mari haisi shoma, uye yakasiyana neimwe munhu. Regai kirasi kudzidza vana 25, rinorevei, uye vabereki vachava runoenzanirana chitsama. Kuti varege rikaunganidza munhu Database hombe nhamba zvinyorwa, zvakafanira kuti donhwe-pasi mazita kuti kuvanza mashoko basa, uye kana zvinotarisirwa zvakare, ivo achibatsira kukutsigira zvakare.

How kusika munhu donhwe-pasi mazita?

Kutevedzera munda mazita uye achivabudisa pamusoro zvibereko jira, izvo zvivanakire Zvinokoshawo kutaura. Ngazvive Somuenzaniso, "Parents." Kana date iri kutevedzerwa, pasi pavo nyora mumasero chinhu zvose zvakafanira mashoko.

To MS Excel Database chinopa mukana kusarudza umboo kubva donhwe-pasi pasi, iwe unofanira asike chaiyo inonyatsoita. Kuti aite izvi, unofanira kuisa mashoko ose pamusoro vabereki zvakawanda netsika nemazita. Mberi kusvika jira, apo vose nemashoko akanyorwa pasi zita "Vabereki" uye akavhura hwindo chinokosha kusika munhu zita. Somuenzaniso, muna Excel 2007, unogona kuita izvozvo nekudzvanya pamusoro "Formula" uye nekudzvanya "Muzvitsaurire zita". Muzita Nhoroondo: FIO_roditelya_vybor. Asi chii kunyora zviri kuwanda tsika? Pano, zvinhu zvose zvikuru kuoma.

Kuwanda tsika mu Excel

Kune mhando inoverengeka neeSultan netsika. Range nako tinoshanda, isu vanonzi simba. Izvi zvinoreva kuti masero ose vanonzi vari Database angachinja nemiganhu yayo. changed yavo kunoitika zvichienderana neuwandu tsika mune imwe siyana.

Kuti tiwane simba siyana, zvakakosha kushandisa Kushaya fomura. It, zvisinei aiswa mibvunzo, anodzoka Munongedzo pakutanga mashoko. Mugore donhwe-pasi pasi, izvo zvinoitika pakupedzisira, asingadi kusangana null tsika. With ichi chete zvakakwana kuzvigona simba siyana. Ari kunorondedzerwa Coordonatele maviri muchitokisi; kumusoro kuruboshwe uye pasi kurudyi, sokunge uri diagonal. Saka, tinofanira kuteerera nzvimbo patafura yako unotanga, kana kuti, pamusoro Coordonatele foni pamusoro kuruboshwe. Regai hwendefa rinotanga achitandadza A5. kukosha ichi chichava rokumusoro rworuboshwe sero. Zvino kuti chokutanga kutsvaka chinhu chinowanikwa, endai wechipiri.

Sero rezasi rworudyi akatsunga nyaya yakadaro, nohupamhi uye kukwirira. Kukosha yokupedzisira ngazvive akaenzana 1, uye wokutanga payakavakirwa anoti SCHOT3 (Vabereki $ B $ 5 :! $ I $ 5).

Saka, muna nyora mumunda siyana = Kushaya (Parent $ A $ 5, 0, 0; COUNTA (Parent $ A :! $ A) -1;! 1). Achizviendesa OK bhatani. In zvose zvinotevera neeSultan kutangira A Kuchinja B, C uye zvichingodaro. D.

Anoshanda Database muna Excel ndiye anenge wakakwana. We kudzokera jira wokutanga nokusika anodonha-pasi mazita ari mabhokisi akakodzera. Kuti aite izvi, tinya chinhu sero (somuenzaniso B3), iri pasi munda "Zita vabereki." Kuchava kupindwa. Mu "Check chiyamuro tsika" iri Tab inonzi "Settings" nyora mu "Source" = FIO_roditelya_vybor. Mu "Data Type" Muterere iri "List".

Saizvozvowo isu mberi pamwechete neminda vasara, kuchinja zita panobva Data kuti unoenderana masero. Basa donhwe-pasi mazita ari kutopedza. Zvadaro sarudza Sero yechitatu uye "tatamuka" nayo mhiri tafura. The Database muna Excel ari vatogadzirira!

Kutarisika Database

Beautiful magadzirirwo unoitawo basa rinokosha pakasikwa racho. Excel Chirongwa anogona kupa anoishandisa kusarudza dzakasiyana-siyana kuti kugadzira kune Database. Kuwanda ruvara zvirongwa vakapfuma zvikuru, haufaniri chete sarudza yakakodzera coloring kwomweya. Uyezve, hazvina zvakakodzera kuita Database yose iyoyo manyorerwo, unogona pendi imwe mbiru yebhuruu, imwe - rwegirini, uye zvichingodaro ..

How uchatamisa imwe Database kubva Excel kuti Access

Excel kwete chete chete anogona kuita Database. Microsoft akaita akasunungura asi mumwe chigadzirwa anonyatsorayiridzwa dzinodzorwa pamwe ichi zvakaoma. Doma nayo - Access. Sezvo chirongwa ichi zvikuru dzakashandisa nokuumba Database kupfuura Excel, uye ipapo kushanda ichava nokukurumidza uye nyore zvikuru.

Asi sei kuita kudaro, kuti ndiwane Access Database? Excel kunoita kuti rokushandisa chido. Izvi zvinogona kuitwa nenzira dzakasiyana:

• Munogona kusarudza mashoko ose nenzira Excel pepa, kutevedzera uye kuibvisa kupinda imwe chirongwa. Kuti aite izvi, kusarudza mashoko uchida kutevedzera, uye tinya rworudyi mbeva bhatani. Achizviendesa "Copy" kubva chechinyorwa Muterere. Zvadaro chinja kuna Access, sarudza mashoko Tab "Table", boka "mufananidzo" uye vakachengeteka tinya bhatani "Mharidzo". Sarudzai nzira "Mode Table" uye dzinoisa mashoko kuburikidza nekudzvanya zvakarurama mbeva bhatani uye sarudza "namatidza".

• Unogona kutenga imwe pasi youduku .xls (.xlsx). Open Access, pre-kuvhara Excel. In zviripo, sarudza "Import", uye tinya aida shanduro chirongwa kubva yamuchakwanisa kutenga faira. Zvadaro tichiita "OK".

• Unogona kushamwaridzana Excel mafaira pamwe mabwendefa Access. Nokuti chinangwa ichi, "Eksele" zvakakodzera kusarudza zvakawanda masero ane zvakafanira ruzivo uye tinya kurudyi mbeva bhatani, sarudza zita kuwanda. Ponesai uye ndavhara Excel. Zarura "Access" Tab inonzi "Wana External Data", sarudza "tafura E-Excel" uye kupinda zita rayo. Zvadaro tinya chinhu inotarisira kuti tafura kusika kuti kubatana kusvika date kunobva uye tsanangurai zita rayo.

Ndizvo zvose. Shanda makagadzirira!