How to create a relational database using forms and subforms without using macro code.
In this tutorial, I walk you through the creation of a useful database that manages courses and the students enrolled in these courses.
Together we build a complex form with four main sections and a total of 7 independent table grids.
This tutorial covers creating the database from scratch.
Using SQL to create the tables.
Using SQL to load some data to the tables.
Designing the forms and subforms.
Writing SQL queries to make the forms work.
Creating Useful forms in LibreOffice Base
LibreOffice Base complete playlist (all lessons):
• How To download Libre Office Mac and ...
☕
If you found this tutorial helpful consider supporting this channel with a steaming hot cup of coffee... https://kofi.com/seanbjohnson
☕
BlogPost Link for this tutorial https://www.businessprogrammer.com/li...
Resources
============
LibreOffice Base (book is titled OpenOffice) PROGRAMMING https://amzn.to/3sSK3xg'>https://amzn.to/3sSK3xg'>https://amzn.to/3sSK3xg'>https://amzn.to/3sSK3xg'>https://amzn.to/3sSK3xg'>https://amzn.to/3sSK3xg'>https://amzn.to/3sSK3xg'>https://amzn.to/3sSK3xg
Video Production
===============
Sony Camera: https://amzn.to/3mqyqfu
Elgato HDMI Stream Capture: https://amzn.to/2Yfyrum
Microphones
Screen Casting: https://amzn.to/3a2TnHN
Microphone and Arm: https://amzn.to/3iwvL2S
Talking To Camera: https://amzn.to/3FqXI6b
Video Kit
Lights
Elgato video Lights: https://amzn.to/3sSK3xg'>https://amzn.to/3sSK3xg'>https://amzn.to/3sSK3xg'>https://amzn.to/3sSK3xg'>https://amzn.to/3sSK3xg'>https://amzn.to/3sSK3xg'>https://amzn.to/3sSK3xg'>https://amzn.to/3sSK3xg
Background Light: https://amzn.to/3uTXyPh
Note Taking
Rocketbook reusable notebook https://amzn.to/3sSK3xg'>https://amzn.to/3sSK3xg'>https://amzn.to/3sSK3xg'>https://amzn.to/3sSK3xg'>https://amzn.to/3sSK3xg'>https://amzn.to/3sSK3xg'>https://amzn.to/3sSK3xg'>https://amzn.to/3sSK3xg
Other
Rocketbook reusable notebook https://amzn.to/3sSK3xg'>https://amzn.to/3sSK3xg'>https://amzn.to/3sSK3xg'>https://amzn.to/3sSK3xg'>https://amzn.to/3sSK3xg'>https://amzn.to/3sSK3xg'>https://amzn.to/3sSK3xg'>https://amzn.to/3sSK3xg
#libreoffice #openoffice #businessprogrammer #LibreOfficeBase #Databases
DISCLAIMER: This video and description contain affiliate links, this means if you click on one of the product links, I might receive a small commission.