Excel 2003 Form Entry Form

01 ye 08

Kushandisa Form for Data Entry mu Excel

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 kana zvichidiwa

Ona mazano akafanana: Excel 2010/2007 Data Entry Form .

02 of 08

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

03 of 08

Kuvhura Dhipatimendi Rokupinda Data

Cherechedza: Kubatsirwa nemuenzaniso uyu, ona mufananidzo uri pamusoro.

1. Dzvanya pane sero A2 kuti uite sero rinoshanda .
2. Dzvanya paData> Fomu muma menus.
3. Kuzarura fomu kutanga kuunza bhokisi remashoko kubva kuExcel ine nhamba yezvingasarudzwa 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.

04 of 08

Kuwedzera Data Records neFomu

Cherechedza: Kubatsirwa nemuenzaniso uyu, ona mufananidzo uri pamusoro.

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 semadhijhi edzidzidzidzi (nhamba chete mushure mokunge dash yakasiyana), shandisa kopi uye unyore kuti uwedzere uye uite nyore kupinda.

05 of 08

Kuwedzera Data Records neFomu (Con't)

Cherechedza: Kubatsirwa nemuenzaniso uyu, ona mufananidzo uri pamusoro.

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

06 of 08

Kushandisa Form's Data Tools

Cherechedza: Kubatsirwa nemuenzaniso uyu, ona mufananidzo uri pamusoro.

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 rekudzorera inoshanda chete chero bedzi rekodhi iripo mune fomu. 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.

07 of 08

Kutsvaga Mareji Achishandisa Rimwe Munda Wezita

Bhokisi reCriter rinokubvumira kutsvaga dhesi rekushandisa marekhodi uchishandisa rimwe kana mamwe mazita emunda - akadai sezita, zera, kana chirongwa.

Cherechedza: Kubatsirwa nemuenzaniso uyu, ona mufananidzo uri pamusoro.

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 pane Tsvaga Bhokisi Rinotevera kechipiri uye chechitatu uye zvinyorwa zveJ. Graham naWilliam Henderson vanofanira kuonekwa mumwe mushure mokunge vakanyoresa purogiramu yeArt.

Chikamu chinotevera chekudzidzisa chinosanganisira muenzaniso wekutsvaga marekodhi anowirirana maitiro akawanda.

08 we 08

Kutsvaga Mareji Achishandisa Multiple Field Names

Bhokisi reCriter rinokubvumira kutsvaga dhesi rekushandisa marekhodi uchishandisa rimwe kana mamwe mazita emunda - akadai sezita, zera, kana chirongwa.

Cherechedza: Kubatsirwa nemuenzaniso uyu, ona mufananidzo uri pamusoro.

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 paBhitirano yeCriteria mune fomu.
2. Dzvanya pazera remakore uye faira 18 .
3. Dzvanya paIndaneti munda uye faira zveArt .
4. Dzvanya pane Tsvaga Bhokisi Rinotevera . Nhoroondo yeHh Thompson inofanira kuonekwa muchimiro kubvira iye ava nemakore gumi nemasere uye akanyoresa purogiramu yeArt.
5. Dzvanya pa Tsvaga Bhokisi Rinotevera kechipiri uye rekodhi yeJ. Graham inofanira kuonekwa sezvo iyewo ari nemakore gumi nemasere uye akanyoresa purogiramu yeArt.
6. Dzvanyira pa Tsvaga Bhokisi Rinozotevera kechipiri uye rondedzero yeJ. Graham inofanira kunge ichiri kuonekwa sezvo pasina zvimwe zvinyorwa zvinofanidza zvose zvinotarisirwa.

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