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

From Script | Spoken-Tutorial
Revision as of 14:40, 23 May 2017 by PoojaMoolya (Talk | contribs)

Jump to: navigation, search
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