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.