LibreOffice-Suite-Base/C3/Create-tables/Khasi
From Script | Spoken-Tutorial
| 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. |
