Fomu ya Fomu ya Entry 2003

01 a 08

Kugwiritsa Ntchito Fomu ya Kulowa kwa Data mu Excel

Kugwiritsira ntchito Excel komwe kumapangidwira mawonekedwe oyendetsa deta ndi njira yofulumira komanso yosavuta yolowetsa deta muzenera za Excel.

Kugwiritsa ntchito mawonekedwe kumakuthandizani kuti:

• Yambani tebulo latsopano lachinsinsi kapena kuwonjezera zolemba zatsopano kwa zomwe zilipo
• pendekani kudzera m'masitomala olemba limodzi panthawi
• fufuzani zolemba zomwe zili ndi mauthenga enieni
• sintha kapena kuchotsa zolembera ngati kuli kofunikira

Onani phunziro lothandizira: Excel 2010/2007 Fomu Yoyenera Kulowa .

02 a 08

Kuwonjezera Maina a Ma Field Field

Monga tanenedwa kale, zonse zomwe tifunika kuchita kuti tigwiritse ntchito mawonekedwe olowa mu Excel ndikupereka maina a mndandanda kapena maina a m'munda kuti agwiritsidwe ntchito mu database.

Njira yosavuta yowonjezeramo mayina a pamunda ndi mawonekedwewa ndi kuwasungira m'maselo mu tsamba lanu. Mukhoza kukhala ndi mayina 32 m'munda mwa mawonekedwe.

Lowetsani zotsatirazi mmaselo A1 mpaka E1:

Wophunzira
Dzina lomaliza
Poyamba
Zaka
Pulogalamu

03 a 08

Kutsegula Fomu Yoyenera Kulowa

Dziwani: Pothandizidwa ndi chitsanzo ichi, onani chithunzi pamwambapa.

1. Dinani pa selo A2 kuti mupange selo yogwira ntchito .
2. Dinani pa Data> Fomu mu menyu.
3. Kutsegula fomuyo kumabweretsa bokosi la uthenga kuchokera ku Excel lomwe liri ndi zosankha zingapo zokhudzana ndi kuwonjezera mutu ku mawonekedwe.
4. Popeza tayimilira kale maina omwe tikufuna kuti tigwiritse ntchito monga mautumiki onse tiyenera kuchita ndi Dinani OK mu bokosi la uthenga.
5. Fomu yomwe ili ndi mayina onse a pamunda ayenera kuwoneka pawindo.

04 a 08

Kuwonjezera Zolemba Zina ndi Fomu

Dziwani: Pothandizidwa ndi chitsanzo ichi, onani chithunzi pamwambapa.

Momwe malemba awonjezeredwa ku mawonekedwe owonjezera zolemba ku detayi ndi nkhani yokha yolemba mu data molondola mu mawonekedwe a fomu.

Zitsanzo Zolemba

Onjezerani zolemba zotsatirazi ku deta yanu polemba deta mu mawonekedwe omwe ali pafupi ndi mutu woyenera. Dinani ku Bungwe Latsopano mukalowetsa zolemba zoyamba kuti mutsegule minda ya mbiri yachiwiri.

1. Ophunzira : SA267-567
   Dzina Lomaliza : Jones
   Poyamba : B.
   Zaka : 21
   Pulogalamu : Zinenero
   
   Ophunzira : SA267-211
   Dzina Lomaliza : Williams
   Poyamba : J.
   Zaka : 19
   Pulogalamu : Sayansi

Langizo: Pakalowa deta yomwe ili yofanana kwambiri ndi chiwerengero cha ziwerengero za ophunzira (nambala yokha pambuyo pa dash ndi yosiyana), gwiritsani ntchito kukopera ndi kusonkhanitsa kuti mufulumire ndi kuchepetsa kulowera deta.

05 a 08

Kuwonjezera Zolemba Zina ndi Fomu (Con't)

Dziwani: Pothandizidwa ndi chitsanzo ichi, onani chithunzi pamwambapa.

Kuti muwonjezere zolemba zotsalira ku deta yolumikiza, gwiritsani ntchito mawonekedwe kuti mulowetse deta yonse yomwe imapezeka mu chithunzi pamwamba pa maselo A4 mpaka E11.

06 ya 08

Mukugwiritsa ntchito Fomu ya Data Tools

Dziwani: Pothandizidwa ndi chitsanzo ichi, onani chithunzi pamwambapa.

Vuto lalikulu ndi database likusunga kukhulupirika kwa deta monga fayilo imakula kukula. Izi zimafuna:

• kukonza zolakwika za deta kapena kusinthira zolemba za munthu aliyense
• kuchotsa zolemba zosawerengeka kapena zobwereza

Fomu yopangira deta ili ndi zipangizo zingapo kumbali yakanja lamanja zomwe zimapangitsa kuti zikhale zosavuta kupeza ndi kukonza kapena kuchotsa zolemba kuchokera ku deta.

Zida izi ndi:

• Chotsatira ndi Kupeza Mabungwe Otsatira - awa amakulolani kuti mupite patsogolo ndi kubwerera ku deta imodzi panthawi imodzi.
• Chotsani Chotsitsa - ichi chikugwiritsidwa ntchito kuchotsa zolemba kuchokera ku deta.
• Bomba lobwezeretsa - Bululi lingagwiritsidwe ntchito kuthetsa kusintha kwa mbiri yomwe ikukonzedwa. Nthaŵi zina, timasintha zolakwika pa zolemba kapena ngakhale kusintha zolakwika zonse. Ngati ndi choncho, batani yobwezeretsa ikhoza kugwiritsidwa ntchito kuthetsa kusintha kumeneku.
• Dziwani: batani yobwezeretsa imagwira ntchito malinga ngati mbiri ilipo mu mawonekedwe. Mutangotenga mawonekedwe ena kapena kutseka mawonekedwe, batani yobwezeretsa imasiya kugwira ntchito.
• Bungwe la Criteria limakulolani kuti mufufuze kaundula za zolemba zochokera pazinthu zoyenera, monga dzina, zaka, kapena pulogalamu. Chitsanzo chogwiritsa ntchito batani lachitsulo chikuphatikizidwa mu sitepe yotsatira ya phunzirolo.

07 a 08

Kufufuza Mauthenga Pogwiritsa Ntchito Dzina Limodzi

Bungwe la Criteria limakulolani kuti mufufuze kaundula mauthenga pogwiritsa ntchito mayina amodzi kapena ambiri - monga dzina, zaka, kapena pulogalamu.

Dziwani: Pothandizidwa ndi chitsanzo ichi, onani chithunzi pamwambapa.

1. Dinani pa batani la Criteria mu mawonekedwe.
2. Kulimbana ndi batani la Criteria kumatsuka fomu yonse koma samachotsa deta iliyonse kuchokera ku deta.
3. Dinani pa Pulogalamu ya Pulogalamuyo ndi kujambula Zojambula pamene tikufuna kufufuza ophunzira onse omwe akulembera pa Maphunziro a Phunziro ku koleji.
4. Dinani pa Banda Lotsatila. Mbiri ya H. Thompson iyenera kuoneka ngati momwe akulembera pulogalamu ya Arts.
5. Dinani pa Banda Lotsatira Lotsatira kachiwiri ndi lachitatu ndipo zolemba za J. Graham ndi W. Henderson ziyenera kuwonetseratu wina ndi mzake pamene akulembedweranso mu pulogalamu ya Arts.

Gawo lotsatira la phunzirolo likuphatikizapo chitsanzo cha kufufuza zolemba zomwe zikufanana ndi zambiri.

08 a 08

Kufunafuna Zolemba Pogwiritsa Ntchito Maina Ambiri Amtundu

Bungwe la Criteria limakulolani kuti mufufuze kaundula mauthenga pogwiritsa ntchito mayina amodzi kapena ambiri - monga dzina, zaka, kapena pulogalamu.

Dziwani: Pothandizidwa ndi chitsanzo ichi, onani chithunzi pamwambapa.

Mu chitsanzo ichi, tifunafuna ophunzira onse omwe ali ndi zaka 18 ndipo alembetsa pulogalamu yamakono ku koleji. Zomwezo zomwe zimagwirizanitsa zonsezi ziyenera kuwonetsedwa mu mawonekedwe.

1. Dinani pa batani la Criteria mu mawonekedwe.
2. Dinani kumunda wa zaka ndi mtundu 18 .
3. Dinani pa Pulogalamuyi ndi kujambula Zojambula .
4. Dinani pa Banda Lotsatila. Mbiri ya H. Thompson iyenera kuoneka mu mawonekedwe kuyambira ali ndi zaka 18 ndipo alembedwe mu pulogalamu ya Arts.
5. Dinani pa Bata Lotsatira Lachiwiri kachiwiri ndipo mbiri ya J. Graham iyenera kuonekera popeza iye nayenso ali ndi zaka 18 ndipo analembetsa mu pulogalamu ya Arts.
6. Dinani pa Banda Lotsatila Lachitatu ndipo mbiri ya J. Graham iyenera kukhala ikuwonekera popeza palibe zolembedwa zina zomwe zimagwirizanitsa zonsezo.

Mbiri ya W. Henderson sayenera kuwonetsedwa mu chitsanzo ichi chifukwa, ngakhale kuti atalembedwa mu pulogalamu ya Arts, iye ali ndi zaka 18 kotero sagwirizana ndi zofufuzira zonsezi.