Difference between revisions of "LibreOffice-Suite-Base/C3/Create-tables/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 3: Line 3:
 
|'''Narration'''
 
|'''Narration'''
 
|-
 
|-
−
||00:00
+
|00:00
−
||Khublei ngi pdiangsngewbha iaphi sha ka “Spoken tutorial” halor ka “LibreOffice Base”
+
|Ngi pdiangsngewbha iaphi sha ka “Spoken tutorial” halor ka “LibreOffice Base”.
 
|-
 
|-
−
||00:03
+
|00:04
−
||Ha kane ka jinghikai, ngin ia pule kumno:
+
|Ha kane ka jinghikai, ngin ia pule kumno
 
|-
 
|-
−
||00:07
+
|00:07
−
||* Ban shna ia ka “report”.
+
| Ban shna ia ka “Table” da kaba-
−
* Ban Select, Label bad Sort ia ki report fields.
+
 
|-
 
|-
−
||00:12
+
|00:09
−
||* Jied ia ka report layout bad jied ia ka jait report: static lane dynamic.
+
|a) Shna ia ka “Views” bad
 
|-
 
|-
−
||00:19
+
|00:11
−
||Na ka bynta kane, to ngin ia peit ia ka nuksa jong ka “Library” database.
+
|b) Da kaba pyndonkam da ka rukom “Copy”.
 
|-
 
|-
−
||00:27
+
|00:13
−
||Hangne, ngi lah buh ia ki jingtip shaphang ki books bad members ha kane ka Library database.
+
|To ngin ia leit sha ka “Library” database jong ngi.
 
|-
 
|-
−
||00:36
+
|00:16
−
||Ngi don ruh ia ka “table” ban khmih ia ki books ba la ai sha ki members.
+
|To ngin nion ha ka “Tables” icon ha ka panel ba sha kadiang.
 
|-
 
|-
−
||00:42
+
|00:21
−
||Ngi lah pule kumno ban shna ia ka “form” bad queries ha ki jinghikai kiba hashwa.
+
|Ha ka panel ba sha kamon, ngi iohi lai tylli ki rukom ha kaban shna ia ka table.
 
|-
 
|-
−
||00:48
+
|00:26
−
||Shwa ban pule kumno ban shna ia ka “report”, to ngin ia pule shwa kaei ka report?
+
|Ngin ia iaid lyngba ia ka “Create View” opshon mynta.
 
|-
 
|-
−
||00:56
+
|00:30
−
||Ka report kadei kawei pat ka rukom ban sei ia ki jingtip na ka database, kumba long ka “query”
+
|Shwa kata, to ngin ia pule shaphang ki “View”. Kaei ka View?
 
|-
 
|-
−
||01:05
+
|00:36
−
||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.
+
|Ka “View” kalong syriem ia ka “table” hynrei kam don ha ka ia ka data.
 
|-
 
|-
−
||01:14
+
|00:43
−
||Ia ka “Report” lah ban pynmihna ka database “table” lane queries.
+
|La shim ia ka kum ka Query Expression, kaba dei tang ka jingpynmih ia ka data na ka table lane na ka database.
 
|-
 
|-
−
||01:21
+
|00:54
−
||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.
+
|Lada ngi peit, kadon ia ki column bad ki row jong ki data kumba long ka table.
 
|-
 
|-
−
||01:32
+
|01:00
−
||Kidon ar tylli ki bynta jong ka report- “static” bad “dynamic”.
+
|“View”s lah ban pyndonkam ban ailad tang katto katne ka jingtreikam
 
|-
 
|-
−
||01:38
+
|01:06
−
||Man ba plie ban peit ia ka “Static report”,
+
|Lane pynjah ia ka dur ka dar bad ka kyrteng jong ki table column kiba don hapoh bad ka data jong ka table.
 
|-
 
|-
−
||01:42
+
|01:13
−
||Kan sa pyni barabor ia kajuh ka data kaba don ha kapor ba shna ia ka report.
+
|Kum ka nuksa, ngi lah ban shna ia ka view kaba suk kaban lis ia baroh ki member jong ka library
 
|-
 
|-
−
||01:48
+
|01:21
−
||Ia kane la tip ruh kum ka snapshot.
+
|Bad ngi lah ban ieh ia ki phone number jong ki ban buh ia ka jinglong donkam ba kyrpang jong ki.
 
|-
 
|-
−
||01:52
+
|01:27
−
||Hynrei ka “Dynamic report” ka  pyni ia ka data ba dang shen na ka database, man ba plie ban peit ia ka.
+
|Hangne ka table kaba hapoh kan dei ka “Members”.
 
|-
 
|-
−
||02:00
+
|01:32
−
||Te, mynta, to ngin ia shna ia ka sample report.
+
|Kiwei ki nongpyndonkam jong ka “Library” database la ai ia ki ban lah ban pyndonkam ia kane ka view hynrei ym ia ka “Members” table.
 
|-
 
|-
−
||02:05
+
|01:40
−
||Ha ka ‘Library’ database,
+
|Ha kane ka rukom, ngi lah ban iohi tang ia ki kyrteng jong ki member ym dei ia ki phone number jong ki.
 
|-
 
|-
−
||02:08
+
|01:46
−
||To ngin nion ha “Reports” icon ha ka panel  ba sha kadiang.
+
|Te, to ngin ia phai biang sha ka “Base” window ba shakhmat bad shna ia kane ka “view”
 
|-
 
|-
−
||02:12
+
|01:53
−
||Ha ka panel ba sha kamon, to ngin nion ha ‘Use Wizard to create report’.
+
|To ngin nion ha “Create View” ha ka panel ba sha kamon.
 
|-
 
|-
−
||02:18
+
|01:58
−
||Kane kadei ka opshon kaba suk bad ba kloi ban shna ia ki report.
+
|Ngi iohi ia ka window ba thymmai kaba kyrteng “View Design” bad ka pop-up window kaba ong “Add tables”.
 
|-
 
|-
−
||02:24
+
|02:06
−
||Mynta ngi iohi ia ka window kaba thymmai kaba la khot ruh ka “Report Builder” window
+
|To ngin nion ha “Members”
 
|-
 
|-
−
||02:31
+
|02:09
−
||Bad ngi iohi ruh ia ka wizard ryngkat bad ki 6 tylli ki step ba la lis ha ka liang ka diang.
+
|Bad khang ia kane ka pop-up window.
 
|-
 
|-
−
||02:39
+
|02:12
−
||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.
+
|Mynta, ngi don ha kane ka “View design” window.
 
|-
 
|-
−
||02:47
+
|02:16
−
||''''History of books issued to the Library members’'''.
+
|Bad ngin ia nion ar sien ha ka “MemberId” bad ha ka “Name” fields.
 
|-
 
|-
−
||02:51
+
|02:21
−
||Ngi don ha ka “Step 1 – Field Selection”.
+
|Ban pyndap ia ka ‘Id” field barabor kalong kaba myntoi shibun
 
|-
 
|-
−
||02:56
+
|02:25
−
||Ngin ia pynbeit ban buh ia ka tynrai jong ka report data hangne: da ka table ne query.
+
|Namar kane ka iarap ia ngi ban pyniasnoh ia kane ka view bad kino kino kiwei pat ki table badon ka jingiadei, kum ka nuksa- ka “BookIssued” Table.
 
|-
 
|-
−
||03:05
+
|02:34
−
||To ngin ia jied ia ka “query: ‘History of books Issued to member” jong ngi na ka drop-down lis kaba hajrong.
+
|Ngi lah ban pyndap ia ka functions, criteria bad pynbeit ryntih ia ki ha kano kano ka rukom katba ngi kwah.
 
|-
 
|-
−
||03:14
+
|02:40
−
||Mynta ngi iohi ia ka lis jong ka available fields na ka query ha ka liang kadiang.
+
|Hynrei ia mynta, ngin ia pynbeit ryntih ia ka member names ha ka rukom ba kiew shajrong.
 
|-
 
|-
−
||03:21
+
|02:45
−
||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.
+
|Na ka bynta kane, to ngin nion ha ka “cell” ba thylli ha ka “Sort” row hapoh jong ka “Name” column ha ka section ba hapoh.
 
|-
 
|-
−
||03:30
+
|02:54
−
||Mynta to ngin nion ha u “Next” button ban leit sha ka step kaba bud.
+
|Bad nangta nion ha “ascending”.
 
|-
 
|-
−
||03:35
+
|02:58
−
||'''Step 2. Labelling Fields'''.
+
|To ngin “save” ia kane ka view ba nyngkong.
 
|-
 
|-
−
||03:39
+
|03:01
−
||To ngin type ia ka descriptive label ba harum ha ka label text-box kumba la pyni ha ka dur.
+
|Hangne, to ngin type ia ka kyrteng ba jrong na ka bynta kane ka view- “View: Members Name Only”.
 
|-
 
|-
−
||03:50
+
|03:10
−
||Te, to mynta ngin nion ha “Next” button.
+
|Bad to ngin nion ha u “OK” button.
 
|-
 
|-
−
||03:55
+
|03:14
−
||Ngi don ha ka “Step 3 – Grouping”.
+
|Ban iohi ia ki data ba hapoh, to ngin nion ha u “Edit” menu hajrong
 
|-
 
|-
−
||03:59
+
|03:22
−
||Ia kane la pyndonkam man ba ngi donkam ban group ia ki data da ki set jong ki fields ba ngi la jied.
+
|Bad nangta nion ha ka “Run Query” ha trai.
 
|-
 
|-
−
||04:05
+
|03:27
−
||Kum ka nuksa- ha ka report jong ngi, ngi lah ban group ia ka data da ka “Book title”.
+
|Bad ngi iohi ia ka section ba thymmai ha jrong kaba lis ia baroh ki member jong ka ‘Library’ ha ka order kaba kiew shajrong.
 
|-
 
|-
−
||04:12
+
|03:36
−
||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.
+
|Kynmaw ba ngim iohi phone numbers eiei.
 
|-
 
|-
−
||04:22
+
|03:40
−
||Nangta ngin sa iohi ia ka book title kaba bud, bad kumta ter ter.
+
|Bad hangne ka “view” ba suk jong ngi.
 
|-
 
|-
−
||04:27
+
|03:43
−
||Ia mynta, to ngin ieh ia ka report jong ngi ha ka rukom kaba suk.
+
|Ngi lah ban shna bad design ia ki views katkum ka jingdonkam jong ngi.
 
|-
 
|-
−
||04:31
+
|03:48
−
||Te, ngin ia nion ha u “Next” button.
+
|Ha shwa ba ngin leit sha kawei pat ka phang, hangne ka kam na ka bynta jong phi.
 
|-
 
|-
−
||04:36
+
|03:53
−
||Mynta, ngi don ha ka ‘Step 4 – Sorting Options’.
+
|Shna ia ka View jong ka ‘Books Issued’ sha ka Member bad tang ia kito ki kot kiba khlem checked-in.
 
|-
 
|-
−
||04:41
+
|04:01
−
||To ngin ia sort ia ki data ha ka chronological order.
+
|Kynthup lang ha ka view, ia kine ki fields: “Books Titles, Member Names, Issue Date” bad “Return Date”.
 
|-
 
|-
−
||04:46
+
|04:12
−
||Bad nangta sort ia ka da ka Book title ha ka ascending order.
+
|Jer kyrteng ia ka view kum “View: List of Books not checked in”.
 
|-
 
|-
−
||04:52
+
|04:20
−
||Na ka bynta kane, ngin ia nion ha “Sort by” drop-down box
+
|To, ngin ia pule kumno ban shna ia ka “table”s da kaba pyndonkam ia ka “copy” method.
 
|-
 
|-
−
||04:58
+
|04:25
−
||Bad nangta nion ha “Issue Date”.
+
|Kane kadei ka rukom kaba suk ban shna ia ki tables, lada ngi tip ia ka dur ba kan long kaba ia syriem.
 
|-
 
|-
−
||05:03
+
|04:33
−
||Nangta ngin nion ha ka drop-down box ba ar
+
|Na ka bynta kane, to ngin shim ba ka “Library” jong ngi kadon ia ka DVDs bad CDs.
 
|-
 
|-
−
||05:08
+
|04:39
−
||Bad nangta nion ha u  “Book Title”.
+
|Bad ngi lah ban buh ia kine ki data ha ka table kaba thymmai kaba kyrteng ka “Media”.
 
|-
 
|-
−
||05:12
+
|04:44
−
||Mynta, to ngin nion ha u “Next” button.
+
|Kum ka nuksa ka CD lane ka DVD ka lah ban don ia ka title bad ia ka publish-year.
 
|-
 
|-
−
||05:16
+
|04:51
−
||'''Step 5.- Choose Layout'''.  
+
|Khnang ban pyniapher hapdeng ka audio bad ka video, ngin ia pynithuh ia ka “MediaType” field.
 
|-
 
|-
−
||05:20
+
|05:00
−
||Ngi lah ban customize ia ka dur bad jinglong jong ka report hangne.
+
|Mynta, namar ba ka “Books” table kadon jan baroh ki fields kiba ia syriem, ngi lah ban copy-paste ia ka “Books” table.
 
|-
 
|-
−
||05:25
+
|05:08
−
||To ngin nion ha “Columnar, single-column” layout lis.
+
|Bad nangta ngi lah ban “rename” ia ka fields bad ka kyrteng jong ka table ha ka jingtreikam jong ngi.
 
|-
 
|-
−
||05:31
+
|05:14
−
||Phin iohi ba ka “Report Builder” ba shadien ka lah pyn thymmai ialade.
+
|Ngin ia peit kumno.
 
|-
 
|-
−
||05:36
+
|05:16
−
||Ka pyni ia baroh ki label ha ka liang ka diang bad ki fields ba iadei sha ka liang kamon.
+
|To ngin ia leit sha ka “Base” window ba hakhmat.
 
|-
 
|-
−
||05:43
+
|05:19
−
||To ngan jied ha ka “Columnar, two columns”.
+
|Hangne, to ngin nion kamon ha ka “Books” table.
 
|-
 
|-
−
||05:48
+
|05:23
−
||Sa shisien ka window ba hapoh ka lah pynthymmai ban pyni  ia ar tylli ki column layout.
+
|Bad ngin sa iohi ia ka “Copy” opshon. To ngin nion ha u.
 
|-
 
|-
−
||05:54
+
|05:28
−
||Ha kane ka rukom, ngi lah ban jied ia kano kano ka layout kaba ka “Base Wizard” ka ai.
+
|Bad nangta nion ha ka liang kamon ha u.
 
|-
 
|-
−
||06:02
+
|05:31
−
||Ngi lah ruh ban pynkylla ia ka hadien katkum ka jingdonkam jong ngi.
+
|Phin iohi ia ki opshons bapher bapher hangne. Hangne u “Paste” bad ruh u “Paste Special”.
 
|-
 
|-
−
||06:07
+
|05:39
−
||Ia mynta, to ngin nion ha ka item ba nyngkong – ‘Tabular’
+
|Ngi lah ban pyndonkam ia ka “copy” bad “paste” ha kane ka format.
 
|-
 
|-
−
||06:12
+
|05:44
−
||Bad nion ha u “Next” button.
+
|Ki format kiba biang kidei ki Formatted text, HTML lane ka Data Source Table.
 
|-
 
|-
−
||06:16
+
|05:51
−
||Te, ka step ka ba khatduh – ‘Create Report’.
+
|Te, ngi lah ban jied ia ka database table nangne
 
|-
 
|-
−
||06:20
+
|05:55
−
||To ngin ai ka kyrteng ba jrong ia ka report jong ngi hangne: “Books Issued to Members: Report History”.
+
|Lane ngi lah ban jied “Paste” na ka menu ynda ngi nion kamon ha u mouse.
 
|-
 
|-
−
||06:30
+
|05:59
−
||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.
+
|Kane kan plie ia ka wizard bad ha kane ka window.
 
|-
 
|-
−
||06:38
+
|06:03
−
||Na ka bynta kane, to ngin nion ha “Dynamic Report” opshon
+
|Ngin ia rename shwa ia ka table jong ngi da kaba ngi type “Media” mar pyrshah ia ka kyrteng jong ka table.
 
|-
 
|-
−
||06:45
+
|06:11
−
||Kumba ngi kwah barabor ban ioh ia ka data ba thymmai, man ba ngi plie ban peit ia ka report.
+
|Ha ki opshon, ngin ia nion ha “Definition and data”.
 
|-
 
|-
−
||06:52
+
|06:16
−
||Te, ngi la dep bad ka “Report” jong ngi. To ngin nion ha “Create Report now” opshon
+
|To ngin ia nion ha u “Next” button.
 
|-
 
|-
−
||06:59
+
|06:19
−
||Bad khatduh nion ha u “Finish” button.
+
|Ha ka window kaba bud, ngin ia pyndap ia ki columns.
 
|-
 
|-
−
||07:05
+
|06:23
−
||Mynta ngi iohi ia ka window ba thymmai bad kane kadei ka “Report” kaba ngi shna mynta.
+
|To ngin ia jied “BookId, title” bad “publish-year” na ka bynta kane ka jinghikai.
 
|-
 
|-
−
||07;12
+
|06:29
−
||Phin iohi ba kadon ia ka field label hajrong, ha “bold” font bad ki data badei la lis ha ka rukom tabular
+
|Mynta, ngin ia jied ia kine ki fields ha ka liang kadiang bad pyndonkam ia u khnam badon uwei u khlieh ban pynkynriah ia ki sha kaliang kamon.
 
|-
 
|-
−
||07:24
+
|06:39
−
||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.
+
|Bad nion ha u “Next” button.
 
|-
 
|-
−
||07:38
+
|06:42
−
||Da kumne ngi lah shna ia ka chronological report jong ka kot ba la ai sha ki “Library” members.
+
|Ha ka window kaba bud, ngi iohi ia ki columns jong ngi.
 
|-
 
|-
−
||07:46
+
|06:46
−
||Ha ka jinghikai kaba bud, ngin ia pule kumno ban pynkylla ia ka report jong ngi.
+
|Hangne ngi lah rename ia ki fields bad pynkylla ia ki data types jong ngi.
 
|-
 
|-
−
||07:52
+
|06:51
−
||Hangne ki kam na ka bynta jong phi:
+
|Ngin ia rename ia ka “BookId” sha ka “MeidaId”.
 
|-
 
|-
−
||07;54
+
|06:55
−
||Shna ia ka report jong baroh ki kot ha ka library bad group ia ki da ki “Publishers” jong ki.
+
|Bad ngin ia nion ha ka “Create” button
 
|-
 
|-
−
||08;01
+
|06:59
−
||Baroh ar ki “Publishers” bad “Book titles” dei ban long ha ka ascending order.
+
|Ha ka “Base” window ba hakhmat, ngi iohi ia ka “Media” table ba thymmai jong ngi.
 
|-
 
|-
−
||08:07
+
|07:05
−
||Pyndonkam ia ka “Columnar, Single-column” layout.
+
|To mynta ngin ia edit ia ka table ban pyndap ia ka field ba thymmai “MediaType” kaban buh ia ka jingtip jong ka audio lane ka video.
 
|-
 
|-
−
||08:11
+
|07:15
−
||Da kane ngi la poi sha kaba kut jong kane ka jinghikai halor ki “Reports” ha ka “LibreOffice Base”.
+
|Mynta ngi don ha ka “Table Design” window.
 
|-
 
|-
−
||08:17
+
|07:19
−
||Ban kyllum lang, ngi la pule kumno:
+
|Hangne, to ngin pynithuh ia ka “MediaType” kum ka column kaba khatduh.
 
|-
 
|-
−
||08:21
+
|07:24
−
||* Ban shna ia ka Report
+
|To ngin nion ha ka “cell” hapoh jong ka “publishyear”
 
|-
 
|-
−
||08;22
+
|07:27
−
||* Select, Label bad Sort  ia ki report fields
+
|Bad pyndap ‘MediaType’ kum “Field Name” bad nangta jied “Text” lane “Field Type”.
 
|-
 
|-
−
||08;25
+
|07:36
−
||* Jied ia ka report layout
+
|Mynta, to ngin “save” ia ka table design bad hangne ngi la dep.
 
|-
 
|-
−
||08:26
+
|07:41
−
||Bad * jied ia ka jait report: static lane dynamic.
+
|Te hangne, ngi lah shna ia ka “Media” table jong ngi da kaba pyndonkam da ka “Copy” method.
 
|-
 
|-
−
||08:31
+
|07:48
−
||“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.
+
|Te, hangne sa kawei ka kam na ka bynta jong phi.
 
|-
 
|-
−
||08:42
+
|07:51
−
||Ia kane ka project la pynbit pynbiang da ka http://spoken-tutorial.org.
+
|Shna ia ka table da kaba pyndonkam da ka ‘Use Wizard to Create table’ method.
 
|-
 
|-
−
||08:48
+
|07:57
−
||Kham bun ki jingtip halor kane kidon ha ka link harum.
+
|Hangne, pyndonkam da ka ‘Assets’ sample table bad rename ia ka ‘AssetsCopy’
 +
|-
 +
|08:04
 +
|Bad wad bniah ia kiwei kiwei ki opshon ha kane ka method.
 +
|-
 +
|08:08
 +
|Da kane ngi lah poi sha kaba kut jong kane ka jinghikai halor ka “Creating Tables in LibreOffice Base”.
 +
|-
 +
|08:14
 +
|Ban kyllum lang, ngi la pule kumno-
 +
|-
 +
|08:17
 +
|Ban shna ia ka table da kaba
 +
a) Shna ia ki views bad
 +
b) Pyndonkam da ka Copy method.
 +
|-
 +
|08:23
 +
|“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, Sorkat India. Ia kane ka project la pynbit pynbiang da ka http://spoken-tutorial.org. Kham bun ki jingtip halor kane kidon ha ka link harum.
 +
|-
 +
|08:44
 +
|Ia kane ka script la noh synniang da ka Priya Suresh, DesiCrew Solutions. Bad nga dei u Pdiangburom na Shillong nga pynkut ia kane.
 +
Khublei shibun ia ka jingsnohkti lang jong phi.
 
|-
 
|-
−
||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.
 

Latest revision as of 11:35, 2 May 2017

Time Narration
00:00 Ngi pdiangsngewbha iaphi sha ka “Spoken tutorial” halor ka “LibreOffice Base”.
00:04 Ha kane ka jinghikai, ngin ia pule kumno
00:07 Ban shna ia ka “Table” da kaba-
00:09 a) Shna ia ka “Views” bad
00:11 b) Da kaba pyndonkam da ka rukom “Copy”.
00:13 To ngin ia leit sha ka “Library” database jong ngi.
00:16 To ngin nion ha ka “Tables” icon ha ka panel ba sha kadiang.
00:21 Ha ka panel ba sha kamon, ngi iohi lai tylli ki rukom ha kaban shna ia ka table.
00:26 Ngin ia iaid lyngba ia ka “Create View” opshon mynta.
00:30 Shwa kata, to ngin ia pule shaphang ki “View”. Kaei ka View?
00:36 Ka “View” kalong syriem ia ka “table” hynrei kam don ha ka ia ka data.
00:43 La shim ia ka kum ka Query Expression, kaba dei tang ka jingpynmih ia ka data na ka table lane na ka database.
00:54 Lada ngi peit, kadon ia ki column bad ki row jong ki data kumba long ka table.
01:00 “View”s lah ban pyndonkam ban ailad tang katto katne ka jingtreikam
01:06 Lane pynjah ia ka dur ka dar bad ka kyrteng jong ki table column kiba don hapoh bad ka data jong ka table.
01:13 Kum ka nuksa, ngi lah ban shna ia ka view kaba suk kaban lis ia baroh ki member jong ka library
01:21 Bad ngi lah ban ieh ia ki phone number jong ki ban buh ia ka jinglong donkam ba kyrpang jong ki.
01:27 Hangne ka table kaba hapoh kan dei ka “Members”.
01:32 Kiwei ki nongpyndonkam jong ka “Library” database la ai ia ki ban lah ban pyndonkam ia kane ka view hynrei ym ia ka “Members” table.
01:40 Ha kane ka rukom, ngi lah ban iohi tang ia ki kyrteng jong ki member ym dei ia ki phone number jong ki.
01:46 Te, to ngin ia phai biang sha ka “Base” window ba shakhmat bad shna ia kane ka “view”
01:53 To ngin nion ha “Create View” ha ka panel ba sha kamon.
01:58 Ngi iohi ia ka window ba thymmai kaba kyrteng “View Design” bad ka pop-up window kaba ong “Add tables”.
02:06 To ngin nion ha “Members”
02:09 Bad khang ia kane ka pop-up window.
02:12 Mynta, ngi don ha kane ka “View design” window.
02:16 Bad ngin ia nion ar sien ha ka “MemberId” bad ha ka “Name” fields.
02:21 Ban pyndap ia ka ‘Id” field barabor kalong kaba myntoi shibun
02:25 Namar kane ka iarap ia ngi ban pyniasnoh ia kane ka view bad kino kino kiwei pat ki table badon ka jingiadei, kum ka nuksa- ka “BookIssued” Table.
02:34 Ngi lah ban pyndap ia ka functions, criteria bad pynbeit ryntih ia ki ha kano kano ka rukom katba ngi kwah.
02:40 Hynrei ia mynta, ngin ia pynbeit ryntih ia ka member names ha ka rukom ba kiew shajrong.
02:45 Na ka bynta kane, to ngin nion ha ka “cell” ba thylli ha ka “Sort” row hapoh jong ka “Name” column ha ka section ba hapoh.
02:54 Bad nangta nion ha “ascending”.
02:58 To ngin “save” ia kane ka view ba nyngkong.
03:01 Hangne, to ngin type ia ka kyrteng ba jrong na ka bynta kane ka view- “View: Members Name Only”.
03:10 Bad to ngin nion ha u “OK” button.
03:14 Ban iohi ia ki data ba hapoh, to ngin nion ha u “Edit” menu hajrong
03:22 Bad nangta nion ha ka “Run Query” ha trai.
03:27 Bad ngi iohi ia ka section ba thymmai ha jrong kaba lis ia baroh ki member jong ka ‘Library’ ha ka order kaba kiew shajrong.
03:36 Kynmaw ba ngim iohi phone numbers eiei.
03:40 Bad hangne ka “view” ba suk jong ngi.
03:43 Ngi lah ban shna bad design ia ki views katkum ka jingdonkam jong ngi.
03:48 Ha shwa ba ngin leit sha kawei pat ka phang, hangne ka kam na ka bynta jong phi.
03:53 Shna ia ka View jong ka ‘Books Issued’ sha ka Member bad tang ia kito ki kot kiba khlem checked-in.
04:01 Kynthup lang ha ka view, ia kine ki fields: “Books Titles, Member Names, Issue Date” bad “Return Date”.
04:12 Jer kyrteng ia ka view kum “View: List of Books not checked in”.
04:20 To, ngin ia pule kumno ban shna ia ka “table”s da kaba pyndonkam ia ka “copy” method.
04:25 Kane kadei ka rukom kaba suk ban shna ia ki tables, lada ngi tip ia ka dur ba kan long kaba ia syriem.
04:33 Na ka bynta kane, to ngin shim ba ka “Library” jong ngi kadon ia ka DVDs bad CDs.
04:39 Bad ngi lah ban buh ia kine ki data ha ka table kaba thymmai kaba kyrteng ka “Media”.
04:44 Kum ka nuksa ka CD lane ka DVD ka lah ban don ia ka title bad ia ka publish-year.
04:51 Khnang ban pyniapher hapdeng ka audio bad ka video, ngin ia pynithuh ia ka “MediaType” field.
05:00 Mynta, namar ba ka “Books” table kadon jan baroh ki fields kiba ia syriem, ngi lah ban copy-paste ia ka “Books” table.
05:08 Bad nangta ngi lah ban “rename” ia ka fields bad ka kyrteng jong ka table ha ka jingtreikam jong ngi.
05:14 Ngin ia peit kumno.
05:16 To ngin ia leit sha ka “Base” window ba hakhmat.
05:19 Hangne, to ngin nion kamon ha ka “Books” table.
05:23 Bad ngin sa iohi ia ka “Copy” opshon. To ngin nion ha u.
05:28 Bad nangta nion ha ka liang kamon ha u.
05:31 Phin iohi ia ki opshons bapher bapher hangne. Hangne u “Paste” bad ruh u “Paste Special”.
05:39 Ngi lah ban pyndonkam ia ka “copy” bad “paste” ha kane ka format.
05:44 Ki format kiba biang kidei ki Formatted text, HTML lane ka Data Source Table.
05:51 Te, ngi lah ban jied ia ka database table nangne
05:55 Lane ngi lah ban jied “Paste” na ka menu ynda ngi nion kamon ha u mouse.
05:59 Kane kan plie ia ka wizard bad ha kane ka window.
06:03 Ngin ia rename shwa ia ka table jong ngi da kaba ngi type “Media” mar pyrshah ia ka kyrteng jong ka table.
06:11 Ha ki opshon, ngin ia nion ha “Definition and data”.
06:16 To ngin ia nion ha u “Next” button.
06:19 Ha ka window kaba bud, ngin ia pyndap ia ki columns.
06:23 To ngin ia jied “BookId, title” bad “publish-year” na ka bynta kane ka jinghikai.
06:29 Mynta, ngin ia jied ia kine ki fields ha ka liang kadiang bad pyndonkam ia u khnam badon uwei u khlieh ban pynkynriah ia ki sha kaliang kamon.
06:39 Bad nion ha u “Next” button.
06:42 Ha ka window kaba bud, ngi iohi ia ki columns jong ngi.
06:46 Hangne ngi lah rename ia ki fields bad pynkylla ia ki data types jong ngi.
06:51 Ngin ia rename ia ka “BookId” sha ka “MeidaId”.
06:55 Bad ngin ia nion ha ka “Create” button
06:59 Ha ka “Base” window ba hakhmat, ngi iohi ia ka “Media” table ba thymmai jong ngi.
07:05 To mynta ngin ia edit ia ka table ban pyndap ia ka field ba thymmai “MediaType” kaban buh ia ka jingtip jong ka audio lane ka video.
07:15 Mynta ngi don ha ka “Table Design” window.
07:19 Hangne, to ngin pynithuh ia ka “MediaType” kum ka column kaba khatduh.
07:24 To ngin nion ha ka “cell” hapoh jong ka “publishyear”
07:27 Bad pyndap ‘MediaType’ kum “Field Name” bad nangta jied “Text” lane “Field Type”.
07:36 Mynta, to ngin “save” ia ka table design bad hangne ngi la dep.
07:41 Te hangne, ngi lah shna ia ka “Media” table jong ngi da kaba pyndonkam da ka “Copy” method.
07:48 Te, hangne sa kawei ka kam na ka bynta jong phi.
07:51 Shna ia ka table da kaba pyndonkam da ka ‘Use Wizard to Create table’ method.
07:57 Hangne, pyndonkam da ka ‘Assets’ sample table bad rename ia ka ‘AssetsCopy’
08:04 Bad wad bniah ia kiwei kiwei ki opshon ha kane ka method.
08:08 Da kane ngi lah poi sha kaba kut jong kane ka jinghikai halor ka “Creating Tables in LibreOffice Base”.
08:14 Ban kyllum lang, ngi la pule kumno-
08:17 Ban shna ia ka table da kaba

a) Shna ia ki views bad b) Pyndonkam da ka Copy method.

08:23 “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, Sorkat India. Ia kane ka project la pynbit pynbiang da ka http://spoken-tutorial.org. Kham bun ki jingtip halor kane kidon ha ka link harum.
08:44 Ia kane ka script la noh synniang da ka Priya Suresh, DesiCrew Solutions. Bad nga dei u Pdiangburom na Shillong nga pynkut ia kane.

Khublei shibun ia ka jingsnohkti lang jong phi.

Contributors and Content Editors

Pdiangburom

Retrieved from "https://script.spoken-tutorial.org/index.php?title=LibreOffice-Suite-Base/C3/Create-tables/Khasi&oldid=36846"