How to use Relationship Form and Table using OpenOffice Base
Apache OpenOffice is the leading open-source office suite software for word processing, spreadsheets, presentations, graphics, databases and more. More Information
What Will I Learn?
In the video I give an explanation how to create Relationship in OpenOffice base.
- You will learn how to create relationships between the tables you have created.
- You will learn how to create a new form with different content using the form navigator.
- You will learn how to add a new table to the form and use the Table controls to add a List box, as well as connect the box with the Table you created in the Database.
- You will learn how to connect the Form and tables you have created.
What is OpenOffice Database?
Openoffice.org base or known as BASE alone is software to manipulate and manage the database. Making data input, as well as manipulating and making reports can be done with this BASE.
Benefit of Relationship on Database
Database relationship is a relation or relationship between multiple tables in the database that we have. Relation between tables connected by prymary key and foreign key. To create a relationship then each table must have a primary key and a foreign key to be able to connect between the parent table with the child table.
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)
Information
- Website & Download: https://www.openoffice.org/
- Type : Office suite software
- License : Dual-licensed under the SISSL and GNU LGPL
- Operating System : Linux, OS X, Microsoft Windows, Solaris
- Platform : IA-32, x86-64, PowerPC, SPARC
Difficulty
Intermediate
Description
Apache OpenOffice is the leading open source office software for word processing, spreadsheets, presentations, graphics, databases and more. It can be downloaded and used completely free for any purpose. In the video below, Here I explain how to set relationship on database.
Video Tutorial
Curriculum
If you want to learn more about OpenOffice, I have uploaded my previous video, you can see below :
- Apache OpenOffice learn to use Mail Merge
- Apache OpenOffice Formula learning (1)
- Apache OpenOffice Formula learning (2)
- And if you want to know more of tutorials you can directly see on my profile
Posted on Utopian.io - Rewarding Open Source Contributors
Thank your for your contribution. It has been approved.
Need help? Write a ticket on https://support.utopian.io.
Chat with us on Discord.
[utopian-moderator]
Thank you mod
Thank your for your contribution. It has been approved.
Here are some suggestions for you:
Try to speak more deliberately and clearly as you create the tutorial.
If possible, put some pauses in between to lay out the different steps clearly. In that way, people can follow the steps without guessing.
Try to use arrows or boxes to help people focus on the specifics that you are teaching them. This will help people to follow your points more dynamically.
Need help? Write a ticket on https://support.utopian.io.
Chat with us on Discord.
[utopian-moderator]
Thank you for your suggestion. i will try to work better again.
Hey @darsondrew I am @utopian-io. I have just upvoted you!
Achievements
Utopian Witness!
Participate on Discord. Lets GROW TOGETHER!
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