Difference between revisions of "LibreOffice-Suite-Base/C2/Create-reports/Khasi"

From Script | Spoken-Tutorial
Jump to: navigation, search
(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 shna ia ka “report”.
* Ban Select, Label bad Sort ia ki report fields.
+
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.  
+
|| 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;12
+
||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;54
+
||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;01
+
||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;22
+
||08:22
 
||* Select, Label bad Sort  ia ki report fields
 
||* Select, Label bad Sort  ia ki report fields
 
|-
 
|-
||08;25
+
||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.

Contributors and Content Editors

Pdiangburom, Pratik kamble