LibreOffice-Suite-Base/C2/Create-queries-using-Query-Wizard/Khasi
From Script | Spoken-Tutorial
| Time | Narration |
| 00:02 | Khublei ngi pdiangsngewbha iaphi sha ka “Spoken toturial” halor ka “LibreOffice Base”. |
| 00:06 | Ha kane ka jinghikai, ngin ia pule kumno ban:
Shna ia ki jingkylli basuk da kaba pyndonkam da ka “Query wizard”, jied ia ki fields, buh ryntih ha ki order jong ki field bad, ban ai ki lad ne ki kyndon ha ka ban wad ia ki jingkylli. |
| 00:24 | To ngin ia pule shwa kaei ka “query”. |
| 00:29 | Ka query lah ban pyndonkam ban ioh ia ki jingtip ba dei na ka database. |
| 00:36 | Ha kawei ka rukom, ngi lah ban “query” ia ka database na ka bynta ki data kiba iadei bad ka kyndon ba la ai. |
| 00:48 | Kum ka nuksa, to ngin ia peit ia ka ‘Library’ database jong ngi kaba ngi la leh ha ki jinghikai ba shakhmat. |
| 00:56 | Ngi lah buh ia ki jingtip shaphang ki kot bad member ha ka Library database jong ngi. |
| 01:04 | Mynta ngi lah ban query ia ka Library database na ka bynta baroh ki member jong ka Library. |
| 01:12 | Lane ngi lah ban query ia ka database na ka bynta baroh ki kot ki bym don ha ka Library. |
| 01:21 | To ngin ia peit kumno ban shna ia ka query kaba suk da kaba pyndonkam da ka “Base”. |
| 01:30 | Ka nuska jong ngi kadei ban lis ia baroh ki member jong ka ‘Library’ ryngkat bad ki phone numbar jong ki. |
| 01:44 | Ngi don ha ka ‘Library’ database. Phi lah tip kumno ban plie ia kane mynta. |
| 01:51 | To ngin nion ha ka “Queries” icon kaba don ha ka panel ba sha kadiang. |
| 01:57 | Ha ka panel ba sha kamon, ngi iohi lai tylli ki opshon. |
| 02:03 | Namar ba ngi shna shwa nyngkong ia ka query kaba suk, ngin ia jied ia ka rukom kaba suk bad kaba kloi. |
| 02:11 | Bad kata kadei da kaba pyndonkam da ka “Query Wizard”. |
| 02:17 | Na ka bynta ban shna ia ki queries kiba kham eh, ka “Base” ka ai ia ngi ryngkat ki opshons kiba suk ban pyndonkam kum ka ‘Create Query in Design View’ |
| 02:28 | Bad ‘Create Query in SQL view’ ha kaba ngin sa ia pule kham shadien. |
| 02:36 | Ia mynta, to ngin nion ha ‘Use Wizard to Create Query’. |
| 02:43 | Mynta, ngi iohi ia ka pop-up window kaba ong “Query Wizard” ha jrong. |
| 02:50 | Ha ka liang ka diang, ngi iohi 8 tylli ki step kiba ngi hap ban iaid lyngba. |
| 02:57 | Ngi don ha ka “Step 1 – Field Selection”. |
| 03:03 | Ha ka liang ka mon, ngi iohi ia ka drop-down box hapoh jong ka label “Tables”. |
| 03:11 | Kane kadei ka jaka ha kaba ngin jied ia ka tynrai jong ka data kaba ngi kwah na ka query. |
| 03:21 | Namar ba ka nuksa jong ka query jong ngi kadei ban ioh ia ki lis jong baroh ki member jong ka Library, ngin ia nion ha ka “Tables:Members” na ka drop-down box. |
| 03:35 | Mynta, to ngin nion ar sien ha ka “Name” field ha ka “Available fields” lis ha ka liang ka diang bad pynkynriah sha ka lis box ba sha kamon. |
| 03:50 | Hadien kane, to ngin nion ha ka “Phone” field ha ka liang ka diang bad pynkynriah ia ka sha ka liang kamon. |
| 04:00 | Kynmaw ba lada kwah ban pynkynriah ia baroh ki fields sha ka liang kamon, ngi lah ban pyndonkam ia u khnam ba don ar tylli uba kdew sha ka liang ka mon. |
| 04:09 | Mynta, to ngin nion ha u “Next” button ha trai. |
| 04:15 | Mynta ngi don ha ka “Step 2 – Sorting Order”. |
| 04:20 | Namar ba ngi kwah ba ka query jong ngi kan pynmih ia ki lis jong ki member bad phone numbar jong ki, ngi lah ban ieh ia ka kumba kalong. |
| 04:30 | Lane ngi lah ban pynbeit ryntih ia ka lis da ka kyrteng ki member. |
| 04:36 | Ka “Base Wizard” ka ai lad ia ngi ban buh pynbeit haduh 4 “fields” ha ka result lis ha ka shisien leh. |
| 04:45 | Ia mynta, to ngin nion ha ka drop-down box kaba hajrong duh. |
| 04:51 | Bad nion ha “Members.Name”. |
| 04:55 | Ngi lah ruh ban jied lada ngi kwah ban buh pynbeit ryntih ia ki kyrteng ha ka order ba kiew ne ba hiar. |
| 05:03 | To ngin nion ha ka “Ascending” opshon |
| 05:07 | Bad iaid shakhmat sha ka step kaba bud. |
| 05:11 | Step 3 - Search Conditions. |
| 05:16 | Kane ka step kan iarap lada ngi kwah ban pyrkhing ia ka result lane ka jingpynmih ha ki kyndon. |
| 05:22 | Kum ka nuksa, ngi lah ban pyrkhing ia ka jingmih ne result tang sha kito ki member kiba ai ka kyrteng jong ki ka ba sdang na u alphabet R. |
| 05:34 | Na ka bynta kane, to ngin nion ha ka “Fields” drop-down box bad nangta nion ha “Member.Name”. |
| 05:45 | Mynta, nion ha “Condition” drop-down box. |
| 05:51 | Phin iohi ia bun tylli ki kyndon hangne. |
| 05:58 | To ngin nion ha “like”. |
| 06:02 | Ha ka “Value” text box, to ngin type ha ‘capital R’ bad u ‘percentage symbol’. |
| 06:13 | Da kumne ngi lah ban pynithuh ia ki kyndon kiba suk bad ba eh hapoh ka query jong ngi. |
| 06:22 | To ngin ia pyndam ia u ‘R%” na ka “Value” text-box ba kan lis ia baroh ki member bad nion ha u “Next” button. |
| 06:37 | Sngewbha kynmaw ba ngi lah jam sha ka step 7. |
| 06:43 | Namar ba ngi shna ia ka query kaba suk tang na kawei ka “table”. |
| 06:51 | Bad ka query kan sa pynphai ia ki jingtip ba bniah ym dei jingtip kyllum. |
| 06:57 | Ki queries jong ka jingtip kyllum ki pyni ia ki data na ka aggregate functions bad da ka group. |
| 07:05 | Khyndiat ki nuksa la niew ia baroh ki member lane ka dor jong baroh ki kot. |
| 07:13 | Ngin ia pule ia kine hadien. |
| 07:17 | Te, hangne to ngin ia set ia ki aliases, |
| 07:23 | Kaba mut ba ngin ai ia ki label ne header ba iadei paralok bad ba bniah ha ka resulting lis. |
| 07:32 | Te ka ‘Name’ field ka lah ban don ia ki alias kum ki ‘Member Name’ bad ki ‘Phone’ field ki lah ban don ia ki alias kum ‘Phone Number’. |
| 07:46 | Te, to ngin type ha kine ki aliases ba thymmai ha ki ar tylli ki text-boxes bad nion ha u “Next” button. |
| 07:57 | Mynta, ngi don ha ka “Step 8 – the final step”. |
| 08:03 | Hangne to ngin ai kyrteng bajrong bad ba sngewtynad ia ka query ba suk jong ngi. |
| 08:09 | To ngin type ‘List of all members and their phone numbers’ mar pyrshah bad ka ‘Name of the Query label. |
| 08:20 | Mynta, phin iohi ba ngi iohi ia ka overview jong ka jingkwah jong ngi ha ka wizard. |
| 08:27 | Bad kumno ngi kwah ban iaid shakhmat nangne? |
| 08:31 | To ngin nion ha u ‘Display Query’ opshon hajrong kamon bad nion ha u “Finish” button. |
| 08:41 | Ka “wizard window” ka khang bad hangne ka window ba thymmai ka plie kaba ong – ‘List of all member and their phone numbers’. |
| 08:52 | Phin iohi ba ngi iohi ia baroh saw tylli ki member kaba ngi pyndap nyngkong duh ha ka “Members” table ryngkat bad ki phone number jong ki. |
| 09:04 | Bad ruh, ngi iohi ba kane ka lis ka lah pynbeit alphabetically ha ka order kaba kiew shajrong. |
| 09:13 | Te, kane kadei ka query basuk bad kaba nyngkong jong ngi. |
| 09:18 | Hangne ka kam na ka bynta jong phi. |
| 09:21 | Shna ia ka query ka ban lis ia baroh ki kot ha ka order kaba kiew shajrong. |
| 09:28 | Kynthup lang ia baroh ki fields. |
| 09:31 | Jer kyrteng ia ka ‘List of all books in the Library’. |
| 09:38 | Da kane ngi la poi sha kaba kut jong kane ka jinghikai halor ka “Creating Queries using Wizard in LibreOffice Base”. |
| 09:45 | Ban kyllum lang, ngi la pule kumno ban:
Shna ia ki jingkylli basuk da kaba pyndonkam da ka “Query wizard”, jied ia ki fields, buh ryntih ha ki order jong ki field bad, ban ai ki lad ne ki kyndon ha ka ban wad ia ki jingkylli. |
| 10:00 | “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. |
| 10:12 | Ia kane ka project la pynbit pynbiang da ka http://spoken-tutorial.org. |
| 10:17 | Kham bun ki jingtip halor kane kidon ha ka link harum. |
| 10:22 | nga dei u Pdiangburom na Shillong nga pynkut ia kane.
Khublei shibun ia ka jingiasnohkti lang jong phi. |
