LibreOffice-Suite-Base/C3/Create-Subforms/Khasi
From Script | Spoken-Tutorial
Revision as of 21:26, 7 May 2017 by Pdiangburom (Talk | contribs)
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. |