LibreOffice-Suite-Base/C3/Create-tables/Khasi

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