LibreOffice-Suite-Base/C2/Create-queries-using-Design-View/Khasi

Time	Narration
00:00	Khublei ngi pdiangsngewbha iaphi sha ka “Spoken tutorial” halor ka “LibreOffice Base”.
00:04	Ha kane ka jinghikai, ngin ia pule kumno ban:
00:06	Ban shna ia ka “query” da kaba pyndonkam da ka “Design View”.
00:10	Pyndap ia ki tables ha ka “Query Design” window
00:13	Jied ia ki “field”, Set up ia ki “aliase”, Set up sorting order bad, Set up ia ka rukom pynbeit ryntih, ban ai ia ki kyndon ban it na ka bynta ka “query”.
00:23	Na ka bynta kane, to ngin ia peit ia ka nuksa jong ka ‘Library’ database jong ngi.
00:29	Ha kane ka ‘Library’ database, ngi la buh ia ki jingtip shaphang ki book bad ki member.
00:37	Bad ruh, ngi don ia ka “table” ban khmih ia ki book ba la ai sha ki member.
00:45	Mynta ngin ia shna ia ka “query” ba thymmai ban lis ia baroh ki kot kiba la ai sha ki member.
00:54	Ha kawei ka rukom, to ngin ia pynmih ia ka history jong ki book ba la ai sha ki member.
01:03	To ngin ia plie ia ka “Library” database.
01:07	To ngin nion ha ka “Queries” icon ha ka panel ba sha kadiang.
01:13	Ha ka panel ba sha kamon, ngin ia nion ha ka ‘Create Query in Design view’. Mynta ngi iohi ia ka window ba thymmai kaba ngi khot ruh ka “Query Design” window.
01:28	Bad ngi iohi ruh ia ka pop-up window ba rit hajrong kaba ong “Add Table or Query”.
01:39	Hangne ngin sa ia buh ia ka tynrai jong ka data na ka bynta ka query.
01:46	Bad ngin sa donkam ia baroh ki lai tylli ki table na ka bynta ka query ban pynmih ia ka “history” jong ki kot ba la ai sha ki member.
01:57	Ngin leh ia kane da kaba nion ha ka “Books” table ha ka lis bad nangta nion ha u “Add” button ha ka liang ka mon ha ka “pop-up window”.
02:11	Ngin ia pyndap kumjuh ia ka “Books Issued” table bad ka “Member table”.
02:19	Mynta ngi iohi ba ki lai tylli ki table ki lah paw ha ka query design window ba shadien.
02:26	To mynta ngin ia khang noh ia ka pop-up window.
02:31	Kane ka wallam ia ka “Query design window” sha khmat.
02:39	Phin iohi ba ki lai tylli ki table kidon hajrong shiteng jong ka window.
02:46	Hangne, to ngin pynithuh ia katto katne ki jaka hapdeng kine ki table.
02:53	To ngin nion, tan bad pynhap ia ka “Members” table sha ka liang kamon.
03:01	Bad nangta nion, tan bad pynhap ia ka “Books Issued” table hapdeng.
03:11	Mynta ngi iohi ia ki lain kiba pyniasnoh bad kine kidei ki “relationship” kiba ngi lah pyniasnoh hashwa.
03:23	Ngi lah ban nion ar sien ha ki lain ban iohi ia ki jingtip ba bniah jong kane ka “relationship”.
03:30	Ia mynta, to ngin ia peit ia shiteng jong ka ‘Query design’ window ba hapoh.
03:37	Kane ka area kadon bun tylli ki row jong ki “cell”. Ngin ia pyndap ia kine, kumba ngi pynwandur ia ka query.
03:48	Nyngkong, ngin ia peit ia ka “Field” column.
03:53	Kane kadei ban pynithuh ia ki field kiba ngi kwah ba kan paw ha ka result set.
04:01	Ban leh ia kane, ngin ia nion shwa ar sien ha ka “Title” field ha ka “Books” table hajrong ha ka window ba shiteng.
04:12	Hadien kane kadei ka “Name” field ha ka “Members” table.
04:17	Bad nangta, ka “Issue Date” field ha ka “Books Issued” table.
04:24	Hadien kane, ka “Return date, the actual return date”. Bad khatduh ka “checked in” field.
04:34	Phin iohi ia kine ki field ha trai ba shiteng jong ka window ha ka row ba nyngkong.
04:44	Bad ruh ia ka kyrteng ka “table” ba mar bud ha ka row ba lai.
04:50	Hadien kane, to ngin ia peit ha ka “Alias” ha ka row ba ar.
04:57	Hangne ngi lah ban pyndap ia ka kyrteng ba jrong na ka bynta ka field ba la jied.
05:04	Te, to ngin type ha aliases kumba la pyni ha ka dur.
05:11	Bad ngi la dep bad ki aliases.
05:15	Hadien kane, to ngin ia peit ha ka “Sort” row.
05:21	Ngi lah ban pynithuh ia ka order jong ka “result set” hangne.
05:26	Namar ba ngi donkam ia ka “history” jong ki books ba la ai, ngin ia pynbeit ia kane katkum ki tarik ba wan nyngkong
05:34	Kaba mut- ngin ia pynbeit ia ka “result set” da ka “Issue Date” ha ka order kaba kiew sha jrong.
05:43	Na ka bynta kane, ngin ia nion ha ka “cell” ba thylli ha ka “Sort” row, hapoh jong ka “Issue date” field. Bad to ngin nion ha “Ascending”.
05:56	Te, ngin ia leit sha ka row kaba bud – “Visible”.
06:02	Hangne, ngi lah ban set kumno ngin iohi ia ki field ba ngi jied da kaba check lane un-check ia ki.
06:11	Phin iohi ba, da kaba la long hi, baroh kine ki lah dei check lypa.
06:17	Hadien kane, ngin ia leit sha ka “Function” row. Kane la pyndonkam ban shna ia ka queries ba eh. Ngin ia ieh shwa ia kane ia mynta.
06:27	Bad ngin leit sha ka “Criterion” row.
06:32	Hangne ngi lah ban buh kyndon bad pyrkhing ia ka “result set” sha ka simple lane ka complex set.
06:40	Kum ka nuksa, ngi lah ban “query” tang ia kito ki books kiba ngi lah ai hynrei ki bym pat shym la pynphai da ki member.
06:49	Kaba mut- tang ia kito ki bym pat pynphai.
06:54	Te, to ngin nion ha ka “cell” ba thylli ha kane ka row, hapoh jong ka “Checked In” field bad type ‘Equals Zero’.
07:06	Tang katne shwa. To ngin “run” mynta ia ka query.
07:10	Ngi lah ban pyndonkam ia ka keyboard shortcut “F5” lane nion ha u “Edit” menu hajrong jong ka window bad nangta nion ha “Run Query” ha trai.
07:27	Phi lah ban iohi ia ki katto katne ki data hajrong ha ka window ba shiteng?
07:32	Kine kidei ki result jong ka query jong phi.
07:36	Phin iohi, ba ngi iohi ia ka “history” jong ki books ba la ai sha ki member bad la pynbeit da “Issue Date”. Bad ruh phin iohi ba ym don kawei ruh ka kot ba la wan pynphai
07:51	Mynta ngi lah ban leit sha ka query design area kaba hapoh bad pynkylla ia ka katba ngi mon.
08:00	Kum ka nuksa, to ngin weng ia ka “Checked In” criterion.
08:07	Mynta, to ngin “run” ia ka query da kaba shon “F5” sa shisien.
08:15	Mynta ngi iohi ia ka lis ba jrong jong ki data ba la ioh na ka query.
08:23	Hadien kane, to ngin “save” ia kane ka query da kaba shon “Control, S”. Kane ka plie ia ka pop-up window kaba rit.
08:34	To ngin ai ia ka kyrteng ba jrong ia ka query hangne.
08:38	To ngin type ‘History of Books Issued to Members’
08:46	Bad nangta nion ha “OK” button. Bad khang ia kane ka window.
08:52	Ngi lah ban plie ia kane ka query ba la save da kaba nion ar sien ha ka kyrteng jong ka query ha ka “Base” window ba hakhmat.
09:01	Te, ka jingshna ia ka query da kaba pyndonkam da ka “Design View” ka lah long kaba jop.
09:09	Hangne ka kam na ka bynta jong phi.
09:12	Pynmih ia ki lis jong ki books ba la ai sha ka member Nisha Sharma. Ka lis kadei ban dei ha ka rukom katkum ki tarik da ka “Issue date”.
09:24	Da kane ngi la poi sha kaba kut jong kane ka jinghikai halor ka “Creating queries in Design View”, ha ka “LibreOffice Base”.
09:31	Ban kyllum lang, ngi la pule kumno:
09:33	Ban shna ia ka “query” da kaba pyndonkam da ka “Design View”. Ban pyndap ia ki table ha ka Query Deisgn window Ban jied ia ki field
09:41	Set up ia ki aliases, Set up sorting order bad, ban ai ia ki kyndon ban it na ka bynta ka “query”.
09:49	Ka “Spoken Tutorial” project kadei shi bynta jong ka “Talk to a Teacher” project, la kyrshan ia ka da ka National Misson on Education lyngba ka ICT, MHRD, Sorkar India. Ia kane ka Project la pynbit pynbiang da ka http://spoken-tutorial.org. Kham bun ki jingtip halor kane kidon ha kane ka link ba la ai harum.
10:10	nga dei u Pdiangburom na Shillong nga kynkut ia kane. Khublei shibun ia ka jingsnoh kti lang jong phi.

Contributors and Content Editors

Pdiangburom, PoojaMoolya