Difference between revisions of "LibreOffice-Suite-Base/C3/Create-Subforms/Khasi"
From Script | Spoken-Tutorial
Pdiangburom (Talk | contribs) (Created page with " {| border=1 |'''Time''' |'''Narration''' |- |00:00 |Khublei ngi pdiangsngewbha iaphi sha ka “Spoken tutorial” halor ka “LibreOffice Base”. |- |00:04 |Ha kane ka jingh...") |
PoojaMoolya (Talk | contribs) |
||
| Line 19: | Line 19: | ||
|- | |- | ||
|00:18 | |00:18 | ||
| − | | | + | |Kumno ngi lah ban lis ia baroh ki members jong ka library? |
|- | |- | ||
|00:22 | |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 | |00:31 | ||
Revision as of 14:40, 23 May 2017
| 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. |
