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

From Script | Spoken-Tutorial
Revision as of 11:35, 2 May 2017 by Pdiangburom (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
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