Pdiangburom at 10:18, 25 May 2017

2017-05-25T10:18:40Z

PoojaMoolya at 05:23, 23 May 2017

2017-05-23T05:23:14Z

Pdiangburom: Created page with "{| border=1 |'''Time''' |'''Narration''' |- ||00:02 ||Khublei ngi pdiangsngewbha iaphi sha ka “Spoken toturial” halor ka “LibreOffice Base”. |- ||00:06 ||Ha kane ka ji..."

2017-04-21T12:57:10Z

Created page with "{| border=1 |'''Time''' |'''Narration''' |- ||00:02 ||Khublei ngi pdiangsngewbha iaphi sha ka “Spoken toturial” halor ka “LibreOffice Base”. |- ||00:06 ||Ha kane ka ji..."

New page

{| border=1
|'''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
||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 jingiasnohkti lang jong phi.

|-

@@ Line 243: / Line 243: @@
 |-
 ||10:22
-||Ia kane ka script la noh synniang da ka Priya Suresh, DesiCrew Solutions. Bad nga dei u Pdiangburom na Shillong nga pynkut ia kane.
+||nga dei u Pdiangburom na Shillong nga pynkut ia kane.
 Khublei shibun ia ka jingiasnohkti lang jong phi.
 |-

@@ Line 8: / Line 8: @@
 ||00:06
 ||Ha kane ka jinghikai, ngin ia pule kumno ban:
-* Shna ia ki jingkylli basuk da kaba pyndonkam da ka “Query wizard”
+Shna ia ki jingkylli basuk da kaba pyndonkam da ka “Query wizard”,
-* jied ia ki fields
+jied ia ki fields,
-* buh ryntih ha ki order jong ki field bad
+buh ryntih ha ki order jong ki field bad,
-* ban ai ki lad ne ki kyndon ha ka ban wad ia ki jingkylli.
+ban ai ki lad ne ki kyndon ha ka ban wad ia ki jingkylli.
 |-
 ||00:24
@@ Line 228: / Line 228: @@
 ||09:45
 ||Ban kyllum lang, ngi la pule kumno ban:
-* Shna ia ki jingkylli basuk da kaba pyndonkam da ka “Query wizard”
+Shna ia ki jingkylli basuk da kaba pyndonkam da ka “Query wizard”,
-* jied ia ki fields
+jied ia ki fields,
-* buh ryntih ha ki order jong ki field bad
+buh ryntih ha ki order jong ki field bad,
-* ban ai ki lad ne ki kyndon ha ka ban wad ia ki jingkylli.
+ban ai ki lad ne ki kyndon ha ka ban wad ia ki jingkylli.
 |-
 ||10:00

LibreOffice-Suite-Base/C2/Create-queries-using-Query-Wizard/Khasi - Revision history

Pdiangburom at 10:18, 25 May 2017

PoojaMoolya at 05:23, 23 May 2017

Pdiangburom: Created page with "{| border=1 |'''Time''' |'''Narration''' |- ||00:02 ||Khublei ngi pdiangsngewbha iaphi sha ka “Spoken toturial” halor ka “LibreOffice Base”. |- ||00:06 ||Ha kane ka ji..."