LibreOffice-Suite-Base/C3/Create-Subforms/Khasi

Time	Narration
00:00	Khublei ngi pdiangsngewbha iaphi sha ka “Spoken tutorial” halor ka “LibreOffice Base”.
00:04	Ha kane ka jinghikai, ngin ia pule kumno ban
00:07	Shna ia ka “Subform”.
00:09	Na ka bynta kane, to ngin ia bteng ia ka nuksa jong ka “Library” database.
00:15	Bad ngin ia peit ia ki case ba hapoh:
00:18	Kumno ngi lah ban lis ia baroh ki members jong ka library?
00:22	Bad na ka bynta iwei pa iwei i member, kumno ngi lah ban iohi tang ia ki kot kiba khlem pat pynphai da ki member?
00:31	Kawei ka rukom kadei ban shna ia ka “form” kaban lis ia baroh ki members ha ka library.
00:36	Bad nangta shna ia ka “subform” hapoh jong ka, ban lis ia kita ki kot kiba khlem pat pynphai da ki member.
00:44	Shisien ba ngi lah design ia kane ka form, ngin sa lah ban update ia ka “form”.
00:49	Kum ka nuksa, lada ki member ki pynphai ia ka kot, ngi lah ban update ia kane ka jingtip.
00:55	Bad hangne, ka sample screenshot jong ka form ka ba ngin sa design.
01:01	Phin iohi, ka pyni ruh ia ka “subform ha trai.
01:06	To ngin plie ia ka “Library” database jong ngi.
01:09	Ha ka jinghikai kaba hashwa, ngi la shna ia ka ‘History of Books Issued to Members’ query.
01:17	Mynta ngin ia pyndonkam ia kane ka “query” bad ka “Member” table kum ka tynrai na ka bynta ban shna ia ka form ba thymmai jong ngi.
01:25	To ngin ia copy shwa nyngkong ia kane ka query da kaba nion kamon ha ka kyrteng jong ka query bad nangta to ngin nion ha “Paste”.
01:34	Ha ka pop-up window na ka bynta ka kyrteng jong ka query, to ngin type ia ka kyrteng ba thymmai: ‘Books Not Returned’
01:42	To ngin ia plie mynta ia ka ‘Books Not Returned’ query ha ka “edit” mode.
01:48	Ha ka “Query Design” window, to ngin pyndap ia ka criterion ban pyni tang ia ki kot kiba khlem checked-in.
01:58	Na ka bynta kane, to ngin type ‘equals 0’ ha ka “Criterion” column, hapoh ka “CheckedIn”.
02:06	Bad shon “Enter”.
02:09	To mynta ngin “save” ia ka query bad khang ia ka window.
02:13	Ha ka “Base” window ba hakhmat, to ngin nion ha ka “Forms” icon ha ka panel ba sha kadiang.
02:20	Bad nangta nion ha ka ‘Use Wizard to create Form’ opshon.
02:25	Mynta ngin iohi ia ka “Form” wizard kaba ngi lah ithuh teng.
02:28	To ngin ia iaid lyngba ia 8 tylli ki step ha ka liang ka diang ban shna ia ka “form” jong ngi.
02:34	Ha ka “step 1. field selection”, to ngin jied “Table: Members”.
02:40	Nangta to ngin pynkynriah ia baroh ki fields sha ka liang kamon.
02:46	Bad to ngin nion ha u “Next” button.
02:49	Ngi don ha ka “Step 2. Setup a subform.”
02:54	Te hangne, to ngin check ia ka ‘Add subform’ check-box
02:59	Bad nangta nion ha ka opshon: ‘Subform based on manual selection of fields’.
03:07	To ngin leit sha ka “Step 3. Add subform fields”.
03:11	Hangne ngin ia wanrah ia ka “query” ba thymmai ka ba ngi la shna khyndiat minute hashwa.
03:18	To, ngin ia jied ‘Query: Books Not Returned’ na ka “Tables or Queries” drop-down.
03:26	Bad ngin ia pynkynriah ia ki fields ba lah jied na ka lis badon sha ka liang kamon kumba la pyni ha ka screen.
03:37	Nion ha “Next”.
03:39	Step 4. Get joined fields.
03:43	Hangne ngin ia jied ia ka “MemberId” field na ar tylli ki drop-downs ba hajrong, namar tang ma ka kaba don ka jingiadei bad kane ka field.
03:53	Bad nion ha u “Next” button.
03:57	Step 5. Arrange Controls.
04:00	Hangne, ngin ia jied ia ka opshon kaba lai – “Data sheet”, na ka bynta baroh ar ka “form” bad ka “subform”.
04:08	Bad nion ha u “Next” button.
04:11	Step 6. Set data entry.
04:15	Hangne, ngin ia ieh ia kane ka opshon kumba kalong bad ngin nion “Next”.
04:22	Step 7. Apply Styles.
04:26	To ngin jied Grey kum ka form background.
04:29	Bad ngin leit sha ka step kaba khatduh.
04:32	Step 8. Set Name.
04:36	Hangne, to ngin ia ai ka kyrteng kaba jrong ia ka form jong ngi: ‘Members Who Need to Return Books’
04:45	Bad to ngin nion ha u “Modify form” opshon, ba ngin leh shuh shuh sa ia kiwei ki jingpynkylla.
04:53	Mynta to ngin nion ha u “Finish” button.
04:56	Ha ka “Form Design” window, phin iohi ba don ar tylli ki tabular data sheet areas.
05:04	Kaba hajrong kadei ka “form” bad kaba hapoh kadei ka “subform”.
05:11	Mynta, to ngin pyndap ia ka label hajrong jong ka form.
05:15	Ngin ia nion ha u “Label” icon ha ka “Form Controls” toolbar ha jrong bad dro ia ka ha ka form.
05:25	Nion ar sien ha ka label, kan sa pynmih ia ka properties jong ka.
05:31	Hangne ngin ia type ‘Member of the Library’ mar pyrshah ia ka label
05:37	Bad pynkylla ia ka font style sha “Arial, Bold” bad “Size”.
05:47	Ha kajuh ka rukom, to ngin pyndap ia ka label ba ar hajrong jong ka “subform” kumba la pyni ha ka screen.
05:55	Bad ngin khot ia ka “List of Books to be returned by the member’.
06:00	Hadien kane, to ngin pyn lyngkot ia ka jingjrong jong ka form kumba la pyni ha ka screen.
06:07	Bad nangta to ngin ia pynheh ia ka jingjrong jong ka “Name” field ha ka “form”.
06:13	Ha kajuh ka rukom, to ngin pynjrong ia ka “Book title” field ha ka “subform”.
06:21	To ngin ia pynkylla ia ki fonts hangne sha “Arial, Bold” bad “Size 8”.
06:28	Bad pynkylla ia ka rong jong ka background sha white na ka bynta ka “form” bad Blue 8 na ka bynta ka “subform”.
06:37	Hadien kane, to ngin buhrieh ia ka “MemberId” column da kaba nion ha ka liang kamon ha ka bad jied ia ka “Hide” column opshon.
06:47	Te, ngi la dep. To, ngin ia “save” ia ka form design bad ngin ia tes ia ka.
06:54	Ha ka “Base” window ba hakhmat, to ngin plie ia ka ‘Members Who Need to Return Books’ form da kaba nion ar sien ha ka.
07:03	Hangne kadei ka “form”.
07:05	To ngin ia browse ia kine ki member da kaba pyndonkam da u up lane down keys,
07:12	Lane da kaba shu nion ha ka kyrteng jong kine ki member bapher bapher.
07:16	Phin iohi ba ka subform ba hapoh ka pynthymmai bad ka pyni ia ki kot ba la pynphai.
07:23	Ha ka subform, to ngin jied kano kano ka record
07:27	Bad to ngin type ‘12/7/11’ ha ka actual return date fields bad check ia ka “CheckedIn” field
07:41	Bad shon “Enter”.
07:45	Mynta to ngin pynthymmai ia ka form da kaba nion ha u “Refresh” icon ha ka “Form Navigation” toolbar ha trai.
07:56	Phin iohi ba ka “record” ba ngi dang shu edit kam don shuh ha kane ka lis hangne
08:02	Kaba mut ba ki kot lah pynphai lane checked-in.
08:07	Te, kane kadei ka form bad ka subform jong ngi.
08:11	Da kane ngi la poi sha kaba kut jong ka jinghikai halor ka “Subform in LibreOffice Base”.
08:17	Ban kyllum lang, ngi la pule kumno ban:
08:20	Shna ia ka subform.
08:23	“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. Ia kane ka project la pynbit pynbiang da ka http://spoken-tutorial.org. Kham bun ki jingtip halor kane kidon ha ka link harum.
08:44	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 jingiasnoh kti lang jong phi.

Contributors and Content Editors

Pdiangburom, PoojaMoolya