Malangizo ndi ndondomeko yolowera deta
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 zolemba zanu ngati mukufunikira
Zowonjezera Kuwonjezera Fomu ya Fomu Yoyenera Kulowa ku Quick Access Toolbar
Fomu yolowera deta ndi imodzi mwa zipangizo zowonongeka za Excel. Kugwiritsa ntchito zonse zomwe mukuyenera kuchita ndi kupereka mitu ya mndandanda yomwe ikugwiritsidwa ntchito mumasamba anu, dinani pa Foni, ndipo Excel idzachita zina zonse.
Pofuna kuti zinthu zikhale zovuta kwambiri, komabe kuyambira Excel 2007, Microsoft yasankha kusaika Foni yonyamulira pa kaboni.
Njira yoyamba yogwiritsira ntchito fomu yolowera deta ndiyo kuwonjezera foni ya Fomu ku Quick Access Toolbar kuti tithe kuigwiritsa ntchito.
Imeneyi ndi ntchito yamodzi. Powonjezeredwa, chizindikiro cha Fomu chikupezekabe pa Quick Access Toolbar.
Kupeza Boma la Fomu Yoyenera
Babu Yopangirako Yowonjezera imagwiritsidwa ntchito kusunga mafupi kuti agwiritsidwe ntchito nthawi zambiri mu Excel. Ndipamene mungathe kuwonjezera zidulezo ku zida za Excel zomwe sizipezeka pa kaboni.
Chimodzi mwa izi ndi mawonekedwe olowera deta.
Fomu ya deta ndi njira yosavuta komanso yosavuta kuwonjezera deta ku tebulo lachinsinsi la Excel.
Pazifukwa zina, Microsoft idasankha kuwonjezera fomu ku imodzi mwa ma teboni kuyambira ndi Excel 2007.
M'munsimu muli masitepe omwe angakuwonetseni momwe mungawonjezere chizindikiro cha Fomu ku Quick Access Toolbar.
Onjezani Fomu ya Data ku Quick Access Toolbar
- Dinani pansi pavivi pamapeto a Quick Access Toolbar kuti mutsegule menyu.
- Sankhani Malamulo Owonjezera kuchokera pa mndandanda kuti mutsegule Bokosi la bokosi la Quick Toolbar lofulumira.
- Dinani pansi pavivi pamapeto a Sankhani malemba kuchokera pa mzere kuti mutsegule menyu.
- Sankhani Malamulo Onse kuchokera mndandanda kuti muwone malamulo onse omwe alipo mu Excel 2007 kumanja kwamanzere.
- Pezani mndandanda wamakalata kuti mupeze Fomu yoyenera.
- Dinani pazowonjezera pazithunzi pakati pa mau olamulira kuti muwonjezere Fomu lamulo ku Quick Access Toolbar.
- Dinani OK .
Fomu ya Fomu iyenera kuwonjezeredwa ku Quick Access Toolbar.
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
Kutsegula Fomu Yoyenera Kulowa
Kutsegula Fomu Yoyenera Kulowa
- Dinani pa selo A2 kuti mupange selo yogwira ntchito .
- Dinani pa chithunzi cha mawonekedwe chomwe chinawonjezeredwa ku Quick Access Toolbar patsamba 2.
- Kusindikiza pazithunzi za mawonekedwe kudzabweretsa bokosi la uthenga kuchokera ku Excel lomwe liri ndi zozizwitsa zingapo zokhudzana ndi kuwonjeza mutu ku mawonekedwe.
- Popeza tayimilira kale maina omwe tikufuna kuti tigwiritse ntchito monga mautumiki onse tiyenera kuchita ndi Dinani OK mu bokosi la uthenga.
- Fomu yomwe ili ndi mayina onse a pamunda ayenera kuwoneka pawindo.
Kuwonjezera Zolemba Zina ndi Fomu
Kuwonjezera Records Records ndi Fomu
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.
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 kopikira ndikuyika kuti mufulumire ndi kuchepetsa kulowera deta.
Kuti muwonjezere zolemba zotsalira ku deta yolumikiza, gwiritsani ntchito mawonekedwe kuti mulowetse deta yonse yomwe imapezeka mu chithunzi pamwamba pa maselo A4 mpaka E11.
Kuwonjezera Zolemba Zina ndi Fomu (con't)
Kuti muwonjezere zolemba zotsalira ku malo osungirako maphunziro, gwiritsani ntchito mawonekedwe kuti mulowetse deta yonse yomwe imapezeka mu chithunzi apa maselo A4 mpaka E11.
Mukugwiritsa ntchito Fomu ya Data Tools
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: Bulu lobwezeretsa limagwira 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.
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.
Kufufuza Mauthenga Pogwiritsa Ntchito Dzina Limodzi
- Dinani pa batani la Criteria mu mawonekedwe.
- Kulimbana ndi batani la Criteria kumatsuka fomu yonse koma samachotsa deta iliyonse kuchokera ku deta.
- Dinani pa Pulogalamu ya Pulogalamuyo ndi kujambula Zojambula pamene tikufuna kufufuza ophunzira onse omwe akulembera pa Maphunziro a Phunziro ku koleji.
- Dinani pa Banda Lotsatila. Mbiri ya H. Thompson iyenera kuoneka ngati momwe akulembera pulogalamu ya Arts.
- Dinani pa Banda Lotsatira Lachiwiri ndi lachitatu ndi zolemba za J. Graham ndi W. Henderson ayenera kuwonetseratu wina ndi mzake pamene akulembedweranso mu pulogalamu ya Arts.
Gawo lotsatira la phunziroli likuphatikizapo chitsanzo cha kufufuza zolemba zomwe zikufanana ndi zambiri.
Kufunafuna Zolemba Pogwiritsa Ntchito Maina Ambiri Amtundu
Muzitsanzo izi tidzasaka ophunzira onse omwe ali ndi zaka 18 ndikulembetsa pa maphunziro a masukulu ku koleji. Zomwezo zomwe zimagwirizanitsa zonsezi ziyenera kuwonetsedwa mu mawonekedwe.
- Dinani batani la Criteria mu mawonekedwe.
- Dinani munda wa zaka ndi mtundu wa 18.
- Dinani mu Pulogalamu ya Pulogalamu ndi kujambula Zojambula.
- Dinani Bwerezani Lotsatira . Mbiri ya H. Thompson iyenera kuoneka mu mawonekedwe kuyambira ali ndi zaka 18 ndipo alembedwe mu pulogalamu ya Arts.
- Dinani kachiwiri ka Fufuzani Chotsatira ndipo mbiri ya J. Graham iyenera kuonekera popeza iye nayenso ali ndi zaka 18 ndipo analembetsa mu pulogalamu ya Arts.
- Dinani BUKHU LOPEREKEZA PAMENE LIMENE LIMENE LIMENE LIMENE LIMENE LIMENE LIMENE LIMENE LIMENE LIMAPHUNZITSA. J. Graham ayenera kukhala akuwonekera popeza palibe zolemba 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.