Difference between revisions of "LibreOffice-Suite-Base/C4/Access-data-sources/Khasi"
From Script | Spoken-Tutorial
PoojaMoolya (Talk | contribs) |
PoojaMoolya (Talk | contribs) |
||
| Line 292: | Line 292: | ||
|- | |- | ||
||11:05 | ||11:05 | ||
| − | || | + | ||Access ia kiwei ki Data Sources |
|- | |- | ||
||11:07 | ||11:07 | ||
| − | || | + | ||Register ia ka .odb databases |
|- | |- | ||
||11:12 | ||11:12 | ||
| − | || | + | ||Ban peit ia ka Data sources |
|- | |- | ||
||11:14 | ||11:14 | ||
| − | || | + | ||Bad ban pyndonkam ia ka Data Source ha ka Writer. |
|- | |- | ||
||11:19 | ||11:19 | ||
Revision as of 11:35, 24 May 2017
| Time | Narration |
| 00:00 | Ngi pdiang sngewbha iaphi sha ka “Spoken tutorial” halor ka “LibreOffice Base”. |
| 00:04 | Ha kanae ka jinghikai ngin pule shaphang: |
| 00:08 | Ban access ia kiwei ki data sources |
| 00:10 | Ban ‘Register’.odb’ databases |
| 00:15 | Ban view Data sources |
| 00:17 | Bad * Pyndonkam ia ki Data Sources ha ka “Writer”. |
| 00:22 | To ngin ia peit kumno ban access ia kiwei ki “Data Sources” ha ka “Base”. |
| 00:28 | “LibreOffice” ka ai lad ia kiwei ki data sources ban accessed shi bynta na ka “Base Databases”. |
| 00:37 | Ka ailad ruh ban “link” ia ki bad kiwei ki “Libre Office documents”. |
| 00:43 | Kum ka nuksa, ngi lah ban access ia ka “spreadsheet” lane ia ka text document kaba suk napoh jong ka Libre Office Base. |
| 00:53 | Bad nangta link ia ki hapoh ka “LibreOffice Writer” document. |
| 00:58 | Kum ka nuksa, to ngin shna ia ka nuksa jong ka spreadsheet da ka pyndonkam ia ka “LibreOffice Calc”. |
| 01:06 | Nion ha “Start Menu>> All Programs” bad plie ia ka “LibreOffice Suite menu”. |
| 01:16 | Lane, lada ka LibreOffice ka la plie lypa ngin lah ban nion ha u “File, New” bad nangta “Spreadsheet” ban plie ia spreasheet ba thymmai. |
| 01:30 | Mynta, ha ka spreasheet, to ngin type katto katne ki sample data kumba la pyni ha kane kadur. |
| 01:46 | Bad “save” ia kane ka spreasheet kum ka “LibraryMembers” ha ka jaka ba ka directory kadon. |
| 01:54 | Mynta, to ngin kynmaw ia ka jaka namar ba ngin sa donkam ban pyndonkam ia kane ka file hadien kum ka nuksa jong ngi. |
| 02:02 | Bad ngin ia khang ia ka “Calc” window. |
| 02:07 | Te, mynta to ngin peit kumno ban access ia kane ka spreasheet na ka ‘LibreOffice Base’. |
| 02:15 | Ban leh ia kane, plie ia ka “Base” na ka “Windows” lane “Start” menu |
| 02:25 | Lane lada ka LibreOffice ka lah plie lypa ngin ia nion ha u “File, New” bad nangta “Database”. |
| 02:36 | Mynta, kane kan plie ia ka “Database Wizard”. |
| 02:39 | Hangne, ngin ia nion ha ka “Connect to an existing database” |
| 02:45 | Nangta nion ha u drop-down. |
| 02:48 | Phin iohi ia bun ki database sources ha kane ka lis kaba ka “Base” ka lah ban access. |
| 02:55 | Bad ngin ia nion ha ka “Spreadsheet” hangne. |
| 02:59 | Bad ha u “Next” button. |
| 03:02 | Mynta, da kaba pyndonkam ia u browse button, to ngin leit sha ka jaka ba ka spreasheet kadon ha kaba ngi lah save hashwa. |
| 03:10 | Lada kadon ka password na ka bynta ka spreasheet, ngi hap ban ai ia kata ruh. |
| 03:16 | Hangne ngim donkam ia kata. |
| 03:19 | To ngin nion ha u “Next” button. |
| 03:22 | Mynta to ngin register ia kane ka spreasheet kum ka data source |
| 03:27 | Bad plie ia ka na ka bynta ka editing. |
| 03:32 | Bad, nion ha u “Finish” button. |
| 03:36 | Mynta, to ngin ai ia ka kyrteng jong ka database hangne. To ngin type “LibraryMembers”. |
| 03:44 | Phin iohi ia ka “Save as type”: Ka ong “ODF Database” kaba dei ka ‘.odb’ ha ka bynta ba iadei bad ngi. |
| 03:56 | Bad “Save” ia ka ha kajuh ka jaka bad ka spreasheet. |
| 04:01 | Hangne ngi lah registered ia ka spreadsheet kum ka data source ha ka “Base”. |
| 04:07 | Bad ngi don ha ka Base window ba hakhmat mynta. |
| 04:11 | Hangne, to ngin nion ha ka “Tables” icon ha ka panel ba sha kadiang. |
| 04:16 | Phin iohi ia ki tables ‘Sheet1’, Sheet2, bad ‘Sheet3’. |
| 04:23 | To ngin nion ar sien ha ka “Sheet1” ban plie ia ka bad hangne kadei ka data jong ka spreadsheet. |
| 04:31 | Mynta, da kane ka rukom ban access ia ka Spreadsheet, ngim lah ban leh kano kano ka jingpynkylla nangne. |
| 04:39 | Ngi lah tang ban peit ia ka data lane shna ia ka queries bad reports based ha ka data ba lah don lypa nangne. |
| 04:47 | Te, ki jingpynkylla dei ban leh ha ka Spreadsheet hi. |
| 04:54 | Registering '.odb' databases. |
| 04:59 | Mynta, kidon sa kiwei ki programs kum ka “OpenOffice.org” kaba lah ban pynmih ia ka ‘.odb’ databases. |
| 05:11 | Ban leh ia kine hapoh jong ka LibreOffice Base, ngi donkam shwa nyngkong ban register ia ki ha ka “Base”. |
| 05:19 | Ban register kano kano ka ‘.odb’ database, ngin donkam ban plie ia ka Base bad |
| 05:28 | Jied “Tools, Options, LibreOffice Base” bad “Databases”. |
| 05:36 | Hapoh ka “Registered Databases”, nion “New”. |
| 05:42 | Leit shaba ka database kadon bad pynthikna ba ka kyrteng ba lah register kadei kaba dei |
| 05:51 | Bad nion ha u “OK” button. |
| 05:55 | To ngin iapeit kumno ngi lah ban view ia ka Data sources ha ka LibreOffice. |
| 06:01 | Na ka bynta kane, to ngin shim ia ka nuksa jong ka spreadsheet kaba ngi lah registered ha ka Base. |
| 06:07 | Mynta, ngi lah ban pyndonkam ia ka ha ka “LibreOffice Writer” lane “Calc”. |
| 06:12 | Kum ka nuksa, to ngin ia peit kumno ngi lah ban view ia ka hapoh ka ‘LibreOffice Writer’. |
| 06:19 | Nyngkong, to ngin plie ia ka “Writer” na ka ‘Base’ window. |
| 06:24 | Na ka bynta kane, to ngin nion ha ka “File, New” bad nangta “Text Document”. |
| 06:33 | Mynta ngi don ha ka “Writer” window. |
| 06:36 | Ban peit ia ki data sources kiba don, ngin ia nion ha ka “View” menu hajrong bad nion ha “Data Sources”. |
| 06:46 | Da kawei pat ka rukom, ngi lah ban shon “F4” key. |
| 06:52 | Mynta ngi iohi ia ka list jong ki database ba lah registered hajrong kadiang, kynthup ia ka “Library Members” kaba ngi dang shu shna. |
| 07:03 | Ban peit ia ka database, ngi lah ban pynheh ia ka kaba nion ha u plus symbol ha kadiang jong ka kyrteng ka database |
| 07:14 | Bad ngin ia pynheh ia ka Tables. |
| 07:18 | Hangne ki Sheet1, 2, bad 3. |
| 07:24 | To ngin nion ha u “Sheet1”. |
| 07:28 | Te, hangne ka data jong ngi ha kajrong kamon jong ka Writer window. |
| 07:36 | Mynta ngin ia peit kumno ban pyndonkam ia kane ka data ha ka nuksa jong ngi ka “Writer document”. |
| 07:43 | Te, hangne lada ngi kwah ban pyndonkam ia baroh ki data na ka table hajrong te nyngkong ngin ia jied ia baroh ki records nangne. |
| 07:55 | Na ka bynta kane, ngin ia nion ha u cell ba rong dpei ha kadiang jong ka column ba nyngkong ha ka record ba nyngkong. |
| 08:05 | Nangta, katba ngi dang shon “Shift” key, ngin ia nion ha u cell ba rong dpei sha kadiang ha ka column ba nyngkong ha ka record ba khatduh. |
| 08:17 | Phin iohi ba baroh ki data ki lah thaba. |
| 08:21 | Mynta ngin ia nion, tan bad pynhap ia kane ha ka Writer document hapoh. |
| 08:30 | Hadien kane, ngi iohi ia u pop-up window uba kyrteng “Insert Database columns”. |
| 08:37 | Te hangne, ngin ia nion ha ka “Table” opshon hajrong |
| 08:42 | Bad nangta nion ha u khnam button badon ar khlieh ban pynkynriah ia baroh ki fields na kadiang sha ka lis kamon. |
| 08:52 | Phin iohi ia bun kiba ngi lah ban jied hangne. |
| 08:56 | Ia mynta, ngin shu nion ha u “OK” button. |
| 09:00 | Bad hangne kadei baroh kawei ka table jong ka data ha ka document. |
| 09:05 | Hadien kane, to ngin ia peit kumno ngin thep ia ki fields ba marwei. |
| 09:13 | To ngin ia leit shajrong jong ka Writer document bad shon “Enter” key arsien. Sa shisien, leit shajrong kadiang. |
| 09:22 | Hangne, to ngin type ha u “Member name” colon. |
| 09:28 | Bad nangta nion ha u “Name” column ha ka data sources area hajrong liang kamon. |
| 09:36 | Mynta ngin ia nion, tan bad pynhap ia ka ha ka text ba bud ba ngi lah typed. |
| 09:43 | Bad ngin ia shon ha u “Tab” key bad type “Phone number” colon. |
| 09:51 | Bad....ngi tip kumno ban leh, ym dei? |
| 09:55 | Ngin ia nion bad tan ia u “Phone” column najrong bad pynhap ia ka ha marbud jong ka text jong ngi. |
| 10:04 | Nangta to ngin pynthaba ia ka record ba nyngkong da kaba nion ha u cell ba rong dpei sha ka diang jong ka record ba nyngkong. |
| 10:13 | Bad nangta, ngin ia nion ha ka “Data to Fields” icon. |
| 10:19 | Ia kane lah ban shem ha ka “Table Data” toolbar hajrong, hapoh jong ka “Formatting toolbar”. |
| 10:27 | Phin iohi ia ki data ha ka table ba hajrong mynta kadon ha ka Writer document. |
| 10:35 | Kane ka wanlam sha kawei pat ka record, ngi hap ban shu pynthaba ia ki record bapher bapher bad pyndonkam ia ka “Data to Fields” icon sa shisien. |
| 10:46 | Te, hangne ngi lah pule kumno ban pyndonkam ia ka data source hapoh jong ka LibreOffice documents. |
| 10:54 | Da kane ngi lah poi sha kaba kut jong kane ka jinghikai halor ka “Accessing other Data Sources in LibreOffice Base”. |
| 11:01 | Ban kyllum lang, ngi lah pule kumno ban: |
| 11:05 | Access ia kiwei ki Data Sources |
| 11:07 | Register ia ka .odb databases |
| 11:12 | Ban peit ia ka Data sources |
| 11:14 | Bad ban pyndonkam ia ka Data Source ha ka Writer. |
| 11:19 | “Spoken Tutorial” project kadei shi bynta jong ka “Talk to a Teacher” project, |
| 11:23 | La kyrshan ia ka da ka National Mission on Education lyngba ka ICT, MHRD, Sorkar India. |
| 11:30 | Ia kane ka project la pynbit pynbiang da ka http://spoken-tutorial.org. |
| 11:35 | Kham bun ki jingtip halor kane kidon ha ka link harum. |
| 11:44 | Ia kane ka project la noh synniang da ka Priya Suresh, DesiCrew Solutions. Bad nga dei u Pdiangburom na Shilong, nga pynkut ia kane.
Khublei shibun ia ka jingsnohkti lang jong phi. |
