Excel Data Entry Form

Nhanho-nhanho mirayiridzo yekupinda dheta

Kushandisa Excel yakavakwa mufomu yekupinda kwedhizha inzira inokurumidza uye iri nyore yekuisa deta muDesecent database .

Kushandisa fomu kukubvumira kuti:

• tanga tafura yezvinyorwa zvitsva kana kuwedzera zvinyorwa zvitsva kune imwe iripo
• pfugama nemanhoroondo epa data imwe panguva
• tsvaga zvinyorwa zvine mashoko chaiwo
• kuronga kana kuvhara marekodhi ega seanoda

Nezve Kuwedzera Dhipatimendi Rokupinda Fomu Icon ku Quick Access Toolbar

Iko fomu yekupinda kwedhidha imwe yeExcel yakagadzirwa-in data tools. Kuti uishandise zvose zvaunoda kuita ndeyokupa iyo misoro yehurukuro inoshandiswa mune yako database, chengeta paFomu icon, uye Excel ichaita zvese.

Kuita kuti zvinhu zvive zvakaoma, zvakadaro, kubva paExcel 2007, Microsoft yakasarudza kusaisa Fomu icon paibhoni.

Nhanho yekutanga yekushandisa fomu yekupinda kwedhadha kuwedzera Fomu icon ku Quick Access Toolbar kuitira kuti tigone kuishandisa.

Iyi ibasa rimwe chete. Kana wawedzerwa, Fomu icon inogara iripo pa Quick Access Toolbar.

Kutsvaga Bhuku reDhipatimendi Rokupinda Dhiyabhorosi

The Quick Access Toolbar inoshandiswa kuchengetedza zvidzitiro zvinowanzoshandiswa muExcel. Icho ndipo pane iwe unogona kuwedzera zvitsvaga kuExcel zvinhu zvisingawaniki pabhoni.

Chimwe chezvinhu izvi ndeye fomu yekupinda kwedhesi.

Fomu ye data ndiyo nzira inokurumidza uye iri nyore yekuwedzera deta kune tafura yeDeccel database.

Nechimwe chikonzero, zvisinei, Microsoft yakasarudza kusawedzera fomu kune imwe yemaabbi edhibhoni anotanga neExcel 2007.

Pasi pane matanho achakuratidza kuti ungawedzera sei Fomu icon ku Quick Access Toolbar.

Wedzera Fomu yeData ku Quick Access Toolbar

1. Dzvanya pasi pasi pemiseve panoperera Quick Access Toolbar kuti uzarure mhando yezvinyorwa.
2. Sarudza Mitemo Yakawanda kubva pakurongwa kuti uzarure Chengetedza Quick Access Toolbar dialog box .
3. Dzvanya pasi pasi pemiseve pamugumo weSarudza mirairo kubva kune mutsara kuti uzarure mhando yekunyorera.
4. Sarudza Mitemo Yese kubva pakurongwa kuti uone mirairo yose inowanikwa muExcel 2007 muruboshwe-pane pane.
5. Dhavhima kuburikidza netsamba iyi yepafabheti kuti uwane Fomu murairo.
6. Dzvanya paIndaneti bhokisi pakati pemirairo yepamusoro kuti uwedzere Fomu murairo ku Quick Access Toolbar.
7. Dzvanya OK .

Fomu yeFomu inofanira kuwedzerwa zvino ku Quick Access Toolbar.

Kuwedzera Database Database Mazita

Sezvambotaurwa, zvose zvatinofanira kuita kuti tishandise fomu yekupinda kwekutsvaga muExcel ndeyokupa mutsara wemisoro kana mazita mazita kuti ashandiswe mu database yedu.

Nzira iyo iri nyore yekuwedzera mazita emunda kune fomu ndeyokuti uaisire mumasero mupaji rako remabasa. Iwe unogona kusanganisira kusvika kumasita makumi maviri emumunda mufomu.

Pinda misoro inotevera mumasero A1 kusvika E1:

StudentID
Zita rokupedzisira
Pakutanga
Age
Purogiramu

Kuvhura Dhipatimendi Rokupinda Data

Kuvhura Dhipatimendi Rokupinda Data

1. Dzvanya pane sero A2 kuti uite sero rinoshanda .
2. Dzvanya pamufananidzo wefomu wakawedzerwa ku Quick Access Toolbar pane peji 2.
3. Kushandura mufananidzo yefomu kuchaunza bhokisi remashoko kubva kuExcel ine zvimwe zvingasarudzwa zvine chokuita nekuwedzera misoro kune fomu.
4. Sezvo tatove takanyora mumasita emumunda watinoda kushandisa semusoro wezvose zvatinofanira kuita ndezvokusarudza OK mubhokisi remashoko.
5. Fomu ine mazita ose emunda inofanira kuonekwa pachikona.

Kuwedzera Data Records neFomu

Kuwedzera Data Records neFomu

Kamwe kana zvinyorwa zvekutsvaga zvave zvichiwedzerwa kune fomu kuwedzera zvinyorwa kune database zvinongova nyaya yekunyora munharaunda mune zvakakonzerwa mumamiriro ekuma.

Muenzaniso Marenda

Wedzera zvinyorwa zvinotevera kune dhesiyo kuburikidza nekuisa deta mumasimi masimba pedyo nemusoro wakakodzera. Dzvanya paNew bouton mushure mokupinda mu rekodhi yekutanga kuitira kuti usvike minda yekodhi repiri.

1. Mudzidzisi : SA267-567
   Zita rekupedzisira : Jones
   Pakutanga : B.
   Zera : 21
   Purogiramu : Mitauro
   
   MudzidzisiID : SA267-211
   Zita rekupedzisira : Williams
   Pakutanga : J.
   Zera : 19
   Purogiramu : Sayenzi

Zano: Paunopinda dhiyabhorosi yakafanana zvakadai sedhijiti dzeAdhi dzevadzidzi (chete nhamba mushure mokunge dash yakasiyana) shandisa kopi uye unamate kuti uwedzere uye uite nyore kupinda.

Kuti uwedzere zvinyorwa zvakasara kune dhesi rekudzidzisa, shandisa iyo fomu kupinda mune imwe nzvimbo yedata yakawanikwa mumufananidzo uri pamusoro pemasero A4 kusvika E11.

Kuwedzera Data Records neFomu (con't)

Kuti uwedzere zvinyorwa zvakasara kune dhesi rekudzidzisa, shandisa fomu kuisa mamwe ose e data akawanikwa mumufananidzo pano mumasero A4 kusvika E11.

Kushandisa Form's Data Tools

Dambudziko guru rine database rakachengetedza kuvimbika kwedheta sezvo faira inokura muhukuru. Izvi zvinoda:

• Kugadzirisa zvikanganiso zvepa data kana kuvandudza marekodhi evanhu.
• kubvisa zvisiri zvekare kana kudhinda zvinyorwa.

Iyo fomu yekupinda yedhiyo ine zvigadzirwa zvakasiyana-siyana parutivi rworudyi-rutivi runoita kuti zvive nyore kuwana nekugadzirisa kana kubvisa zvinyorwa kubva pane dhesi.

Zvishandiso izvi ndezvi:

• Iyo Tsvaga Tsvaga uye Tsvaga Bhatani Zvitsva - izvi zvinokubvumira kuti upfuurire mberi uye kudzoka kuburikidza ne database imwe rekodi panguva imwe.
• Kubvisa bhodhi - iyi inoshandiswa kuvhara marekodhi kubva kune database.
• Bhodha Yodzorera - Iyi bhatinhi inogona kushandiswa kugadzirisa kushanduka kune rekodhi iri kuchinjwa. Dzimwe nguva, tinoita shanduko dzisina kunaka kune rekodhi kana kunyora zvinyorwa zvisina kururama zvachose. Kana zvakadaro, bhodhi rekudzorera rinogona kushandiswa kugadzirisa kuchinja ikoko.
• Cherechedza: Bhodhi redzorera inoshanda chete chero bedzi rekodhi iripo mufananidzo. Kana uchangosvika kune imwe rekodhi kana kuvhara fomu, bhodhi rekudzorera inenge isina kushanda.
• Bhokisi reCriter rinokubvumira kutsvaga dhesi yezvinyorwa zvichibva pane zvido zvakananga, zvakadai sezita, makore, kana chirongwa. Muenzaniso wekushandisa bhodhi yeCriteria inowanikwa mune danho rinotevera rekudzidzisa.

Kutsvaga Mareji Achishandisa Rimwe Munda Wezita

Bhokisi reCriter rinokubvumira kutsvaga dheseti yezvinyorwa uchishandisa rimwe kana mamwe mazita emunda, zvakadai sezita, zera, kana chirongwa.

Kutsvaga Mareji Achishandisa Rimwe Munda Wezita

1. Dzvanya paBhitirano yeCriteria mune fomu.
2. Kushandura bhodhi reCriteria kunotsvaga mafomu ose asi asi haibvisi chero data kubva kune database.
3. Dzvanya paPurogiramu yepaIndaneti uye tonga Chirongwa sezvo tichida kutsvaga vese vadzidzi vakanyoresa purogiramu yeBhizinesi pajiji.
4. Dzvanya pane Tsvaga Bhokisi Rinotevera . Nhoroondo yeHh Thompson inofanira kuonekwa nenzira iyo yakanyoresa purogiramu yeArt.
5. Dzvanya pa Tsvaga Tsvaga Yechipiri chechipiri uye yechitatu uye zvinyorwa zveJ. Graham naWilliam Henderson vanofanira kuonekwa mumwe mushure mokunge vakanyoresa purogiramu yeArt.

Danho rinotevera rekudzidzisa iyi rinosanganisira muenzaniso wekutsvaga marekodhi anowirirana maitiro akawanda.

Kutsvaga Mareji Achishandisa Multiple Field Names

Mumuenzaniso uyu tichatsvaga vadzidzi vose vane makore gumi nematanhatu uye vakanyoresa purogiramu yeBhizinesi pajiji. Izvo chete zvinyorwa zvinofanidza zvose zvinogadziriswa zvinofanira kuratirwa mufomu.

1. Dzvanya bhatani reCriteria mune fomu.
2. Dzvanya munda wezera uye faira 18.
3. Dzvanya muPurogiramu munda uye faira zveArt.
4. Dzvanyira Tsvaga Bhokisi Rinotevera . Nhoroondo yeHh Thompson inofanira kuonekwa muchimiro kubvira iye ava nemakore gumi nemasere uye akanyoresa purogiramu yeArt.
5. Dzvanyira Tsvaga Tsvaga Kechipiri kechipiri uye nhoroondo yeJ. Graham inofanira kuonekwa sezvo iyewo ava nemakore gumi nemana makumi mapfumbamwe uye vakanyoresa purogiramu yeArt.
6. Dzvanyira Tsvaga Bhokisi Rinozotevera kechipiri uye rondedzero yeJ. Graham inofanira kunge ichiri kuonekwa sezvo pasina imwe marekodhi anowirirana nematambudziko ose.

Nhoroondo yeW W. Henderson haifaniri kuratidzwa mumuenzaniso uyu nokuti, kunyange zvazvo akanyoresa purogiramu yeBhizinesi, haasi nemakore gumi nemasere saka haafanisi zvose zvitsva zvinotsvaga.