What Will I Learn?
we will learn how to add push button in form on apache open office app, with this button will simplify our work when managing a database and we can save data and add new data
- How to set up a form
- How to add a button in form
Requirements
- System Requirements Program Install Support: Install and Uninstall
- System Requirements No special requirements.
- OS Support Windows (XP, 2003, Vista, 7, 8 and 10) GNU/Linux (x86 and x86-64, RPM and DEB -
based Linux distributions) Mac OS X (x86-64 only)
Difficulty
- Intermediate
Tutorial Contents
Apache open officeis the app exactly the same as microsoft office, but apache openoffice is opensource, here we can find the facilities such as, openoffice presentation, openoffice calc, openoffice base, and others. on this occasion I want to share about openoffice base equivalent to microsoft access on microsoft office, with open office base we can create a databse and set it up in such a way, create a query, create a table, create a report and create a form, on this occasion we focused on the form that is how to create a form and add a button on the form.
make sure you have create a database firs, the goal is to make data storage - data that we will input later on the form by using the button or add new data by using button add new data later, after that go to the form and click on the "use wizard to create form"
next click the aero right icon to move or for enter all data to the form
and then click on next
and now set the form as you want and enter name for the form, here I suggest to choose "columnar - labels on top" on arrange controls for simple form and easy to use.
after you set up the form design in such a way next select the button on the left toolbar, And add 2 buttons, a buttonto save, and another one to create new data, next right-click on each button and select the control to add the label and action.
next save this form, and now we're trying to operate it, to open the form that has the way is back on display the beginning of the open office base on the menu of the form double click on "Frm_student". to ensure the form works fine please input the data for the experiment according to what you want. for example, like this :
and click on save button that has been made, and make sure the data has been stored by the way check it out on the table in the database.
if the data saved then it will automatically be stored in the database, the image above shows how the function of the save button works fine, when the data in the save, next we will try with the function button next button add new data where when the button is operated in the automatic form the form will provide a new line or removes (not deletes) the data that has been entered last.
and make sure that display when you click on the add new data button will be like the picture above, if so then the 2 buttons that we have created is functioning properly, to add new data you just need to click on add new data and to store data that has been added you just need to click on the save button, in addition to making the 2 button's here. we can also make more button how to choose what functions we want in action, just the tutorial on this time, and see you.
Posted on Utopian.io - Rewarding Open Source Contributors