Difference between revisions of "LibreOffice-Suite-Base/C4/Access-data-sources/Khasi"
From Script | Spoken-Tutorial
PoojaMoolya (Talk | contribs) |
Pdiangburom (Talk | contribs) |
||
(One intermediate revision by one other user not shown) | |||
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 | ||
Line 316: | Line 316: | ||
|- | |- | ||
||11:44 | ||11:44 | ||
− | || | + | ||nga dei u Pdiangburom na Shilong, nga pynkut ia kane. |
Khublei shibun ia ka jingsnohkti lang jong phi. | Khublei shibun ia ka jingsnohkti lang jong phi. | ||
|- | |- |
Latest revision as of 11:58, 26 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 | nga dei u Pdiangburom na Shilong, nga pynkut ia kane.
Khublei shibun ia ka jingsnohkti lang jong phi. |