Tutorial How to Make a Form With Base Database LibreOffice

in #utopian-io7 years ago (edited)

cara-upgrade-libre-office.png

What Will I Learn?

  • How to make a Database with LibreOffice
  • How to Make a Form
  • How to use Wizard on tools

Requirements

  • System Requirements
    No special requirements.

  • OS Support
    Microsoft Windows (IA-32 and x86-64), Linux (IA-32 and x86-64) and macOS (x86-64).

  • Requirements
    Program Install Support: Install and Uninstall

Difficulty

Intermediate

Information

  • Website & Download: https://www.libreoffice.org/

  • Type : Office suite software

  • License : The LibreOffice project uses a dual LGPLv3 (or later) / MPL 2.0 license

  • Operating System : Linux, OS X, Microsoft Windows, Solaris

  • Platform : IA-32, x86-64, PowerPC, SPARC

for more information Klik Here

Tutorial Contents

LibreOffice is the open source office software for word processing, spreadsheets, presentations, graphics design, databases and math. It can be downloaded and used completely free for any purpose. at this time i will give tutorial how to make a form and make database from libreoffice.

The Step of Tutorial

  • open the libreoffice application and select database base.
    1.png
    LibreOffice Base Database is relational database applications similar to Microsoft Access. LibreOffice Base enables database creation and management, the preparation of forms and reports for easy data access by end users. Like Access, Base can be used as an embedded small database, stored in document files (using Java-based HSQLDB as its storage engine), and for heavier jobs can also be used as a front-end for various systems database, including Access database (JET), ODBC / JDBC data source, and MySQL, MariaDB, PostgreSQL or Microsoft Access.
    Source Klik Here

  • then select the database and click the next button on the bottom to continue on the next step.
    2.png
    after you klik next button and then choose the icon if you not yet have the database before.
    3.png

  • after you have completed the previous step then will appear a box that contains about tables, queries, forms and reports. Then you choose to create a table in design view so that raises table table you have to design If you want to create a form.
    5.png
    Then you fill the table table with some things Example as I made there is the ID number, address ,name, then the GPA.
    6.png

  • After you do this then beside the ID number and others there is a file type and then there is a vharchar text. Then you change the vharchar text from ID number to integer. Then the IPK is converted to decimal.
    7.png
    Then the IPK is converted to decimal.8.png
    the steps are used to facilitate each user to perform a valid number and decimal number.

    • in the required entry under which the arrow you are marked change the entire field name and field type to yes.
      9.png
      then after doing so then save the file you created with the name of example 1.
      10.png

    • Next step you close the box Then you go to the form menu, and select the menu use wizards to create form.11.png
      use wizards to create form in order to make it easier for every user to create a form without creating it manually. in use wizards to create this form have been provided some things in need to create a form.
      12.png
      then fill in the box that is available in addition to the database that you created earlier in order to facilitate us memelakukan next step.
      12.png
      after filling with the guide above then the next button pressed to finish. but in the choice of arrange controls you can select several types of forms that exist in the wizard will automatically be formed.
      13.png
      I myself use the first number wizard equipment because it fits perfectly with the form I'm going to make .
      14.png
      Then you Click the finish button when finished in your work choose the form you want then Click save button to save the box or the form you want to make. then will appear the example of the form you want.
      15.png
      Then Click the close button to exit to base base database as below. to make edits on the form you want like If you want to add the next previous button and save it is very easy that is by Right Click on your mouse then select the edit menu to do it.
      16.png
      select the push button to add a button on your form.
      18.png
      Then double click on the push button box then change its name level with its name next and the label is replaced with next too, so the name on the label is changed to next.
      19.png
      and then change the action to become a next button on your form.
      20.png
      then If you want to add previous and save button then do the same thing as before
      21.png

    • if you have done the previous step correctly then you next save the form and then you go back to the tables in the basic options, then right click on your mouse to do the initial database filling for a form you want to make.
      22.png
      contents of the table with the id number, name, address and GPA someone, and for example as follows.
      23.png
      save the example you have created, then click the close button and return again on the form in the base database options.and go directly to the example that you created earlier so that automatically generate the person you have registered earlier.
      24.png
      then you can see the next list by using the nect button, and if you want to go back then click the previous button.

    • then last if you want to insert a new name into your form, then you just need to fill in the boxes on your form with different numbers and different names.
      25.png
      then click the save button to save it into the database you have created.
      26.png
      so automatically the new name you enter has entered in the database that you have created before.
      26.png

    Curriculum

    this is my first tutorial



    Posted on Utopian.io - Rewarding Open Source Contributors

Sort:  

Thank you for the contribution. It has been approved.

  • To some extend ,it seems a little not technical .I am struggling if i should reject it .
  • sure to make more good quality contributions .

You can contact us on Discord.
[utopian-moderator]

Hey @hansconan I am @utopian-io. I have just upvoted you!

Achievements

  • You have less than 500 followers. Just gave you a gift to help you succeed!
  • Seems like you contribute quite often. AMAZING!

Suggestions

  • Contribute more often to get higher and higher rewards. I wish to see you often!
  • Work on your followers to increase the votes/rewards. I follow what humans do and my vote is mainly based on that. Good luck!

Get Noticed!

  • Did you know project owners can manually vote with their own voting power or by voting power delegated to their projects? Ask the project owner to review your contributions!

Community-Driven Witness!

I am the first and only Steem Community-Driven Witness. Participate on Discord. Lets GROW TOGETHER!

mooncryption-utopian-witness-gif

Up-vote this comment to grow my power and help Open Source contributions like this one. Want to chat? Join me on Discord https://discord.gg/Pc8HG9x