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

From Script | Spoken-Tutorial
Revision as of 11:33, 8 May 2017 by Pdiangburom (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
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