Difference between revisions of "LibreOffice-Suite-Base/C2/Create-reports/Khasi"
From Script | Spoken-Tutorial
Pdiangburom (Talk | contribs) (Created page with "{| border=1 |'''Time''' |'''Narration''' |- ||00:00 ||Khublei ngi pdiangsngewbha iaphi sha ka “Spoken tutorial” halor ka “LibreOffice Base” |- ||00:03 ||Ha kane ka jin...") |
|||
Line 10: | Line 10: | ||
|- | |- | ||
||00:07 | ||00:07 | ||
− | || | + | || Ban shna ia ka “report”. |
− | + | Ban Select, Label bad Sort ia ki report fields. | |
|- | |- | ||
||00:12 | ||00:12 | ||
− | || | + | || Jied ia ka report layout bad jied ia ka jait report: static lane dynamic. |
|- | |- | ||
||00:19 | ||00:19 | ||
Line 214: | Line 214: | ||
||Mynta ngi iohi ia ka window ba thymmai bad kane kadei ka “Report” kaba ngi shna mynta. | ||Mynta ngi iohi ia ka window ba thymmai bad kane kadei ka “Report” kaba ngi shna mynta. | ||
|- | |- | ||
− | ||07 | + | ||07:12 |
||Phin iohi ba kadon ia ka field label hajrong, ha “bold” font bad ki data badei la lis ha ka rukom tabular | ||Phin iohi ba kadon ia ka field label hajrong, ha “bold” font bad ki data badei la lis ha ka rukom tabular | ||
|- | |- | ||
Line 229: | Line 229: | ||
||Hangne ki kam na ka bynta jong phi: | ||Hangne ki kam na ka bynta jong phi: | ||
|- | |- | ||
− | ||07 | + | ||07:54 |
||Shna ia ka report jong baroh ki kot ha ka library bad group ia ki da ki “Publishers” jong ki. | ||Shna ia ka report jong baroh ki kot ha ka library bad group ia ki da ki “Publishers” jong ki. | ||
|- | |- | ||
− | ||08 | + | ||08:01 |
||Baroh ar ki “Publishers” bad “Book titles” dei ban long ha ka ascending order. | ||Baroh ar ki “Publishers” bad “Book titles” dei ban long ha ka ascending order. | ||
|- | |- | ||
Line 247: | Line 247: | ||
||* Ban shna ia ka Report | ||* Ban shna ia ka Report | ||
|- | |- | ||
− | ||08 | + | ||08:22 |
||* Select, Label bad Sort ia ki report fields | ||* Select, Label bad Sort ia ki report fields | ||
|- | |- | ||
− | ||08 | + | ||08:25 |
||* Jied ia ka report layout | ||* Jied ia ka report layout | ||
|- | |- |
Revision as of 16:37, 12 May 2017
Time | Narration |
00:00 | Khublei ngi pdiangsngewbha iaphi sha ka “Spoken tutorial” halor ka “LibreOffice Base” |
00:03 | Ha kane ka jinghikai, ngin ia pule kumno: |
00:07 | Ban shna ia ka “report”.
Ban Select, Label bad Sort ia ki report fields. |
00:12 | Jied ia ka report layout bad jied ia ka jait report: static lane dynamic. |
00:19 | Na ka bynta kane, to ngin ia peit ia ka nuksa jong ka “Library” database. |
00:27 | Hangne, ngi lah buh ia ki jingtip shaphang ki books bad members ha kane ka Library database. |
00:36 | Ngi don ruh ia ka “table” ban khmih ia ki books ba la ai sha ki members. |
00:42 | Ngi lah pule kumno ban shna ia ka “form” bad queries ha ki jinghikai kiba hashwa. |
00:48 | Shwa ban pule kumno ban shna ia ka “report”, to ngin ia pule shwa kaei ka report? |
00:56 | Ka report kadei kawei pat ka rukom ban sei ia ki jingtip na ka database, kumba long ka “query” |
01:05 | Ngi lah ban customize ia ka layout, ka dur bad jinglong jong ka khnang ba kan long kaba suk ban pule lane print ha ka kot. |
01:14 | Ia ka “Report” lah ban pynmihna ka database “table” lane queries. |
01:21 | Ki lah ruh ban don ia baroh ki fields ha ka table lane ha ka query lane tang ki kynhun jong ki field ba la jied. |
01:32 | Kidon ar tylli ki bynta jong ka report- “static” bad “dynamic”. |
01:38 | Man ba plie ban peit ia ka “Static report”, |
01:42 | Kan sa pyni barabor ia kajuh ka data kaba don ha kapor ba shna ia ka report. |
01:48 | Ia kane la tip ruh kum ka snapshot. |
01:52 | Hynrei ka “Dynamic report” ka pyni ia ka data ba dang shen na ka database, man ba plie ban peit ia ka. |
02:00 | Te, mynta, to ngin ia shna ia ka sample report. |
02:05 | Ha ka ‘Library’ database, |
02:08 | To ngin nion ha “Reports” icon ha ka panel ba sha kadiang. |
02:12 | Ha ka panel ba sha kamon, to ngin nion ha ‘Use Wizard to create report’. |
02:18 | Kane kadei ka opshon kaba suk bad ba kloi ban shna ia ki report. |
02:24 | Mynta ngi iohi ia ka window kaba thymmai kaba la khot ruh ka “Report Builder” window |
02:31 | Bad ngi iohi ruh ia ka wizard ryngkat bad ki 6 tylli ki step ba la lis ha ka liang ka diang. |
02:39 | Ngin ia peit ia ka wizard ban shna ia ka report kaba shong nongrim halor ka query kaba ngi la shna ha ka jinghikai kaba hashwa. |
02:47 | 'History of books issued to the Library members’. |
02:51 | Ngi don ha ka “Step 1 – Field Selection”. |
02:56 | Ngin ia pynbeit ban buh ia ka tynrai jong ka report data hangne: da ka table ne query. |
03:05 | To ngin ia jied ia ka “query: ‘History of books Issued to member” jong ngi na ka drop-down lis kaba hajrong. |
03:14 | Mynta ngi iohi ia ka lis jong ka available fields na ka query ha ka liang kadiang. |
03:21 | Ngi kwah ia baroh ki field ha ka report jong ngi; te ngin shu nion beit ha u khnam ba don ar tylli uba phai sha ka liang kamon. |
03:30 | Mynta to ngin nion ha u “Next” button ban leit sha ka step kaba bud. |
03:35 | Step 2. Labelling Fields. |
03:39 | To ngin type ia ka descriptive label ba harum ha ka label text-box kumba la pyni ha ka dur. |
03:50 | Te, to mynta ngin nion ha “Next” button. |
03:55 | Ngi don ha ka “Step 3 – Grouping”. |
03:59 | Ia kane la pyndonkam man ba ngi donkam ban group ia ki data da ki set jong ki fields ba ngi la jied. |
04:05 | Kum ka nuksa- ha ka report jong ngi, ngi lah ban group ia ka data da ka “Book title”. |
04:12 | Lada ngi leh kumta, ngin sa iohi ha ka report jong ngi ia ka book title nangta baroh ki member kiba la ai ia kine ki kot. |
04:22 | Nangta ngin sa iohi ia ka book title kaba bud, bad kumta ter ter. |
04:27 | Ia mynta, to ngin ieh ia ka report jong ngi ha ka rukom kaba suk. |
04:31 | Te, ngin ia nion ha u “Next” button. |
04:36 | Mynta, ngi don ha ka ‘Step 4 – Sorting Options’. |
04:41 | To ngin ia sort ia ki data ha ka chronological order. |
04:46 | Bad nangta sort ia ka da ka Book title ha ka ascending order. |
04:52 | Na ka bynta kane, ngin ia nion ha “Sort by” drop-down box |
04:58 | Bad nangta nion ha “Issue Date”. |
05:03 | Nangta ngin nion ha ka drop-down box ba ar |
05:08 | Bad nangta nion ha u “Book Title”. |
05:12 | Mynta, to ngin nion ha u “Next” button. |
05:16 | Step 5.- Choose Layout. |
05:20 | Ngi lah ban customize ia ka dur bad jinglong jong ka report hangne. |
05:25 | To ngin nion ha “Columnar, single-column” layout lis. |
05:31 | Phin iohi ba ka “Report Builder” ba shadien ka lah pyn thymmai ialade. |
05:36 | Ka pyni ia baroh ki label ha ka liang ka diang bad ki fields ba iadei sha ka liang kamon. |
05:43 | To ngan jied ha ka “Columnar, two columns”. |
05:48 | Sa shisien ka window ba hapoh ka lah pynthymmai ban pyni ia ar tylli ki column layout. |
05:54 | Ha kane ka rukom, ngi lah ban jied ia kano kano ka layout kaba ka “Base Wizard” ka ai. |
06:02 | Ngi lah ruh ban pynkylla ia ka hadien katkum ka jingdonkam jong ngi. |
06:07 | Ia mynta, to ngin nion ha ka item ba nyngkong – ‘Tabular’ |
06:12 | Bad nion ha u “Next” button. |
06:16 | Te, ka step ka ba khatduh – ‘Create Report’. |
06:20 | To ngin ai ka kyrteng ba jrong ia ka report jong ngi hangne: “Books Issued to Members: Report History”. |
06:30 | Mynta to ngin pynwandur ia ka report jong ngi khnang ba ka report kan ai ia ngi barabor ia ki data kiba thymmai na ka database. |
06:38 | Na ka bynta kane, to ngin nion ha “Dynamic Report” opshon |
06:45 | Kumba ngi kwah barabor ban ioh ia ka data ba thymmai, man ba ngi plie ban peit ia ka report. |
06:52 | Te, ngi la dep bad ka “Report” jong ngi. To ngin nion ha “Create Report now” opshon |
06:59 | Bad khatduh nion ha u “Finish” button. |
07:05 | Mynta ngi iohi ia ka window ba thymmai bad kane kadei ka “Report” kaba ngi shna mynta. |
07:12 | Phin iohi ba kadon ia ka field label hajrong, ha “bold” font bad ki data badei la lis ha ka rukom tabular |
07:24 | Bad phin iohi ba ka lah sort da ka “Issue Date” field ha ka ascending order kata, chronologically bad nangta da ka ‘Book Title’ ha ka ascending order. |
07:38 | Da kumne ngi lah shna ia ka chronological report jong ka kot ba la ai sha ki “Library” members. |
07:46 | Ha ka jinghikai kaba bud, ngin ia pule kumno ban pynkylla ia ka report jong ngi. |
07:52 | Hangne ki kam na ka bynta jong phi: |
07:54 | Shna ia ka report jong baroh ki kot ha ka library bad group ia ki da ki “Publishers” jong ki. |
08:01 | Baroh ar ki “Publishers” bad “Book titles” dei ban long ha ka ascending order. |
08:07 | Pyndonkam ia ka “Columnar, Single-column” layout. |
08:11 | Da kane ngi la poi sha kaba kut jong kane ka jinghikai halor ki “Reports” ha ka “LibreOffice Base”. |
08:17 | Ban kyllum lang, ngi la pule kumno: |
08:21 | * Ban shna ia ka Report |
08:22 | * Select, Label bad Sort ia ki report fields |
08:25 | * Jied ia ka report layout |
08:26 | Bad * jied ia ka jait report: static lane dynamic. |
08:31 | “Spoken Tutorial” project kadei shi bynta jong ka “Talk to a Teacher” project, la kyrshan ia ka da ka National Mission on Education lyngba ka ICT, MHRD, Sorkar India. |
08:42 | Ia kane ka project la pynbit pynbiang da ka http://spoken-tutorial.org. |
08:48 | Kham bun ki jingtip halor kane kidon ha ka link harum. |
08:51 | Ia kane ka script la noh synniang da ka Priya Suresh, DesiCrew Solutions. Bad ma nga u Pdiangburom na Shillong nga pynkut ia kane. Khublei shibun ia ka jingsnohkti lang jong phi. |