LibreOffice-Suite-Base/C4/Access-data-sources/Khasi

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.

Contributors and Content Editors

Pdiangburom, PoojaMoolya